graphic2
graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.2 Modify a Query: Add New Fields

Add Fields to the Query

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