Question: Mark the steps as checked when you complete them. Open the SanDiegoSailing - 0 3 . accdb database start file. The file will be renamed

Mark the steps as checked when you complete them.
Open the SanDiegoSailing-03.accdb database start file.
The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.
Enable content in the database.
Create a new summary query in Design view. The Sailing Club 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.
Click the Query Design button [Create tab, Queries group] to open the Add Tables task pane.
Alternate Instruction for Microsoft 365 Apps iconClick the Query Design button [Create tab, Queries group] to open the Show Table dialog box.
Office 365 Update note icon NOTE: The Show Table dialog in your version of Microsoft Access may appear different due to Office 365 updates.
Select the SailboatFleet table and click the Add Selected Tables button.
Alternate Instruction for Microsoft 365 Apps iconSelect the SailboatFleet table and click the Add button.
Select the SDRentals table and click the Add Selected Tables button.
Alternate Instruction for Microsoft 365 Apps iconSelect the SDRentals table and click the Add button.
Click the Close button in the Add Tables task pane.
Alternate Instruction for Microsoft 365 Apps iconClick the Close button in the Show Table dialog box.
Increase the size of the table objects to display all of the fields.
Click the drop-down arrow in the first Field row cell of the query design grid and select FKBoatID.
Click the second cell in the Field row, click the drop-down arrow, and select BoatType.
Click the third cell in the Field row, click the drop-down arrow, and select FullDayRentalRate.
Click the fourth cell in the Field row, click the drop-down arrow, and select FourHourRental?.
Click the Totals button [Design tab, Show/Hide group].

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!