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…

Question

Options

• AFind Unmatched
• BSimple
• CCrosstab
• DFind Duplicates

• A
  5% (3)
• B
  6% (4)
• C
  78% (50)
• D
  11% (7)

Explanation

The various types of the Query wizard are as follows: 1.Simple: It is used to set up a query in order to retrieve data from one or more tables and display the results in a datasheet. 2.Find Duplicates: It is used to set up a query in order to locate records. These records contain the same data in one or more specified fields. 3.Find Unmatched: It is used to set up a query in order to locate records in a single table. These records do not contain any related record in 4.Crosstab: It is used to set up a query in order to calculate and re-organize information for making the analysis easy.

No community discussion yet for this question.