Question

Find out the odd one?

• A. Select query
• B. Parameter query
• C. Action query
• D. Data query

Answer 1

Answer:

D. Data query

Query

• A query is an instruction to retrieve information from a table based on specific criteria
• We can also use a query to modify the information that we retrieve
• In access , we can categorize queries as follows:

select query

• A select query retrieves information that we want from one or more tables in a database
• We can also use a select query to group records and to calculate sums , counts average and other types of mathematical values
• The select query can also do string manipulation.

Parameter query

• A parameter query retrieves information in an interactive manner
• We can use a parameter query to extend the flexibility of other query types

Action query

• An action query performs an action on data in a table
• We can use an action query to insert new records , to update existing records , or to delete existing records

Crosstab query

• We can use a crosstab query to analyze information that you retrieved
• We can use a crosstab query to group data in rows or in columns
• We can also use a crosstab query to calculate the sum or the average of a data group
• SQL -specific queries , such as the union query , the pass through query , and the data definition query
• However ,Access does not provide a graphical user interface that we can use to create an SQL-specific query.