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
Made with FlippingBook - Online magazine maker