Question

For the database the number of items for each category is required to
computed, which query type is required to be used?
(a) Select Query
(b) Group By query
(c) Crosstab Query
(d) Duplicate Query​

Answer 1

From my opinion I like to go with C option

Answer 2

Answer:

The answer to the given question is:

(c) Crosstab Query

Explanation:

To make summary data easier to read and understand in Access, we recommend using a crosstab query. A crosstab query computes a sum, average, or other aggregate function and then groups the results into two sets of values. One is on the side of the table and the other is on top. On the ribbon, click New, and then in the Query group, click Query Wizard. In the New Query dialog box, double-click Cross Query Wizard.

Crosstab queries display summary information in tabular form, making it easy to analyze and compare data. When you run a cross-query, the results are displayed in a data table with a different structure than a different type of table.

#SPJ2