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 is looking for all the customers who both are in the state of IL and have a 312 area code. He would create 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 is looking for all the customers who both are in the state of IL and have a 312 area code. He would create a(n) ____.
A) And query 
B) Or query 
C) either a or b 
D) neither a nor b

Quizplus · Accepted Answer

Robert is looking for customers who meet both conditions (state of IL and 312 area code), so he would use an And query. An Or query would return customers who match either condition, not necessarily both.

Robert Has Imported Some Data from Access and Is Using