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.
Made with FlippingBook - professional solution for displaying marketing and sales documents online