Which of the following types of Query wizard will you use to accomplish the task?

You have a datasheet named Datasheet1 created in Microsoft Office Access 2010. You need to calculate the sum, average, and count for data. This data is grouped by two types of information, one down the left side of the datasheet and another across the top of the datasheet. You want to display the results of the query’s calculation in the cell at the junction of each row and column .

Which of the following types of Query wizard will you use to accomplish the task?
A . Crosstab
B . Find Duplicates
C . Simple
D . Find Unmatched

View Answer

Answer: A

The various types of the Query wizard are as follows: