4. Run the Query

When you run a query, Microsoft Access will review your tables and find the answers to your questions.

 

Look for the red exclamation point. This is the Run command.

 

 

When you run the query, it will search tblMovieTitles and return the Movie and Year. There are 359 records in the table.

 

What do you see? The query only displays the two fields you chose: ignoring the rating, genre, and other details in the Movie table.