Access 2016 Intermediate

Lesson 7 - Using Advanced Database Features

Access 2016

L INKING D ATA TO AN A CCESS T ABLE



Discussion

You can link to an external data source, such as another Access database or a database created in a different program (e.g., dBASE or Excel). You can also link to HTML data tables on a network server or on the Internet.

When you link to an external data source, the data format in the data source does not change, although you can use Access to add, edit, or delete the data.

A linked table displays a special icon in the Database window. A table linked to another Access database has an arrow to the left of the icon. A table linked to a source created in a different program displays an arrow and the initials of the source program (e.g., Px for Paradox).

Linking tables is useful when you want to share data on a network. If you link to a table on a network, the link ensures that the data you are viewing is always the latest available.

NOTE When you delete a linked table, you are deleting the icon and the link to the source table, not the source table itself.



Procedures

1. Select the External Data tab.

2. In the Import & Link group, select the New Data Source button

.

3. From the drop-down list, select From Database then select Access

.

4. Select . 5. Select the drive where the source data is stored. 6. Open the folder where the source data is stored. 7. Select the file containing the source data. 8. Select the desired link option.

Page 122

OFFICEPRO, Inc.