Question 1

Match between columns
                        Premises: Helps you step through the process from Access with a Word label or letter
Word document that contains the standard text for each mail-merge letter/label
Data from an Access object is combined with a Word label or letter
Is replaced with the value in the field that the code represents

Accepted Answer

The Answer of Mail Merge task pane and Merge field is...

Question 2

____ makes a duplicate copy of the data in the Access database.

Accepted Answer

A)  Linking 
B)  Importing 
C)  Compacting 
D)  Indexing 
A)  Linking 
B)  Importing 
C)  Compacting 
D)  Indexing B

Question 3

Kelsey needs to send information from an Access report to her manager.  What is the advantage of sending the report as a PDF?

Accepted Answer

Anyone can read the document but they cannot edit or change the information.

Question 4

To import data from Excel to Access, you would begin by clicking the ____.

Accepted Answer

A)  Relationships button 
B)  Foreign key field 
C)  External Data tab 
D)  Enforce Referential Integrity button 
A)  Relationships button 
B)  Foreign key field 
C)  External Data tab 
D)  Enforce Referential Integrity button

Question 5

Which type of template creates a traditional Access database?

Accepted Answer

A)  custom Web app 
B)  Application Parts 
C)  custom desktop 
D)  desktop database 
A)  custom Web app 
B)  Application Parts 
C)  custom desktop 
D)  desktop database

Question 6

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

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

Accepted Answer

A) True 
 B)False

Question 8

Describe when you would use the Saved Exports button on the External Data tab.

Accepted Answer

If you need to export the same data freq

Question 9

Databases created by templates can be modified for your specific needs.

Accepted Answer

A) True 
 B)False

Question 10

Microsoft _____ is the spreadsheet program within the Microsoft Office suite.

Accepted Answer

The answer of Microsoft _____ is the spreadsheet program within...

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

Some templates are _____  which means they are available to download from the Microsoft Office Online Web site.

Accepted Answer

The answer of Some templates are _____  which means they are...

Question 13

ODBC stands for _____.

Accepted Answer

A)  Open Database Communication 
B)  Object Database Connections 
C)  Object Database Corrections 
D)  Open Database Connectivity 
A)  Open Database Communication 
B)  Object Database Connections 
C)  Object Database Corrections 
D)  Open Database Connectivity

Question 14

A feature called ____ helps you copy information from Excel to Access.

Accepted Answer

A)  Shortcut 
B)  Table Template 
C)  Import Spreadsheet Wizard 
D)  Mail Merge Task Pane 
A)  Shortcut 
B)  Table Template 
C)  Import Spreadsheet Wizard 
D)  Mail Merge Task Pane

Question 15

Codes that are replaced with values in a field during a mail merge process are called ____.

Accepted Answer

A)  Merge fields 
B)  Export agents 
C)  OLE fields 
D)  Hyperlink connections 
A)  Merge fields 
B)  Export agents 
C)  OLE fields 
D)  Hyperlink connections

Question 16

Cascade Delete Related Records automatically deletes all records in the ____ if the record with the matching key field in a "one" table is deleted.

Accepted Answer

A)  "many" table 
B)  "one" table 
C)  database 
D)  primary key field 
A)  "many" table 
B)  "one" table 
C)  database 
D)  primary key field

Question 17

Match between columns
                        Premises: Copying data from Access to an external file
Combining data from Access to a Word form letter, label, or envelope
Connecting data in an external file to an Access database
Copying data from an external file into an Access database

Accepted Answer

The Answer of Mail merging and Importing and Linking and is...

Question 18

Which process is most like copying and pasting?

Accepted Answer

A)  Linking 
B)  Relating 
C)  Querying 
D)  Importing 
A)  Linking 
B)  Relating 
C)  Querying 
D)  Importing

Question 19

In the Relationships window, a linking line without referential integrity shows the "one" and "many" symbols. _____

Accepted Answer

A) True 
 B)False

Question 20

Aaron needs to send information from an Access report to his manager.  What is the advantage of emailing the report as a PDF file?

Accepted Answer

Anyone can read a PDF document

____ makes a duplicate copy of the data in the Access database.

Kelsey needs to send information from an Access report to her manager. What is the advantage of sending the report as a PDF?

To import data from Excel to Access, you would begin by clicking the ____.

Which type of template creates a traditional Access database?

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

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

Describe when you would use the Saved Exports button on the External Data tab.

Databases created by templates can be modified for your specific needs.

Microsoft _____ is the spreadsheet program within the Microsoft Office suite.

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

Some templates are _____ which means they are available to download from the Microsoft Office Online Web site.

ODBC stands for _____.

A feature called ____ helps you copy information from Excel to Access.

Codes that are replaced with values in a field during a mail merge process are called ____.

Cascade Delete Related Records automatically deletes all records in the ____ if the record with the matching key field in a "one" table is deleted.

Which process is most like copying and pasting?

In the Relationships window, a linking line without referential integrity shows the "one" and "many" symbols. _____

Aaron needs to send information from an Access report to his manager. What is the advantage of emailing the report as a PDF file?

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 9: Importing and Exporting Data

____ makes a duplicate copy of the data in the Access database.

Kelsey needs to send information from an Access report to her manager. What is the advantage of sending the report as a PDF?

To import data from Excel to Access, you would begin by clicking the ____.

Which type of template creates a traditional Access database?

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

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

Describe when you would use the Saved Exports button on the External Data tab.

Databases created by templates can be modified for your specific needs.

Microsoft _____ is the spreadsheet program within the Microsoft Office suite.

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

Some templates are _____ which means they are available to download from the Microsoft Office Online Web site.

ODBC stands for _____.

A feature called ____ helps you copy information from Excel to Access.

Codes that are replaced with values in a field during a mail merge process are called ____.

Cascade Delete Related Records automatically deletes all records in the ____ if the record with the matching key field in a "one" table is deleted.

Which process is most like copying and pasting?

In the Relationships window, a linking line without referential integrity shows the "one" and "many" symbols. _____

Aaron needs to send information from an Access report to his manager. What is the advantage of emailing the report as a PDF file?

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters