How to Link Tables in MS Access 2007

by Greg Lindberg

With the Microsoft Office Access 2007 database management application you can import or link to other types of data stored from other databases and applications. For example, if you have a table stored in one database then you can easily link that table into a database you are currently working in. With a table linked you can make any specific changes to the table and directly affect the table in both databases without the need to create two separate copies of the same type of data.

1

Open the Microsoft Access 2007 database on your computer that you want to link data to.

2

Click on the “External Data” tab and then click on the “Access” option from the “Import” group.

3

Click on the “Browse” button and locate the source database that contains the table you want to link.

4

Click on the database and then click on the “Link to the data source by creating a linked table” option. Click on the “OK” button.

5

Select the table you want to link to from the Link Tables dialog box and then click on the “OK” button. The table will then be linked on the database file you have open.

Items you will need

Photo Credits

  • photo_camera Siri Stafford/Digital Vision/Getty Images