Access: Investigations Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

Rex Stout, creator of Nero Wolfe
Create ->Query Design -> Join Properties

Test the Query

Add the Fields:

Movie

Genre

Rating

 

Test the Query.

Does your query return all of the movies? Are some of the records incomplete: no genre or no rating?

 

Save the Query and name it MovieTitleSearchSQ

 

  Microsoft Access 2007 Exam 77-605 Topic: 4. Creating and modifying queries 

  4.1. Create queries  4.1.1. Create queries based on single tables: Add fields to queries