Exam 9: Fine-Tuning the Database: Hands-On-Exercise Videos

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.

You would use the ________ to evaluate a database and produce results for optimizing the database.

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

Which of the following is NOT a database security measure?

You would use the Performance Analyzer tool to help reduce data redundancies.

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

To prevent users from making changes to a database,you can save it as a(n)________ file.

When you use the Database Splitter tool,it splits a database into two files: ________.

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

A digitally signed database requires a password to open it.

First normal form requires that ________.

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

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

Which normal form requires that all non-key fields are functionally dependent on the entire primary key?

Which normal form requires that no transitive dependencies exist?

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

If you lose the password of an encrypted database,you can contact Microsoft to unlock the database.