Administrator: Rave Reviews Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 More

Review the Data

Microsoft Access has a Query Wizard that compares two tables and determines if there are any records which do not match. This would be an excellent tool to confirm if the Archive Movie Table got all of the old movies.

 

Try it: Find Unmatched Records

Go to Create->Query.

Select Find Unmatched Records.

Create ->Query Wizard  -> Find Unmatched Query Wizard
 

 

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

  4.1.2.  Create queries based on more than one table: Find unmatched records