Deck 26: Integration Unit B: Integrating Word, Excel, and Access

Question 1

After importing Excel data into Access without links, any changes you make to the Excel source data will be reflected in the Access table.

Answer 1

False

Question 2

If you need to create sales charts, order new products, complete purchase orders, and produce proposals to obtain new contracts, you can use ____ techniques in the Office suite to accomplish your tasks.

A) validation
B) authentication
C) certification
D) integration

Answer 2

D

Question 3

When you add data from one table to an existing table, you need to make sure that the number of records is the same in both tables.

Answer 3

True

Question 4

You can modify calculations based on the pasted data in Excel that is linked to an Access source table.

Question 5

You can copy a table created in Word into an Access table .

Question 6

By integrating information created in Word, Excel, and Access, the information ____.

A) persists indefinitely
B) is guaranteed to be secure
C) is guaranteed to be accurate
D) works together

Question 7

You can enter data into an Access ____, make calculations using that data in Excel, and then create a report in Word that incorporates the Excel data and the Access table.

A) workbook
B) database
C) spreadsheet
D) attachment

Question 8

Be sure to click the Excel button in the Export group when transferring data from Excel into Access.

Question 9

Before exporting data from Excel into Access, you need to remove titles, subtitles, charts, and any other extraneous data.

Question 10

You cannot import data into an Access database table from a text file.

Question 11

You can delete any of the rows in pasted Excel data that are linked to an Access source table.

Question 12

The Paste Special command does not provide formatting options for pasted objects that are not linked.

Question 13

If you want to select from a variety of formatting options when pasting an object into Word, you should use the Paste Format command.

Question 14

The most appropriate application for storing information that does not require calculations or formal presentation is ____.

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

Question 15

You can increase efficiency by integrating the information you create in Word, Excel, and Access.

Question 16

You can import data from an Excel spreadsheet into Access.

Question 17

You can modify cell formatting of pasted data in Excel that is linked to the Access source table.

Question 18

You cannot append Excel data to an existing table in Access.

Question 19

You use the ____ command in Access to import data from an outside source.

A) New
B) Open
C) Get External Data
D) Export

Question 20

You cannot copy an Access table and paste it directly into Word as a link.

Question 21

You can choose to import Excel data directly into a new table or you can ____ the data to an existing table.

A) extract
B) prefix
C) append
D) join

Question 22

In the figure above, item 2 points to an Excel table ____ Access.

A) exported from
B) deleted from
C) compressed in
D) imported into

Question 23

Excel contains ____ tools not available in Access.

A) data storage
B) copy
C) calculation
D) pasting

Question 24

In the figure above, item 1 points to ____.

A) Access data
B) Excel data
C) Word data
D) PowerPoint data

Question 25

The most appropriate tool for formatting the data pointed to by item 2 in the figure above is ____.

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

Question 26

The source of the data shown in the figure above is a(n) ____ in Word.

A) table
B) column chart
C) image
D) textbox

Question 27

In the Get External Data Excel Spreadsheet dialog box shown in the figure above, you can choose from among ____ options.

A) two
B) three
C) four
D) five

Question 28

In Word, you can click the ____ button to select the contents of an entire table.

A) Tables and Borders
B) Insert Table
C) Insert Hyperlink
D) table select

Question 29

In the figure above, item 1 points to a(n) ____.

A) import command
B) export command
C) file path
D) link command

Question 30

You can minimize typing time by ____ Excel data directly into a table in an Access database.

A) importing
B) exporting
C) compressing
D) encrypting

Question 31

After exporting Excel data into Access, the column headings in the Excel spreadsheet become ____ in the Access table.

A) data cells
B) row ids
C) record pointers
D) field names

Question 32

In the figure above, item 1 points to a(n) ____.

A) column chart
B) table
C) photograph
D) icon

Question 33

You link an Access table to Excel and then to Word when you want the data in all three applications to always remain ____.

A) current
B) static
C) secure
D) encrypted

Question 34

In the figure above, the ____ button opens a dialog box that enables you to navigate to the drive and folder where you store your Data Files.

A) OK
B) Browse
C) Cancel
D) Help

Question 35

During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.

A) values
B) locations
C) source code
D) data types

Question 36

In the figure above, item 3 points to a field name change that occurred during the ____ process.

A) export
B) linking
C) import
D) embedding

Question 37

If you are adding ten Excel records to an existing Access table, you should ensure that the Access table has ____ records.

A) five
B) ten
C) fifteen
D) twenty

Question 38

A workbook that you plan to export from Excel into Access should only contain the ____ that you want to appear in the Access table.

A) titles
B) data
C) subtitles
D) charts

Question 39

You can import data into Access from ____.

A) another Access database
B) a JPG file
C) a GIF file
D) a BMP file

Question 40

Because an Access table is the ____ of the data pointed to by item 2 in the figure above, whenever you change the data in the Access table, the linked data in Word also changes.

A) destination
B) image
C) source
D) copy

Question 41

After pasting data into Excel that is linked to an Access source table, you can ____.

A) delete rows
B) modify cell formatting
C) delete columns
D) modify the Access source table from Excel

Question 42

In the figure above, item 1 points to a(n) ____.

A) record
B) data type
C) table property
D) field name

Question 43

Explain how to use Office integration techniques to accomplish diverse business tasks quickly and easily.

Question 44

Explain what rules you should observe when opening files created in different applications.

Question 45

To copy the spreadsheet data in the figure above to the Clipboard, you should first select the range B1:____.

A) B10
B) B11
C) G11
D) G12

Question 46

Describe how to link an Access table to Excel and then to Word.

Question 47

To change the structure of a table in Access, you need to click the View button and then switch to ____________________ View.

Question 48

After pasting a table into Word as a link, you can modify the ____________________ of the pasted table so that the table is attractive and communicates the data clearly.

Question 49

Explain how to link an Access table to Excel and Word.

Question 50

The proper formula for finding the product of E2 and F2 in the figure above is ____.

A) =E2+F2
B) =E2*F2
C) =E2%F2
D) =E2/F2

Question 51

The data shown in the figure above contains six ____.

A) primary keys
B) records
C) hyperlinks
D) schemes

Question 52

With the exception of a(n) ____________________, the Paste command allows you to paste an object without creating a link.

Question 53

In Word, the ____ Link command is used to update data linked to an Excel spreadsheet and Access source table.

A) Update
B) Revise
C) Format
D) Modify

Question 54

If you want to import additional records to an existing Access database, make sure that the imported Excel data contains the same number of ____________________ as the database.

Question 55

To convert raw data in Excel to a date, you should use the ____ format.

A) General
B) Number
C) Short Date
D) Special

Question 56

You can copy an existing table from Word and paste it into a new Access ____________________.

Question 57

Explain the options you have for copying a Word table into Access.

Question 58

The figures pointed to by item 1 in the figure above are given meaning by the ____ format.

A) Accounting Number
B) Currency
C) General
D) Percentage

Question 59

If you want to retain the source format of the spreadsheet in the figure above, select the ____ format when pasting and linking in the destination Word file.

A) Formatted Text (RTF)
B) Unformatted Text
C) Word Hyperlink
D) Microsoft Office Excel Worksheet Object

Question 60

When the Paste Special dialog box is open in Word, select the ____ option to allow for flexible formatting capabilities.

A) Formatted Text (RTF)
B) Unformatted Text
C) Plain Text
D) Unformatted Unicode Text

Question 62

Mary Lou Jacobs has asked you to train a colleague in Office integration tasks. Your colleague has some questions about the procedure for importing an Excel spreadsheet into an Access table, which is represented in the figure below. How do you locate the external Excel data from the Access application?

Question 63

Mary Lou Jacobs has asked you to train a colleague in Office integration tasks. Your colleague has some questions about the procedure for importing an Excel spreadsheet into an Access table, which is represented in the figure below. Which option In the Get External Data Excel Spreadsheet dialog box links the imported data to the imported Excel source file?

Question 64

Mary Lou Jacobs has asked you to test the quality of links from an Access table to an Excel spreadsheet and a Word document. In the figure below, the Tours table is linked to a table in Excel, which in turn is linked to a source Access table. The Guides table is directly linked to a source Access table. After changing the last name in record 1 of the source Access Guides table to Abrams, how do you verify that Last Name changes to Abrams in Word?

Question 65

Mary Lou Jacobs has asked you to test the quality of links from an Access table to an Excel spreadsheet and a Word document. In the figure below, the Tours table is linked to a table in Excel, which in turn is linked to a source Access table. The Guides table is directly linked to a source Access table. After changing the Price field in record 1 (2010 Celebration) of the source Access Tours table to 5000, how do you verify that the tour Revenue changes to $75,000 in Excel and Word?

Question 66

Mary Lou Jacobs has asked you to test the quality of links from an Access table to an Excel spreadsheet and a Word document. In the figure below, the Tours table is linked to a table in Excel, which in turn is linked to a source Access table. The Guides table is directly linked to a source Access table. If the Last Name value in record 1 of the Guides table was not revised after your first attempt to update, what should you do?