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


Answer: B

Computer Science & Information Technology

You might also like to view...

All programs can be written in terms of three types of control structures: _______, _______ and _______.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

When checking the width of the gutter, which of the following contains the Gutter value?

A. Gutter Value dialog box B. Margins and Columns dialog box C. Body / Text dialog box D. Location dialog box

Computer Science & Information Technology

The Break statement is the only way to prevent the rest of the code from being performed.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

During which type of DoS can the attacker use a transmitter to flood the airwaves in the vicinity of the wireless network?

a. Authentication flood attack b. Deauthentication flood attack c. Network jamming attack d. Equipment destruction attack

Computer Science & Information Technology