Microsoft Office Tutorials and References
In Depth Information
Design for the Member table
Caption = Member ID
Caption = Program ID
Caption = First Name
Caption = Last Name
Format = Short Date
Caption = Date Joined
Date when membership expires
Format = Short Date
Caption = Expiration Date
Active, Inactive, or On Hold
Caption = Membership Status
8. Save the Member table. Click the Yes button when a message appears indicating
some data might be lost.
9. The Default Value property for a ﬁ eld allows you to specify the value that should
be entered, by default, for that ﬁ eld for each new record you enter in the table.
Specifying a default value can save you time if most of the records you enter will
include that value for the ﬁ eld. Set the Default Value property for the Status ﬁ eld to
"Active" (including the quotation marks). Save and close the Member table.
10. Open the Member table in Datasheet view and conﬁ rm that the InitiationFeeWaived
ﬁ eld was removed from the table. If not, open the table in Design view again, repeat
the step to delete the InitiationFeeWaived ﬁ eld, and then save and close the table.
11. Add the records shown in Figure 2-52 to the Member table. ( Hint : Use the New
button in the Records group on the Home tab to add a new record.) Be sure to enter
your ﬁ rst and last names in the appropriate ﬁ elds for the ﬁ rst new record added.
Note the default ﬁ eld value of “Active” in the Membership Status column as you
enter the new records.
Records for the Member table
Member ID Program ID First Name Last Name
40 Green Boulevard
25 Fairway Drive
12. Resize columns in the datasheet to their best ﬁ t (as necessary), and then save and
close the table.
13. Deﬁ ne a one-to-many relationship between the primary Program table and the
related Member table. Select the referential integrity option and the cascade updates
option for this relationship.
14. Save the changes to the Relationships window and close it, compact and repair the
Fitness database, and then close the database.