Question 1

You should wait to create table relationships until after the ________ process is complete.

Accepted Answer

The answer of You should wait to create table relationships...

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Question 5

It is always a good idea to ________ your database before optimizing your database through the Performance Analyzer tool in case something goes wrong.

Accepted Answer

backup,bac

Question 6

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

Question 7

________ is the process of efficiently organizing data so that the same data is not stored in more than one table,and that related data is stored together.

Accepted Answer

The answer of ________ is the process of efficiently organizing...

Question 8

Which of the following are typically not stored in the front-end database file?

Accepted Answer

A) Forms 
B) Reports 
C) Tables 
D) Queries 
A) Forms 
B) Reports 
C) Tables 
D) Queries

Question 9

A table is in third normal form if it meets 2NF criteria and all the fields have transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 10

After using the Database Splitter tool,in which file are the tables located?

Accepted Answer

A) Front-end 
B) Back-end 
C) Table-end 
D) Split-end 
A) Front-end 
B) Back-end 
C) Table-end 
D) Split-end

Question 11

Adding an index saves time searching without increasing the time it takes to add information to the database.

Accepted Answer

A) True 
 B)False

Question 12

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 13

The Database ________ can allow you to view details that are not necessarily apparent by looking at an object.

Accepted Answer

The answer of The Database ________ can allow you to...

Question 14

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 15

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 16

The Database Documenter tool can provide information about when a field or other object was last modified.

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: Open exclusive
Encrypt with Password
Database Documenter
Database Relationships
Database splitter

Accepted Answer

The Answer of File tab; Info and Database Tools tab; is...

Question 18

Sometimes a way to handle a conversion to 3NF is to ________ fields that may not be necessary.

Accepted Answer

The answer of Sometimes a way to handle a conversion...

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) They must be fixed manually. 
B) They are identified by a lightbulb. 
C) These changes carry the highest risk of any of the three types. 
D) These often include changing data types. 
A) They must be fixed manually. 
B) They are identified by a lightbulb. 
C) These changes carry the highest risk of any of the three types. 
D) These often include changing data types.

You should wait to create table relationships until after the ________ process is complete.

What is not true about table relationships?

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

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.

It is always a good idea to ________ your database before optimizing your database through the Performance Analyzer tool in case something goes wrong.

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

________ is the process of efficiently organizing data so that the same data is not stored in more than one table,and that related data is stored together.

Which of the following are typically not stored in the front-end database file?

A table is in third normal form if it meets 2NF criteria and all the fields have transitive dependencies.

After using the Database Splitter tool,in which file are the tables located?

Adding an index saves time searching without increasing the time it takes to add information to the database.

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

The Database ________ can allow you to view details that are not necessarily apparent by looking at an object.

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

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 tool can provide information about when a field or other object was last modified.

Sometimes a way to handle a conversion to 3NF is to ________ fields that may not be necessary.

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

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

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

You should wait to create table relationships until after the ________ process is complete.

What is not true about table relationships?

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

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.

It is always a good idea to ________ your database before optimizing your database through the Performance Analyzer tool in case something goes wrong.

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

________ is the process of efficiently organizing data so that the same data is not stored in more than one table,and that related data is stored together.

Which of the following are typically not stored in the front-end database file?

A table is in third normal form if it meets 2NF criteria and all the fields have transitive dependencies.

After using the Database Splitter tool,in which file are the tables located?

Adding an index saves time searching without increasing the time it takes to add information to the database.

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

The Database ________ can allow you to view details that are not necessarily apparent by looking at an object.

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

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 tool can provide information about when a field or other object was last modified.

Sometimes a way to handle a conversion to 3NF is to ________ fields that may not be necessary.

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

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

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