Report Grouping (Grade 12 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What is the main advantage of using report grouping in a database?
What is the main advantage of using report grouping in a database?
Data becomes easier to read and analyse
Where do you find the Report Wizard in Microsoft Access?
Where do you find the Report Wizard in Microsoft Access?
In the Create tab on the ribbon
Which step in the Report Wizard is described as the most crucial for grouped reports?
Which step in the Report Wizard is described as the most crucial for grouped reports?
Step 4: Set up grouping
How many different sorting criteria can you set up in the Report Wizard?
How many different sorting criteria can you set up in the Report Wizard?
Up to four
Which layout option is good for making comparisons in a report?
Which layout option is good for making comparisons in a report?
Tabular
What typically appears in a group footer?
What typically appears in a group footer?
Summary calculations like totals
Which calculation function finds the largest value in a group?
Which calculation function finds the largest value in a group?
MAX
What must all Access formulas start with?
What must all Access formulas start with?
An equals sign (=)
Where should you place a calculation textbox to calculate for one specific group only?
Where should you place a calculation textbox to calculate for one specific group only?
In the group header or footer
What does 'Summary Only' display in Summary Options?
What does 'Summary Only' display in Summary Options?
Only group calculations, no records