Microsoft Office Tutorials and References
In Depth Information
Cases and Places
Apply your creative thinking and problem solving skills to design and implement a solution.
E ASIER •• M ORE D IFFICULT
1: Querying the Second Hand Goods Database
Use the Second Hand Goods database you created in Cases and Places 1 in Chapter 1 on page AC 71
for this assignment, or see your instructor for information on accessing the fi les required for this topic.
Create queries for the following:
a. Find the number and description of all items that contain the word Table.
b. Find the item number, description, and condition of the item that has the earliest posting date.
c. Find the total price of each item available for sale. Show the item description and total price.
d. Find the seller of each item. Show the seller’s fi rst name and last name as well as the item description,
price, quantity, and date posted. Sort the results by item description within seller last name.
e. Create a parameter query that will allow the user to enter an item description when the query is
run. The user should see all fi elds in the query result.
f. Find all items posted between April 1, 2008 and April 4, 2008. The user should see all fi elds in the
query result.
Submit the revised database in the format specifi ed by your instructor.
• 2: Querying the BeachCondo Rentals Database
Use the BeachCondo Rentals database you created in Cases and Places 2 in Chapter 1 on page AC 71
for this assignment, or see your instructor for information on accessing the fi les required for this topic.
Create queries for the following:
a. Find all units that rent for less than $1,000 per week and have at least two bedrooms. The user
should see all fi elds in the query result.
b. Find all units that are on the fourth fl oor. (Hint: The fi rst digit of the Unit Number fi eld indicates
the fl oor.) Include the Unit Number and the Weekly Rate fi elds in the query result.
c. Find all units that have more than one bedroom and more than one bathroom and provide linens.
Include the Unit Number, Bedrooms, and Weekly Rate fi elds in the query result.
d. Owner BE20 offers a 15 percent discount on the weekly rate if renters rent for more than one
week. What is the discounted weekly rental rate for his units? Your result should include the unit
number, bedrooms, bathrooms, sleeps, and discounted weekly rate in your result. Be sure the
discounted rate appears as currency.
e. List the owner’s fi rst and last name as well as telephone number. Also include the unit number and
the weekly rate. All owners should appear in the result even if they currently have no rental units.
f. Find the highest and lowest weekly rate.
Submit the revised database in the format specifi ed by your instructor.
•• 3: Querying the Restaurant Database
Use the restaurant database you created in Cases and Places 3 in Chapter 1 on page AC 71 for this
assignment, or see your instructor for information on accessing the fi les required for this topic. Using
the Plan Ahead guidelines presented in this chapter, determine at least fi ve questions the conference
director might want to ask the database. Using a word processing program, such as Microsoft Word,
write the questions in your own words. Then, design the queries for Access. Run and save each query.
Submit the Word document and the revised database in the format specifi ed by your instructor.
Continued >
Search JabSto ::




Custom Search