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

Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited. April-2006.