Question

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

Use more than one table or query as a record source.
Use an expression to create fields.
Display data grouped by category.
Add a parameter prompt.

Answer 1

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

Step-by-step 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".