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. |