Exam 38: Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

A conversion to a 3NF removes dependencies on part of a composite primary key.

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

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

Which of the following is NOT a tool database administrators can use to improve the performance of a database?

A timestamp can prove that your database has or has not been modified since you applied your signature.

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

What appears when you point to a table name of a linked table?

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

A(n)________ database contains only the tables of a database.

________ is electronic,encryption-based,secure stamps of authentication that confirms who created the file,that the file is valid,and that no changes have been made to the file after its authentication.

Transitive dependencies exist in third normal forms.

A(n)________ occurs when the value of one field is determined by the value of another.

After the Performance Analyzer lists its analysis results,Access can perform recommendations and suggestions automatically,but idea optimizations must be performed manually.

The Database Documenter creates a report that contains detailed information about the tables and other selected objects in your database.

An inconsistency in a database is referred to as a(n)________.

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

What does the Database Documenter list?

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

Any field that is not part of the primary key is called a(n)________.

The main reason to split an Access database is to improve development and maintenance.