Question 1

In Access,Word Merge is on the ____ tab.

Accepted Answer

D

Question 2

The Query Wizard button opens the ____.

Accepted Answer

A

Question 3

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.

Accepted Answer

The correct feature to initiate the merge process directly from Access by merging data contained in an Access query datasheet with a Word document is "Merge it with Microsoft Office Word." This option integrates Access data with Word for document creation and mailing purposes.

Question 4

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

Accepted Answer

The "Filter and Sort" dialog box in the mail merge process allows users to specify criteria to filter and sort the records that will be included in the merge, ensuring that only records meeting certain conditions are selected.

Question 5

The Address Block button is found on the ____ group.

Accepted Answer

The Address Block button is part of the "Write & Insert Fields" group in applications like Microsoft Word, which is used for creating and managing mail merge documents.

Question 6

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

Accepted Answer

The Query Wizard button is found in the "CREATE" tab in Microsoft Access. This tab is used for creating new database elements, including tables, forms, reports, and queries.

Question 7

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

Accepted Answer

Exporting an Access table to Excel creates a static copy of the data at the time of export; subsequent changes in Access do not automatically update in the Excel file.

Question 8

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

Accepted Answer

A query datasheet is a table-like view of the data in a query. It is used to preview the data before it is merged into a Word document.

Question 9

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

Accepted Answer

Microsoft Word provides filtering options during the mail merge process to select specific records for merging.

Question 10

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.

Accepted Answer

When you import an Access table into Word, it is not dynamically linked by default; changes made in the Access database after the import will not automatically reflect in the Word document.

Question 11

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.

Accepted Answer

Exporting Access data in Rich Text Format (RTF) allows it to be opened and edited in Word.

Question 12

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

Accepted Answer

The correct option is "Preview Results" because it allows you to see how the final document will look after merging, helping you identify if any spaces need to be added or deleted.

Question 13

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

Accepted Answer

Exporting an Access table to Word is a static process, meaning the exported data will not automatically update if the database information changes.

Question 14

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

Accepted Answer

In Microsoft Access, you can select specific records to merge into a Microsoft Word document by using the Mail Merge feature, which allows you to filter and select specific records for the merge process.

Question 15

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.

Accepted Answer

The Simple Query Wizard in Access allows you to select fields from a table or query to include in a new query, which can then be used to merge with a form letter in Word.

Question 16

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

Accepted Answer

Item 3 typically points to the list of available fields that can be used in the query, indicating the fields that can be selected from the tables or queries added to the query design.

Question 17

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

Accepted Answer

Access is a database management system that can be used to create and manage databases. It can also be used to merge data from a database with a Word letter to produce a series of individually addressed form letters.

Question 18

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

Accepted Answer

Item 1 typically points to the list of available tables and queries in a database application that can be used to build a query, showing the sources from which you can select fields.

Question 19

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

Accepted Answer

The answer of 
-In the accompanying figure,item 2 points to...

Question 20

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

Accepted Answer

In an Access record, pressing the [Tab] key moves the cursor from one field to the next, allowing for efficient data entry across different fields.

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