Question

Which of the following statement is wrong about crosstab query?

• A. We can use a crosstab query to analyze information that you retrieved
• B. We can use a crosstab query to group data only in rows
• C. We can also use a crosstab query to calculate the sum or the average of a data group
• D. None of these

Answer 1

Answer:

B. We can use a crosstab query to group data only in rows

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.