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