Question 1

What are four ways to keep your database application safe?

Accepted Answer

Create a navigation form,encry

Question 2

A(n)________ occur when the value of one non-key field is functionally dependent on the value of another non-key field.

Accepted Answer

A)  transitive dependencies 
B)  composite keys 
C)  non-key fields 
D)  functional dependencies 
A)  transitive dependencies 
B)  composite keys 
C)  non-key fields 
D)  functional dependencies

Question 3

What are the three Performance Analyzer result types?

Accepted Answer

Recommenda

Question 4

A ________ is a tabbed menu system that ties the objects in the database together so that the database is easy to use.

Accepted Answer

A)  navigation form 
B)  switchboard 
C)  command option 
D)  ribbon 
A)  navigation form 
B)  switchboard 
C)  command option 
D)  ribbon

Question 5

________ dependencies occur when the value of one non-key field is functionally dependent on the value of another non-key field.

Accepted Answer

The answer of ________ dependencies occur when the value of...

Question 6

To start a navigation form automatically on start up,change settings in the Options window.

Accepted Answer

A) True 
 B)False

Question 7

________ makes the database unreadable by encrypting the database.

Accepted Answer

A)  Password protect 
B)  Make ACCDE 
C)  Digital Signature 
D)  Encryption 
A)  Password protect 
B)  Make ACCDE 
C)  Digital Signature 
D)  Encryption

Question 8

Transitive dependencies exist in third normal forms.

Accepted Answer

A) True 
 B)False

Question 9

There are three normal forms; however,the majority of database designs only require the first two normal forms.

Accepted Answer

A) True 
 B)False

Question 10

After the Performance Analyzer lists its analysis results,Access can perform recommendations and suggestions automatically,but idea optimizations must be performed manually.

Accepted Answer

A) True 
 B)False

Question 11

A table that contains no repeating groups or repeating columns is in:

Accepted Answer

A)  first normal form. 
B)  second normal form. 
C)  third normal form. 
D)  fourth normal form. 
A)  first normal form. 
B)  second normal form. 
C)  third normal form. 
D)  fourth normal form.

Question 12

A table is in ________ if it meets 1NF criteria and all non-key fields are functionally dependent on the entire primary key.

Accepted Answer

A)  second normal form 
B)  third normal form 
C)  fourth normal form 
D)  fifth normal form 
A)  second normal form 
B)  third normal form 
C)  fourth normal form 
D)  fifth normal form

Question 13

A certification authority is a commercial company that issues and validates identities using digital signatures for a fee.

Accepted Answer

A) True 
 B)False

Question 14

Any field that is not part of the primary key is called a(n)________.

Accepted Answer

The answer of Any field that is not part of...

Question 15

Minimizing data redundancy is one of the benefits of normalization.

Accepted Answer

A) True 
 B)False

Question 16

A ________ is a combination of the date and time that is encrypted as part of the digital signature.

Accepted Answer

A)  timestamp 
B)  certificate 
C)  navigation 
D)  password 
A)  timestamp 
B)  certificate 
C)  navigation 
D)  password

Question 17

The Database Splitter tool enables you to split a database into two files,a back-end and front-end database.

Accepted Answer

A) True 
 B)False

Question 18

What does the Database Splitter do?

Accepted Answer

A)  Splits database into two files, a back-end and a front-end database 
B)  Divides the table and creates relationships that control how the new tables are linked 
C)  Adds more indexes to increase database performance 
D)  Provides a brief description of a potential problem and its possible solution 
A)  Splits database into two files, a back-end and a front-end database 
B)  Divides the table and creates relationships that control how the new tables are linked 
C)  Adds more indexes to increase database performance 
D)  Provides a brief description of a potential problem and its possible solution

Question 19

The Database Documenter saves its report in a number of formats including PDF or XPS formats.

Accepted Answer

A) True 
 B)False

Question 20

A timestamp can prove that your database has or has not been modified since you applied your signature.

Accepted Answer

A) True 
 B)False

Exam 21: Fine-Tuning the Database: Analyzing and Improving Database Performance

What are four ways to keep your database application safe?

A(n)________ occur when the value of one non-key field is functionally dependent on the value of another non-key field.

What are the three Performance Analyzer result types?

A ________ is a tabbed menu system that ties the objects in the database together so that the database is easy to use.

________ dependencies occur when the value of one non-key field is functionally dependent on the value of another non-key field.

To start a navigation form automatically on start up,change settings in the Options window.

________ makes the database unreadable by encrypting the database.

Transitive dependencies exist in third normal forms.

There are three normal forms; however,the majority of database designs only require the first two normal forms.

After the Performance Analyzer lists its analysis results,Access can perform recommendations and suggestions automatically,but idea optimizations must be performed manually.

A table that contains no repeating groups or repeating columns is in:

A table is in ________ if it meets 1NF criteria and all non-key fields are functionally dependent on the entire primary key.

A certification authority is a commercial company that issues and validates identities using digital signatures for a fee.

Any field that is not part of the primary key is called a(n)________.

Minimizing data redundancy is one of the benefits of normalization.

A ________ is a combination of the date and time that is encrypted as part of the digital signature.

The Database Splitter tool enables you to split a database into two files,a back-end and front-end database.

What does the Database Splitter do?

The Database Documenter saves its report in a number of formats including PDF or XPS formats.

A timestamp can prove that your database has or has not been modified since you applied your signature.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Using Macros and SQL in Access: Advanced Techniques

Filters