Microsoft Office Tutorials and References
In Depth Information
text “Page 1 of 1” to the left so it is within the page area. Also, resize the box
containing the total amount that appears below the TeacherID column so that the amount is
completely displayed. Display the report in Print Preview and verify that the ﬁ elds and
page number appear within the page area. Save the report as TeacherList , print the
report (only if asked by your instructor to do so), and then close it.
11. Close the Teacher table, and then compact and repair the Pinehill database.
12. Close the Pinehill database.
Apply what you
learned to create
a database for a
business in the
i tness industry.
Case Problem 2
Data File needed for this Case Problem: Health.accdb
Parkhurst Health & Fitness Center After many years working in various corporate
settings, Martha Parkhurst decided to turn her lifelong interest in health and ﬁ tness into a
new business venture and opened the Parkhurst Health & Fitness Center in Richmond,
Virginia. In addition to providing the usual ﬁ tness classes and weight training facilities,
the center also offers specialized programs designed to meet the needs of athletes—both
young and old—who participate in certain sports or physical activities. Martha’s goal in
establishing such programs is twofold: to help athletes gain a competitive edge through
customized training, and to ensure the health and safety of all participants through
proper exercises and physical preparation. Martha wants to use Access to maintain
information about the members who have joined the center and the types of programs
offered. She needs your help in creating this database. Complete the following steps:
1. Create a new, blank database named Fitness , and save it in the Access1\Case2 folder
provided with your Data Files.
2. In Datasheet view for the Table1 table, rename the default primary key ID ﬁ eld to
ProgramID . Change the data type of the ProgramID ﬁ eld to Text.
3. Add the following three ﬁ elds to the new table in the order shown; all of them are
Text ﬁ elds except MonthlyFee, which is a Currency ﬁ eld: ProgramType , MonthlyFee ,
and PhysicalRequired . Resize the columns as necessary so that the complete ﬁ eld
names are displayed. Save the table as Program .
4. Enter the records shown in Figure 1-32 in the Program table.
Program table records
Junior Full (ages 13-17)
Junior Limited (ages 13-17)
Young Adult Full (ages 18-25)
Young Adult Limited (ages 18-25)
5. Martha created a database named Health that contains a Class table with
program data. The Program table you created has the same design as the Class table.
Copy all the records from the Class table in the Health database (located in the
Access1\Case2 folder provided with your Data Files) and paste them at the end of
the Program table in the Fitness database.
6. Resize columns in the datasheet, as necessary, so that all the ﬁ eld values are
completely displayed, and then save the Program table.
7. Use the Simple Query Wizard to create a query that includes all the ﬁ elds from the
Program table. In the second Simple Query Wizard dialog box, select the Detail
option. Save the query as ProgramData . Resize the columns in the query datasheet so
that all the ﬁ eld values are completely displayed, if necessary, and then close the query.