Question 1

A(n) ________ is an error or inconsistency within a database.

Accepted Answer

The answer of A(n) ________ is an error or inconsistency...

Question 2

What are the rules to optimize and fix potential repetition issues in a database known as?

Accepted Answer

A)  Encryption 
B)  Normal forms 
C)  Data validation 
D)  Table Analyzer tool 
A)  Encryption 
B)  Normal forms 
C)  Data validation 
D)  Table Analyzer tool

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

A(n) ________ for a field reduces the time it takes to run queries and reports.

Accepted Answer

The answer of A(n) ________ for a field reduces the...

Question 6

Adding an index saves time searching without increasing the time it takes to add information to the database.

Accepted Answer

A) True 
 B)False

Question 7

Implementing the third normal form often involves creating more ________.

Accepted Answer

A)  tables 
B)  fields 
C)  relationships 
D)  databases 
A)  tables 
B)  fields 
C)  relationships 
D)  databases

Question 8

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

Accepted Answer

A)  They must be fixed manually. 
B)  They are identified by a lightbulb. 
C)  These changes carry the highest risk of any of the three types. 
D)  These often include changing data types. 
A)  They must be fixed manually. 
B)  They are identified by a lightbulb. 
C)  These changes carry the highest risk of any of the three types. 
D)  These often include changing data types.

Question 9

________ makes the data unreadable to anyone except those who possess the key password.

Accepted Answer

The answer of ________ makes the data unreadable to anyone...

Question 10

What does ACCDE stand for?

Accepted Answer

A)  Access Database Extended 
B)  Access Database Example 
C)  Access Database Evaluation 
D)  Access Database Executable 
A)  Access Database Extended 
B)  Access Database Example 
C)  Access Database Evaluation 
D)  Access Database Executable

Question 11

What is the most common object analyzed by the Database Documenter tool?

Accepted Answer

A)  Table 
B)  Field 
C)  Report 
D)  Form 
A)  Table 
B)  Field 
C)  Report 
D)  Form

Question 12

Which database tool turns your database into two files?

Accepted Answer

A)  Database Divider 
B)  Database Splitter 
C)  Database Division 
D)  Database Performance 
A)  Database Divider 
B)  Database Splitter 
C)  Database Division 
D)  Database Performance

A(n) ________ is an error or inconsistency within a database.

What are the rules to optimize and fix potential repetition issues in a database known as?

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

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

A(n) ________ for a field reduces the time it takes to run queries and reports.

Adding an index saves time searching without increasing the time it takes to add information to the database.

Implementing the third normal form often involves creating more ________.

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

________ makes the data unreadable to anyone except those who possess the key password.

What does ACCDE stand for?

What is the most common object analyzed by the Database Documenter tool?

Which database tool turns your database into two files?

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters

Exam 9: Fine-Tuning the Database

A(n) ________ is an error or inconsistency within a database.

What are the rules to optimize and fix potential repetition issues in a database known as?

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

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

A(n) ________ for a field reduces the time it takes to run queries and reports.

Adding an index saves time searching without increasing the time it takes to add information to the database.

Implementing the third normal form often involves creating more ________.

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

________ makes the data unreadable to anyone except those who possess the key password.

What does ACCDE stand for?

What is the most common object analyzed by the Database Documenter tool?

Which database tool turns your database into two files?

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters