Database Splitter Results

The Database Splitter created a new database just for the Tables. The Forms, Queries, Reports and Macros are still in the database you opened.

The linked Tables were saved to a new database.


3. Try it: Review the Linked Tables
FrontRowVideo11.accb. is still open.

Go to External Data ->Import and Link.
Click on Linked Table Manager.
 

What Do You See? Review the location for the linked Tables. In this example, the Tables can be found in FrontRowVideo11_be.accb. Access appended "_be" to the name of the Tables database when it was saved.

 

Click Cancel to close the Linked Table Manager.

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.5. Import data from a single data file: The Database Splitter

External Data ->Import and Link->Linked Table Manager