Exam 10: Fine-Tuning the Database

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

The Database ________ tool divides your database into two files.

Logical security involves the information that is found on physical devices.

You should wait until the normalization process is complete before creating relationships between tables.

________ is the process of efficiently organizing data so that the same data is not stored in more than one table, and that related data is stored together.

After using the Database Splitter tool, the tables are found in the back-end file.

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.

Which is not a benefit of normalization?

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

The Database ________ tool creates a detailed report for each selected object.

Which database tool turns your database into two files?

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

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

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

Which of the following is not true about following the suggestions of the Table Analyzer tool?

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

DBMS stands for ________.

Which tool evaluates each object in the database and suggests ways to make the database more efficient?

Navigation forms are only for forms and/or reports, not for tables or queries.

The Database Documenter tool can provide information about when a field or other object was last modified.