Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT
Number of Students on Teams query
Create a delete query that prompts the user to enter the ID number of a student whose intramural record
should be deleted. The query should also prompt the user to enter the student
s associated team color. Save
the query as Delete Members. Test the query by entering a new record and deleting it.
Create a report called Referee Times. Begin the report by creating a query that displays columns for the
Referee Last Name, Referee First Name, Date, Game Time, and Winning Team. (The Game Time is
the total time of the game, which is a calculation.) Save the query as For Report, bring the query into a
report, and group on Referee Last Name. The report should include subtotals of game times for
each referee. Adjust the output so that the Referee First Name is on the same line as the Referee Last
Name. Your output should resemble that in Figure 3-7. Make sure that all headings and data are visible.
Referee Times report