James works as a Database Designer for Tech Perfect Inc. He has to create a query that will extract
the name and address of each customer who has made more than one order. Which of the following
Query wizards should he use to accomplish the task?
A.
Simple
B.
Find Unmatched
C.
Find Duplicates
D.
Crosstab
Explanation:
In order to accomplish the task, James should use the Find Duplicates Query wizard. This wizard is
used to set up a query in order to locate records. These records contain the same data in one or
more specified fields.
Answer A is incorrect. He can use the Simple Query wizard to extract the name and address of each
customer who has ever made an order.
Answer B is incorrect. He can use the Find Unmatched Query wizard to locate the customers who do
not have made any order.Answer D is incorrect. He can use the Crosstab Query wizard to calculate and re-organize data for
making the analysis easy.