Question 1

David is creating  new database.  Discuss a pro and con of creating it from a predeveloped Access database template.

Accepted Answer

An Access database template would help D

Question 2

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 3

The file format RTF stands for _____.

Accepted Answer

A)  Recordset text format 
B)  Record type format 
C)  Rich text format 
D)  Registered time format 
A)  Recordset text format 
B)  Record type format 
C)  Rich text format 
D)  Registered time format

Question 4

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

Accepted Answer

Because both options

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

The Office Clipboard is a tool that helps you copy Access data to other applications.

Accepted Answer

A) True 
 B)False

Question 8

Once a linked table is related to other objects in a database, it can be a part of _____ that use fields from multiple tables.

Accepted Answer

A)  Forms 
B)  Queries 
C)  Neither A nor B 
D)  Both A and B 
A)  Forms 
B)  Queries 
C)  Neither A nor B 
D)  Both A and B

Question 9

If referential integrity is applied to a one-to-many relationship, what happens?

Accepted Answer

A)  Connects tables 
B)  Prevents the creation of orphan records 
C)  Related fields are updated 
D)  Related fields are deleted 
A)  Connects tables 
B)  Prevents the creation of orphan records 
C)  Related fields are updated 
D)  Related fields are deleted

Question 10

In the figure above, item 3 points to the ____.

Accepted Answer

A)  Import from Excel spreadsheet button 
B)  Import from workbook button 
C)  Merge to Excel workbook button 
D)  Export to Excel spreadsheet button 
A)  Import from Excel spreadsheet button 
B)  Import from workbook button 
C)  Merge to Excel workbook button 
D)  Export to Excel spreadsheet button

Question 11

In the figure above, items 3, 4, 5, and 6 help you ____.

Accepted Answer

A)  Export data from Access to another file 
B)  Import data from Access to another file 
C)  Link to data from another file into Access 
D)  Copy data from another file into Access 
A)  Export data from Access to another file 
B)  Import data from Access to another file 
C)  Link to data from another file into Access 
D)  Copy data from another file into Access

Question 12

Which of the following is NOT a way to set a startup form?

Accepted Answer

A)  Use Access Options 
B)  Create an AutoExec macro 
C)  Name a form Startup 
D)  Each of these methods creates a startup form 
A)  Use Access Options 
B)  Create an AutoExec macro 
C)  Name a form Startup 
D)  Each of these methods creates a startup form

Question 13

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 14

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

Question 15

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

Accepted Answer

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

Question 16

Describe how Aaron could use the Contacts option selected in the figure shown to enhance an existing database.

Accepted Answer

The Contacts Application Part

Question 17

Microsoft often changes and updates online templates.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

1.  Copy and Paste (

Question 19

Word automatic is a feature that determines when a line of text extends into the right margin of the page and automatically forces the text to the next line without pressing [Enter].

Accepted Answer

A) True 
 B)False

Question 20

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

David is creating new database. Discuss a pro and con of creating it from a predeveloped Access database template.

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

The file format RTF stands for _____.

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

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

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

The Office Clipboard is a tool that helps you copy Access data to other applications.

Once a linked table is related to other objects in a database, it can be a part of _____ that use fields from multiple tables.

If referential integrity is applied to a one-to-many relationship, what happens?

In the figure above, item 3 points to the ____.

In the figure above, items 3, 4, 5, and 6 help you ____.

Which of the following is NOT a way to set a startup form?

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

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

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

Describe how Aaron could use the Contacts option selected in the figure shown to enhance an existing database.

Microsoft often changes and updates online templates.

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

Word automatic is a feature that determines when a line of text extends into the right margin of the page and automatically forces the text to the next line without pressing [Enter].

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

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 9: Importing and Exporting Data

David is creating new database. Discuss a pro and con of creating it from a predeveloped Access database template.

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

The file format RTF stands for _____.

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

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

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

The Office Clipboard is a tool that helps you copy Access data to other applications.

Once a linked table is related to other objects in a database, it can be a part of _____ that use fields from multiple tables.

If referential integrity is applied to a one-to-many relationship, what happens?

In the figure above, item 3 points to the ____.

In the figure above, items 3, 4, 5, and 6 help you ____.

Which of the following is NOT a way to set a startup form?

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

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

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

Describe how Aaron could use the Contacts option selected in the figure shown to enhance an existing database.

Microsoft often changes and updates online templates.

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

Word automatic is a feature that determines when a line of text extends into the right margin of the page and automatically forces the text to the next line without pressing [Enter].

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

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters