Access 2016 Intermediate

Access 2016

Lesson 7 – Using Advanced Database Features

NOTE The Linked Table Manager does not physically move database files or tables; it only refreshes or corrects the link information. If you change the name of a table after it is linked, the Linked Table Manager will not be able to refresh the links. In this case, you must delete the link and create a new one.



Procedures

1. On the External Data tab in the Import & Link group, select Linked Table Manager . 4. Select the linked table you want to update.

5. Select . 6. Select the drive where the file is stored. 7. Open the folder where the file is stored. 8. Select the name of the file containing the linked table.

9. Select

.

10. Select

.

11. Select

.



Step-by-Step

Use the Linked Table Manager to correct the path of a linked table.

Steps

Practice Data

1. On the External Data tab in the Import & Link group, select Linked Table Manager . The Linked Table Manager opens, displaying all linked tables with their corresponding paths. 2. Select the linked table you want to update. The table is selected.

Click

Click

Packing Slip

OFFICEPRO, Inc.

Page 125