Section 3- Queries
In this section you will need to develop a number of queries for use by the department.
9. In some cases, students who have academic approval but not a signed liability form can
play intramural sports. However, students who do not have academic approval cannot
participate in intramural sports. At the beginning of each semester, the department
receives a list of students who are not approved to play sports. The staff records that
information in the student table. They also want to remove from the table the students
who do not have academic approval. Marianna asks you to identify students who do not
have academic approval, isolate them in a separate table, and then remove them from the
student table, which should contain only those students who have been academically
approved. Name the queries qryUnapprovedStudents and qryDeleteUnapprovedStudents
as appropriate. 10. The staff also needs a way to track students in the future in case someone signs up for a
sport and is not assigned to a team. Provide a way for the staff to track these students.
Name the query qryStudentWithoutTeam. 11. To manage the teams, the coaches need a list of teams and their student captains. The
captain names for this list are most useful as full names, with the last name appearing
first. Name the query qryTeamCaptainAssignments. 12. If a sports field is available in the spring, it is also available in the summer. In other
words, a field that is recorded as available only in the spring is actually available in the
spring and summer, and a field that is recorded as available in the fall and spring is
actually available in the fall, spring, and summer. Marianna wants to know if you can
easily update the data to reflect this information. Name the query qrySeasonChange. 13. Provide at least two additional lists that would be helpful to the intramural staff, such as
students who are in multiple sports or teams where players are needed. Create at least one
by modifying an existing query in SQL view. 14. Close the Hershey.accdb database and then close Access.

• 1498195943-Case 3 Section 3.docx

SuperTutor

(15)

Status NEW Posted 23 Jun 2017 05:06 AM My Price 6.00

-----------

Attachments

file 1498195945-Solutions file.docx preview (56 words )

S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e. ----------- H-----------YPE-----------RLI-----------NK -----------&qu-----------ot;-----------htt-----------p:/-----------/wo-----------rkb-----------ank-----------247-----------.co-----------m/&-----------quo-----------t; -----------\t -----------&qu-----------ot;-----------_bl-----------ank-----------&qu-----------ot;----------- -----------Tha-----------nk -----------you----------- -----------

Not Rated(0)

• Buy Answer