Create a field to store hyperlinks

1. Open an existing table in Design view, or create a new table.
2. In the Field Name portion of the window, type a name for the field that you'll use to store the hyperlinks.
3. In the Data Type column for that field, select Hyperlink.
4. Click Save on the toolbar to save the table.

Notes

• In Datasheet view, you can create a field to store hyperlinks by clicking the Hyperlink Column command on the Insert menu and then typing the hyperlink address in the new field.
• If you create a table by importing data, Microsoft Access automatically converts any column that contains URLs or UNC paths into a hyperlink field. Access will convert the column only if all the values start with a recognized protocol, such as "http:" or "\\". If any value starts with an unrecognized protocol, Access won't  convert the column into a hyperlink field.