MOS Access Expert Practice Questions - Microsoft Office Specialist Access Expert (Office 2019) (Exam MO-500) Exam

Access More Questions

You want to bring data from an Excel worksheet into an existing Access database while keeping a live connection so changes in Excel are reflected in Access. Which option on the External Data tab accomplishes this?

Import the source data into a new table in the current database Append a copy of the records to an existing table Link to the data source by creating a linked table Export the Access table to the Excel workbook

Correct Answer:

Link to the data source by creating a linked table

Access more questions from this quiz

Continue to MOS Access Expert Practice Questions - Microsoft Office Specialist Access Expert (Office 2019) (Exam MO-500) Exam for more practice questions and the full quiz experience.

Access More Questions