Crosstab Query Wizard:

Select the Record Source

The Crosstab Query can use a Table or Query for the Record Source.

 

3. Try it: Select the Record Source

Select a Table: tblMovies.

 

Click Next. Keep going..

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Create a Crosstab Query

Create ->Queries ->Query Design->Crosstab Query Wizard