Question 1

After using the Database Splitter tool, the tables in the back-end are replaced with ________ to those tables in the front-end.

Accepted Answer

The answer of After using the Database Splitter tool, the...

Question 2

Often the front-end database file is stored on a server for increased security.

Accepted Answer

A) True 
 B)False

Question 3

As new tables, queries, forms, and reports are added to a database, Access actually becomes more efficient and the performance of the database increases.

Accepted Answer

A) True 
 B)False

Question 4

Unfortunately, to bring all your tables into Normalization often involves data loss.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

If a table contains no repeating groups or repeating columns, it is said to be in compliance with which normal form?

Accepted Answer

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

Question 9

Before running the Documenter, you should narrow the options so only the pertinent information is displayed.

Accepted Answer

A) True 
 B)False

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

What is not true about table relationships?

Accepted Answer

A)  They must be set up manually. 
B)  They are created automatically by Access when normalization is complete. 
C)  Creating them can be a good test your normalization efforts. 
D)  Creating them allows you to retrieve data in a multi-table database. 
A)  They must be set up manually. 
B)  They are created automatically by Access when normalization is complete. 
C)  Creating them can be a good test your normalization efforts. 
D)  Creating them allows you to retrieve data in a multi-table database.

Question 12

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 13

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 14

The Database Documenter is useful for identifying flaws in the design of a database.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

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 18

The best way to use the Database Documenter tool is to select every option, otherwise you might miss including important data.

Accepted Answer

A) True 
 B)False

Question 19

Match the following commands with their outcomes:
I. Database Splitter
II. Database Documenter
III. Analyze Performance
IV. Analyze Table
V. Encryption
A. Produces recommendations, suggestions, and ideas
B. Allows you to add password protection
C. Divides the database into front-end and back-end database files
D. Helps to optimize your database
E. Can create a very long report

Accepted Answer

The answer of Match the following commands with their outcomes:
I....

Question 20

Which of the following is not considered to be an enterprise-level DBMS?

Accepted Answer

A)  Oracle 
B)  Access 
C)  MySQL 
D)  Microsoft SQL Server 
A)  Oracle 
B)  Access 
C)  MySQL 
D)  Microsoft SQL Server

After using the Database Splitter tool, the tables in the back-end are replaced with ________ to those tables in the front-end.

Often the front-end database file is stored on a server for increased security.

As new tables, queries, forms, and reports are added to a database, Access actually becomes more efficient and the performance of the database increases.

Unfortunately, to bring all your tables into Normalization often involves data loss.

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

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

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

If a table contains no repeating groups or repeating columns, it is said to be in compliance with which normal form?

Before running the Documenter, you should narrow the options so only the pertinent information is displayed.

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

What is not true about table relationships?

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.

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

The Database Documenter is useful for identifying flaws in the design of a database.

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

Implementing the third normal form often involves creating more ________.

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

The best way to use the Database Documenter tool is to select every option, otherwise you might miss including important data.

Which of the following is not considered to be an enterprise-level DBMS?

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

After using the Database Splitter tool, the tables in the back-end are replaced with ________ to those tables in the front-end.

Often the front-end database file is stored on a server for increased security.

As new tables, queries, forms, and reports are added to a database, Access actually becomes more efficient and the performance of the database increases.

Unfortunately, to bring all your tables into Normalization often involves data loss.

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

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

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

If a table contains no repeating groups or repeating columns, it is said to be in compliance with which normal form?

Before running the Documenter, you should narrow the options so only the pertinent information is displayed.

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

What is not true about table relationships?

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.

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

The Database Documenter is useful for identifying flaws in the design of a database.

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

Implementing the third normal form often involves creating more ________.

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

The best way to use the Database Documenter tool is to select every option, otherwise you might miss including important data.

Which of the following is not considered to be an enterprise-level DBMS?

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