SECTION 5
Lesson 1.5: Linking Files

   

 

 

A hyperlink is a special type of object that, when clicked, will direct you to some other file, object, or resource. For example, the Northwind Sample Database contains a Shippers table containing the name and phone number of shipping companies that distribute Northwind’s products:

 

 

Let’s insert another field into this database, a hyperlink to each shipper’s Web site. First, open the table in Design view. Then, enter WebSite as the field name, and choose Hyperlink from the Data Type combo box. We will also add a description of what this field is for:

 

 

Now that the data field is made, switch back to Datasheet view and enter the website of each shipping company:

 

 

To visit the Web site specified by the hyperlink, just click on the link while in Datasheet view or when the link is visible in a form or report. Your default Internet browser will launch and take you to the Web site.