Exam 8: Integration Lesson 1: Understanding Integration Fundamentals

When you integrate information between programs, the information being shared is referred to as a(n) data source .

To import data, you can use the Mail Merge Wizard in the destination program to guide you through the process.

When you import from Excel into Access, a copy of the data is brought into Access and stored in a new or existing ____.

Which task is most similar to copying and pasting?

The source file is not resaved in the destination file when you link.

When you embed an object, the object remains in the source file and you place a link to the object in the destination file.

You can save the steps of a(n) ____ process so they can be easily repeated again in the future without using the wizard.

Case INT 1-1 In the past, Tara frequently needed to update a Word report with sales data from Excel, so she inserted a linked table into the document. Now that she no longer needs the object to be linked, she wants to break the link. To display the Links dialog box, Tara would click the File tab, click ____, and then click Edit Links to Files.

Embedding is useful when the object you are integrating requires tools and features not normally supported by the destination program.

When sharing information between programs, the originating file is called the destination file.

When you embed an object, there is no connection to the source program.

The source and destination files must be stored on the same computer or network when you are ____.

When creating a table in Access using data from an Excel worksheet, Access would be the ____.

____________________ is an integration technology in Office that allows you to share information between Office programs.

Case INT 1-2 Brayden plans to use the Mail Merge Wizard to create personalized form letters to send out to each of his clients announcing the grand opening of his new office. To start the process, Brayden would click the Start Mail Merge button on the ____ tab in the Start Mail Merge group and then click Step by Step Mail Merge Wizard.

____ is used to make content that is created in the source program available and fully editable in the destination program.

____________________ is the process of using information in a file created in one program and incorporating it into a file created in another program.

You can export a ____ from Access to a variety of Office programs.

> is an example of a(n) ____.