Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT
Students without Physical Exam query
Create a query called Members of What Team. This query should prompt the user to enter a team color, and
then list the names and cell phone numbers of the team members. Your output will differ, but the layout
should resemble that in Figure 3-4.
Members of What Team query
Create a query called Game Times that calculates the length of each game and shows the date and game time.
Your data will differ, but the output should resemble that in Figure 3-5.
Game Times query
Create a query called Number of Students on Teams. The query should list team names and the number of
players on each team. Sort the output to this query. Your output should resemble that in Figure 3-6, although
the data will differ. Note the column heading change from the default setting provided by the query generator.