Exam 10: Integration : Integrating Word, Excel, and Access

An Access report that you export to an .rtf file is not linked to ____.

After you export an Access table to Excel,changes you make to the data in Access are also made to the data in Excel.

The Address Block button is found on the ____ group.

When you want to include an Access table in a Word document,you first export it to a document that is saved in ____________________ Format.

The first step in merging an Access database with Word is to create a query datasheet.

To create a column chart in Excel,first select a range of data,then click the Insert Column Chart button in the Charts group on the ____ tab.

You can use the filtering options in ____ to select the records you would like to use in a merge.

When merging from Access to Word,you can edit the recipients list in Word and use the ____________________ options to select the records you want to use in the merge.

In the accompanying figure,the double arrow buttons in the center of the dialog box are used if you want to select all ____________________.

An Access table you import into Word is not ____.

If you export an Access report to Word,you can use the tools in Word to convert the report into a(n)____.

You can export an Access table to ____ when you want to use its features to filter,chart,analyze,or edit the table data.

In Excel,the Subtotal button appears in the ____ group of the DATA tab.

In Access,the Query Wizard button appears in the ____ tab.

In the ____ dialog box,you can specify the criteria that each of the records you want to merge should meet.

-The Access table in the accompanying figure has the ____ format applied.

In Access,the ____ is a dialog box where you can select all the fields that you want to include in the table you will merge with a form letter you create in Word.

The ____ feature in Excel can perform calculations on sorted data,such as calculating the total amount that each company in the list spent on travel.

You export an Access table to Word when you will not need to update the exported information when the database information changes.

When merging from Access to Word,you can initiate the merge process directly from Access by using the ____ feature to merge data contained in an Access query datasheet with a Word document.