Final answer:
To create a new summary query in design view to calculate the total dollar value of full day rentals by boat, you need to use a database software like Microsoft Access. Use the Sum function to tally up the rental dollar values and group them by boat, ensuring you include only full day rentals in your criteria.
Step-by-step explanation:
To create a new summary query in design view for San Diego Sailing to find out the total dollar value of full day rentals by boat, you will need to use a database software like Microsoft Access. Here is a step-by-step process:
Open the design view in Microsoft Access.
Add the sdrentals table to the query design.
Select the boat field that identifies each unique boat.
Next, add the field that contains the dollar value of the rentals.
Then, set up the query to calculate the sum of the rental values. For this, you may need to use the Sum function in the Total row of the query design grid.
Set the criteria for the sum function to only include full day rentals if there's a field that specifies the rental duration.
After setting up your fields and criteria, run the query to view the total dollar value of full day rentals by boat.
This will give you a summary of the total revenues generated from full day rentals, categorised by boat, based on the data in the sdrentals table.