Question 1

The ________ tool enables you to split a database into a front-end and back-end database.

Accepted Answer

The answer of The ________ tool enables you to split...

Question 2

________ are not allowed in a normalized table.

Accepted Answer

A)  Repeating groups 
B)  Functional dependencies 
C)  Non-key fields 
D)  Composite keys 
A)  Repeating groups 
B)  Functional dependencies 
C)  Non-key fields 
D)  Composite keys

Question 3

Name two situations that violate 1NF.

Accepted Answer

Multiple values in the same fi

Question 4

Functional dependency occurs when the value of one field is determined by the value of another.

Accepted Answer

A) True 
 B)False

Question 5

A composite key is a primary key that is made up of one field.

Accepted Answer

A) True 
 B)False

Question 6

A back-end database contains the queries,forms,and reports of the database.

Accepted Answer

A) True 
 B)False

Question 7

What database format prohibits users from making design and name changes to forms or report within the database,and prohibits users from creating new forms and reports?

Accepted Answer

A)  Access Database Executable file 
B)  Access Database file 
C)  Access Database Template file 
D)  Database Documenter 
A)  Access Database Executable file 
B)  Access Database file 
C)  Access Database Template file 
D)  Database Documenter

Question 8

What are two formats Database Documenter reports can be saved in?

Accepted Answer

A)  PDF or XPS 
B)  PDF or WPX 
C)  XPS or XLS 
D)  PDF or CSV 
A)  PDF or XPS 
B)  PDF or WPX 
C)  XPS or XLS 
D)  PDF or CSV

Question 9

A(n)________ is a primary key that is made up of two or more fields.

Accepted Answer

The answer of A(n)________ is a primary key that is...

Question 10

What is the main reason to split an Access database?

Accepted Answer

A)  Improve development and maintenance 
B)  To confirm the primary key of each table 
C)  Controls how the tables are linked 
D)  To decide which fields go to which tables 
A)  Improve development and maintenance 
B)  To confirm the primary key of each table 
C)  Controls how the tables are linked 
D)  To decide which fields go to which tables

Question 11

What are the benefits of normalization?

Accepted Answer

Minimization of data redundanc

Question 12

What is the main reason for splitting a database?

Accepted Answer

To improve development and maintenance o

Question 13

A table is in ________ if it meets 2NF criteria and no transitive dependencies exist.

Accepted Answer

A)  third normal form 
B)  fourth normal form 
C)  fifth normal form 
D)  first normal form 
A)  third normal form 
B)  fourth normal form 
C)  fifth normal form 
D)  first normal form

Question 14

What is the difference between first,second,and third normal form?

Accepted Answer

First normal form removes repeating grou

Question 15

________ creates a report that contains detailed information about the tables and other selected objects in your database.

Accepted Answer

A)  Database Documenter 
B)  Performance Analyzer 
C)  Database Splitter 
D)  Oracle 
A)  Database Documenter 
B)  Performance Analyzer 
C)  Database Splitter 
D)  Oracle

Question 16

Access 2013 incorporates encryption methods to keep databases secure.

Accepted Answer

A) True 
 B)False

Question 17

A(n)________ occurs when the value of one field is determined by the value of another.

Accepted Answer

A)  functional dependency 
B)  non-key field 
C)  composite key 
D)  primary key 
A)  functional dependency 
B)  non-key field 
C)  composite key 
D)  primary key

Question 18

Table Analyzer can create additional tables in your database.

Accepted Answer

A) True 
 B)False

Question 19

When a database has been converted to an .accde file,it can be converted back to its source format (accdb).

Accepted Answer

A) True 
 B)False

Question 20

The ________ evaluates a database and makes recommendations for optimizing the database.

Accepted Answer

A)  Performance Analyzer 
B)  Database Documenter 
C)  Table Analyzer 
D)  Database Splitter 
A)  Performance Analyzer 
B)  Database Documenter 
C)  Table Analyzer 
D)  Database Splitter

Exam 21: Fine-Tuning the Database: Analyzing and Improving Database Performance

The ________ tool enables you to split a database into a front-end and back-end database.

________ are not allowed in a normalized table.

Name two situations that violate 1NF.

Functional dependency occurs when the value of one field is determined by the value of another.

A composite key is a primary key that is made up of one field.

A back-end database contains the queries,forms,and reports of the database.

What database format prohibits users from making design and name changes to forms or report within the database,and prohibits users from creating new forms and reports?

What are two formats Database Documenter reports can be saved in?

A(n)________ is a primary key that is made up of two or more fields.

What is the main reason to split an Access database?

What are the benefits of normalization?

What is the main reason for splitting a database?

A table is in ________ if it meets 2NF criteria and no transitive dependencies exist.

What is the difference between first,second,and third normal form?

________ creates a report that contains detailed information about the tables and other selected objects in your database.

Access 2013 incorporates encryption methods to keep databases secure.

A(n)________ occurs when the value of one field is determined by the value of another.

Table Analyzer can create additional tables in your database.

When a database has been converted to an .accde file,it can be converted back to its source format (accdb).

The ________ evaluates a database and makes recommendations for optimizing the database.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

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

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Using Macros and SQL in Access: Advanced Techniques

Filters