Querying a Database - Access 2007

Complete and submit Cases and Places 2, p. AC 135. You will use the BeachCondo Rentals database created in the case study for Unit 2. You will query this database for several types of information and sort the results. You will create and save six queries, and will submit the database containing the queries.

Hello class,
I just wanted to give a few tips on the Unit 4 assignment. In this assignment you will be working with adding validation rules to your database as well as adding a field and some new data. Some in your first incarnation of your database didn't have the Owner Code in your Units or Rentals table. Well the initial data load was missing this so I wasn't too concerned if you didn't add it, but some did. I would suggest that all of you add the Owner Code field to your Rentals table and populate it. You will be adding the referential integrity, foreign key, in this assignment if you don't already have it in place. Remember that validation rules enforce data integrity. The chapter has some good examples of how to do this.

Querying a Database
Complete and submit Cases and Places 2, p. AC 135. You will use the BeachCondo Rentals database created in the case study for Unit 2. You will query this database for several types of information and sort the results. You will create and save six queries, and will submit the database containing the queries.

The steps for the queries are listed in the textbook alphabetically. Use this alphabetic list for naming your queries as you save them. For instance, name the query created in step a as Query A, and so forth.
2: Querying the BeachCondo Rentals Database
a. Find all the units that rent for less than $1,000 per week and have at least two bedrooms. The user should see all fields in the query result.
b. Find all units that are on the fourth floor. (Hint: The first digit of the Unit Number field indicates the floor.) Include the Unit Number and the Weekly Rate fields 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 fields in the query results.
d. Owner BE20 offers a 15% discount on the weekly rate if renters rent fore more than one week. What is the discounted weekly rate for his units? Your result should include the unit number, bedrooms, bathrooms, sleeps and discounted weekly rate in your results. Be sure the discounted rate appears as currency.
e. List the owner's first 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.

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/computer-science/software-development/querying-a-database-access-2007-7efr

Solution Preview

...had bedrooms as text, you were only selecting those with two bedrooms and forgetting that the query wants at least two. Another mistake was that the query wants ALL fields to be shown.

Query B
Correct except that you were ...