Report Grouping (Grade 12 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Definition of report grouping
Definition of report grouping
Organising data in structured format by specific categories
Where to find Report Wizard in Access
Where to find Report Wizard in Access
Create tab in the ribbon
Most crucial step in Report Wizard for grouping
Most crucial step in Report Wizard for grouping
Step 4 - setting up grouping levels
Maximum sorting criteria in Report Wizard
Maximum sorting criteria in Report Wizard
Four different sorting criteria
Two page orientation options in Access reports
Two page orientation options in Access reports
Portrait (tall) or Landscape (wide)
Where group headers appear in a report
Where group headers appear in a report
At the start of each new group
What group footers typically contain
What group footers typically contain
Summary calculations like totals, averages, and counts
Calculation types available in Access (name 3)
Calculation types available in Access (name 3)
SUM, AVERAGE, COUNT, MIN, MAX
Required structure for Access formulas
Required structure for Access formulas
Starts with = and uses [square brackets] around field names
Effect of textbox placement in group vs report footer
Effect of textbox placement in group vs report footer
Group footer: that group only; Report footer: all data