Question 1

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

Accepted Answer

Functional

Question 2

What does the Database Documenter list?

Accepted Answer

The properties of each object in a database

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

The Answer of the process of altering digital information using is...

Question 5

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

Accepted Answer

A)  navigation form 
B)  switchboard 
C)  command option 
D)  ribbon 
A)  navigation form 
B)  switchboard 
C)  command option 
D)  ribbon

Question 6

________ dependencies occur when the value of one non-key field is functionally dependent on the value of another non-key field.

Accepted Answer

The answer of ________ dependencies occur when the value of...

Question 7

A ________ is a combination of the date and time that is encrypted as part of the digital signature.

Accepted Answer

A)  timestamp 
B)  certificate 
C)  navigation 
D)  password 
A)  timestamp 
B)  certificate 
C)  navigation 
D)  password

Question 8

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 9

First normal form requires that ________.

Accepted Answer

A)  all non-key fields in your tables are functionally dependent on the primary keys 
B)  all foreign keys are independent from the primary keys 
C)  your tables have no transitive dependencies 
D)  your tables contain no repeating groups or columns. 
A)  all non-key fields in your tables are functionally dependent on the primary keys 
B)  all foreign keys are independent from the primary keys 
C)  your tables have no transitive dependencies 
D)  your tables contain no repeating groups or columns.

Question 10

The Table Analyzer analyzes the database and normalizes it for you.

Accepted Answer

A) True 
 B)False

Question 11

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 12

A table is in ________ if it meets 2NF criteria and no transitive dependencies exist.

Accepted Answer

A)  third normal form 
B)  fourth normal form 
C)  fifth normal form 
D)  first normal form 
A)  third normal form 
B)  fourth normal form 
C)  fifth normal form 
D)  first normal form

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Optimizing a database may affect the database in ways you might not consider as positive results.

Accepted Answer

A) True 
 B)False

Question 15

You can digitally sign and publish your database simultaneously from within Access 2013.

Accepted Answer

A) True 
 B)False

Question 16

Match the following terms with their meanings:
I. Database Splitter
II. functional dependency
III. Table Analyzer
IV. transitive dependencies
V. Performance Analyzer
A. analyzes the tables in a database and normalizes them for you
B. evaluates a database and then makes recommendations for optimizing the database
C. occurs when the value of one non-key field is functionally dependent on the value of another non-key field
D. when the value of one field is determined by the value of another
E. enables you to split a database into two files: a back-end database, which contains the data tables, and a front-end database

Accepted Answer

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

Question 17

What are the benefits of normalization?

Accepted Answer

Minimization of data redundanc

Question 18

When a database has been converted to an .accde file, it can be converted back to its source format (accdb).

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

Database Documenter

Question 20

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

Accepted Answer

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

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

What does the Database Documenter list?

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

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

________ dependencies occur when the value of one non-key field is functionally dependent on the value of another non-key field.

A ________ is a combination of the date and time that is encrypted as part of the digital signature.

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

First normal form requires that ________.

The Table Analyzer analyzes the database and normalizes it for you.

How does Access handle multivalued fields?

A table is in ________ if it meets 2NF criteria and no transitive dependencies exist.

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

Optimizing a database may affect the database in ways you might not consider as positive results.

You can digitally sign and publish your database simultaneously from within Access 2013.

What are the benefits of normalization?

When a database has been converted to an .accde file, it can be converted back to its source format (accdb).

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

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

Introduction to Access: Finding Your Way Through an Access Database

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

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

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

What does the Database Documenter list?

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

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

________ dependencies occur when the value of one non-key field is functionally dependent on the value of another non-key field.

A ________ is a combination of the date and time that is encrypted as part of the digital signature.

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

First normal form requires that ________.

The Table Analyzer analyzes the database and normalizes it for you.

How does Access handle multivalued fields?

A table is in ________ if it meets 2NF criteria and no transitive dependencies exist.

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

Optimizing a database may affect the database in ways you might not consider as positive results.

You can digitally sign and publish your database simultaneously from within Access 2013.

What are the benefits of normalization?

When a database has been converted to an .accde file, it can be converted back to its source format (accdb).

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

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

Introduction to Access: Finding Your Way Through an Access Database

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters