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:

Owner's Equity

The residual interest in the assets of a business after deducting liabilities, representing the owner's claim against the company's assets.

Withdrawals

Funds drawn from the enterprise by its proprietors for their personal needs.

Revenues

Revenues are the total income generated by a company from its business activities, such as sales of goods or services, before any expenses are deducted.

Expenses

The costs incurred in the process of earning revenue, including operating costs, taxes, interest, and cost of goods sold.