Question 1

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

Accepted Answer

blank

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

A)  the Import Objects Wizard 
B)  the Import Data button 
C)  the Import Objects button 
D)  Mail Merge 
A)  the Import Objects Wizard 
B)  the Import Data button 
C)  the Import Objects button 
D)  Mail Merge 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.

Accepted Answer

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

Question 5

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

Accepted Answer

The answer of The ________ bar reports that certain features...

Question 6

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

Accepted Answer

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 
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 7

Data is stored in Excel in ________.

Accepted Answer

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

Question 8

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

Accepted Answer

The answer of In Word,the only command to import data...

Question 9

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.

Accepted Answer

The answer of When you use the export command in...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

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 
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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: import
named range
Mail Merge
Security Warning bar

Accepted Answer

The Answer of a function used to create customized documents is...

Question 18

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

Accepted Answer

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 
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 19

You can import ________ at a time into Access.

Accepted Answer

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

Question 20

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

Accepted Answer

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

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

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

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

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

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

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

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

Data is stored in Excel in ________.

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

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.

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

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

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

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

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

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.

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

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

You can import ________ at a time into Access.

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

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters