In MS Access, a query that groups data and calculates sums, averages, or counts is known as: MCQ with Answer and Explanation

Question
In MS Access, a query that groups data and calculates sums, averages, or counts is known as:
A. Crosstab query
B. Totals query
C. Parameter query
D. Select query
Answer: Option B
Solution (By JKSSB Mock Tests)
A Totals query (using Group By, Sum, Avg, etc.) aggregates data. Crosstab query also aggregates but in a cross-tab format.
This question belongs to: Computer Microsoft Office
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In MS PowerPoint, which of the following is used to add a chart?
A. Insert > Shapes
B. Insert > Table
C. Insert > Chart
D. Insert > SmartArt
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Chart is under Insert > Chart.
This question belongs to: Computer Microsoft Office
Question #2
In MS Access, which of the following is NOT a valid section in a report?
A. Navigation Pane
B. Page Header
C. Detail
D. Report Footer
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Navigation Pane is an interface element, not a report section. Sections include Report Header, Page Header, Group Header, Detail, Group Footer, Page Footer, Report Footer.
This question belongs to: Computer Microsoft Office
Question #3
Which features in MS Word are used to divide a single document into separate formatting zones for columns, page numbering styles, or custom margins?
A. Page Breaks
B. Paragraph Indents
C. Style Sets
D. Section Breaks
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Section breaks allow you to isolate and apply different layouts, headers, footers, and structural configurations within the same document.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Cyber Security 269 Computer Abbreviations 369 Operating Systems 510 Computer Software 347 CPU (Central Processing Unit) 327
Explore Subjects
Accountancy and Statistics 3179 Science 4430 Computer 5279 History GK 3374 Current Affairs 575
Practice Mix
The receipt ______ they gave is fake.
Identify the error: 'He is the most young of the team.'
Which view in PowerPoint displays thumbnails of all slides for easy rearrangement?
A sum of money at compound interest doubles in 5 years. In how many years will it become 4 times?
Which of the following is an example of educational software?