Exam 9: Fine-Tuning the Database

Which of the following is not a reason to split a database?

One way to bring a database into 3NF compliance is to delete all unnecessary fields.

Match the following terms with their descriptions: I. Normalization II. First normal form III. Second normal form IV. Third normal form V. Normal forms A. No transitive dependencies exist B. Process of efficiently organizing data C. Table contains no repeating groups or columns D. The rules to optimize and fix potential repetition issues in a database E. All non-key fields are functionally dependent on the entire primary key

After using the Database Splitter tool, the tables in the back-end are replaced with ________ to those tables in the front-end.

A table is in third normal form if it meets 2NF criteria and all the fields have transitive dependencies.

Match the following commands with where they are found on the ribbon: I. Database Relationships II. Database Documenter III. Database splitter IV. Encrypt with Password V. Open exclusive A. Database Tools tab; Relationships group B. Database Tools tab; Analyze group C. Database Tools tab; Move Data group D. File tab; Info E. File tab; Open; Browse; Open drop-down list

DBMS stands for ________.

Creating relationships is not an effective way to test your normalization.

Which of the following statements is not true about recommendations displayed by the Performance Analyzer tool?

Which of the following statements is not true about suggestions displayed by the Performance Analyzer tool?

An added benefit of a navigation form is that it can be easily converted to a(n) ________ form if the Access database is deployed on a company intranet or on the Internet.

Often the front-end database file is stored on a server for increased security.

Before running the Documenter, you should narrow the options so only the pertinent information is displayed.

Match the following terms with their descriptions: I. Composite key II. Non-key field III. Index IV. Anomaly V. ACCDE A. Any key which is not a part of the primary key B. Inconsistency when adding, editing, or deleting data C. Speeds up searches D. A primary key made up of more than one field E. Prohibits user from creating new forms or reports

When should table relationships be created?

When a primary key is made up of more than one field, it is known as what type of key?

You should wait to create table relationships until after the ________ process is complete.

Converting an Access database to an enterprise-level DBMS will automatically correct design issues which were present in the Access database.

After using the Database Splitter tool, in which file are the tables located?

Match the following terms with their descriptions: I. Front-end database II. Back-end database III. Database Splitter IV. Composite key V. Index A. Contains the forms, reports, and queries B. Converts a database into two files C. Speeds up searches and reports D. Primary key is made up of more than one field E. Contains the tables