Exam 6: Integrating Access

Explore all topics

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.

(Essay)

4.7/5

(35)

Question 21

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

(Short Answer)

4.9/5

(37)

Question 22

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

(True/False)

4.9/5

(42)

Question 23

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.

(Multiple Choice)

4.9/5

(39)

Question 24

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

(Multiple Choice)

4.8/5

(31)

Question 25

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.

(Multiple Choice)

4.9/5

(33)

Question 26

When a field name in the data source contains a space, the merge field in Word replaces the space with a question mark.

(True/False)

4.9/5

(28)

Question 27

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.

(Multiple Choice)

4.9/5

(43)

Question 28

When you export the data to Excel, it will be saved in Excel format, with each field in the table stored in a worksheet column and each record in the table stored as a row in the worksheet.

(True/False)

4.8/5

(32)

Question 29

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

(True/False)

5.0/5

(29)

Question 30

When data is formatted using comma separators, the comma is called a limiter .

(True/False)

4.8/5

(26)

Question 31

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

(Multiple Choice)

4.8/5

(39)

Question 32

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

(Multiple Choice)

4.7/5

(38)

Question 33

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?

(Multiple Choice)

4.9/5

(31)

Question 34

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

(Multiple Choice)

4.8/5

(43)

Question 35

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

(Multiple Choice)

4.8/5

(42)

Question 36

Identify the letter of the choice that best matches the phrase or definition.

If you click the Address block link in the Mail Merge task pane, the ____ Address Block dialog box opens and shows a preview of the address information.

Address

To merge selected records in the data source, click the ____ recipient list link in the Mail Merge task pane to open the Mail Merge Recipients dialog box.

Insert

Use the ____ block link in the Mail Merge task pane to add an address to the letter in the location of the insertion point.

Merge

Correct Answer:

Verified

If you click the Address block link in the Mail Merge task pane, the ____ Address Block dialog box opens and shows a preview of the address information.

To merge selected records in the data source, click the ____ recipient list link in the Mail Merge task pane to open the Mail Merge Recipients dialog box.

Use the ____ block link in the Mail Merge task pane to add an address to the letter in the location of the insertion point.

Click the Print link in the ____ section of the Mail Merge task pane to print the letters.

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.

(Matching)

4.7/5

(35)

Question 37

When you merge the data source with the form letter, one letter is printed for each record in the data source. In this case, the form letter is also called the primary document.

(True/False)

4.9/5

(41)

Question 38

Most word processors, including Word, can open files with the .rtf file name extension.

(True/False)

4.9/5

(38)

Question 39

To import data and create a new table, click the External Data tab on the Ribbon, and then click the Text File button in the ____ group.

(Multiple Choice)

4.8/5

(37)

Question 40

Showing 21 - 40 of 46

Exam 6: Integrating Access

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

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

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.

FIGURE AC 6-1 Referring to Figure AC 6-1 above, the following is NOT a field 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 a field name in the data source contains a space, the merge field in Word replaces the space with a question mark.

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.

When you export the data to Excel, it will be saved in Excel format, with each field in the table stored in a worksheet column and each record in the table stored as a row in the worksheet.

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

When data is formatted using comma separators, the comma is called a limiter .

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

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

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?

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

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

When you merge the data source with the form letter, one letter is printed for each record in the data source. In this case, the form letter is also called the primary document.

Most word processors, including Word, can open files with the .rtf file name extension.

To import data and create a new table, click the External Data tab on the Ribbon, and then click the Text File button in the ____ group.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters