$34.98
Add to Cart
HW-1899 NP_Access2013_CS_T1-4_P1a_FirstnameLastname_2
More than 10 available, 7 sold
Details
Shipping: Australia: free (more destinations)
Condition: Used
Assignment_NP_Access2013_CS_T1-4_P1a
New Perspectives Access 2013
Tutorials 1–4: SAM Capstone Project 1a
Northwestern Swimming
CREATING TABLES, QUERIES, FORMS, AND REPORTS IN A DATABASE
PROJECT DESCRIPTION
Northwestern Swimming (NWS) manages athlete and coach data for swim teams located throughout Washington. Athletes include both developmental swimmers who are learning to swim and athletes who have competed at the Olympic and world-championship levels. Julia Montoya is the general chairperson of NWS, and she 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:
o NP_Access2013_CS_T1-4_P1a_FirstLastName_1.accdb
• Open the file you just downloaded and save it with the name:
o NP_Access2013_CS_T1-4_P1a_FirstLastName_2.accdb
o 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:
o support_NP_A13_CS_T1-4_P1a_nws.accdb
o support_NP_A13_CS_T1-4_P1a_teams.txt
o support_NP_A13_CS_T1-4_P1a_practice.txt
o support_NP_A13_CS_T1-4_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 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 12/31/2017
901901 DEV1 Whitney Long 12/31/2017 12/31/2017
3. Create a new table in Datasheet View. Save the table as Athlete, and then make the following changes in Datasheet View:
a. Change the data type of the ID field to Short Text, and then change the field name to AthleteID.
b. Add the following fields to the table in the order listed, and choose the Short Text data type for each field: TeamID, FirstName, LastName, Address, City, State, Zip, GroupID, and Gender.
c. Save the table.
4. Switch to Design View for the Athlete table, and then set the field properties shown in Table 2 below. The AthleteID field should be set as the primary key for the table.
Table 2: Athlete Table
________________________________________
Field Name Data Type Description Field Size Other
AthleteID Short Text Primary key 5 Caption: Athlete ID
TeamID Short Text Foreign key 4 Caption: Team ID
FirstName Short Text 20 Caption: First Name
LastName Short Text 30 Caption: Last Name
Address Short Text 35
City Short Text 35
State Short Text 2 Default Value: WA
Zip Short Text 10
GroupID Short Text Foreign key 4 Caption: Group ID
Gender Short Text M, F 1
5. Add a new field to the Athlete table after the Zip field. Use the field name BirthDate, the Date/Time data type, the Short Date format, and the caption Birth Date.
6. Move the GroupID field so it follows the AthleteID field. Save and close the table.
7. Use the Import Spreadsheet Wizard to add data to the Athlete table from an Excel spreadsheet as follows:
a. Specify support_NP_A13_CS_T1-4_P1a_athletes.xlsx, available for download from the SAM website, as the source of the data.
b. Select the option to append a copy of the records to the Athlete table.
c. In the Import Spreadsheet Wizard dialog boxes, choose the Athlete worksheet, and import to the Athlete table. Do not save the import steps.
d. Open the Athlete table in Datasheet View, and then resize each column to best fit the data it contains.
e. Save and close the Athlete table.
8. Import the structure of the Team table in the database support_NP_A13_CS_T1-4_P1a_nws.accdb, available for download from the SAM website, into the current database. 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. (Hint: The TeamID field should be the primary key for the table.)
25. Use conditional formatting in the AthleteListing report to format birth dates that are equal to or earlier than 12/31/2005 in a bold, Red font (2nd column, last row in the Standard Colors palette), as shown in Figure 4 on the following page. Display the report in Print Preview and review its pages, and then save and close the report.
..............
There are 25 steps in this assignment.
You need to update name and other details in _Gradinginfo table.
Answer will be sent by email as attachment.
New Perspectives Access 2013
Tutorials 1–4: SAM Capstone Project 1a
Northwestern Swimming
CREATING TABLES, QUERIES, FORMS, AND REPORTS IN A DATABASE
PROJECT DESCRIPTION
Northwestern Swimming (NWS) manages athlete and coach data for swim teams located throughout Washington. Athletes include both developmental swimmers who are learning to swim and athletes who have competed at the Olympic and world-championship levels. Julia Montoya is the general chairperson of NWS, and she 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:
o NP_Access2013_CS_T1-4_P1a_FirstLastName_1.accdb
• Open the file you just downloaded and save it with the name:
o NP_Access2013_CS_T1-4_P1a_FirstLastName_2.accdb
o 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:
o support_NP_A13_CS_T1-4_P1a_nws.accdb
o support_NP_A13_CS_T1-4_P1a_teams.txt
o support_NP_A13_CS_T1-4_P1a_practice.txt
o support_NP_A13_CS_T1-4_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 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 12/31/2017
901901 DEV1 Whitney Long 12/31/2017 12/31/2017
3. Create a new table in Datasheet View. Save the table as Athlete, and then make the following changes in Datasheet View:
a. Change the data type of the ID field to Short Text, and then change the field name to AthleteID.
b. Add the following fields to the table in the order listed, and choose the Short Text data type for each field: TeamID, FirstName, LastName, Address, City, State, Zip, GroupID, and Gender.
c. Save the table.
4. Switch to Design View for the Athlete table, and then set the field properties shown in Table 2 below. The AthleteID field should be set as the primary key for the table.
Table 2: Athlete Table
________________________________________
Field Name Data Type Description Field Size Other
AthleteID Short Text Primary key 5 Caption: Athlete ID
TeamID Short Text Foreign key 4 Caption: Team ID
FirstName Short Text 20 Caption: First Name
LastName Short Text 30 Caption: Last Name
Address Short Text 35
City Short Text 35
State Short Text 2 Default Value: WA
Zip Short Text 10
GroupID Short Text Foreign key 4 Caption: Group ID
Gender Short Text M, F 1
5. Add a new field to the Athlete table after the Zip field. Use the field name BirthDate, the Date/Time data type, the Short Date format, and the caption Birth Date.
6. Move the GroupID field so it follows the AthleteID field. Save and close the table.
7. Use the Import Spreadsheet Wizard to add data to the Athlete table from an Excel spreadsheet as follows:
a. Specify support_NP_A13_CS_T1-4_P1a_athletes.xlsx, available for download from the SAM website, as the source of the data.
b. Select the option to append a copy of the records to the Athlete table.
c. In the Import Spreadsheet Wizard dialog boxes, choose the Athlete worksheet, and import to the Athlete table. Do not save the import steps.
d. Open the Athlete table in Datasheet View, and then resize each column to best fit the data it contains.
e. Save and close the Athlete table.
8. Import the structure of the Team table in the database support_NP_A13_CS_T1-4_P1a_nws.accdb, available for download from the SAM website, into the current database. 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. (Hint: The TeamID field should be the primary key for the table.)
25. Use conditional formatting in the AthleteListing report to format birth dates that are equal to or earlier than 12/31/2005 in a bold, Red font (2nd column, last row in the Standard Colors palette), as shown in Figure 4 on the following page. Display the report in Print Preview and review its pages, and then save and close the report.
..............
There are 25 steps in this assignment.
You need to update name and other details in _Gradinginfo table.
Answer will be sent by email as attachment.
