Question 1

Which program would be best suited to entering, editing, and managing large paragraphs of text?

Accepted Answer

A)  Access 
B)  Excel 
C)  Outlook 
D)  Word 
A)  Access 
B)  Excel 
C)  Outlook 
D)  Word

Question 2

Cascade Update Related Fields automatically updates the data in the primary key field when the matching foreign key field is changed.

Accepted Answer

A) True 
 B)False

Question 3

You can establish referential integrity with a linked table.

Accepted Answer

A) True 
 B)False

Question 4

To export a report as an email attachment, click the _____ button in the Export group of the tab on the Ribbon.

Accepted Answer

A)  Attach 
B)  Send 
C)  Email 
D)  PDF 
A)  Attach 
B)  Send 
C)  Email 
D)  PDF

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

A(n) _____ text file typically contains one record on each line, with the field values separated by a common character.

Accepted Answer

The answer of A(n) _____ text file typically contains one...

Question 9

The RTF file format can be opened and edited in Microsoft Word . _____

Accepted Answer

A) True 
 B)False

Which program would be best suited to entering, editing, and managing large paragraphs of text?

Cascade Update Related Fields automatically updates the data in the primary key field when the matching foreign key field is changed.

You can establish referential integrity with a linked table.

To export a report as an email attachment, click the _____ button in the Export group of the tab on the Ribbon.

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

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

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

A(n) _____ text file typically contains one record on each line, with the field values separated by a common character.

The RTF file format can be opened and edited in Microsoft Word . _____

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

Which program would be best suited to entering, editing, and managing large paragraphs of text?

Cascade Update Related Fields automatically updates the data in the primary key field when the matching foreign key field is changed.

You can establish referential integrity with a linked table.

To export a report as an email attachment, click the _____ button in the Export group of the tab on the Ribbon.

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

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

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

A(n) _____ text file typically contains one record on each line, with the field values separated by a common character.

The RTF file format can be opened and edited in Microsoft Word . _____

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