Question

a query grouped in categorises a simple query
Cross tab a and b both. none of these​

Answer 1

Answer:

To make summary data in Access easier to read and understand, consider using a crosstab query. A crosstab query calculates a sum, average, or other aggregate function, and then groups the results by two sets of values— one set on the side of the datasheet and the other set across the top. On the ribbon, click Create, and then in the Queries group, click Query Wizard. In the New Query dialog box, double-click Crosstab Query Wizard.

If one set of headings has date values, the wizard will help you group the records by standard intervals – such as months or quarters.

Explanation: