preview

Access Lab Assignment

Decent Essays

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 …show more content…

Figure 2-52 Field Name | Date Type | Description | Field Size | Other Properties | MemberID | Text | Primary key | 4 | Caption | ProgramID | Text | Foreign key | 3 | Caption | FirstName | Text | | 18 | Caption | LastName | Text | | 18 | Caption | Street | Text | | 30 | | City | Text | | 24 | | State | Text | | 2 | | Zip | Text | | 10 | | Phone | Text | | 14 | | DateJoined | Date/Time | | | Format: Short Date Caption | ExpirationDate | Date/Time | Date when membership expires | | Format: Short Date Caption | MembershipStatus | Text | Active, Inactive, or On Hold | 8 | Caption Default Value (see next step) | 13. Set the Default Value property for the MembershipStatus field to “Active” (include the quotation marks). For help with this or to understand the concept of setting a default value for a field better, open Access Help (F1) and enter default value as the search text. Select the Help article titled, “Set default values for fields or controls,” then select “Set a default value for a table field.” Read that section of the Help article, and view the examples of default values. Close the Access Help window after you’ve completed this step. 14. Save the Member table again. Click the Yes button for message indicating some data might be lost. 15. In Datasheet View, add the records shown in the figure below to the Member table. Figure 2- 53 Member ID | Program ID | First Name

Get Access