Hello, Linked Tables!

The Linked Tables have a different icon than the Tables that were created in this Database.

 

8. Try it: Review the Linked Tables

Go to All Access Objects->Tables.

Open any Table and review the data.

 

These are "live" connections. Whatever you edit in a Form will change the information in these linked Tables.

 

Each Point of Sale computer in the Front Row Video Store would have a copy of the User interface (Forms, Queries and Reports), FRFORMS.accdb.

 

All of the FRFORMS databases are linked to the same Tables: FRDATA.accdb.

 

This works!!

Get External Data ->Import and Link->Access

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.5. Import data from a single data file: Import data as Linked Tables