A school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?
A)Perform two separate select queries, using only one zip code for each task
B)Perform a single select query, placing the zip codes on the same Criteria line of the query
C)Perform a single select query, placing the zip codes on separate Criteria lines of the query
D)Perform a single, update query
E)none of these (this is not possible using Microsoft Access)

Question

Quizplus · Accepted Answer

The Answer of A school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?
A)Perform two separate select queries, using only one zip code for each task
B)Perform a single select query, placing the zip codes on the same Criteria line of the query
C)Perform a single select query, placing the zip codes on separate Criteria lines of the query
D)Perform a single, update query
E)none of these (this is not possible using Microsoft Access)

A School Administrator Wishes to Select the Names of All