You Create a Calculated Field That Finds the Average of a Column

question 51

Multiple Choice

You create a calculated field that finds the average of a column of numbers. Access automatically names the field Expr1. Which of the following statements is true regarding the automatic naming of the calculated field?

• A) You cannot edit an expression in a calculated field that has been named Expr1 by Access
• B) Access assigns Expr1 to a calculated field name when an expression contains an error.
• C) You cannot edit the name of a calculated field that has been named Expr1
• D) Access assigns Expr1 to a calculated field without a name, and this name can be edited

---

Definitions:

Bona Fide Purchaser

An individual who purchases an item in good faith, without knowledge of any existing claims or defects on the property.

Security Interest

A legal claim or lien on collateral that secures the fulfillment of an obligation, often used in lending to ensure repayment.

Manufacturer

A company or individual that produces finished goods from raw materials in large quantities using tools, machinery, and labor.

Restaurant

A business establishment where meals or refreshments may be purchased by consumers.