I need to have screenshots of the DESIGN view of the query to understand how it works.

10. For the movie theater database from Exercise 1, create a Totals query that prompts for an actor in a movie and a show period with a beginning date and an ending date and returns the title of each movie including the selected actor and the total number of shows for each movie in the selected period. Note that the user input for the prompt of an actor may contain only the first name or the last name of the actor, whereas an actor stored in the database has the actors full name. The format of the query result is shown as follows.

Below is the data that is currently in the database from a previous exercise in Movie, Show and ShowRoom

Below is the the Relationships view in Access of my database

Below is the relational model of the database if you need it

Title TotalShows Moneyball The Thing Title TotalShows Moneyball The Thing