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

Question 1

In Access,Word Merge is on the ____ tab.

A) MAIL
B) MERGE
C) MAIL MERGE
D) EXTERNAL DATA

Answer 1

D

Question 2

The Query Wizard button opens the ____.

A) Simple Query Wizard dialog box
B) Smart Query Wizard dialog box
C) Query Wizard dialog box
D) Merge it With Microsoft Office Word dialog box

Answer 2

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.

A) Merge All
B) Merge it
C) Combine Access and Word
D) Merge it with Microsoft Office Word

Answer 3

D

Question 4

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

A) Start Mail Merge
B) Mail Merge Recipients
C) Filter and Sort
D) Merge Criteria

Question 5

The Address Block button is found on the ____ group.

A) Name & Address
B) Insert Address
C) Write & Insert Fields
D) Address

Question 6

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

A) FILE
B) EDIT
C) QUERY
D) CREATE

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.

Question 8

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

Question 9

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

A) Microsoft Word
B) Microsoft Access
C) the Simple Wizard dialog box
D) the Merge it With Microsoft Office Word dialog box

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.

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.

A) in Rich Text Format
B) as a JPEG
C) in .accdb format
D) in HTML format

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.

A) Preview
B) Preview Results
C) Check Spacing
D) Preview Merge

Question 13

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

Question 14

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

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.

A) Simple Query Wizard
B) Advanced Query Wizard
C) Merge Query Wizard
D) Word Query Wizard

Question 16

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

A) list of available tables and queries that can be used in the query
B) list of selected fields that can be used in the query
C) list of available fields that can be used in the query
D) list of Word documents to choose from that will act as the form letter after the merge

Question 17

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

A) Excel
B) PowerPoint
C) Outlook
D) Access

Question 18

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

A) list of available tables and queries that can be used in the query
B) list of selected fields that can be used in the query
C) list of available fields that can be used in the query
D) list of Word documents to choose from that will act as the form letter after the merge

Question 19

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

A) list of available tables and queries that can be used in the query
B) list of selected fields that can be used in the query
C) list of available fields that can be used in the query
D) list of Word documents to choose from that will act as the form letter after the merge

Question 20

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

A) [Enter]
B) [Page Down]
C) [Tab]
D) [Alt]

Question 21

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

A) linked
B) embedded
C) formatted
D) editable

Question 22

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.

A) file
B) report
C) table
D) chart

Question 23

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

Question 24

The Access table in the accompanying figure has the ____ format applied.

A) Banded Rows
B) Alternating Rows
C) Alternating Columns
D) Banded Columns

Question 25

An Access table you import into Word is not ____.

A) embedded
B) editable
C) linked
D) locked

Question 26

You can export an Access table to ____ when you want to use its features to filter,chart,analyze,or edit the table data.

A) AutoCad
B) Excel
C) Word
D) PowerPoint

Question 27

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

Question 28

When merging from Access to Word,you can edit the recipients list in Word and use the ____________________ options to select the records you want to use in the merge.

Question 29

In the accompanying figure,the double arrow buttons in the center of the dialog box are used if you want to select all ____________________.

Question 30

In Excel,the Subtotal button appears in the ____ group of the DATA tab.

A) Total
B) AutoSum
C) Outline
D) Calculate

Question 31

If you export an Access report to Word,you can use the tools in Word to convert the report into a(n)____.

A) list
B) table
C) chart
D) outline

Question 32

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

A) the Access table
B) Microsoft Word
C) the Access database
D) the .rtf file

Question 33

When you want to include an Access table in a Word document,you first export it to a document that is saved in ____________________ Format.

Question 34

The ____ feature in Excel can perform calculations on sorted data,such as calculating the total amount that each company in the list spent on travel.

A) Subtotal
B) Sort
C) SUM
D) Calculate

Question 35

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.

Question 36

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

Question 37

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

Question 38

To create a column chart in Excel,first select a range of data,then click the Insert Column Chart button in the Charts group on the ____ tab.

A) INSERT
B) CHART
C) DATA
D) FORMAT

Question 39

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

Question 40

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.