What is the difference between the Find Duplicates Query Wizard and the Find Unmatched Query Wizard? ...

The Find Duplicates Query will find values in a field that are entered more than once. This can be used to find multiple orders for a product, or to find data entry errors where a value was mistakenly entered more than one time. The Unmatched Query Wizard finds records in one table that do not have a matching record in another table. This is helpful when you have a master table with a list of names and you are looking for those names in a second table. For example, if one table lists all students enrolled in a school, and another lists classes students are enrolled in, the unmatched query wizard will find all students enrolled in the school but who are not enrolled in any classes.