graphic2
graphic1

Share the Data: Export to Excel

Tables, Reports and Queries can be exported to Microsoft Excel so that you can analyze it with a powerful set of Formula and Data Tools.

 

2. Try it: Export to Excel

The tblMovies_Crosstab Query is still open.
Go to External Data
->Export->Excel.

 

Export-Excel Spreadsheet: You will be prompted to Browse for a Folder. The default name for the spreadsheet is the name of the Report in Access. The File format is Excel Workbook (*.xlsx).

 

Click OK to create a spreadsheet.

Keep going...

External Data->Export->Excel

Exam 77-424: Microsoft Access 2013
1.0 Create and Manage a Database
1.5 Print and Export a Database: Export to Alternate Formats (Excel)