Microsoft Office Professional 2010 Step by Step eBook

770 Chapter 25 Explore an Access 2010 Database

4. In the Navigation pane, double-click Categories.

The Categories form opens on its own tabbed page. This form includes a main form

and a subform. The main form displays information from the Categories table, and

the subform, which looks like a datasheet, displays information for the current record

from the Products table.

Subform

This form is the interface for the Categories and Products tables.

5. On the record navigation bar, click the Next Record button a few times to display
   the next few records.
   Notice that the subform changes with each click to display the products in each
   category.