Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT
Query 1
Create a query called Members in What State? In Figure 2-4, the queried state is Pennsylvania (PA). This
query should prompt the user to enter a state name. The output of the query should list the last name, first
name, full address, and cell phone number of members in the designated state. Your output should resemble
that shown in Figure 2-4, although your data will be different.
FIGURE 2-4
Members in What State? query
Query 2
Create a query called Mid-March Reservations (or use another month if your data is for a different time
period). List the date requested, the type of airplane, and the origination of all flights for a particular 10-day
period. Your output should look like that in Figure 2-5, although your data will be different.
FIGURE 2-5
Mid-March Reservations query
Query 3
Create a query called Number of Jets Reserved. In this query, you need to determine the number of times
each type of jet has been reserved. List the jet type and the number of times it has been reserved, showing
the most popular to the least popular. Note the column heading change from the default setting provided by
the query generator. Your output should resemble the format shown in Figure 2-6, but the data will be
different.
FIGURE 2-6
Number of Jets Reserved query
 
Search JabSto ::




Custom Search