Question 1

How does Access handle multivalued fields?

Accepted Answer

A)  Creates special invisible tables in the background 
B)  Appear as repeating groups in the table 
C)  Makes the multivalue field dependent on the primary key 
D)  Removes dependencies on required fields 
A)  Creates special invisible tables in the background 
B)  Appear as repeating groups in the table 
C)  Makes the multivalue field dependent on the primary key 
D)  Removes dependencies on required fields

Question 2

________ is the formal process of deciding which fields should be grouped together into which table.

Accepted Answer

A)  Normalization 
B)  Anomaly 
C)  Second normal form 
D)  Transitive dependencies 
A)  Normalization 
B)  Anomaly 
C)  Second normal form 
D)  Transitive dependencies

Question 3

In the Navigation Pane,________ tables have an arrow icon to indicate they are linked to another Access database.

Accepted Answer

The answer of In the Navigation Pane,________ tables have an...

Question 4

A good password should be at least eight characters which combines uppercase and lowercase letters,numbers,and symbols to make the password more difficult for others to guess.

Accepted Answer

A) True 
 B)False

Question 5

The Performance Analyzer lists three kinds of analysis results: recommendations,suggestions,and ideas.

Accepted Answer

A) True 
 B)False

Question 6

What does the Database Documenter list?

Accepted Answer

The proper

Question 7

Which process guarantees that you are the only one currently using the database?

Accepted Answer

A)  Open exclusive 
B)  Encryption 
C)  Password protect 
D)  Selfcert 
A)  Open exclusive 
B)  Encryption 
C)  Password protect 
D)  Selfcert

Question 8

Which tool does NOT identify flaws in the design of the database?

Accepted Answer

A)  Database Documenter 
B)  Performance Analyzer 
C)  Table Analyzer 
D)  Document Splitter 
A)  Database Documenter 
B)  Performance Analyzer 
C)  Table Analyzer 
D)  Document Splitter

Question 9

Match between columns
                        Premises: composite key
anomaly
encryption
non-key field

Accepted Answer

The Answer of a primary key that is made up is...

Question 10

________ mode guarantees that you are the only one currently using the database.

Accepted Answer

The answer of ________ mode guarantees that you are the...

Question 11

What are three useful Access tools that database administrators can use to improve the performance of a database?

Accepted Answer

Database Documenter

Question 12

The formal process of deciding which fields should be grouped together into which fields is called ________.

Accepted Answer

The answer of The formal process of deciding which fields...

Question 13

A(n)________ is an error or inconsistency within a database.

Accepted Answer

A)  anomaly 
B)  normalization 
C)  first normal form 
D)  non-key field 
A)  anomaly 
B)  normalization 
C)  first normal form 
D)  non-key field

Question 14

________ is the protection of data from unauthorized access,change,or destruction.

Accepted Answer

A)  Computer security 
B)  Improved performance 
C)  Encryption 
D)  Flexible Environment 
A)  Computer security 
B)  Improved performance 
C)  Encryption 
D)  Flexible Environment

Question 15

A method to encrypt a database is to assign a password to the file.

Accepted Answer

A) True 
 B)False

Question 16

Normalization rules indicate the current state of a table.

Accepted Answer

A) True 
 B)False

Question 17

First normal form is a table that contains no repeating groups or repeating columns.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

What is the purpose of a password?

Accepted Answer

To keep unauthorized

Question 20

You cannot create an ACCDE file unless you have enabled the content in the database.

Accepted Answer

A) True 
 B)False

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

How does Access handle multivalued fields?

________ is the formal process of deciding which fields should be grouped together into which table.

In the Navigation Pane,________ tables have an arrow icon to indicate they are linked to another Access database.

A good password should be at least eight characters which combines uppercase and lowercase letters,numbers,and symbols to make the password more difficult for others to guess.

The Performance Analyzer lists three kinds of analysis results: recommendations,suggestions,and ideas.

What does the Database Documenter list?

Which process guarantees that you are the only one currently using the database?

Which tool does NOT identify flaws in the design of the database?

________ mode guarantees that you are the only one currently using the database.

What are three useful Access tools that database administrators can use to improve the performance of a database?

The formal process of deciding which fields should be grouped together into which fields is called ________.

A(n)________ is an error or inconsistency within a database.

________ is the protection of data from unauthorized access,change,or destruction.

A method to encrypt a database is to assign a password to the file.

Normalization rules indicate the current state of a table.

First normal form is a table that contains no repeating groups or repeating columns.

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

What is the purpose of a password?

You cannot create an ACCDE file unless you have enabled the content in the database.

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