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…

The correct answer is C. Find Duplicates. 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…

Creating and Modifying Queries

Question

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?

Options

ASimple
BFind Unmatched
CFind Duplicates
DCrosstab

How the community answered

(26 responses)

A
4% (1)
B
15% (4)
C
73% (19)
D
8% (2)

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.

Topics

#Find Duplicates wizard#query wizard#duplicate records#customer orders

Community Discussion

No community discussion yet for this question.

Full 77-885 Practice