graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.1 Create a Query: Create Crosstab Queries (Select the Column Headings)

Crosstab Query Wizard:

Select the Column 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...

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