use design view to create edit add aggregate functions and add criteria to a query to find the total dollar value of the rentals for each boat in its fleet

San Diego Sailing Club wants to create three queries. To ensure consistency, the starting file is provided for you. Use Design view to create, edit, add aggregate functions, and add criteria to a query to find the total dollar value of the rentals for each boat in its fleet. After saving and testing the query, create a second query that uses aggregate functions and a parameter. Finally, create a query to find which boat types have been rented.

File Needed: SanDiegoSailing-03.accdb (Student data files are available in the Library of your SIMnet account.)

Completed Project File Name: [your initials] Access 3-2.accdb

Skills Covered in This Project

  • Create a query using Design view.
  • Add fields to a query.
  • Add criteria to a query.
  • Execute a query.
  • Save and test a query.
  • Save a copy of a query.
  • Add a parameter.
  • Use aggregate functions.
  • Use the Unique Values property.

Hi there, would you like us to help you do this question?

We are professional assignment help service for students who can't even. Get your papers written starting at just $11.99 a page.

Do my question How much will it cost?