Back to lesson
1. To bring in data and objects from another Access database, click on the Access icon in …
The Import group on the GET DATA ribbon.
The External Data group on the IMPORT ribbon.
The Import & Link group on the EXTERNAL DATA ribbon.
2. To bring a copy of data and objects, as they currently exist, from another Access database into your current Access database, choose:
3. When tables are imported that have relationships to existing tables in your database:
Relationships are automatically created.
All relationships have to be defined.
New relationships have to be created to existing tables.
4. 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
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement