What Do You Know?

The Movie table stores the name of the movie, the year it was released, the rating and the genre. This data should be included in your report.

 

Try it: Create a Movie Query

Go to Create ->Query Design

Select tblMovieTitles at the Show Table

 

Add the following fields from tblMovieTitles:  Movie, Year, Rating and Genre.

 

Edit the Movie field: Sort Ascending

 

Now, run your query and look at the data.

 

Save this query for your report.

Name it: rptMovieTitleSQ