Shelly Cashman Access 365/2021 | Module 1: End of Module Project 1

24 / 7 Live Support
[e-mail]
[phone]
[phone]
Competitive Swim Clubs, Inc.
BUILDING AN ACCESS DATABASE TO MANAGE MEMBER DATA
GETTING STARTED
• Open the file SC_AC365_2021_EOM1-1_FirstLastName_1.accdb, available for download.
• Save the file SC_AC365_2021_EOM1-1_FirstLastName_1.accdb as SC_AC365_2021_EOM1-1_FirstLastName_2.accdb
o Edit the file name by changing “1” to “2”.
o If you do not see the .accdb file extension, do not type it. The file extension will be added for you automatically.
• With the file SC_AC365_2021_EOM1-1_FirstLastName_2.accdb open, ensure that your first and last name is displayed as the first record in the _GradingInfoTable table.
o If the table does not display your name, delete the file and download a new copy.
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.