Which of the following types of Access queries performs operations on the records that match
specified criteria?
A.
Parameter query
B.
Select query
C.
Action query
D.
Crosstab query
Explanation:
The different types of queries in Microsoft Access 2010 are as follows:
1.Select query: It retrieves and displays records in the Table window in Datasheet view.
2.Crosstab query: It calculates and restructures data for easier analysis.
3.Action query: It performs operations on the records that match specified criteria.
4.Parameter query: It allows a user to prompt for a specific information to use as selection criteria in the query.
An action query is a query that makes changes to or moves many records in just one operation. There are four types of action queries: delete, update, append, and make-table.