Which of the following statements about calculated fields is NOT true? A. A calculated field does not store data in a recordset. B. Calculated fields use an expression or formula as its data source. C. Data contained in a calculated field is created the first time a query is run. D. A calculated field can be created using the Expression Builder dialog box.

The correct answer is: A. A calculated field does not store data in a recordset.

A calculated field is a field that is created by using an expression or formula. The expression or formula can use data from other fields in the recordset, or it can use constants. The data contained in a calculated field is created each time the query is run.

A calculated field does not store data in a recordset because it is not a real field. It is simply a way of displaying data from other fields in a recordset. The data contained in a calculated field is not stored anywhere, and it is not available for use in other queries or reports.

Here is a brief explanation of each option:

• A calculated field does not store data in a recordset. This is because it is not a real field. It is simply a way of displaying data from other fields in a recordset. The data contained in a calculated field is not stored anywhere, and it is not available for use in other queries or reports.
• Calculated fields use an expression or formula as its data source. This is true because the data contained in a calculated field is created by using an expression or formula. The expression or formula can use data from other fields in the recordset, or it can use constants.
• Data contained in a calculated field is created the first time a query is run. This is true because the data contained in a calculated field is not stored anywhere. It is created each time the query is run.
• A calculated field can be created using the Expression Builder dialog box. This is true because the Expression Builder dialog box is a tool that can be used to create expressions and formulas.