Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Edit the query to add additional fields and an aggregate function and parameters. Click the Design View icon in the Status bar. Drag the FullDayRentalRate

Edit the query to add additional fields and an aggregate function and parameters.
Click the Design View icon in the Status bar.
Drag the FullDayRentalRate field from the SailboatFleet table to the fifth column in the query design grid. (Yes, this field is in the query twice!)
Click the Total row cell for this field, click the drop-down arrow, and select Count.
Drag the RentalDate field from the SDRentals table to the sixth column in the query design grid.
Click the Total row cell for this field, click the drop-down arrow, and select Where. This causes the Show row check box for the RentalDate field to be deselected.
Click the Criteria row cell of the RentalDate field.
Right-click and select Zoom.
Type Between [Enter the Start Date] And [Enter the End Date] in the Zoom box to add the two parameters.
Click OK. The query window should look similar to Figure 3-90.
Click the Save button and save the changes to the query.
Test the query.
Click the Run button.
Enter 2/1/2020 in the Enter the Start Date box of the Enter Parameter Value dialog box.
Click OK.
Enter 2/28/2020 in the Enter the End Date box of the Enter Parameter Value dialog box.
Click OK. The query should open in Datasheet view and display the records shown in Figure 3-91.
Click the Save button to save the changes made to the query.
Close the query.
Review the query.
Reopen the query in Design view. Notice that Access has reordered the position of the fields. The two fields that use the Where option on the Total row have been moved to the right side of the query design grid. This does not affect the way the query runs.
Close the query.
Create a new query in Design view. The Sailing Club wants to find out what boat types have been rented so it can decide whether to adjust pricing or marketing of its boat types. If a boat has been rented, a record of that rental exists in the SDRentals table.
Click the Query Design button [Create tab, Queries group] to open the Add Tables task pane.
Click the Query Design button [Create tab, Queries group] to open the Show Table dialog box.
NOTE: The Show Table dialog in your version of Microsoft Access may appear different due to Office 365 updates.
Select the SDRentals table, press and hold the Shift key, select the SailboatFleet table, and click the Add Selected Tables button.
Select the SDRentals table, press and hold the Shift key, select the SailboatFleet table, and click the Add button.
Click the Close button in the Add Tables task pane.
Click the Close button in the Show Table dialog box.
Click the drop-down arrow in the first Field row cell in the query design grid and select FKBoatID.
Click the Sort row, click the drop-down arrow, and select Ascending.
Click the second cell in the Field row, click the drop-down arrow, and select BoatType.
Click the Run button [Design tab, Results group] to execute the query. The query should open in Datasheet view and display 28 records (Figure 3-92). Notice that in a number of instances the same Boat ID displays multiple times, once for each time that boat was rented.
Click the Run button [Query Tools Design tab, Results group] to execute the query. The query should open in Datasheet view and display 28 records (Figure 3-92). Notice that in a number of instances the same Boat ID displays multiple times, once for each time that boat was rented.
I already did the first few steps, but I reopened the microsoft access file today, and I do not see a run! button. I need help doing the rest of these steps after the first 5 steps. A picture is attached to help me figure out how do this. Again, a run! button is not showing up now still.
image text in transcribed

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

Knowledge Discovery In Databases

Authors: Gregory Piatetsky-Shapiro, William Frawley

1st Edition

0262660709, 978-0262660709

More Books

Students also viewed these Databases questions