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

graphics/1_icon.jpg

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

graphics/2_icon.jpg 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.

graphics/10inf16.jpg

Remove a Group

graphics/1_icon.jpg

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

graphics/2_icon.jpg Click the Demote button.

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

graphics/10inf17.jpg

Specify Group Options

graphics/1_icon.jpg

Display the grouped data access page in Design view.

graphics/2_icon.jpg

Click the Group Level Properties list arrow.

graphics/3_icon.jpg

Click Group Level Properties.

graphics/4_icon.jpg

Change or modify any or all of the grouping properties.

graphics/5_icon.jpg

Click the Close button.

graphics/10inf18.jpg

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.




Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net