Access_2021_in_practice_ch3_guided_project_3-2 | Ch3 Guided Project 3-2 | Guided Project 3 2 Access

Contact Us
Whatsapp No : +994-401583314

#independentproject1-4 #independentproject2-6 #independentproject3-6 #independentproject4-4 #independentproject1-6
#independentproject2-5 #independentproject3-4 #independentproject4-5 #independentproject1-5 #independentproject3-7
excel 2019 independent project 2-4,cit110 independent project 2-4,#Independent Project 2-4,#ind pro 2-4,#excel independent project 4-5,#excel 2019 in practice-ch6 guided project 6-3,#excel 2019 in practice-ch1 guided projecrt 1-3,#excel independent project 3-4,#excel 2019 in practice-ch2 guided project 2-3,#excel independent project 2-5,#excel independent project 6-6,#independent project 6-5,#excel independent project 2-4,#excel 2019 in practice-ch4 guided project,CIT
#ch2ChallengeYourself2.3 #ch1ChallengeYourself1.3 #ch4ChallengeYourself4.4 #ch5ChallengeYourself5.3 #ch1ChallengeYourself1.3
#ch2ChallengeYourself2.4 #ch3ChallengeYourself3.3 #ch4ChallengeYourself4.3 #ch5ChallengeYourself5.3 #ch1ChallengeYourself1.4
#ch2ChallengeYourself2.4 #ch3ChallengeYourself3.4 #ch4SkillReview4.2 #ch4Challenge4.4 #Ch4Fixit4.6 #Ch5SkillReview5.1
#Ch5ChallengeYourself5.3 #Ch5Fixit5.6 #Ch6SkillReview6.2 Excel 2019 Independent Project 1-4
#Excel 2016 In Practice - Ch2 Independent Project 2-4
#Excel 2016 In Practice - Ch1 Independent Project 1-4
#Excel 2016 In Practice - Ch5 Independent Project 5-4
#Excel 2016 In Practice - Ch6 Independent Project 6-3
#Excel 2016 In Practice - Ch7 Independent Project 7-3
#Excel 2016 In Practice - Ch8 Independent Project 8-3
#Excel 2016 In Practice - Ch9 Independent Project 9-3
#Excel 2016 In Practice - Ch2 Independent Project 2-3
#Excel 2016 In Practice - Ch3 Independent Project 3-3
#Excel 2016 In Practice - Ch3 Independent Project 3-4
#Excel 2016 In Practice - Ch4 Independent Project 4-3
#Excel 2016 In Practice - Ch4 Independent Project 4-4

Guided Project 3-2
San Diego Sailing 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.
[Student Learning Outcomes 3.2, 3.3, 3.4, 3.5, 3.6, 3.8]
File Needed: SanDiegoSailing-03.accdb (Available from the Start File link.)
Completed Project File Name: [First Name.Last Name]-SanDiegoSailing-03.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.
Steps to complete This Project
Mark the steps as checked when you complete them.
1. Open the SanDiegoSailing-03.accdb database start file.
2. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.
3. Enable content in the database.
4. Create a new summary query in Design view. San Diego Sailing wants to find out the total dollar value of the full day rentals, by boat, from the boats that have been rented. If a boat has been rented, a record displays in the SDRentals table.
a. Click the Query Design button [Create tab, Queries group] to open the Query Design window and the Add Tables task pane.
b. Double-click the SailboatFleet table to add it to the Query Design window.
c. Double-click the SDRentals table to add it to the Query Design window.
d. Click the X in the right corner of the Add Tables task pane to close it.
e. Right-click inside each table to open the context menu and select Size to Fit to increase the size of each table object.
f. Click the drop-down arrow in the first Field row cell of the query design grid and select SDRentals.FKBoatID.
g. Click the second cell in the Field row, click the drop-down arrow, and select SailboatFleet.BoatType.
h. Click the third cell in the Field row, click the drop-down arrow, and select SailboatFleet.FullDayRentalRate.
i. Click the fourth cell in the Field row, click the drop-down arrow, and select SDRentals.FourHourRental?.
j. Click the Totals button [Query Design tab, Show/Hide group].
k. Click the Run button [Query Design tab, Results group] to execute the query. The query should open in Datasheet view and display 13 records (Figure 3-99). This query only shows boats that have been rented. At most a Boat ID appears in two rows; one row if the Four Hour Rental? box is checked and another row if the Four Hour Rental? box is not checked.