Exam 35: Fine Tuning the Database: Analyzing and Improving Database Performance

Transitive dependencies exist in third normal forms.

What is the main reason for splitting a database?

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

What are four ways to keep your database application safe?

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

Minimizing data redundancy is one of the benefits of normalization.

Access 2013 incorporates encryption methods to keep databases secure.

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

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

What does a back-end database contain?

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

What are the benefits of normalization?

You should add a(n)________ to any field that will be searched because it reduces the time it takes to run queries and reports when it is added.

________ 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.

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

When a file is saved as an Access Database Executable file,VBA code can be executed,but it cannot be modified.

A(n)________ is a primary key that is made up of two or more fields.

What does the Table Analyzer do?

To start a navigation form automatically on start up,change settings in the Options window.