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.