Microsoft Office Tutorials and References
In Depth Information
13. Designate the Level.02\Case3 folder as a trusted folder. ( Note: Check with your
instructor before adding a new trusted location.)
14. Close the Agency database without exiting Access, make a backup copy of the data-
base, open the Agency database, compact and repair the database, close the database,
and then exit Access.
| Case Problem 4
Apply the skills you’ve
learned, and explore
some new skills, to
work with the data for
a luxury property
Data File needed for this Case Problem: Vacation.accdb
GEM Ultimate Vacations Griffin and Emma MacElroy own and operate their own
agency, GEM Ultimate Vacations, which specializes in locating and booking luxury rental
properties in Europe and Africa. To track their guests, properties, and reservations, they
created the Vacation database. Griffin and Emma want you to create several queries and
to make changes to the table design. To do so, you’ll complete the following steps:
1. Open the Vacation database, which is located in the Level.02\Case4 folder pro-
vided with your Data Files.
2. Modify the first record in the tblGuest table datasheet by changing the First Name
and Last Name column values to your first and last names.
3. Create a query to find all records in the tblProperty table in which the PropertyName
field value starts with the word Chateau. Display all fields except the Description field
in the query recordset. Save the query as qryChateauProperties , run the query, and then
4. Make a copy of the qryChateauProperties query using the new name
qryNonChateauProperties . Modify the new query to find all records in the
tblProperty table in which the PropertyName field value starts with a word other
than Chateau, and sort in ascending order by PropertyName. Save and run the
query, and then close it.
5. Create a query to find all records in the tblGuest table in which the City field value
is Aurora, Chicago, or Crown Point. Use a list-of-values match for the selection crite-
rion, and display all fields from the tblGuest table in the query recordset. Save the
query as qrySelectedGuests , run the query, and then close it.
6. Create a query to select all records from the tblProperty table with nightly rates of
$1,700 or $2,000 in France or Italy. Display all fields except the Description field in
the query recordset. Save the query as qryFranceItalySelectedProperties , run the
query, and then close it.
7. Create a parameter query to select the tblProperty table records for a Country field
value that the user specifies. If the user doesn’t enter a Country field value, select all
records from the table. Display all fields from the tblProperty table in the query
recordset, and sort in ascending order by PropertyName. Save the query as
qryCountryParameter . Run the query and enter no value as the Country field value,
and then run the query again and enter Scotland as the Country field value. Close