Before you actually learn how to create a page, let's look at a few and compare them to forms and reports . Northwind (the sample database that comes with Access) has a few pages we can use to demonstrate their design.
Launch Northwind (close the opening splash screen and close the switchboard forms if necessary). Click the Pages shortcut on the Database window's Object bar, and Access displays a list of page objects. Hover the mouse pointer over any part of the page objects list. You'll notice that Access displays a ScreenTip that contains the name of the page, as shown in Figure 10.1. Access doesn't do this for other objects.
Figure 10.1. Access displays the page object's name in a ScreenTip.
Did you also notice that the object name contains a .htm extension? That's because a page object is really an HTML file. Unlike other Access objects, Access doesn't actually store page objects in the MDB file. The items listed in the Database window are shortcuts ( hyperlinks ) to the HTM files stored outside the MDB file.
Now, double-click the Review Products page to open it. Then, click the Maximize button so you can view more of it. This page lists all the products in alphabetical order, but they're grouped by their first letters . When you first open the page, it doesn't show any products. Click the arrow next to the letter A .
Figure 10.2 shows the result of clicking this control, called an expand/collapse control . After expanding a section, the arrow points down. To hide, or collapse , a section, simply click the arrow again.
Figure 10.2. Click the arrow next to the letter A to display products that begin with that letter.
After you expand a group, you can see that a page can be similar to a grouped report. In this case, each group consists of the products that begin with a common letter. A group heading of labels describes the data, and just below it, the group displays the actual data.
As is, this page only displays data without letting you change it. That means, even if you viewed it in a Web browser, that's all you'd be doingviewing data. It's a read-only object, and as such, you can't modify the actual product records in the Northwind database.
Comparing Forms, Reports, and Pages
The page object is similar in look and purpose to both the form and the report objects. Table 10.1 compares the three objects.
Table 10.1. Features of Forms, Reports, and Pages