Jack Wants to Find the Number of Records Containing "Unpaid

question 105

Multiple Choice

Jack wants to find the number of records containing "Unpaid" in the Invoice field. Which of the following aggregate functions should he use in Query Design view?

• A) Sum
• B) Minimum
• C) Average
• D) Count

---

Definitions:

Extraneous Solutions

Extraneous solutions are solutions that arise in the process of solving an equation but do not satisfy the original equation.

Equation

An affirmation in mathematics that posits the equality of two different expressions.

Directly

Directly refers to a manner of action or occurrence that happens without any intervening factors or steps.

Square

A mathematical operation involving multiplying a number by itself, or a geometric figure with four equal sides and four right angles.