1.                   

Open the Northwind Sample Database.

2.                   

Select the Tables object in the Database window and click File à Get External Data à Link Tables. Navigate to the Exercise Files folder, select Microsoft Excel from the Files of Type combo box and then click Link.

3.                   

The first page of the Link Spreadsheet Wizard asks what data it should link. The default settings (Show Worksheets, Sheet1) are fine for our purposes, so click Next.

4.                   

In our case, the first row of data does contain field names. Make sure the check box is selected and click Next.

5.                   

Finally, give the new table a meaningful name; name the table Emergency Contact Information. The sample data you have just linked is emergency contact information for each employee. The Employee field in this table corresponds 1:1 with each EmployeeID field in the Employees table. Click Finish to complete the link.

You will now see a linked Excel file in the Database window:

6.                   

Click the Shippers table in the Database window and open it in Design view.

Add the following information to the row directly beneath the Phone row:

Web Site as the field name, Hyperlink as the Data Type, and enter Web site of each shipper as the Description:

Close the table and save the changes.

7.                   

Open the Shippers table in Datasheet view, and enter www.speedyexpress.com, www.unitedpackage.com, and www.federalshipping.com for Shipper ID’s 1, 2, and 3 respectively.

8.                   

Close the Shippers table, and then close Microsoft Access 2003.