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:

High-Level

A term used to describe activities or plans that are of great importance or operate at a senior decision-making level.

Validated Learning

An approach in lean startup methodology where insights and understanding are gained by trying out initial ideas and iteratively testing them with users.

Prototype

A preliminary model or version of a product used to test and refine design and functionality before final production.

Iteration

The process of repeating a sequence of operations or activities in order to generate a desired outcome or improve a product, system, or design.