Access 2016 Intermediate

Lesson 7 - Using Advanced Database Features

Access 2016

8. Double-click the desired file.

9. Select . 10. Enter the desired name for the database object.

11. Select

.



Step-by-Step

Export a table to another Access database.

If necessary, display the All Access Objects on the Navigation pane.

Steps

Practice Data

1. Select the database object you want to export. The database object is selected. 2. On the Ribbon select the External Data tab. The External Data tab appears. 3. Select the Access button in the Export group. A list of export options appears. 5. Select the drive where the file to which you want to export is stored. A list of available folders appears. 6. Open the folder where the desired file is stored. A list of available folders and files appears. 4. Select Browse . A list of available drives appears.

Click the Reps table

Click External Data

Click

Click

Click the student data drive

Double-click the student data folder

7. Select the desired file. The file is selected.

Double-click EMPLOYEE.ACCDB

8. Select OK .

Click

The Export Access Database dialog box closes, and the Export dialog box opens.

Page 128

OFFICEPRO, Inc.