Access 2016 Advanced

Lesson 7 – Exporting Data

Access 2016

E XERCISE

E XPORTING D ATA TO E XCEL AND W ORD



Task

Export Access data.

1. Open EXPORT1X.ACCDB . 2. Export the Invoice table as an Excel workbook named Invoice . 3. Open Excel and the Invoice workbook that was just created. 4. Insert a new worksheet into the workbook and name it Payment . 5. Tile the Access and Excel windows. 6. Drag the Payment table in Access to cell A1 of the Payment worksheet in Excel. 7. Save and close the workbook and Excel. 8. Close the database file.

Page 84

OFFICEPRO, Inc.