Access 2016 Advanced

Access 2016

Lesson 8 - Using Access and the Internet

C REATING A H YPERLINK F IELD



Discussion

Add hyperlinks to tables by adding a field name and identifying it as a hyperlink data type. Then add hyperlinks to the appropriate column allowing you to jump to objects in the same database, in another database, in other Microsoft Office documents, on the Internet, or on an intranet.



Procedures

1. Open the desired table in Design view. 2. Select the first blank row in the Field Name column. 3. Type the desired field name. 4. Press [Tab] . 5. Select the Data Type list. 6. Select the Hyperlink data type.



Step-by-Step

From the Student Data directory, open HYPERL1.ACCDB . Create a hyperlink field.

Open the Items table in Design view.

Steps

Practice Data

1. Select the first blank row in the Field Name column. The insertion point appears in the first blank row in the column.

Click in the first blank row in the Field Name column

2. Type the desired field name.

Type Linking to

The field name appears in the Field Name column.

OFFICEPRO, Inc.

Page 87