|The next type of query is
the crosstab query. Point out to the
students how this one differs from the select query. This is a more powerful tool because it
consolidates material data from a table and presents it in row, column
form. The crosstab query uses
calculations to group the data which is then places in the table where it
coincides with the values on the left and top of the table.