Give the design view of the query in the ACCESS database. For the movie theater

Question

Give the design view of the query in the ACCESS database.

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 actor's full name. The format of the query result is shown as follows.

Explanation / Answer

Using select and where clause we can write this query.

Explanation: Fetching the title and number of shows where matching criteria is (matching actor name and between dates).

Here is the query

select title, count(shows) from movie

where (movieDate between CDate(startDate) and CDate(endDate))

and (actorName = lastName or actorName = firstName );

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.