Q&A

Explain the difference between importing and linking.

Importing makes a copy of the data, whereas linking causes data to remain in its source location and format.

What is the purpose of the Linked Table Manager?

The Linked Table Manager allows you to update broken links.

Name some uses of importing.

You might use importing when you are migrating a system to Access or when you want to run a series of reports on data that is stored in another format.

Name some uses of linking.

You might use linking if the data for a system is used by a legacy application, it resides on a database server (for example, SQL Server), or you will access the data on a regular basis.