QuestionQuestion

Instructions: In the following exercises, you will use the Alexamara Marina database.
In each step, use QBE to obtain the desired results. Save each query with it's associated letter, i.e., "Query A", "Query B", etc. Be sure you name the queries correctly!
For additional verification, save the output of each of your queries to a Word document (see attached template)
List the complete Owners Table (all rows and columns).
List the owner number, and first name and last name of all the boat owners.
Create a new table named High-Priced Boat Rentals using the data in the owner number, first name, last name, marina number, boat name, and boat type fields with rental fees of $3,800.00 – $4,200.00.
Use an update query to change the address for Maria Juarez to 8932 Oak Ln.
List the first and last name of all customers who have rental fees of $4,200.00.
List the first and last name, marina number, boat type, boat name, and rental fee of the owner number AN 75.
List the service ID, category, description, and next scheduled service date for the service description that does not have a next scheduled service date. To obtain the service description without a next scheduled service date, use the count command to count how many descriptions do not have a date. Use No Scheduled Service Date as the column name for the calculated field.
List the first and last name along with the complete mailing address of all customers who reside in Bowton, Florida.
List the first and last name along with the complete mailing address of all customers who do not reside in Glandar Bay, Florida.
List the complete Marina Slip table (all rows and columns).
Service ID and category number of all customers who have a scheduled service date.
List the service ID, slip ID, service description, estimated work hours, and work status of all customers on July 13, 2013.
List the service ID of all customers who have an open or service call has been scheduled status.
List the service ID of all customers who completed a transaction on July 12, 2013. Sort service ID by slip ID.
How many technicians have scheduled repairs on July 13, 2013?
Calculate the total estimated work hours for July 17, 2011. Calculate the total estimated work hours on July 13, 2013.
For every service description, category number, service ID, status, completed work hours, estimated work hours, and next scheduled date, sort by category number.
For every category number, list service ID, slip ID, description, status, and next service date.
List the service ID, category number, description, and next scheduled service date with a status of“technician suspects problem.”
Use a delete query to delete all rows from the Service Request table with a status of ”open.”
You will submit your modified access database file that contains all or your queries along with your Word document.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Database Development Problems
    $40.00 for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Database Development Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats