>Create Hyperlink Field In Access 2010

>


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.

Now we will move to editing Hyperlinks. In Email field, highlight the email address and right-click to select Edit Hyperlink.
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.


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


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.

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

Advertisements

About nonerox

Btech Student
This entry was posted in MS Access, MS Office. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s