Database Reference
In-Depth Information
TIP
Displaying a subdatasheet is only possible if a relationship has been established
between two tables. For information about relationships, see “Defining relationships
between tables” in Chapter 2, “Create databases and simple tables.”
7
To the left of the record for the
Bulbs
category, click the
Collapse
button (the minus
sign) to hide the subdatasheet.
1
8
Click the
Close
button at the right end of the page tab bar (not the
Close
button in
the upper-right corner of the program window) to close the
Categories
table.
9
Close the
Products
table, and when Access asks whether you want to save your
changes to this table, click
Yes
.
TIP
In steps 3 and 4, you changed the look of the table by changing the widths of
columns. If you want those changes to be in effect the next time you open the table,
you must save them.
Next let's use a table containing order-fulfillment information to practice moving
among records.
10
In the
Navigation
pane, double-click the
Orders
table.
The record navigation bar at the bottom of the window indicates that this table contains
87 records, and that the active record is number 1 of 87.
11
On the record navigation bar, click the
Next record
button several times to move the
selection down the active
OrderID
field.