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

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

You can choose to import Excel data directly into a new table or you can ____ the data to an existing table.

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. If the Last Name value in record 1 of the Guides table was not revised after your first attempt to update, what should you do?

You cannot import data into an Access database table from a text file.

To convert raw data in Excel to a date, you should use the ____ format.

When you add data from one table to an existing table, you need to make sure that the number of records is the same in both tables.

You cannot copy an Access table and paste it directly into Word as a link.

Explain how to use Office integration techniques to accomplish diverse business tasks quickly and easily.

When the Paste Special dialog box is open in Word, select the ____ option to allow for flexible formatting capabilities.

The proper formula for finding the product of E2 and F2 in the figure above is ____.

You can import data into Access from ____.

If you are adding ten Excel records to an existing Access table, you should ensure that the Access table has ____ records.

A workbook that you plan to export from Excel into Access should only contain the ____ that you want to appear in the Access table.

To change the structure of a table in Access, you need to click the View button and then switch to ____________________ View.

You can increase efficiency by integrating the information you create in Word, Excel, and Access.

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. How do you locate the external Excel data from the Access application?

After pasting a table into Word as a link, you can modify the ____________________ of the pasted table so that the table is attractive and communicates the data clearly.

You can modify calculations based on the pasted data in Excel that is linked to an Access source table.

Explain what rules you should observe when opening files created in different applications.

You can copy a table created in Word into an Access table .