Access 2016 Advanced

Lesson 8 – Using Access and the Internet

Access 2016

Steps

Practice Data

3. Press [Tab] .

Press [Tab]

The insertion point appears in the Data Type column and an arrow appears to the right of the field.

4. Select the Data Type list.

Click Data Type

A list of available data types appears.

5. Select the Hyperlink data type.

Click Hyperlink

The Hyperlink data type appears in the Data Type column.

Close and save the table.

I NSERTING A H YPERLINK F IELD



Discussion

Insert a hyperlink in a field in a table or form. However, the field data type must be Hyperlink . The default settings display a new hyperlink in blue underlined text and a followed hyperlink (one that has been used) in purple underlined text. When you click the label, the hyperlink path opens the specified location. The file at the end of the path can be a web page for company headquarters in Los Angeles, or a file located on your hard drive. For example, in the header of an Annual Sales Report, insert hyperlink labels that, when activated, open related spreadsheets, such as a Quarterly Sales Report for that year. Another example is to create a hyperlink label for a Product field on a form that jumps to a listing of products on your supplier’s web page.

Hyperlink labels in forms or reports must contain a viable path, but the path itself does not need to appear on the label. As with hyperlink fields, you can display a label with descriptive text rather than the actual path.

When you point to a hyperlink, the mouse pointer changes into a hand pointing upward, signifying that one mouse click activates the hyperlink.

Page 88

OFFICEPRO, Inc.