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.)
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
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.