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.