لطفا منتظر باشید ...
Creating Grouped Data Access Pages
Grouping records on a data access page is similar to grouping records on a report. Grouped data access pages have the following advantages over grouped reports:
- Current data is always displayed within the data access page.
- Unlike reports, data access pages are interactive. This means that, using a grouped data access page, a user can filter, sort, and view just the records she wants.
- When grouped data access pages are sent via email, the recipient is presented with current data each time he opens the message.
To create a grouped data access page, follow these steps:
Figure 26.34. To create a grouped data access page, first select fields from multiple tables.
Figure 26.35. The data access Page Wizard allows you to designate the fields in which the data is grouped.
The resulting page appears in Figure 26.36. As you can see, the data automatically appears collapsed. Furthermore, only one project name (the one side of the relationship) appears at a time. Finally, because the data is derived from multiple tables, the resulting data access page is not editable. Fortunately, all these aspects of a grouped data access page are easily modified via properties of the group.
Figure 26.36. A grouped data access page shows the data collapsed while displaying only one group at a time.
To access the properties of a group, you must right-click the group and select Group-Level properties. Figure 26.37 shows the properties of the group. When you set the ExpandedByDefault property to Yes, Access automatically displays the data within a grouping (see Figure 26.38). The DataPageSize property allows you to designate the maximum number of records to show at a time for a particular grouping level. In Figure 26.39, the DataPageSize property of the second-level grouping is set to 3. This means that up to three detail records appear within each grouping level.
Figure 26.37. Using the properties of a group, you can control group attributes.
Figure 26.38. The ExpandedByDefault property of a group allows you to designate whether data at a group level automatically appears in an expanded format.
Figure 26.39. The DataPageSize property of a group allows you to designate the maximum number of detail records that appear at a time within a particular group.
The UniqueTable property designates the editable table in a page based on multiple tables. You can find the property in the Header properties for the detail section of the page (see Figure 26.40). Enter the name of the table whose data you want to edit. In Figure 26.40, the Orders table is designated as the unique table.
Figure 26.40. To render data in a page based on multiple tables as editable, you must designate a unique table.
