Access 2016 Advanced

Lesson 7 – Exporting Data

Access 2016

Steps

Practice Data

8. Select OK .

Click

Access exports the data to Excel.

Click Close , if necessary, to close the Export - Excel Spreadsheet dialog box.

Open the REPS.XSLX workbook in Excel. Close the workbook and Excel.

S AVING E XPORT S ETUP



Discussion

When exporting data , it is possible to save the export steps. This allows you to quickly repeat the export operation without using the wizard.

After completing the export operation, the Save Export Steps screen opens. If you choose to save the export steps, enter a name for the export operation or accept the default name suggested by Access. You can also add a description of the export operation, if desired.

NOTE If you regularly repeat the saved export operation, create an Outlook task that reminds you when it is time to repeat the operation.

D RAGGING AND D ROPPING D ATA INTO E XCEL



Discussion

You can drag and drop data from Access into Excel. For example, you can drag and drop tables and queries from Access and place them in a workbook in Excel. The drag and drop method is very useful when you are building information in an Excel workbook and want to use data from an Access database file in the workbook. When you drag and drop data from Access to Excel, it is best to display the two program windows side-by-side on the desktop.

Page 80

OFFICEPRO, Inc.