Advanced Features  «Prev  Next»
Lesson 6 Create a grouping style Data Access Page
Objective Use the Page Wizard to create a grouped page.
A grouping style data access page lets you see different levels of detail for related records. For example, you can list all the projects for each of the clients in the Consulting407.mdb. A grouping style report is shown in this figure:
Grouping style report
Grouping style report
You can create a grouping style page almost as easily as creating a data entry page. You just need to specify the field you would like to group.
Once the page has a grouping specified, you will not be able to use it for data entry.
To create a grouping style page, you will need to specify the following:
  1. The record source in which to bind the page
  2. The fields you want to display or update
  3. Which fields you want to group.
  4. What sort order you want to use

You can add different grouping levels by selecting fields from various record sources.
The steps are basically the same as creating a data entry style page with a couple of changes. You can pick fields from multiple record sources and specify groupings. Also like the data entry style page, you can pick a theme for your grouping style page as well.
The next lesson is the module conclusion. You will get a brief review of the topics you have covered in this module. Also, you can take a quiz that will help you verify what you have learned and discover topics that you might want to review in a more detailed manner.

Work With Grouped Data - Access Page
Click the Exercise link below to practice using the wizard to create a grouped data access page.
Work With Grouped Data - Access Page