Task 6

Create a query that will show film reviews that have been written for the months of January, February, March and April. The result must show:

• Who wrote the review
• Their comments
• The star rating they gave
• Film information

Show the query as screenshot of the design view.

Create a report based on the query that shows the results in an easy to read format

(part P5)(part M3) Deadline 20^th November

LO(P5): Understand how you perform queries using multiple tables and multiple criteria.
LO(M3): Learn how to export data to an external source.

Export the reviews to a Microsoft Word document. (part M3)

LO(M3): Learn how to export data to an external source.

in this i am making a new query for the form so i will be able to have the information go to the correct places



this is the queries that will take the information from multiple tables and will show the selected fields so we will be able to get the information that we require 

this shows the selected fields from the tables and how i was able to choose the fields from the tables with the information that i required

this is what happened after i ran the querie this shows all of the fields that were required so now you can see all the information for a selected movie so you can see everything that could help you decide if you want to get that movie

this is that data that i was able to export to word so it will be easier to move and can be reviewed on word so people will not need to use access