Unit 9. Crosstab queries (IV)

In this window the wizard asks us the name of the query, this name will also be the title.

Before clicking on the Finish button we can choose between:

View the query in this case we view the result of the query, for example:

or,

Modify the design, if we select this option the Query design view will appear we will be able to modify the definition of the query.

Design view

The design view of a crosstab query is very similar to a summary query with an added row in the grid, the Crosstab: row.

This new row serves to define the concepts that we have seen with the wizard. We do not normally need to change the design, if perhaps the title of the columns.

To practice you can perform Step by step creating crosstab queries.

Unit 9 exercise.

  Unit 9 evaluation test.

Page. 9.4