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

I’m trying to study for my .NET course and I need some help to understand this question.

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.

Get 20% discount on your first order with us. Place an order and use coupon: GET20

Posted in Uncategorized