|
3.
Try it: Run the Query Go to
Query Tools ->Design->Results->Run. What Do
You See? How many records
do you see? There are 401 movies in tblMovies. This is a many-to-many relationship. Many movies have a
PG13 Rating. Many comedies are PG13. What Else
Do You See? The RatingSearchSQ Query also
returned many movies that did not have a Rating.
What Do You Think? The purpose
of this Select Query is to create a little list of Genres in a Combo
Box. Right now, this Combo Box would show lots of repeats: many G,
PG, PG13, R's on the drop down list. In the following pages we
will combine the Ratings with Totals so that the Combo Box will show
only one G, one PG, etc on the drop down list. We will also filter
out movies that don't have a Rating. So, let's keep
going...
Query Design Tools ->Design->Results->Run
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Create a
Select Query |
|
| |
