Create a Crosstab Query: tblMovies_Crosstab A Crosstab Query creates a Table that compares the data. In this example, we can use the Crosstab Query to count how many movies we have in each Rating.   2. Try it: Create a Query Go to Create ->Queries ->Query Wizard. You will be prompted to select which Query Wizard you would like to launch.   There are four Query Wizards: Simple Query Wizard Crosstab Query Wizard Find Duplicates Query Wizard Find Unmatched Query Wizard   Select a Wizard: Crosstab Query Wizard. Click OK. The Query Wizard should start. Create ->Queries ->Query Wizard->Crosstab Query Wizard Exam 77-885: Microsoft Access 2010 4. Creating and Managing Queries 4.1. Construct queries: Create a Crosstab Query