Access Lab Assignment
CISB15 – Microcomputer Applications
Access Lab Assignment - Tutorials 1 & 2
**It is highly recommended that you wait until Access Tutorial 2 is covered before attempting to complete steps 8 - 20.**
Parkhurst Health & Fitness Center
After many years working in various corporate settings, Martha Parkhurst decided to turn her lifelong interest in health and fitness into a new business venture and opened the Parkhurst Health & Fitness Center in Richmond, Virginia. In addition to providing the usual fitness 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: 1. Create a new blank database named Fitness_xx (xx = your initials), and save it to the Access1 folder on your flash drive. NOTE: You will use this same database file for the next Access lab assignment. 2. In Datasheet view for the Table1 table, rename the default primary key ID field to ProgramID. Change the data type of the ProgramID field to Text. 3. Add the following three fields to the new table in the order shown: ProgramType, MonthlyFee, and PhysicalRequired. (ProgramType & PhysicalRequired fields are Text; MonthlyFee is Currency.) Resize the columns as necessary so that the complete field names are displayed. Save the table as ProgramTable_yourName (yourName = your first and last name with no spaces). This table will be referenced in further instructions as the Program table. 4. Enter
Access Lab Assignment - Tutorials 1 & 2
**It is highly recommended that you wait until Access Tutorial 2 is covered before attempting to complete steps 8 - 20.**
Parkhurst Health & Fitness Center
After many years working in various corporate settings, Martha Parkhurst decided to turn her lifelong interest in health and fitness into a new business venture and opened the Parkhurst Health & Fitness Center in Richmond, Virginia. In addition to providing the usual fitness 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: 1. Create a new blank database named Fitness_xx (xx = your initials), and save it to the Access1 folder on your flash drive. NOTE: You will use this same database file for the next Access lab assignment. 2. In Datasheet view for the Table1 table, rename the default primary key ID field to ProgramID. Change the data type of the ProgramID field to Text. 3. Add the following three fields to the new table in the order shown: ProgramType, MonthlyFee, and PhysicalRequired. (ProgramType & PhysicalRequired fields are Text; MonthlyFee is Currency.) Resize the columns as necessary so that the complete field names are displayed. Save the table as ProgramTable_yourName (yourName = your first and last name with no spaces). This table will be referenced in further instructions as the Program table. 4. Enter