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:
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:
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.
Click the Exercise link below to practice using the wizard to create a grouped data access page.
Work With Grouped Data - Access Page