Question

Which action is performed by crosstab queries and can be handled by creating a query using the Crosstab Query wizard?

Answer 1

Answer:

The correct option is "Display data grouped by category".

Explanation:

A crosstab query displays the similar data but organizes it horizontally and vertically in order to ensure that the datasheet is more compact and easy to read.

The crosstab query generates a total, average, or other aggregate function. The results are grouped by two sets of values: one on the datasheet's side and the other across the top.

If one set of headers contains date data, the wizard will guide you through the process of grouping the entries by conventional intervals such as months or quarters.

Therefore, the action that is performed by crosstab queries and can be handled by creating a query using the Crosstab Query wizard is "display data grouped by category".