So far, you have seen how to create simple data access pages. We will now delve into some more complex aspects of data access pages. These include grouping and using pages based on data from multiple tables.
It is easy to add groupings to the data access pages that you build. Here are the steps involved:
Select Pages in the list of objects.
Double-click to create a new page in Design view.
Click OK when prompted with the warning message.
Display the Field List, if it is not already visible.
Select the CustomerID, CompanyName, ContactName, ContactTitle, Phone, and Fax fields (see Figure 22.23).
Figure 22.23. Select the CustomerID, CompanyName, ContactName, ...