|
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.
Create aPivotChart based on tblMovies.
Add a PivotChart to the
Movies by Genre Report
Modify the Report Header of an existing Report, .
Add the
PivotChart to the Report Header as an Unbound Subform/Subreport.
When the Report is in Print Preview, we will practice
exporting the data into several file formats that can be shared and
sent by E-mail.
So, will that work? Let's find out.
|
|
| |
