Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Issues In Database Management A Refernce For The Thinking Practitioner

Authors: Fabian Pascal

1st Edition

0201485559, 978-0201485554

More Books

Students also viewed these Databases questions