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

Question

Quizplus · Accepted Answer

Access automatically assigns the name Expr1 to a calculated field when a name is not specified by the user. However, this default name can be edited to something more meaningful, which helps in identifying the purpose of the calculated field more clearly.

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