www.office.com/setup Blogs: 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.

createtable1 Create Hyperlink Field In Access 2010 - www.office.com/setup

It will create a new table namely Table1. Right-click newly created table and select Design View to add fields with specific Data types.

table11 Create Hyperlink Field In Access 2010 - www.office.com/setup

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.

design view - www.office.com/setup

Select Email table field and under data type options, select Hyperlink.

select hyperlink - www.office.com/setup

Repeat the procedure for assigning Hyperlink data field for other fields as well.

hyperlink other - www.office.com/setup

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.

hyerplinks created - www.office.com/setup

Now we will move to editing Hyperlinks. In Email field, highlight the email address and right-click to select Edit Hyperlink.

edit hyperlink - www.office.com/setup

It will instantly open Edit Hyperlink dialog. Under E-mail address box, enter the email address, and from Subject box, write the subject of the mail. Click OK.

edit hyperlink 1] - www.office.com/setup

Upon clicking on hyperlink, it will immediately open Outlook mail compose window, with specified email address and subject inserted.

email open - www.office.com/setup

Repeat the same procedure for assigning hyperlink to other email addresses in table field. For linking webpages or websites, right-click the link to edit and From Hyperlink sub menu, select Edit Hyperlink.

From Base URL, enter webpage address and click OK.

webpage hyperlink - www.office.com/setup

Upon clicking hyperlink, it will immediately open up specified webpage address in default browser.

Original Post: http://www.addictivetips.com/microsoft-office/create-hyperlink-field-in-access-2010/