|
3. Try it: Add Fields to
the Query
Double click to add the
following Fields:
From tblGenre: Genre.
From tblRating: Rating.
From tblMovies: Movie.
Sort the Genre: Ascending.
Do This, Too: Save the
Query
Go to File->Save.
Enter the Query Name:
RatingSearchSQ.
RatingSearch because we are
looking for the Rating that was selected on the Search Form. SQ
because this is a Select Query.
Click OK. Keep
going.
Query Design Tools ->Design
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Create a
Select Query |
|
| |
