Microsoft Office Tutorials and References
In Depth Information
23. Deﬁ ne the one-to-many relationships between the database tables as follows:
between the primary Student table and the related Contract table, and between the
primary Teacher table and the related Contract table. Select the referential integrity
option and the cascade updates option for each relationship.
24. Save the changes to the Relationships window and close it, compact and repair the
Pinehill database, and then close the database.
Use the Import
Wizard to create
a table to store
i tness center
Case Problem 2
Data Files needed for this Case Problem: Fitness.accdb ( cont. from Tutorial 1 ) and
Parkhurst Health & Fitness Center Martha Parkhurst uses the Fitness database to track
information about members who join the center and the programs in which each
member is enrolled. She asks you to help her maintain this database. Complete the following:
1. Open the Fitness database, which you created and stored in the Access1\Case2
folder in Tutorial 1.
2. Open the Program table in Design view, and change the following ﬁ eld properties:
a. ProgramID: Enter Primary key for the description, change the ﬁ eld size to , and 3
enter Program ID for the caption.
b. ProgramType: Change the ﬁ eld size to and enter Program Type for the caption. 40
c. MonthlyFee: Change the format to Standard and enter Monthly Fee for the
d. PhysicalRequired: Change the data type to Yes/No, the Format property to Yes/No,
and enter Physical Required for the caption.
3. Save and close the Program table. Click the Yes button when a message appears
indicating some data might be lost.
4. Use the Import Spreadsheet Wizard to create a table in the Fitness database. As
the source of the data, specify the Center workbook, located in the Access1\Case2
folder provided with your Data Files. Select the option to import the source data into
a new table in the current database, and then click the OK button.
5. Complete the Import Spreadsheet Wizard dialog boxes as follows:
a. Select Sheet1 as the worksheet you want to import.
b. Accept the option specifying that the ﬁ rst row contains column headings.
c. Accept the ﬁ eld options the wizard suggests, and do not skip any ﬁ elds.
d. Choose MemberID as your own primary key.
e. Import the data to a table named Member , and do not save your import steps.
6. Open the Member table in Design view, and then delete the InitiationFeeWaived ﬁ eld.
7. Modify the design of the Member table so that it matches the design shown in
Figure 2-51. ( Hint : For Text ﬁ elds, delete any formats speciﬁ ed in the Format