Which Excel External Data Option Automatically Updates a Table in the Access

question 29

Multiple Choice

Which Excel external data option automatically updates a table in the Access database when the Excel source file is updated?

• A)import the source data into a new table
• B)link to the data source by creating a linked table
• C)append a copy of the records to a table
• D)copy the data source from Excel

---

Definitions:

Misstatement

An error or inaccuracy in financial records or statements, often resulting due to oversight or misunderstanding.

Cash Management

The process of collecting, managing, and investing a company's cash in a way that optimizes its liquidity, investment return, and risk levels.

Receivables

Amounts owed to a business by its customers for goods or services delivered but not yet paid for.

Expenditures

The flow of cash or cash-equivalent amounts paid out by a company to meet obligations or purchase goods and services.