Robert has imported some data from Access and is using the Query Wizard to filter the data. Please refer to the above figure when answering the questions below.
-Robert wants to send a special gift to anyone who has placed his or her first order in the past three months or who has total sales of over $1,000 per year. In this case, Robert would use a(n) ____.
A) And query
B) Or query
C) either a or b
D) neither a nor b

Question

Robert has imported some data from Access and is using the Query Wizard to filter the data. Please refer to the above figure when answering the questions below.
-Robert wants to send a special gift to anyone who has placed his or her first order in the past three months or who has total sales of over $1,000 per year. In this case, Robert would use a(n) ____.
A) And query 
B) Or query 
C) either a or b 
D) neither a nor b

Quizplus · Accepted Answer

Robert wants to include customers who meet either of two criteria: those who placed their first order within the past three months or those with total sales over $1,000 per year. This requires an "Or" query, where both conditions are checked separately and the results are combined. An "And" query would only include customers who meet both criteria simultaneously, which is not what Robert wants.

Robert Has Imported Some Data from Access and Is Using