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