Grouping a Data Access Page

A grouped data access page is a hierarchical, interactive Web page in which records are grouped based on the values of a grouping field. When browsed, the page displays values of the grouping field, five records at a time. Each record will have a plus sign (+) button before it. Clicking this button will expand the page to show the complete record for that particular field value.

Group a Data Access Page

Display the data access page in Design view, and then select a field that will act as the grouping value.

Click the Promote button.

Access creates a Group section that contains the group field and a plus sign that allows users to expand and collapse the record.

Remove a Group

Display the grouped data access page in Design view, and then select a grouping field.

Click the Demote button.

Access removes the Group section, placing the grouping field in the Detail section.

Specify Group Options

Display the grouped data access page in Design view.

Click the Group Level Properties list arrow.

Click Group Level Properties.

Change or modify any or all of the grouping properties.

Click the Close button.

Did You Know?

You can create a group with the Page Wizard . Create a group and group your data access page with the Page Wizard. In the second step of the wizard, add a grouping level. You can also specify the grouping options that control how groups are selected.

Common Group Properties

Group Property	Group Property Function
Caption Section	Adds a caption to the Group section.
Group Header	Adds a header to the Group section.
Group Footer	Adds a footer to the Group section.
Record Navigation Section	Displays a record navigation box.
Expanded By Default	Expands the detail section when the browser opens the page.
Data Page Size	Determines the number of records shown at one time.
Group On	Determines the size of each group.
Group Interval	Determines the interval of each group
Default Sort	Sorts fields by group.
Group Filter Control	Specifies a combo or list box to filter the records in the group.
Group Filter Field	Specifies which field to filter the records in the group.