Access 2016 Intermediate

Lesson 7 - Using Advanced Database Features

Access 2016

Steps

Practice Data

7. Select OK .

Click

The Get External Data - dialog box closes, and the Link Tables dialog box opens. 8. Select the table containing the source data. The table is selected.

Click Store Location

9. Select OK .

Click

The Link Tables dialog box closes, and the linked table appears in the Navigation pane.

Open the Store Location table in Datasheet view to view its data. Then, close the table.

U SING THE L INKED T ABLE M ANAGER



Discussion

Use the Linked Table Manager to view, refresh, or correct the file name or path of a linked table. If the structure of a linked table changes, for example, use the Linked Table Manager to refresh the link. In addition, if a linked table is moved to a different location, use the Linked Table Manager to correct the path and reestablish the link.

Using the Linked Table Manager

Page 124

OFFICEPRO, Inc.