Question 1

After using the Database Splitter tool, which file remains open?

Accepted Answer

A)  Back-end 
B)  Front-end 
C)  They both remain open 
D)  Neither remains open 
A)  Back-end 
B)  Front-end 
C)  They both remain open 
D)  Neither remains open B

Question 2

One purpose of using the Database Splitter tool is that you can have one front-end file and several back-end files depending on the needs of your company.

Accepted Answer

A) True 
 B)False  False

Question 3

Which tool creates a detailed report for each selected object?

Accepted Answer

A)  Report Wizard 
B)  Database Reporter 
C)  Database Documenter 
D)  Object Documenter 
A)  Report Wizard 
B)  Database Reporter 
C)  Database Documenter 
D)  Object Documenter C

Question 4

The Database ________ tool divides your database into two files.

Accepted Answer

The answer of The Database ________ tool divides your database...

Question 5

Including capital letters, numbers, and special characters help to make the password more secure.

Accepted Answer

A) True 
 B)False

Question 6

Which tool evaluates each object in the database and suggests ways to make the database more efficient?

Accepted Answer

A)  Performance Analyzer 
B)  Object Analyzer 
C)  Database Documenter 
D)  Table Analyzer 
A)  Performance Analyzer 
B)  Object Analyzer 
C)  Database Documenter 
D)  Table Analyzer

Question 7

Removing a password is also known as decrypting.

Accepted Answer

A) True 
 B)False

Question 8

What is it called when the value of one non-key field is functionally dependent on the value of another non-key field?

Accepted Answer

A)  Transitive dependency 
B)  Data Integrity violation 
C)  Normalization 
D)  Composite key violation 
A)  Transitive dependency 
B)  Data Integrity violation 
C)  Normalization 
D)  Composite key violation

Question 9

The goal in proper database design is to be able to qualify for third normal form, then second normal form, then first normal form, then zero normal form.

Accepted Answer

A) True 
 B)False

Question 10

If the problem is important enough, the Performance Analyzer tool will inform you of required changes that must be made to your database.

Accepted Answer

A) True 
 B)False

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

Which of the following is not a type of analysis result given by the Performance Analyzer tool?

Accepted Answer

A)  Ideas 
B)  Suggestions 
C)  Recommendations 
D)  Required 
A)  Ideas 
B)  Suggestions 
C)  Recommendations 
D)  Required

Question 13

A table with a single-field primary key is usually in compliance with what normal form?

Accepted Answer

A)  First 
B)  Second 
C)  Third 
D)  Fourth 
A)  First 
B)  Second 
C)  Third 
D)  Fourth

Question 14

Match the following terms with their descriptions:
I. Database Documenter
II. Performance Analyzer
III. Table Analyzer
IV. Navigation form
V. Functional dependency
A. Makes recommendations for optimizing a database
B. Report containing detailed information for each selected object
C. Tabbed menu making the database easier to use
D. Normalizes database tables
E. Condition that occurs when the value of one field is determined by the value of another

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Question 15

A(n) ________ form is a tabbed menu system which makes the database easier to use.

Accepted Answer

The answer of A(n) ________ form is a tabbed menu...

Question 16

Which of the following is not considered a tool used to analyze and improve the performance of a database?

Accepted Answer

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

Question 17

The Performance Analyzer tool has become so sophisticated that it will catch performance issues in the database.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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 20

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

Accepted Answer

The answer of A(n) ________ dependency occurs when the value...

After using the Database Splitter tool, which file remains open?

One purpose of using the Database Splitter tool is that you can have one front-end file and several back-end files depending on the needs of your company.

Which tool creates a detailed report for each selected object?

The Database ________ tool divides your database into two files.

Including capital letters, numbers, and special characters help to make the password more secure.

Which tool evaluates each object in the database and suggests ways to make the database more efficient?

Removing a password is also known as decrypting.

What is it called when the value of one non-key field is functionally dependent on the value of another non-key field?

The goal in proper database design is to be able to qualify for third normal form, then second normal form, then first normal form, then zero normal form.

If the problem is important enough, the Performance Analyzer tool will inform you of required changes that must be made to your database.

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

Which of the following is not a type of analysis result given by the Performance Analyzer tool?

A table with a single-field primary key is usually in compliance with what normal form?

A(n) ________ form is a tabbed menu system which makes the database easier to use.

Which of the following is not considered a tool used to analyze and improve the performance of a database?

The Performance Analyzer tool has become so sophisticated that it will catch performance issues in the database.

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

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

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

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters

Exam 9: Fine-Tuning the Database

After using the Database Splitter tool, which file remains open?

One purpose of using the Database Splitter tool is that you can have one front-end file and several back-end files depending on the needs of your company.

Which tool creates a detailed report for each selected object?

The Database ________ tool divides your database into two files.

Including capital letters, numbers, and special characters help to make the password more secure.

Which tool evaluates each object in the database and suggests ways to make the database more efficient?

Removing a password is also known as decrypting.

What is it called when the value of one non-key field is functionally dependent on the value of another non-key field?

The goal in proper database design is to be able to qualify for third normal form, then second normal form, then first normal form, then zero normal form.

If the problem is important enough, the Performance Analyzer tool will inform you of required changes that must be made to your database.

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

Which of the following is not a type of analysis result given by the Performance Analyzer tool?

A table with a single-field primary key is usually in compliance with what normal form?

A(n) ________ form is a tabbed menu system which makes the database easier to use.

Which of the following is not considered a tool used to analyze and improve the performance of a database?

The Performance Analyzer tool has become so sophisticated that it will catch performance issues in the database.

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

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

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

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters