Which of the following types of Access queries performs operations on the records that match specified criteria?

Which of the following types of Access queries performs operations on the records that match
specified criteria?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


jean

jean

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.