Microsoft Office Professional 2010 Step by Step eBook

764 Chapter 25 Explore an Access 2010 Database

The Categories table opens on a new tabbed page in Datasheet view. The Categories

page is active, but the Products page is still open and available if you need it.

5. At the left end of the record for the Bulbs category, click the Expand button.

The Bulbs category expands to reveal a subdatasheet containing all the records

from the Products table that are assigned to the Bulbs category. This is possible

because a relationship has been established between the two tables.

Subdatasheet

You can display records from two related tables simultaneously.

See Also For information about relationships, see “Creating Relationships Between

Tables” in Chapter 26, “Create Databases and Simple Tables.”

6. To the left of the record for the Bulbs category, click the Collapse button to hide
   the subdatasheet.


7. Click the Close button at the right end of the tab bar (not the Close button in the
   upper-right corner of the program window) to close the Categories table.


8. Close the Products table, and when Access asks whether you want to save your
   changes to this table, click Yes.