Exam 6: Access Lesson 6: Integrating Access

A form letter is a document that you create using Microsoft Word and that contains codes to tell Word where to insert the record from the data source. The codes are the same as the field names used in the data source.

When you start the mail merge from Access, ____.

Most programs have converters to separate the values in a CSV file into the ____.

You can use any document as a form letter, including documents that you create from scratch or a template.

In a CSV file, ____ separate the field values of each record in the data source.

You can filter mail merge records by clicking the ____ link in the Refine recipient list section, which opens the Filter and Sort dialog box with the Filter Records tab selected.

When you insert a merge field in a Word document, the field name is enclosed in double ____.

When you import data from a Word document, it is usually best to store it in a Word ____.

When you use the data in a workbook to add records to a database table, the columns in the worksheet ____.

You can start a mail merge from Word, but not from Access.

What types of actions can you take in the Refine recipient list section of the Mail Merge Recipients dialog box? An example given in the lesson was that you could print form letters in alphabetical order based on a specific field. Please give an example of a situation where this capability would prove useful.

In the Mail Merge Recipients dialog box, the ____ section provides options for sorting and filtering data, finding duplicate records, locating a specific recipient, and validating addresses.

You can use the ____ link in the Mail Merge task pane to add an address to the letter in the location of the insertion point.

Case AC 6-2 Ross is exporting Access data into Word. After the file is exported into Word, what file format will it be in?

You can import data stored in a workbook into a new or existing database table.

Case AC 6-1 Kathleen is working with a large recipient list for an upcoming promotional mailing. She has opened the Mail Merge Recipients dialog box. Kathleen wants to remove some of the recipients from the mail merge list so they do not receive the promotional mailing. What should she do?

When data is formatted using comma separators, it is called limited data.

A(n) ____________________ is a document that includes codes that print information from a data source.

To start a mail merge using Access, open the database that contains the data source for the form letters, and then click the data source (table or query) in the ____ to select it.