Access 2016 Advanced

Access 2016

Lesson 7 – Exporting Data

5. Locate the folder and file to which you want to export.

6. Select . 7. Select further export options.

8. Select

.



Step-by-Step

From the Student Data directory, open EXPORT1.ACCDB . Export Access data to an Excel workbook.

If necessary, display All Access Objects in the Navigation Pane.

Steps

Practice Data

1. Select the data source you want to export. The data source is selected. 2. On the External Data tab in the Export group select the Excel button The Export - Excel Spreadsheet dialog box appears. 3. Select the desired file format in the File format box. The desired file format is selected.

Click Reps table

Click

Select Excel Workbook (*.xlsx)

4. Select Browse .

Click

A list of available drives appears.

5. Locate the folder and file to which you want to export. A list of available folders appears.

Click the student data drive and student data folder

6. Select Save .

Click

The Save dialog box closes, and the desired destination folder appears in the File name field.

7. Select further export options. The desired export options are selected

Click

Export Data with

formatting and layout

OFFICEPRO, Inc.

Page 79