Exam 26: Integration Unit B: Integrating Word, Excel, and Access

Describe how to link an Access table to Excel and then to Word.

In the figure above, item 2 points to an Excel table ____ Access.

Explain the options you have for copying a Word table into Access.

You can enter data into an Access ____, make calculations using that data in Excel, and then create a report in Word that incorporates the Excel data and the Access table.

In the figure above, item 1 points to a(n) ____.

You can minimize typing time by ____ Excel data directly into a table in an Access database.

By integrating information created in Word, Excel, and Access, the information ____.

You cannot append Excel data to an existing table in Access.

Because an Access table is the ____ of the data pointed to by item 2 in the figure above, whenever you change the data in the Access table, the linked data in Word also changes.

With the exception of a(n) ____________________, the Paste command allows you to paste an object without creating a link.

If you need to create sales charts, order new products, complete purchase orders, and produce proposals to obtain new contracts, you can use ____ techniques in the Office suite to accomplish your tasks.

You can import data from an Excel spreadsheet into Access.

To copy the spreadsheet data in the figure above to the Clipboard, you should first select the range B1:____.

Mary Lou Jacobs has asked you to train a colleague in Office integration tasks. Your colleague has some questions about the procedure for importing an Excel spreadsheet into an Access table, which is represented in the figure below. Which option In the Get External Data Excel Spreadsheet dialog box links the imported data to the imported Excel source file?

In the figure above, item 1 points to ____.

The Paste Special command does not provide formatting options for pasted objects that are not linked.

In the Get External Data Excel Spreadsheet dialog box shown in the figure above, you can choose from among ____ options.

The data shown in the figure above contains six ____.

You link an Access table to Excel and then to Word when you want the data in all three applications to always remain ____.

If you want to retain the source format of the spreadsheet in the figure above, select the ____ format when pasting and linking in the destination Word file.