Access 2016 Advanced

Access 2016

Lesson 8 - Using Access and the Internet

Steps

Practice Data

1. In the first row, right-click the hyperlink you want to edit. The shortcut menu appears.

Right-click the shoes, soccer hyperlink

2. Point to Hyperlink .

Point to Hyperlink

The Hyperlink submenu appears.

3. Select Edit Hyperlink... .

Click Edit Hyperlink...

The Edit Hyperlink dialog box opens.

4. Select the item to be changed. The desired item is selected.

Drag to select DISCLIST.XLSX in the Text to display box

5. Modify the link as desired. The item is modified.

Type Team Discounts

6. Select OK .

Click

The Edit Hyperlink dialog box closes, and the new hyperlink appears in the hyperlink column.

Click any cell in the datasheet window to deselect the hyperlink.

D ELETING A H YPERLINK F IELD



Discussion

If a hyperlink becomes invalid, or is no longer needed, it can be deleted. As with editing a hyperlink, you cannot simply double-click a hyperlink to select it.

NOTE Delete a hyperlink by selecting it and pressing the [Delete] key.



Procedures

1. Open the desired table or form in Datasheet view. 2. Point to the hyperlink you want to delete. 3. Right-click the hyperlink you want to delete.

OFFICEPRO, Inc.

Page 91