|
The Genre
Combo will be based on a new Select Query that uses three Tables. This Query will also use the Group By
option. Our Query
will look up the Rating that the User selected on the Movie
Form with the Rating Combo Box. We will create this code with the
Expression Builder. Before
You Begin: Close all of the Tables, Forms or Queries. 1. Try
it: Create a Select Query What Do
You See? A blank query
will open. The Show Table window will prompt you to
choose a Table or Query. Select a
Table: tblMovies.
Click
Add. Select a
second
Table: tblRating.
Click Add. Select a
third
Table: tblGenre.
Click Add. Click
Close.
Keep
going...
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.2. Manage source tables and
relationships: Use the Show Table Command
Create->Queries->Query Design |
|
| |
