Question 1

If you change data in its original location and it is linked to an Access database, you must also update it in the Access database.

Accepted Answer

A) True 
 B)False

Question 2

Enforce Referential Integrity helps prevent records in the "many" table that don't have a matching record in the "one" table.

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

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 5

-Doug needs to maintain an Excel spreadsheet but also needs to use the same data in an Access database. He wants to make sure that any updates to the Excel spreadsheet are automatically updated in the Access database. In the figure above, which option should he choose and why?

Accepted Answer

Doug should link to the data s

Question 6

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 7

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

If you change data in its original location and it is linked to an Access database, you must also update it in the Access database.

Enforce Referential Integrity helps prevent records in the "many" table that don't have a matching record in the "one" table.

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

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

-Doug needs to maintain an Excel spreadsheet but also needs to use the same data in an Access database. He wants to make sure that any updates to the Excel spreadsheet are automatically updated in the Access database. In the figure above, which option should he choose and why?

The file format RTF stands for _____.

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

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

If you change data in its original location and it is linked to an Access database, you must also update it in the Access database.

Enforce Referential Integrity helps prevent records in the "many" table that don't have a matching record in the "one" table.

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

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

-Doug needs to maintain an Excel spreadsheet but also needs to use the same data in an Access database. He wants to make sure that any updates to the Excel spreadsheet are automatically updated in the Access database. In the figure above, which option should he choose and why?

The file format RTF stands for _____.

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

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