Explore BrainMass
Share

Explore BrainMass

    Querying a Database - Access 2007

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com October 9, 2019, 11:05 pm ad1c9bdddf
    https://brainmass.com/computer-science/sorting/querying-database-access-2007-244219

    Attachments

    Solution Preview

    Problems with database tables:
    Bedroom, bathroom and sleeps fields are numeric and therefore should not be text, so I'll switch the data type to number. Bedroom and sleeps are integers and bathrooms are single

    Query A
    Because you ...

    Solution Summary

    This solution helps with querying a database.

    $2.19