Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q102: When data is in a comma-delimited form,
Q103: The START function returns the starting position
Q104: The SEARCH function finds one text string
Q105: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Julie is
Q106: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Robert has
Q108: If you want to sort by more
Q109: The Subtotal command works with _ calculation(s)
Q110: When working with an Excel table, you
Q111: A PivotChart report represents source data as
Q112: A(n) _ is a set of related