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

If you want to select from a variety of formatting options when pasting an object into Word, you should use the Paste Format command.

Be sure to click the Excel button in the Export group when transferring data from Excel into Access.

The source of the data shown in the figure above is a(n) ____ in Word.

You can copy an existing table from Word and paste it into a new Access ____________________.

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

Excel contains ____ tools not available in Access.

The figures pointed to by item 1 in the figure above are given meaning by the ____ format.

The most appropriate application for storing information that does not require calculations or formal presentation is ____.

Explain how to link an Access table to Excel and Word.

You can modify cell formatting of pasted data in Excel that is linked to the Access source table.

The most appropriate tool for formatting the data pointed to by item 2 in the figure above is ____.

After importing Excel data into Access without links, any changes you make to the Excel source data will be reflected in the Access table.

In Word, the ____ Link command is used to update data linked to an Excel spreadsheet and Access source table.

If you want to import additional records to an existing Access database, make sure that the imported Excel data contains the same number of ____________________ as the database.

Mary Lou Jacobs has asked you to test the quality of links from an Access table to an Excel spreadsheet and a Word document. In the figure below, the Tours table is linked to a table in Excel, which in turn is linked to a source Access table. The Guides table is directly linked to a source Access table. After changing the last name in record 1 of the source Access Guides table to Abrams, how do you verify that Last Name changes to Abrams in Word?

You can delete any of the rows in pasted Excel data that are linked to an Access source table.

During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.

You use the ____ command in Access to import data from an outside source.

In the figure above, the ____ button opens a dialog box that enables you to navigate to the drive and folder where you store your Data Files.