Homework answers / question archive / Shelly Cashman Access 2019 Module 1:End of Module Project 1 Competitive Swim Clubs, Inc

Shelly Cashman Access 2019 Module 1:End of Module Project 1 Competitive Swim Clubs, Inc

MS Access

Share With

---

Shelly Cashman Access 2019 Module 1:End of Module Project 1

Competitive Swim Clubs, Inc.

GETTING STARTED

BUILDING AN ACCESS DATABASE TO MANAGE MEMBER DATA

• Open the file SC_AC19_EOM1-1_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as SC_AC19_EOM1-1_FirstLastName_2.accdb by changing the “1” to a “2”.
• If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

1. Competitive Swim Clubs, Inc. is a national chain of swim clubs targeted to youth and adults who are or who want to be competitive swimmers. You are the regional manager for clubs located in the southeastern United States. You are developing an Access database application to help manage and analyze member and club data.

Open the Clubs table in Datasheet View and use Street to rename the current Address

field. Close the Clubs table.

2. Create a new table in Datasheet View. Change the ID field name to CoachID with the AutoNumber data type, add a field named CoachFirstName with the Short Text data type, add a field named CoachLastName with the Short Text data type, and add a field named ClubID with the Number data type. (Hint: The CoachID field will be automatically set as the primary key.) Save the table with the name Coaches and close it.
3. Open the SwimFees table in Datasheet View and add the new record shown in Table 1. Close the SwimFees table.

Table 1: New Record for SwimFees Table

 

LevelID	Description	Registration	MonthlyFee	AnnualFee
7	Recreational	$165.00	$200.00	$2,100.00

 

4. Open the Clubs table in Datasheet View and delete the record for ClubID C05 (Athens Water Athletics). Modify the ClubName value for the record with ClubID C02 (Hillview Swim Group), using Upstate Swim Group as the new ClubName value, and then close the Clubs table.
5. Create a new query using the Simple Query Wizard. Choose the MemberID, FirstName, Lastname, State, and ClubID fields from the Members table. Title the new query using SCMembers as the name, open the query to view information, a portion of which is shown in Figure 1, and then close it.

Figure 1: SCMembers Query

6. In the Navigation pane, rename the Members form using MemberEntry as the new form name.
7. Create a new form based on the Swimmers table using the Form tool. Title the form SwimmerInfo and confirm that it matches Figure 2, and then save and close it.

Figure 2: SwimmerInfo Form

8. Create a new report using the Report Wizard. Choose the SwimmerID, FirstName, LastName, and LevelID fields from the Swimmers table. Do not add any grouping levels. Sort the records in ascending order by LevelID. Use a Tabular layout and a Portrait orientation. Title the report using SwimmerByLevel as the name, preview the report, a portion of which is shown in Figure 3, and then close it.

Figure 3: SwimmerByLevel Report

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.