What is the difference between the Find Duplicates Query Wizard and the Find Unmatched Query Wizard?
What will be an ideal response?
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.
You might also like to view...
A smartphone is a mobile phone that has Internet connectivity and is able to browse and interact with websites online
Indicate whether the statement is true or false
After you copy text from a Web page, you can paste the text without its formatting into WordPad by:
A) clicking the Paste Special button. B) clicking Paste Special from the Edit menu. C) clicking the Paste button. D) clicking Paste from the Edit menu.