Which of the Following Is NOT True About Changing Field

question 23

Multiple Choice

Which of the following is NOT true about changing field names in a query?

• A) The default name that Access uses for a field that includes an aggregate function is descriptive and does not need to be changed.
• B) Field names in aggregate queries are a composite of the selected aggregate function and the table field name.
• C) The field names assigned in an aggregate query can easily be changed either before or after the query is run.
• D) You must keep the original field name in the query design grid so Access knows what field to perform the calculation on.

---

Definitions:

Depreciation Expense

This refers to the allocation of the cost of a tangible asset over its useful life, representing how much of the asset's value has been used up during a fiscal period.

Accumulated Depreciation

The total amount of depreciation expense that has been recorded against an asset since it was put into service.

Straight-line Method

An accounting method for calculating depreciation by evenly distributing the cost of an asset over its useful life.

Residual Value

The estimated remaining value of an asset at the end of its useful life.