Comma Training Page 244

What is the Plan?

The data analysis will be done with two different approaches: a Crosstab Query that creates a Table array of numbers and a PivotChart that visualizes the same information as a graph.

Create a Crosstab Query: tblMovies_Crosstab

Review the Record Source: tblMovies.

Create a Crosstab Query with the Wizard.

Select Genre for the Row Headings.

Select Rating for the Column Headings.

Export the Records from Microsoft Access

Export to a Microsoft spreadsheet.
Export as a PDF or XPS file.
Export as an attachment to an E-mail message.

Use the Access Tables and Queries in Microsoft Word

Export as a Rich Text document.
Link an Access Query to a Mail Merge in Word.

So, will that work? Let's find out.