Creating hyperlinks in Microsoft Access 2010 can require a bit of guidance, as it’s certainly not as easy as creating hyperlinks in MS Word. In this guide we’ll show how to create a table data field having the data type as a link.
- Start Microsoft Access 2010 and navigate to the Create tab in the Microsoft Access 2010 ribbon and select Table.
- 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. The field which you want to have its data type has Hyperlink – select that field name and under data type options, select Hyperlink.
- Close the Design view after saving the changes. Open the database table in Datasheet view and now any data you enter in the field, it will turn into a hyperlink, marked by its characteristic blue color.
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.
- If you set the hyperlink to be linked to an e-mail address, then clicking the hyperlink entry in Microsoft Access 2010 will open directly in Microsoft Outlook 2010 with the To address being the one you entered in the Access 2010 table.