Microsoft Office Tutorials and References
In Depth Information
Case Problems
Figure 2-51
Design for the Member table
Field Name
Data Type
Description
Field Size
Other
MemberID
Text
Primary key
4
Caption = Member ID
ProgramID
Text
Foreign key
3
Caption = Program ID
First
Text
18
Caption = First Name
Last
Text
18
Caption = Last Name
Street
Text
30
City
Text
24
State
Text
2
Zip
Text
10
Phone
Text
14
DateJoined
Date/Time
Format = Short Date
Caption = Date Joined
Expiration
Date/Time
Date when membership expires
Format = Short Date
Caption = Expiration Date
Status
Text
Active, Inactive, or On Hold
8
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 fi eld allows you to specify the value that should
be entered, by default, for that fi 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 fi eld. Set the Default Value property for the Status fi eld to
"Active" (including the quotation marks). Save and close the Member table.
10. Open the Member table in Datasheet view and confi rm that the InitiationFeeWaived
fi eld was removed from the table. If not, open the table in Design view again, repeat
the step to delete the InitiationFeeWaived fi 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 fi rst and last names in the appropriate fi elds for the fi rst new record added.
Note the default fi eld value of “Active” in the Membership Status column as you
enter the new records.
Figure 2-52
Records for the Member table
Date
Expiration
Membership
Member ID Program ID First Name Last Name
Street
City
State
Zip
Phone
Joined
Date
Status
1170
203
Student
Student
40 Green Boulevard
Bon Air
VA
23235
804-323-6824
6/3/2013
12/3/2013
Active
First
Last
1172
211
Ed
Curran
25 Fairway Drive
Richmond VA
23220
804-674-0227
11/16/2013
11/16/2014
Active
12. Resize columns in the datasheet to their best fi t (as necessary), and then save and
close the table.
13. Defi 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.
 
Search JabSto ::




Custom Search