Fill in the blank with the appropriate term.

Fill in the blank with the appropriate term.

A user can use a _________query to calculate a sum, average, count, or other type of total for data that is grouped by two types of information- one down the left side of the datasheet and one across the top.

View Answer

Answer: crosstab

Explanation:

A crosstab query is a powerful analysis tool used to see the relationship of data between two fields. It calculates and restructures data for easier analysis. A user can use a crosstab query to calculate a sum, average, count, or other type of total for data that is grouped by two types of information- one down the left side of the datasheet and one across the top. The cell at the junction of each row and column displays the results of the query’s calculation. This view is just like a spreadsheet with unique values of one field as rows, unique values of another field as columns, and the summary of another field as the cells in the matrix.

Reference: ECDL/ICDL Exam Course Manual, Contents: "Crosstab query"

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design