Please help with this Homework assignment. Show screenshot of Access Design View to show codes.

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 a screenshot of the Accesss Query Design View.