Question 1

________ makes the data unreadable to anyone except those who possess the key password.

Accepted Answer

The answer of ________ makes the data unreadable to anyone...

Question 2

If you have an address field listing the city,state,and ZIP together such as Paterson,NJ 07501,you have violated the first normal form.

Accepted Answer

A) True 
 B)False

Question 3

Converting an Access database to an enterprise-level DBMS will automatically correct design issues which were present in the Access database.

Accepted Answer

A) True 
 B)False

Question 4

What is a user permitted to do when using an Access Database Executable file?

Accepted Answer

A) Modify data 
B) Make changes to the forms and/or reports 
C) Create new forms and/or reports 
D) Modify VBA code 
A) Modify data 
B) Make changes to the forms and/or reports 
C) Create new forms and/or reports 
D) Modify VBA code

Question 5

Match between columns
                        Premises: Database Documenter
Database Splitter
Encryption
Analyze Performance
Analyze Table

Accepted Answer

The Answer of Helps to optimize your database and Divides is...

Question 6

Which tool makes suggestions to minimize the duplication of data?

Accepted Answer

A) Field Analyzer 
B) Table Analyzer 
C) Performance Analyzer 
D) Database Analyzer 
A) Field Analyzer 
B) Table Analyzer 
C) Performance Analyzer 
D) Database Analyzer

Question 7

Implementing the third normal form often involves creating more ________.

Accepted Answer

A) tables 
B) fields 
C) relationships 
D) databases 
A) tables 
B) fields 
C) relationships 
D) databases

Question 8

The Table Analyzer Wizard can make all the database changes by itself if that is what you desire.

Accepted Answer

A) True 
 B)False

Question 9

A(n)________ for a field reduces the time it takes to run queries and reports.

Accepted Answer

The answer of A(n)________ for a field reduces the time...

Question 10

Database security can be divided into physical security and ________ security.

Accepted Answer

The answer of Database security can be divided into physical...

Question 11

Which of the following is not true about following the suggestions of the Table Analyzer tool?

Accepted Answer

A) The database will store more reliable data. 
B) The database might become smaller. 
C) The database will probably become larger,but more efficient. 
D) Updating the database is faster because fewer changes will be required. 
A) The database will store more reliable data. 
B) The database might become smaller. 
C) The database will probably become larger,but more efficient. 
D) Updating the database is faster because fewer changes will be required.

Question 12

The most common objects analyzed by the Database Documenter tool are ________.

Accepted Answer

The answer of The most common objects analyzed by the...

Question 13

Which of the following statements is not true about recommendations displayed by the Performance Analyzer tool?

Accepted Answer

A) They are identified by an exclamation point. 
B) They can be fixed automatically by the tool. 
C) They carry very low risk. 
D) They carry a much higher risk. 
A) They are identified by an exclamation point. 
B) They can be fixed automatically by the tool. 
C) They carry very low risk. 
D) They carry a much higher risk.

Question 14

________ dependency occurs when the value of one field is determined by the value of another.

Accepted Answer

The answer of ________ dependency occurs when the value of...

Question 15

What is the most common object analyzed by the Database Documenter tool?

Accepted Answer

A) Table 
B) Field 
C) Report 
D) Form 
A) Table 
B) Field 
C) Report 
D) Form

Question 16

What does Access use as the default tab name on a navigation form?

Accepted Answer

A) Tab 1,Tab 2,etc. 
B) Page 1,Page 2,etc. 
C) Name of each form or report 
D) There is no default name assigned to navigation tabs. 
A) Tab 1,Tab 2,etc. 
B) Page 1,Page 2,etc. 
C) Name of each form or report 
D) There is no default name assigned to navigation tabs.

Question 17

An added benefit of a navigation form is that it can be easily converted to a(n)________ form if the Access database is deployed on a company intranet or on the Internet.

Accepted Answer

The answer of An added benefit of a navigation form...

Question 18

Match between columns
                        Premises: Database Documenter
Normalization
Table Analyzer
Encryption
Performance Analyzer

Accepted Answer

The Answer of Report of detailed information about selected objects is...

Question 19

If an Address field lists the city,state,and ZIP together,it would be in violation of the ________ normal form.

Accepted Answer

The answer of If an Address field lists the city,state,and...

Question 20

You can easily convert ACCDE and ACCDB files back and forth from one to the other.

Accepted Answer

A) True 
 B)False

________ makes the data unreadable to anyone except those who possess the key password.

If you have an address field listing the city,state,and ZIP together such as Paterson,NJ 07501,you have violated the first normal form.

Converting an Access database to an enterprise-level DBMS will automatically correct design issues which were present in the Access database.

What is a user permitted to do when using an Access Database Executable file?

Which tool makes suggestions to minimize the duplication of data?

Implementing the third normal form often involves creating more ________.

The Table Analyzer Wizard can make all the database changes by itself if that is what you desire.

A(n)________ for a field reduces the time it takes to run queries and reports.

Database security can be divided into physical security and ________ security.

Which of the following is not true about following the suggestions of the Table Analyzer tool?

The most common objects analyzed by the Database Documenter tool are ________.

Which of the following statements is not true about recommendations displayed by the Performance Analyzer tool?

________ dependency occurs when the value of one field is determined by the value of another.

What is the most common object analyzed by the Database Documenter tool?

What does Access use as the default tab name on a navigation form?

An added benefit of a navigation form is that it can be easily converted to a(n)________ form if the Access database is deployed on a company intranet or on the Internet.

If an Address field lists the city,state,and ZIP together,it would be in violation of the ________ normal form.

You can easily convert ACCDE and ACCDB files back and forth from one to the other.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Enhanced Database Techniques

Filters

Exam 10: Fine-Tuning the Database

________ makes the data unreadable to anyone except those who possess the key password.

If you have an address field listing the city,state,and ZIP together such as Paterson,NJ 07501,you have violated the first normal form.

Converting an Access database to an enterprise-level DBMS will automatically correct design issues which were present in the Access database.

What is a user permitted to do when using an Access Database Executable file?

Which tool makes suggestions to minimize the duplication of data?

Implementing the third normal form often involves creating more ________.

The Table Analyzer Wizard can make all the database changes by itself if that is what you desire.

A(n)________ for a field reduces the time it takes to run queries and reports.

Database security can be divided into physical security and ________ security.

Which of the following is not true about following the suggestions of the Table Analyzer tool?

The most common objects analyzed by the Database Documenter tool are ________.

Which of the following statements is not true about recommendations displayed by the Performance Analyzer tool?

________ dependency occurs when the value of one field is determined by the value of another.

What is the most common object analyzed by the Database Documenter tool?

What does Access use as the default tab name on a navigation form?

An added benefit of a navigation form is that it can be easily converted to a(n)________ form if the Access database is deployed on a company intranet or on the Internet.

If an Address field lists the city,state,and ZIP together,it would be in violation of the ________ normal form.

You can easily convert ACCDE and ACCDB files back and forth from one to the other.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Enhanced Database Techniques

Filters