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

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

What is the main reason to split an Access database?

There are three normal forms;however,the majority of database designs only require the first two normal forms.

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

Name two situations that violate 1NF.

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

What are the benefits of normalization?

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

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

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

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

Access 2013 incorporates encryption methods to keep databases secure.

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

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 Tool creates a report that contains detailed information for each selected object.

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

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

Table Analyzer can create additional tables in your database.

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