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:

Common Features

Shared characteristics or attributes observed in items, concepts, or phenomena within a particular category.

Abnormal Spoilage

Waste or spoilage that exceeds the normal or expected levels during the manufacturing process.

Weighted Average Method

An inventory valuation method that assigns a weighted average cost to each unit of inventory, taking into account both the cost of goods available for sale and the number of units available.

Unit Costs

The cost incurred to produce, store, and sell one unit of a product or service.