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

You can merge a(n)____ database with a Word letter to produce a series of individually addressed form letters.

The Query Wizard button opens the ____.

You ____________________ an Access table to Excel when you want to use Excel features to analyze,chart,filter,or edit the table data but when you don't need to maintain a connection between the Access and Excel objects.

If you don't need to modify database information in Excel,you can export an Access ____ to an RTF file that you can then open and modify in Word.

In Access,you can open the Export - RTF File dialog box by first clicking the ____________________ tab,then the More button,and then Word.

-In the accompanying figure,item 1 points to the ____.

An Access table imported into Word is linked,so any changes you make to the database in Access appear in the table exported to Word.

-In the accompanying figure,item 2 points to the ____.

You can choose which records you want to merge from an Access table to a Word document.

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

-In the accompanying figure,item 3 points to the ____.

-Item ____________________ in the accompanying figure points to the selected fields.

Before you click the Finish & Merge button,you should click the ____ button to see if any spaces need to be added or deleted.

-Item ____________________ in the accompanying figure points to the list of available tables to choose from.

You can merge data from an Access database containing the names,addresses,and other information about a company's customers,contacts,and suppliers with a letter you create in ____________________ to produce a series of individually addressed form letters.

To include Access data in a Word document,you can export a table or a query to a document ____ that you can open in Word.

In Access,Word Merge is on the ____ tab.

The Use Destination Theme & Embed Workbook paste option ensures that a pasted chart will not be ____.

In an Access record,you press ____ to move from one field to another.

-Item ____________________ in the accompanying figure points to the available fields.