Share the Data: Export Records
Everything
in Access starts and ends with the data. The information in the Crosstab Query is calculated live each time the query is run. This is great data but how do you share this information with people who do not have Microsoft Access?
Also, what are the options for using Access Tables and Queries in Microsoft Excel, Word or Outlook?
1.
Try it: Review the Ribbon
The tblMovies_Crosstab Query is still open.
Go to
External Data.
What Do You See? The Export options are:
Saved Exports
Excel
Text File
XML File
PDF or XPS
Email
Access
Mail Merge
More
Keep
going...