Sometimes there is frantic need to create links in database table to web pages, files, folders, images, etc. Access 2010 provides a convenient way to link up data field values with anything to complement the database in much better way. In this post we will guide you on creating a table field having Hyperlink data type.
To start off with, launch Access 2010 and navigate to Create tab and click Table.
It will create a new table namely Table1. Right-click newly created table and select Design View to add fields with specific Data types.
Enter an appropriate table name and start adding fields. We will be entering some generic table fields with their data types such as, ID, Name, Phone Number, Email and other Links.
Select Email table field and under data type options, select Hyperlink.
Repeat the procedure for assigning Hyperlink data field for other fields as well.
Now close the Design view and save the changes made. Open the database table in Datasheet view. Start filling out table fields with values. In Hyperlink assigned data fields, you will notice that on entering values it will automatically turns them into blue, indicating linked data.
From Base URL, enter webpage address and click OK.
Upon clicking hyperlink, it will immediately open up specified webpage address in default browser.