Answered step by step
Verified Expert Solution
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 dropdown 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 dropdown 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.
Rightclick 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
Click the Save button and save the changes to the query.
Test the query.
Click the Run button.
Enter in the Enter the Start Date box of the Enter Parameter Value dialog box.
Click OK
Enter 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
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 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 dropdown arrow in the first Field row cell in the query design grid and select FKBoatID.
Click the Sort row, click the dropdown arrow, and select Ascending.
Click the second cell in the Field row, click the dropdown 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 records Figure 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 records Figure 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 steps. A picture is attached to help me figure out how do this. Again, a run! button is not showing up now still.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started