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:

Interdependent

Mutually dependent; the condition in which two or more persons or elements rely on each other for support, functioning, or survival.

Systematic Approach

Involves a structured, methodical process for solving problems or achieving objectives, often based on a step-by-step methodology.

Theoretical Works

Scholarly writings or concepts that provide explanations or frameworks to understand phenomena within a specific field, based on principles and theories.

Cephalocaudal

A principle of development describing how growth starts at the head and moves towards the feet.