Hi, working on this assignment on acess2016, and cannot figure out how to get these queries working. Here are the instructions:

Create a query that displays data from all three tables in the database as follows: the HikerLast, City, and State fields from the Hiker table; the TourDate field from the Reservation table; and the TourName and TourType fields from the Tour table. Specify that the query select only those records for guests from West Virginia (WV) or guests who are taking climbing tours. Sort the query in ascending order by Tour Name. Save the query as WestVirginiaOrClimbing and then run the query. Resize datasheet columns to their best fit, as necessary, and then save and close the query.

8. Copy and paste the WestVirginiaOrClimbing query to create a new query named SouthCarolinaAndSeptember.

9. Modify the SouthCarolinaAndSeptember query to select all guests from South Carolina (SC) who are taking a tour starting sometime in the month of September 2017. Do not include the State field values in the query results. Run the query. Resize datasheet columns to their best fit, as necessary, and then save and close the query.

10. Create a query that displays the ReservationID, TourDate, and People fields from the Reservation table, and the TourName and PricePerPerson fields from the Tour table for all reservations with a People field value greater than

1. Save the query as ReservationCosts. Add a field to the query named TotalCost that displays the results of multiplying the People field values by the PricePerPerson field values. Set the Caption property Total Cost for the calculated field. Display the results in descending order by TotalCost. Run the query. Modify the query by formatting the TotalCost field to show 0 decimal places. Run the query, resize datasheet columns to their best fit, as necessary, and then save and close the query.

11. Create a query based on the Tour table that determines the minimum, average, and maximum price per person for all tours. Then complete the following:

a. Specify field names of LowestPrice, AveragePrice, and HighestPrice.

b. Set the Caption property for each field to include a space between the two words in the field name.

c. Save the query as PriceStatistics, and then run the query.

d. In Design view, specify the Standard format and two decimal places for each column.

e. Run the query, resize all the datasheet columns to their best fit, save your changes, and then close the query.

f. Create a copy of the PriceStatistics query named PriceStatisticsByTourType.

g. Modify the PriceStatisticsByTourType query to display the price statistics grouped by TourType, with TourType appearing as the first field. Save your changes, and then run and close the query.

h. Compact and repair the Appalachia database, and then close it.

Here is my database so far: https://ufile.io/hw5m1 Thank you!