A(n)____ query performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format.
A)aggregate
B)function
C)crosstab
D)Both A and B

Question

Quizplus · Accepted Answer

A crosstab query is the type of query that performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format. This type of query allows you to summarize and analyze data in a way that is easy to read and understand, making it a useful tool for decision-making and reporting. Options A and B are incorrect because while they are elements of a crosstab query, they do not fully describe what a crosstab query is or does.

A(n)____ Query Performs Aggregate Function Calculations on the Values of One