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.
Download the following file from the SAM website:…show more content… (The file support_NP_A13_CS_P1a_nws.accdb is available from the SAM Web site.) Do not save the import steps.
9. Open the Team table in Design view, and then update the field properties shown in Table 3 below. Save and close the Team table after you finish updating the field properties. (Note: The TeamID field should be the primary key for the table.)
Table 3: Team Table
Field Name Data Type
Caption: Team ID
Caption: Team Name
10. Julia exported her existing team data to a text file and asks you to add this data to the Team table. Import the data as follows:
a. Specify support_NP_A13_CS_P1a_teams.txt as the source of the data. (The file support_NP_A13_CS_P1a_teams.txt is available from the SAM Web site.)
b. Select the option to append a copy of the records to the Team table.
c. In the Import Text Wizard dialog boxes, choose the option to import delimited data, to use a comma delimiter, and to import the data into the Team table. Do not save the import steps.
d. Open the Team table in Datasheet view, and then resize the columns to best fit the data they contain.
e. Save and close the Team table.
11. Create a new table in Design view, and then set the field properties shown in Table 4 below. The GroupID field should be the primary key for the table. Save the table as Practice, and then close the table.