Access 2016 Intermediate

Lesson 6 - Using Advanced Query Wizards

Access 2016

U SING THE C ROSSTAB Q UERY W IZARD



Discussion

Crosstab queries are used to group and summarize information in a spreadsheet format. Crosstab queries make it easier to read and analyze selected data. The Crosstab Query Wizard provides a step-by-step process to help you quickly create a crosstab query, allowing you to enter information about the tables and fields you want to add to the query.

Three fields are required in a crosstab query. The values in the first field appear as row headings in the resulting spreadsheet, the values in the second field appear as column headings, and the calculation is performed on the values in the third field.

A crosstab query can display, for example, products sold (row headings) by sales representative (column headings); the number of products sold by each sales representative appear at the intersection of the corresponding row and column.

A crosstab query recordset

NOTE Select the field with the fewest values for the column headings; the resulting spreadsheet will be less cluttered.

Page 106

OFFICEPRO, Inc.