You have a datasheet named Datasheet1 created in Microsoft Office Access 2010. You need to
calculate the sum, average, and count for dat
A.
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?
Find Unmatched
A.
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?
Find Unmatched
B.
Simple
C.
Crosstab
D.
Find Duplicates
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
another table.
4.Crosstab: It is used to set up a query in order to calculate and re-organize information for making
the analysis easy.