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.
-If Robert wanted to find all records with the value IL in the State field, he would click State in the Column to filter list box, click the State list arrow, and then click ____. Click the list arrow for the second list box, and then select IL.
A) equals
B) find
C) IL
D) search

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.
-If Robert wanted to find all records with the value IL in the State field, he would click State in the Column to filter list box, click the State list arrow, and then click ____. Click the list arrow for the second list box, and then select IL.
A) equals 
B) find 
C) IL 
D) search

Quizplus · Accepted Answer

The option "equals" is the correct choice as it will filter the data to show only the records where the State field equals IL. The options "find" and "search" are not relevant in this context as they do not apply to filtering data in a query. The option "IL" alone is not enough to filter the data as it needs to be combined with the equals operator to form a complete filter criterion.

Robert Has Imported Some Data from Access and Is Using