Deck 2: Integrated Projects, workshop 2: Integrating Word, excel, and Access

Question 1

When you first open a database,if the Security Warning bar displays below the ribbon,you must click the ________ button before you can make changes to the database.

A) Security Checker
B) Close Security
C) Enable Content
D) Virus Checker

Answer 1

C

Question 2

It is a good business practice to maintain the same records in two or more different programs.

Answer 2

False

Question 3

The only way to import data into Word from inside Word is to use ________.

A) the Import Objects Wizard
B) the Import Data button
C) the Import Objects button
D) Mail Merge

Answer 3

D

Question 4

Because all data in Access is stored in tables,the data in Excel must be in a ________ before importing it into Access.

A) list form
B) table form
C) .txt file
D) source file

Question 5

When the Mail Merge Wizard is started in Access,it gives you the option to ________.

A) create a new Word document or use an existing one
B) create a new report to export to a Word document
C) select an existing Word document
D) create a new query to export to a Word document

Question 6

In Access,when you import data,you create a permanent connection to data in Excel that can be refreshed as the data is changed.

Question 7

The Mail Merge Wizard will not work if the Access database you are importing data from is in ________ mode.

A) exclusive
B) update
C) locked
D) data entry

Question 8

Exchanging data between Access and Excel allows you to take advantage of the strengths of each program.

Question 9

If you have a lot of data to enter into Access,it would be beneficial to create a form to make the data entry easier.

Question 10

If you try to import a list into Access that does not contain a field for a primary key,Access will ________.

A) ask you to create a primary key
B) assign one for you
C) give you an error message
D) import the data without a primary key

Question 11

Access gives you the ability to create a named range in Excel.

Question 12

Before you can import Excel data into Access,you must make sure that there are no ________ rows in the Excel file.

Question 13

You can use data from either an Access table or a query for a Word mail merge.

Question 14

Some of the advantages of using Access are What-if models and charts and graphs.

Question 15

Data is stored in Excel in ________.

A) a chart
B) a flat table
C) a relational table
D) multiple tables

Question 16

If a Word document is open when you try to complete a Mail Merge from within Access,you will ________.

A) receive an error message that the Mail Merge completed but cannot be saved
B) receive a message that you must initiate the Mail Merge from within Word
C) receive a message indicating a successful merge
D) receive an error message that the file is locked for editing

Question 17

You can import ________ at a time into Access.

A) one worksheet
B) three worksheets
C) six worksheets
D) two worksheets

Question 18

Opening an Excel workbook in Access will cause Access to ________ instead of importing data.

A) close the database
B) embed the workbook into an Access table
C) give you an error message
D) create a link to the workbook

Question 19

If a worksheet has excess data that you do not want to import into an Access table,you can use a ________.

A) column selection
B) row selection
C) data range
D) named range

Question 20

For step-by-step instructions to import Excel data into an Access table use the ________ Wizard.

A) Import Spreadsheet
B) Import Data
C) Import Workbook
D) Import Worksheet

Question 21

The ________ bar reports that certain features of Access have been disabled to maintain security and prevent viruses from infecting your computer.

Question 22

Data Mail Merged from Access into Word can be used to create customized ________ or labels.

Question 23

In Word,the only command to import data is the ________ option.

Question 24

When you use the export command in Access to export data to Word,the data is copied as a(n)________ file and put into a new Word document.

Question 25

When importing data into a new table,Access will use the imported data's field names and data types for the new table ________.

Question 26

The Import Worksheet Wizard gives you the option to change the field names and ________ before you import the data.