Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
To bring in data and objects from another Access database, click on the Access icon in …
The External Data group on the IMPORT ribbon.
The Import group on the GET DATA ribbon.
The Import & Link group on the EXTERNAL DATA ribbon.
To bring a copy of data and objects, as they currently exist, from another Access database into your current Access database, choose:
When tables are imported that have relationships to existing tables in your database:
All relationships have to be defined.
New relationships have to be created to existing tables.
Relationships are automatically created.
When an Access database contains VBA, its content needs to be enabled for Access to take advantage of it. To trust an Access database, use File, Options, then choose Trust Center and click the _________________ command button.
Trust Center Settings