Using Total and Crosstab Queries - Quiz Explanation
The answers you selected are indicated below, along with text that explains the correct answers.
1.
Which row is not included in a Crosstab query?
Please select the best answer.
A.
Total
B.
Crosstab
C.
Update
D.
Criteria
The correct answer is C.
A, B, and D are incorrect because the Total, Crosstab, and Criteria rows are included in Crosstab queries. Choice C is correct because an Update row is used only in an Update action query.
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
The correct choice is B
, provide aggregate functions for specified fields using groups of records.
Choice A is incorrect because adding records to tables is the job of the Append query. Choice C is incorrect because it is talking about a Delete query. Choice D is incorrect because cross-tabulation is the job of the Crosstab query.
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
The correct choice is B
, the Group By option. This option tells Access to perform whatever aggregate function you pick in other columns based on the field specified with the Group By.