This tutorial explains how to create a table data field that has the data type as a link in Microsoft Access.
Please note: the screenshots used in this guide are from Microsoft Access 2016, but are remarkably similar in earlier and later versions – so you should have absolutely no trouble following along even if you’re not using the exact same version.
- Start Microsoft Access and navigate to the Create tab in the ribbon and then click the Table button.
- A new table will be created named as Table1. Right click Table1 and select Design View to add fields with specific data types.
- Enter an appropriate table name and start adding fields. When you get to the field that you wish to be a link, select that field and from the Data Type options select Hyperlink
- Close the Design view after saving the changes and then open the database table in Datasheet view. You may be prompted to save your data first – if you are, go ahead and save it.
- Any data you enter in the field will now turn into a link right from within Microsoft Access.
If you want to enter the hyperlink data entered in the field with hyperlinks as its data type, then:
- Select the hyperlink entry you want to edit and right click it. Select Hyperlink and then select Edit Hyperlink.
- An Edit Hyperlink dialog will now open where the hyperlink can be edited. You can specify here whether the hyperlink is linked to an e-mail address or a webpage and then set the credentials accordingly.
For more guides like this one, check out the Office section of our site :)