Lab Work (11/05)

Querying the Condo Management Database

Use the Condo Management Database created in the 11/01 lab for this assignment.

1. Open the Condo Management database and display the Unit Number, Weekly Rate, and Owner Id fields for all the records in the condo table and save the query as Query1

2. Display the Unit Number and Weekly Rate fields for all units that rent for less than $1000 per week. Save the query as Query2

3. Display the Unit Number, Sleeps and Weekly Rate for all units that sleep more than four people and have a powder room. Save the query as Query3

4. Display the Unit Number, Bedrooms, and Weekly Rate fields for all units that have 2 bedrooms and a powder room or that have 3 bedrooms. Save the query as Query4

5. Display the Unit Number and Weekly Rate fields for all units that are on the fifth floor. (Hint: The first digit of the Unit Number field indicates the floor.). Save the query as Query5

6. Display the Unit Number, Bedrooms, and Weekly Rate fields for all units that have more than one bedroom and more than one bathroom and provide linens. Save the query as Query6

7. Display the Weekly rates in descending order. Each rate should display only once. Save the query as Query7

8. Display the Unit Number and Weekly Rate fields from the Condo table and First Name, Last Name, and Telephone fields from the Owner table. Save the query as Query8

9. Display the Unit Number and Weekly Rate fields from the Condo table and First Name, Last Name, and Telephone fields from the Owner table for those units that rent for more than $1,000 per week. Save the query as Query9

10. Clear the design grid and remove the Owner table from the query. Owner BR18 offers a 15 percent discount on the weekly rate if reenters rent for more than one week at a time. What is the discounted weekly rental rate for her units? Display the unit number, bedrooms, bathrooms, sleeps, and discounted weekly rate in your result. Format the discounted weekly rate as currency. Refer page A 2.33 to solve this problem. Save the query as Query10. Hint: Discounted Weekly Rate = 0.85 * Weekly Rate

11. Display the average weekly rate for each owner. Save the query as Query11

12. Create a query that includes the Owner Id, First Name, Last Name, Unit Number, and Weekly Rate fields. Sort the query in ascending order by the Owner Id fields. Save the Query as Query12.

Save your finished work in a floppy or C:. Email a copy to capstoneatccsu@yahoo.com