Exam 9: Fine-Tuning the Database

The best way to use the Database Documenter tool is to select every option, otherwise you might miss including important data.

What is not true about table relationships?

Navigation forms are only for forms and ________.

The Table Analyzer Wizard can make all the database changes by itself if that is what you desire.

The most common objects analyzed by the Database Documenter tool are ________.

Which is not a benefit of normalization?

Adding a password and encryption to a database requires the database to be opened in ________ mode.

An unnormalized form might have the designation ________.

The ________ Analyzer tool makes suggestions to minimizing the duplication of data.

The ________ Analyzer tool evaluates each object in the database and suggests ways to make the database more efficient.

Match the following Database Documenter Options with their descriptions: I. Include for table: properties II. Include for table: relationships III. Include for Fields: Nothing IV. Include for Indexes: Nothing V. Include for Indexes: Names and Fields A. Includes the names of all indexes and the fields with which they are associated B. Includes which fields are common between tables and type of relationship, such as one to many C. Includes no detail about the indexes in the selected tables D. Includes no detail about the fields in the selected tables E. Includes number of records, date of last update, and formatting

If you have two values in one field, which normal form have you violated?

If you have an address field listing the city, state, and ZIP together such as Paterson, NJ 07501, you have violated the first normal form.

Match the following terms with their descriptions: I. Access Database Executable II. Transitive dependency III. Anomaly IV. Non-key field V. Encryption A. When the value of one non-key field is functionally dependent on the value of another non-key field B. Any field which is not a part of the primary key C. An error or inconsistency of data D. Limits what users can do in a database E. Makes a database unreadable to anyone who does not have the key

You can easily convert ACCDE and ACCDB files back and forth from one to the other.

Addressing transitive dependencies happens when you are attempting to bring your database into compliance with what normal form?

What is not true about opening a database in exclusive mode?

Which tool makes suggestions to minimize the duplication of data?

Which of the following statements is not true about indexes?

Match the following commands with their outcomes: I. Database Splitter II. Database Documenter III. Analyze Performance IV. Analyze Table V. Encryption A. Produces recommendations, suggestions, and ideas B. Allows you to add password protection C. Divides the database into front-end and back-end database files D. Helps to optimize your database E. Can create a very long report