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

The correct answer is C. Action query. 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…

Create and manage queries

Question

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

Options

AParameter query
BSelect query
CAction query
DCrosstab query

How the community answered

(50 responses)

A
4% (2)
B
6% (3)
C
76% (38)
D
14% (7)

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

Topics

#action query#query types#record operations#DML

Community Discussion

No community discussion yet for this question.

Full 77-885 Practice