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

question 546

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

---

Definitions:

Data Connector

The means of connecting an electronic service tool (EST) to a chassis data bus. Data bus connectors can be six-pin (J1587/1708) or the newer nine-pin (J1939) Deutsch black and green connectors. All U.S.-built trucks have a data connector located on the left side of the steering column, either under the dash or to the left side of the driver’s seat.

Weatherpac

A brand of weatherproof connectors used in automotive and other industries to ensure electrical connections remain secure and unaffected by environmental conditions.

Power Line Carrier Multiplexing

A technology that allows for the transmission of data over electric power lines, enabling communication or control signals.

Vehicle System

A term referring to the entire ensemble of interconnected components and systems within a vehicle that work together to ensure its operation.