Microsoft Office Tutorials and References
In Depth Information
Session 3.2
3. For all guests, display the GuestName, City, StateProv, ReservationID, StartDate, and
EndDate fields. Save the query as GuestTripDates , and then run the query. Resize all
datasheet columns to their best fit. In Datasheet view, sort the query results in
ascending order by the StartDate field. Print the query datasheet, and then save and
close the query.
4. For all guests from Illinois (IL), display the GuestName, City, StateProv, ReservationID,
People, StartDate, and EndDate fields. Sort the query in ascending order by City. Save
the query as IllinoisGuests , and then run the query. Modify the query to remove the
display of the StateProv field values from the query results. Save the modified query,
run the query, print the query datasheet, and then close the query.
5. For all guests who are not from Illinois or who are renting a property beginning in the
month of June 2007, display the GuestName, City, StateProv, ReservationID,
StartDate, and PropertyID fields. ( Hint : Refer to Figure 3-19 to determine the correct
comparison operators to use.) Sort the query in descending order by StartDate. Save
the query as OutOfStateOrJune , run the query, and then print the query datasheet.
Change the query to select all clients who are not from Illinois and who are renting a
property beginning in the month of June 2007. Sort the query in ascending order by
StartDate. Save the query as OutOfStateAndJune , run the query, print the query
datasheet, and then close the query.
6. For all reservations, display the ReservationID, StartDate, EndDate, PropertyID,
PropertyName, People, and RentalRate fields. Save the query as RentalCost . Then
create a calculated field named CostPerPerson that displays the results of dividing the
RentalRate field values by the People field values. Display the results in descending
order by CostPerPerson. Run the query. Modify the query design to set the following
properties for the CostPerPerson field: Format set to Standard; Decimal Places set to
2; and Caption set to “Cost Per Person”. Run the modified query, resize all datasheet
columns to their best fit, print the query datasheet, and then save and close the query.
7. Use the Reservation table to determine the minimum, average, and maximum
RentalRate values for all reservations. Then do the following:
a. Specify column names of Lowest Rate, Average Rate, and Highest Rate.
b. Use the property sheet for each column to format the results as Fixed with two
decimal places.
c. Save the query as RateStatistics , run the query, resize all datasheet columns to
their best fit, print the query datasheet, and then save the query again.
d. Revise the query to show the rate statistics grouped by Country. ( Hint: Use the
Show Table button on the Query Design toolbar to add the Property table to the
query.) Save the revised query as RateStatisticsByCountry , run the query, print the
query datasheet, and then close the query.
8. Use the “Type a question for help” box to ask the following question: “How do I cre-
ate a Top Values query?” Click the topic “Show only the high or low values in a query
(MDB).” Read the displayed information, and then close the Microsoft Office Access
Help window and the task pane. Open the RentalCost query in Design view, and
then modify the query to display only the top five values for the CostPerPerson field.
Save the query as TopRentalCost , run the query, print the query datasheet, and then
close the query.
9. Close the GEM database.
Explore
Explore
Explore
 
Search JabSto ::




Custom Search