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

To make the opening of forms and reports easy for users, you could implement a(n) ________ form, which is a menu system that uses tabs.

The Database Splitter tool enables you to split a database into three files: a back-end, middle, and front-end database.

The Performance Analyzer Tool creates a report that contains detailed information for each selected object.

Relationships are created in the relationships window by dragging a field from one table to a field in another table.

A primary key that consists of more than a single field is called a ________ key.

What is the best way to fix a table with repeating groups?

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

A field that has multiple values separated by commas is an example of a repeating group.

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

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

Which of the following is NOT a database security measure?

________ are not allowed in a normalized table.

What does the Table Analyzer do?

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

Which of the following tools is used to create a report that details information on relationships between tables?

Which of the following can be tested by creating relationships?

What is the difference between first, second, and third normal form?

Which of the following is NOT a result of running the Performance Analyzer tool?

You should consider using the Database Splitter tool to see if the performance of a database can be improved.

Normalization rules indicate the current state of a table.