graphic1

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

Crosstab Query Wizard:

Select the Row Headings

The Row Headings will be shown on the left side of the Crosstab layout. All of the Fields in the Table are available. You can select more than one Field if you wish.

 

4. Try it: Select the Row Headings

Select a Field: Genre.

 

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

 

Click Next. Keep going...

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