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:

Freight-in

The cost associated with transporting goods or inventory to a company, which is often included as part of the inventory cost.

Cost of Goods Sold

The direct costs attributable to the production of the goods sold by a company, including both raw materials and labor costs.

Operating Expenses

Expenses incurred during the normal operation of a business, not including the cost of goods sold.

Supplies Expense

The cost incurred from using supplies during an accounting period, recognized as an expense.