Northwestern Swimming (NWS) manages athlete and coach data for swim teams with different locations in Washington. Athletes include developmental swimmers who are learning to swim and national-level athletes who have competed at the Olympic and world-championship levels. Julia Montoya is the General Chairperson of NWS and has just received approval from the Board of Directors to replace NWS’s manual system of managing data about athletes, coaches, and teams with a database. She asks you to help her to create objects in the database that she and other staff members can use to manage data about the different teams.
GETTING STARTED
Download the following file from the SAM website:
NP_Access2013_CS_P1a_FirstLastName_1.accdb
Open the file you just downloaded and save it with the name:
NP_Access2013_CS_P1a_FirstLastName_2.accdb
Hint: If you do not see the .accdb file extension in the Save file dialog box, do not type it. Access will add the file extension for you automatically.
To complete this Project, you will also need to download and save the following support files from the SAM website: support_NP_A13_CS_P1a_nws.accdb support_NP_A13_CS_P1a_teams.txt support_NP_A13_CS_P1a_practice.txt support_NP_A13_CS_P1a_athletes.xlsx
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. Open the Coach table in Design view and make the following changes.
a. Move the GroupID field to follow the CoachID field.
b. Delete the CertificationLevel field from the table.
c. Save the table.
2. Switch to Datasheet view, enter the records shown in Table 1 below into the Coach table, and then close the Coach table.
Table 1: Coach Table
Coach ID
Group ID
Coach First Name
Coach Last Name
BGC Expiration
Certification Expiration
901900
DEV2
Janice
Buckingham
12/31/2017