Question 1

Match the following terms with the best choice.
-Copying data from Access to an external file

Accepted Answer

A) Importing 
B) Exporting 
C) Linking 
D) Mail merging 
A) Importing 
B) Exporting 
C) Linking 
D) Mail merging B

Question 2

Swipe and drop is a technique to copy Access data to another application.

Accepted Answer

A) True 
 B)False  False

Question 3

Identify three different techniques to copy Access data to other applications.

Accepted Answer

1. Copy and Paste (Office Clipboard)
2. Export
3. Drag and Drop

Question 4

The merge document is the Word document that contains the standard text for each form letter.

Accepted Answer

A) True 
 B)False

Question 5

Why should Cascade Updated Related Fields and Cascade Delete Related Records be used with caution?

Accepted Answer

Because both options

Question 6

-In the figure shown, which option would you choose to copy data into a new table in the existing database?

Accepted Answer

A)  Import the source data into a new table in the current database 
B)  Append a copy of the records to the table 
C)  Link to the data source by creating a linked table 
D)  None of the above 
A)  Import the source data into a new table in the current database 
B)  Append a copy of the records to the table 
C)  Link to the data source by creating a linked table 
D)  None of the above

Question 7

-In the figure above, which button would you use if you wanted to create a custom letter in Word addressed to each customer in a Customers table?

Accepted Answer

A)  4 
B)  5 
C)  6 
D)  7 
A)  4 
B)  5 
C)  6 
D)  7

Question 8

If you link data to an Access database, data can be edited in the original file, but not in the Access database.

Accepted Answer

A) True 
 B)False

Question 9

-In the figure above, which item would help you copy data from another database into Access?

Accepted Answer

A)  2 
B)  3 
C)  4 
D)  5 
A)  2 
B)  3 
C)  4 
D)  5

Question 10

-In the figure above, the Departments field list is probably a _____

Accepted Answer

A)  Linked table 
B)  Many-to-many relationship 
C)  Cascade Update Related Fields option 
D)  Cascade Delete Related Records option 
A)  Linked table 
B)  Many-to-many relationship 
C)  Cascade Update Related Fields option 
D)  Cascade Delete Related Records option

Question 11

One use of a database created by a database template is to help you learn more about Access.

Accepted Answer

A) True 
 B)False

Question 12

-Lara works at a large corporation. Explain how the features shown in the attached figure could help her improve an exist database.

Accepted Answer

Application Parts are object t

Question 13

_____ is a process to quickly copy data from an external file into an Access database.

Accepted Answer

The answer of _____ is a process to quickly copy...

Question 14

To set a startup form, click the FILE tab, then click _____

Accepted Answer

A)  New 
B)  Account 
C)  Open 
D)  Options 
A)  New 
B)  Account 
C)  Open 
D)  Options

Question 15

A(n) _____ file contains field values separated by a common character; this could be a comma, tab, dash, or other character.

Accepted Answer

A)  RTF 
B)  ODBC 
C)  XML 
D)  CSV 
A)  RTF 
B)  ODBC 
C)  XML 
D)  CSV

Question 16

Microsoft often changes and updates online templates.

Accepted Answer

A) True 
 B)False

Question 17

A database _____ is a tool that you use to quickly create a new database based on a particular subject.

Accepted Answer

The answer of A database _____ is a tool that...

Question 18

In a Word merge data from an Access table or query is combined into a Word form letter.

Accepted Answer

A) True 
 B)False

Question 19

Match each term with the best description.
-Is replaced with the value in the field that the code represents

Accepted Answer

A) Main document 
B) Merge field 
C) Mail merge 
D) Mail Merge task pane 
A) Main document 
B) Merge field 
C) Mail merge 
D) Mail Merge task pane

Question 20

Match each term with the best description.
-Helps you step through the process from Access with a Word label or letter

Accepted Answer

A) Main document 
B) Merge field 
C) Mail merge 
D) Mail Merge task pane 
A) Main document 
B) Merge field 
C) Mail merge 
D) Mail Merge task pane

Match the following terms with the best choice. -Copying data from Access to an external file

Swipe and drop is a technique to copy Access data to another application.

Identify three different techniques to copy Access data to other applications.

The merge document is the Word document that contains the standard text for each form letter.

Why should Cascade Updated Related Fields and Cascade Delete Related Records be used with caution?

-In the figure shown, which option would you choose to copy data into a new table in the existing database?

-In the figure above, which button would you use if you wanted to create a custom letter in Word addressed to each customer in a Customers table?

If you link data to an Access database, data can be edited in the original file, but not in the Access database.

-In the figure above, which item would help you copy data from another database into Access?

-In the figure above, the Departments field list is probably a _____

One use of a database created by a database template is to help you learn more about Access.

-Lara works at a large corporation. Explain how the features shown in the attached figure could help her improve an exist database.

_____ is a process to quickly copy data from an external file into an Access database.

To set a startup form, click the FILE tab, then click _____

A(n) _____ file contains field values separated by a common character; this could be a comma, tab, dash, or other character.

Microsoft often changes and updates online templates.

A database _____ is a tool that you use to quickly create a new database based on a particular subject.

In a Word merge data from an Access table or query is combined into a Word form letter.

Match each term with the best description. -Is replaced with the value in the field that the code represents

Match each term with the best description. -Helps you step through the process from Access with a Word label or letter

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 10: Importing and Exporting Data

Match the following terms with the best choice. -Copying data from Access to an external file

Swipe and drop is a technique to copy Access data to another application.

Identify three different techniques to copy Access data to other applications.

The merge document is the Word document that contains the standard text for each form letter.

Why should Cascade Updated Related Fields and Cascade Delete Related Records be used with caution?

-In the figure shown, which option would you choose to copy data into a new table in the existing database?

-In the figure above, which button would you use if you wanted to create a custom letter in Word addressed to each customer in a Customers table?

If you link data to an Access database, data can be edited in the original file, but not in the Access database.

-In the figure above, which item would help you copy data from another database into Access?

-In the figure above, the Departments field list is probably a _____

One use of a database created by a database template is to help you learn more about Access.

-Lara works at a large corporation. Explain how the features shown in the attached figure could help her improve an exist database.

_____ is a process to quickly copy data from an external file into an Access database.

To set a startup form, click the FILE tab, then click _____

A(n) _____ file contains field values separated by a common character; this could be a comma, tab, dash, or other character.

Microsoft often changes and updates online templates.

A database _____ is a tool that you use to quickly create a new database based on a particular subject.

In a Word merge data from an Access table or query is combined into a Word form letter.

Match each term with the best description. -Is replaced with the value in the field that the code represents

Match each term with the best description. -Helps you step through the process from Access with a Word label or letter

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters