Question 1

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.

Accepted Answer

The "Address block" link in the Mail Merge task pane will automatically add the recipient's address in the correct format to the letter at the location of the insertion point. The other options listed do not offer this specific functionality.

Question 2

FIGURE AC 6-1  Referring to Figure AC 6-1 above, the data source for the mail merge is a(n) ____.

Accepted Answer

The answer of FIGURE AC 6-1  Referring to Figure...

Question 3

After verifying that your form letters are correct, click the ____ link at the bottom of the Mail Merge pane.

Accepted Answer

Clicking the "Next: Complete the merge" link at the bottom of the Mail Merge pane will take you to the final step in the process where you can preview the merged documents, customize settings, and complete the merge. The other options (Merge, Complete, Next) do not lead to the final step and may not complete the merge process.

Question 4

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

Accepted Answer

The columns in the worksheet must be the same as the fields in the database and they must contain the same type of data in order for the records to be added accurately. Therefore, the correct answer is both a. and b.

Question 5

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?

Accepted Answer

Kathleen should clear the check box next to the recipient's name in the Mail Merge Recipients dialog box to remove them from the mailing list.

Question 6

FIGURE AC 6-1  Referring to Figure AC 6-1 above, the following is NOT a field in the data source: ____.

Accepted Answer

"Data Source" is not a field in the data source. The other options (Address, City, Last Name) are fields that could potentially be included in the data source.

Question 7

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.

Accepted Answer

The "Refine recipient list" section in the Mail Merge Recipients dialog box provides options for sorting and filtering data, finding duplicate records, locating a specific recipient, and validating addresses. It is the most appropriate choice for the given question. The other options (A, B, and D) either do not apply to this context or are not relevant to the question.

Question 8

You can add merge fields individually at the location of the insertion point by clicking the Insert Merge Field button in the Write & Insert Fields group on the ____ tab.

Accepted Answer

The Mailings tab is where all of the mail merge features are located, including the ability to insert merge fields. Therefore, the correct choice is C, Mailings.

Question 9

When you need to export data from a database table to an Excel workbook, click the ____ tab on the Ribbon, and then click the Excel button in the Export group.

Accepted Answer

The External Data tab on the Ribbon includes options for importing and exporting data from a variety of sources, including Excel. The Export group within this tab specifically includes options for exporting data to various formats, including Excel. Therefore, the correct answer is A) External Data.

Question 10

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?

Accepted Answer

When exporting Access data into Word, the file is typically saved in the Rich Text Format (.rtf), which is compatible with Word.

Question 11

If the preview of the address block in the mail merge is correct, click OK. If it is incorrect, click ____ to make adjustments.

Accepted Answer

If the address block is incorrect, you can click "Match Fields" to adjust how the fields in your data source correspond to the fields in the address block.

Question 12

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.

Accepted Answer

The Navigation Pane is where the tables and queries are listed in Access, making it the most logical location to select the data source for the mail merge. The Task pane is not specific to Access and may not even be open, the status bar only displays information about the database, and the Ribbon is used for accessing commands and options, not selecting the data source for a mail merge.

Question 13

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

Accepted Answer

The field name is enclosed in double angle brackets << >> when inserting a merge field in a Word document.

Question 14

To create a filter using the Filter and Sort dialog box, use the Field list arrow to select the field to filter, use the Comparison list arrow to choose the filter operator, and then type a value in the ____ text box.

Accepted Answer

The "Compare to" text box is where you enter the value that you want to filter by.

Question 15

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 needs to put the mail merge recipient list in alphabetical order. What is her next step?

Accepted Answer

Kathleen should click the Sort link to open the Filter and Sort dialog box. From there she can choose to sort the recipients by any column in alphabetical order. Option A is not necessary since the sorting function is built-in to the dialog box. Option B is not correct as filtering is not necessary to sort in alphabetical order.

Question 16

When you start the mail merge from Access, ____.

Accepted Answer

When starting a mail merge from Access, Word automatically sets the data source using the Access database you are working with.

Question 17

The data source for a form letter can be a(n) ____.

Accepted Answer

Any of the above options can serve as a data source for a form letter, depending on where the necessary information is stored. Word documents, Excel workbooks, and Access databases can all be used to extract data for form letters. Therefore, the best choice is any of the above.

Question 18

When you save database data in another file format, you ____________________ the data from the database.

Accepted Answer

The answer of When you save database data in another...

Question 19

Case AC 6-2 Ross is exporting Access data into Word. What should Ross do to get the export of the Access database into Microsoft Word started?

Accepted Answer

To export Access data into Word, Ross should click the External Data tab on the Ribbon, click the More button in the Export group, and then click Word. This will open the Export - Word Document wizard where Ross can select data from a table or query, choose formatting options, and save the exported data as a Word document. Option A is not correct because there is no Export Data tab on the Ribbon. Option C is not correct because there is no Internal Data tab on the Ribbon. Option D is not correct because one of the other options is the correct way to initiate the export.

Question 20

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.

Accepted Answer

The correct choice is "Filter" because clicking the "Filter" link in the Refine recipient list section opens the Filter and Sort dialog box with the Filter Records tab selected, allowing you to filter mail merge records.

Quiz 6: Access Lesson 6: Integrating Access