Question

Which of the following types of queries are action queries?

• A. Parameter query
• B. Crosstab query
• C. Append queries
• D. None of these

Answer 1

Answer:

C. Append queries

 

 Append Query

•  An Append Query is an action query (SQL statement) that adds records to a table. An Append query is often referred to as an Insert Query because the SQL syntax uses the INSERT INTO command.

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

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.