Review the Record Source

1. Try This: Review the Record Source

Go to All Access Objects ->Tables.

Open a Table: tblMovies.

 

What Do You See? There are 401 Records. Each Record includes:

Movie

Year

Rating

Genre

Stars

RentalPriceID

 

How many Comedies have a PG13 Rating?

How many Comedies have an R Rating?

How many PG13 Movies are Action flix?

 

A Table is a collection of Records. Queries and Reports can analyze those Records. This lesson will use a Crosstab Query to look at the Ratings by Genre. Then, we'll use a PivotChart to visualize the data.

 

Please Close tblMovies. Let's get started.

All Access Objects ->Tables