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)

---

Definitions:

Worksheet

A columnar device used by accountants to aid them in completing the accounting cycle—often just referred to as "spreadsheet." It is not a formal report.

Revenue

The total income received by a company from its normal business activities, before any expenses are subtracted.

Long-term Liabilities

Financial obligations of a business that are due more than one year in the future, such as bonds payable or long-term loans.