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
Made with FlippingBook - Online magazine maker