DBWebApplications 





Refining Access Queries  «Prev  Next»

Using Total and Crosstab queries - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. Which row is not included in a Crosstab query?
Please select the best answer.
  A. Total
  B. Crosstab
  C. Update
  D. Criteria


2. What do Totals queries allow you to do?
Please select the best answer.
  A. Add records to tables
  B. Provide aggregate functions for specified fields using groups of records
  C. Delete records from tables
  D. Cross-tabulate information from tables

3. Which option do you choose in a Totals query to specify on which field to perform aggregate functions?
Please select the best answer.
  A. Column Heading
  B. Group By
  C. Sum
  D. Row Heading
Score =
Correct answers: