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

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

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

________ is the process of altering digital information using an algorithm to make it unreadable to anyone except those who possess the key.

The ________ contains the queries,forms,and reports of the database.

What does a back-end database contain?

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

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

A(n)________ is a rule that indicates the current state of a table.

What are the three kinds of analysis results of the Performance Analyzer?

What does the Table Analyzer do?

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

The Database Splitter is not identified by name on the Access Ribbon.

To set a password,the database has to be opened in exclusive mode.

Digital certificates are electronic,encryption-based,secure stamps of authentication.

________ reduce the time it takes to run queries and reports.

________ provides a brief description of a potential problem and its possible solution.

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

An Access tool that makes recommendations for optimizing the database is called the ________ tool.

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.