Case Access 7-2 Andrew Is an Accountant with a Large

Multiple Choice

Case Access 7-2 Andrew is an accountant with a large investment firm in New York. He keeps an Access database of travel expenditures for all of the auditors within the Oversight and Supervision Division. His database is updated nightly as part of the Computer Operations critical path runtime workload. During your initial discussion with Andrew, he raises a concern regarding how changes to the field data will affect his calculations. You explain to Andrew that if an amount in either of the fields changes, the result in the calculated field ____.

A) remains the same
B) is replaced by pound signs (#)
C) will show the new result
D) is null