Q1: | Explain the difference between importing and linking. |
A1: | Importing makes a copy of the data, whereas linking causes data to remain in its source location and format. |
Q2: | What is the purpose of the Linked Table Manager? |
A2: | The Linked Table Manager allows you to update broken links. |
Q3: | Name some uses of importing. |
A3: | 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. |
Q4: | Name some uses of linking. |
A4: | 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. |