Deck 11: Integration 2: Integrating Word Excel and Access

Question 1

To add new fields to an Access table from a Word table, click New Field ​at the top of the blank column in the Access table.

Answer 1

False

Question 2

When you open files c​reated in different applications, you should open them in the order they were created.

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

The Import Spreadsheet Wizard dialog box displays a preview of the Access table.​

Question 6

If you want to import additional records to an existing database, the imported Excel data must contain the same number of fields (columns) in the database.

Question 7

You cannot paste a Word table into a new, blank Access table.​

Question 8

​When you create a link between an Access database and an Excel worksheet, you can perform calculations but you cannot create charts.

Question 9

When you link an Access table to an Excel worksheet, you cannot delete any of the columns or rows that contain copied data.​

Question 10

If a column heading has the name Participants in an Excel worksheet, you can change it to Volunteers when you import it to an Access table.​

Question 11

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

Question 12

You can import data from an Excel spreadsheet into Access.

Question 13

After you import data into a table in Access, you cannot delete field names.​

Question 14

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.

Question 15

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

Question 16

If Excel data is linked to an Access source table, you can delete any of the rows.

Question 17

When you email your files to another user, the links will not work.​

Question 18

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

Question 19

Copying a table from Word and pasting it into a new or existing table in Access saves typing time and minimizes errors.​

Question 20

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

Question 21

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

Question 22

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

Question 23

​To create a new desktop database in Access, click the _____ button.

A) ​Blank desktop database
B) ​Blank database
C) ​New desktop database
D) ​New database

Question 24

In Microsoft Office 2016, the program that is used to make calculations with data is ____.

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

Question 25

You can enter data into an Access ____.

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

Question 26

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 27

To import an Excel worksheet into Access, click the External Data tab and then click the Excel button in the _____ group. ​

A) ​Paste
B) ​Export
C) ​Files
D) ​Import & Link

Question 28

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

Question 29

To import data into an Access database, click the _____ tab.​

A) ​Import File
B) ​Import Data
C) ​External Data
D) ​New Data

Question 30

When you create a new database, Access automatically creates a blank table called New .​ ____________________

Question 31

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

Question 32

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 33

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

Question 34

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 35

You do not need to close an Access table before you check if linked data has been updated in Excel and Word.​

Question 36

To update a field in a Word table that is linked to an Access table, right-click the table click Refresh Field.​

Question 37

You can import data into Access from ____.

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

Question 38

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

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

Question 39

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 40

When you open files created in different applications, you need to create them on the same computer logged in as the same user.​

Question 41

To create a new database, click the  __________ desktop database button.​

Question 42

When the Paste Special dialog box is open in Word, select the ____ option to paste text as formatted text.

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

Question 43

In Excel, to adjust the column widths to Autofit, select the data, click the ____________________ button in the Cells group, then click AutoFit Column Width.

Question 44

If an Access table is the ____ of the data in a table in Word, 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 45

To copy a table in Word, click the table select button, and then click the Copy button in the _____ group.​

A) ​Table Copy
B) ​Clipboard
C) Advanced
D) ​Copy & Paste

Question 46

When you open a linked Excel file, click _____ if prompted and click Update in response to the message​. ​

A) ​Enable Content
B) ​Activate
C) ​Manage Link
D) ​Refresh

Question 47

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 48

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 49

If you enter the formula =C2*D2 into a cell, you are performing a(n) _____ calculation. ​

A) ​addition
B) ​subtraction
C) ​multiplication
D) ​division

Question 50

After importing 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 51

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 52

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 53

To add borders to a range in Excel, select the range and click the Borders list arrow in the _____ group.​

A) ​Styles
B) ​Formatting
C) ​Editing
D) ​Font

Question 54

In the Get External Data - Excel Spreadsheet dialog box, the Browse button ____.

A) closes the window
B) opens a dialog box
C) opens the specified file
D) appends a record

Question 55

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

Question 56

Excel contains ____ tools not available in Access.

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

Question 57

To apply the accounting format to a range of selected cells, click the Accounting Number Format button in the ____________________ group.

Question 58

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

A) at least one record
B) the same number of records
C) more than ten records
D) less than ten records

Question 59

If you want to paste a Word table into an Access table that already contains records, you need to make sure that the Word table contains the same number of ___________________ as the Access table.

Question 60

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

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

Question 61

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

Question 62

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

Question 65

After changing the last name in record 1 of the source Access Leaders table to Chow, how do you verify that Last Name changes to Chow in Word?

Question 66

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

Question 68

Mary Lou Jacobs has asked you to test the quality of links from an Access table to an Excel spreadsheet and a Word document. The Experiences table in the Word document is linked to a table in Excel, which in turn is linked to a source Access table. The Leaders table is directly linked to a source Access table. After changing the Price field for the first record (Coastal Marine Conservation) of the source Access Experiences table to 5500, how do you verify that the experiences Revenue changes to $66,000.00 in Excel and Word?

Question 69

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

Question 71

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 72

Explain how to import an Excel worksheet into Access.

Question 73

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

Question 74

Explain how to open linked files and enable the content.