A School Administrator Wishes to Select the Names of All

question 26

Multiple Choice

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)