Asked by Jessica Tufts on Jun 11, 2024
Verified
A _____ query in a real estate database could list property types as row headings, number of bedrooms as column headings, and the count of each property type as values.
A) select
B) grouped
C) crosstab
D) calculated
Crosstab Query
A query type that aggregates data based on two or more fields and displays it in a tabular form, often used to create matrix reports.
Property Types
Categories or characteristics of properties in programming or real estate, specifying their data type, value range, or physical attributes.
Row Headings
The labels along the left side of a spreadsheet or table that typically indicate the number or name of each row.
- Gain insight into the organization and effectiveness of crosstab queries, taking account of the arrangement of row and column headings, as well as the adjustment of value parameters.
Verified Answer
YH
Youssef HatimJun 15, 2024
Final Answer :
C
Explanation :
A crosstab query is used when we want to display data in a matrix format, similar to a spreadsheet. In this case, the property types would be the rows, number of bedrooms would be columns, and the count of each property type would be the values.
Learning Objectives
- Gain insight into the organization and effectiveness of crosstab queries, taking account of the arrangement of row and column headings, as well as the adjustment of value parameters.