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:

Residential Psychiatric Facilities

Healthcare establishments where individuals with significant mental health conditions live and receive psychiatric care and treatment on a long-term basis.

Mentally Ill Women

Refers to females suffering from mental disorders that affect their emotions, thinking, behavior, and perception, possibly impacting their overall well-being and function in society.

Violent Acts

Behaviors that involve force or the threat of force against others, which can result in harm or injury.

Major Depression

A mental disorder characterized by persistent sadness, lack of interest in activities, and various physical symptoms, negatively affecting daily functioning.