Crosstab Query Wizard:

Select the Row Headings

The Column Headings will be shown on the top of the Crosstab layout. The remaining Fields in the Table are available. You can select one Field for the Column Heading.

 

5. Try it: Select the Column Headings

Select a Field: Rating.

 

What Do You See? The sample layout shows the position of the Rating data.

 

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 Wizard->Crosstab Query Wizard