Programs: Microsoft Access:  Chapter 3, Lesson 4


Lesson 4

Grouping Records

OBJECTIVES

-Learn how to organize records in a report by grouping them.
  1. Design View for Grouping
  2. Types of Functions
Objective # 1 Design View for Grouping

Group Header
  • Involves a single bound control, which groups the state people live in before each group of records.
  • Look Left.
Detail Section
  • Has bound controls shown right under the heading it relates to in the page header.
  • Look Left.
Group Footer
  • Shown after each group of records.
  • It involves bound and calculated controls.
  • Not displayed in the diagram, but may be inserted if a person wishes.
  • Look Left.
Page Footer
  • Appears near the end of hte report and displays the date, page number, and total number of pages in the report.
  • Look Left.
Report Footer
  • Consists of an unbound control and a calculated control.
  • Look Left.
Objective # 2 Types of Functions
Avg Function
  • Averages a field of records in a group.
Sum Function
  • Adds up a field of records in a group.
Min Function
  • Figures out the lowest value in a field of records in a group.
Max Function
  • Figures out the highest value in a field of records in a group.
Count Function
  • Counts the records in a field in a group.

Lesson Review

You learned how to....
  • Group Records
  • Use the different types of functions
 

back to lesson #3

continue to lesson #5

back to menu 


Programs: Microsoft Access:  Chapter 3, Lesson 4