Asked by Ansley Bailey on Apr 26, 2024
Verified
To create a _____,you add the Total row to the query design grid to specify how to group and perform calculations on the records.
A) select query
B) subtotal query
C) statistics query
D) summary query
Subtotal Query
A database query that generates a subtotal of aggregated data based on specified criteria, often used in reporting and analysis.
Query Design Grid
A graphical user interface in database software that assists users in building queries by defining fields, sort orders, and criteria visually.
Summary Query
A database query that aggregates data, such as summing numbers or counting occurrences, to provide a summary rather than detailed records.
- Attain insight into the process of totaling and calculating statistical figures within query datasheets and tables.
Verified Answer
DB
Dijubert BerthonMay 03, 2024
Final Answer :
D
Explanation :
To create a summary query, you add the Total row to the query design grid. This allows you to specify how to group and perform calculations on the records, summarizing the data.
Learning Objectives
- Attain insight into the process of totaling and calculating statistical figures within query datasheets and tables.