Question 1

The Database Splitter is not identified by name on the Access Ribbon.

Accepted Answer

A) True 
 B)False

Question 2

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 3

A(n)________ occur when the value of one non-key field is functionally dependent on the value of another non-key field.

Accepted Answer

A) transitive dependencies 
B) composite keys 
C) non-key fields 
D) functional dependencies 
A) transitive dependencies 
B) composite keys 
C) non-key fields 
D) functional dependencies

Question 4

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 5

A ________ is a combination of the date and time that is encrypted as part of the digital signature.

Accepted Answer

A) timestamp 
B) certificate 
C) navigation 
D) password 
A) timestamp 
B) certificate 
C) navigation 
D) password

Question 6

The ________ contains the queries,forms,and reports of the database.

Accepted Answer

A) back-end database 
B) database documenter 
C) front-end database 
D) design tools 
A) back-end database 
B) database documenter 
C) front-end database 
D) design tools

Question 7

What does the Database Splitter do?

Accepted Answer

A) Splits database into two files,a back-end and a front-end database 
B) Divides the table and creates relationships that control how the new tables are linked 
C) Adds more indexes to increase database performance 
D) Provides a brief description of a potential problem and its possible solution 
A) Splits database into two files,a back-end and a front-end database 
B) Divides the table and creates relationships that control how the new tables are linked 
C) Adds more indexes to increase database performance 
D) Provides a brief description of a potential problem and its possible solution

Question 8

An inconsistency in a database is referred to as a(n)________.

Accepted Answer

The answer of An inconsistency in a database is referred...

Question 9

What does the Database Documenter list?

Accepted Answer

The proper

Question 10

Any field that is not part of the primary key is called a(n)________.

Accepted Answer

The answer of Any field that is not part of...

Question 11

________ provides a brief description of a potential problem and its possible solution.

Accepted Answer

A) Analysis Notes 
B) Analyzer report 
C) Documenter report 
D) Preview report 
A) Analysis Notes 
B) Analyzer report 
C) Documenter report 
D) Preview report

Question 12

In the Navigation Pane,________ tables have an arrow icon to indicate they are linked to another Access database.

Accepted Answer

The answer of In the Navigation Pane,________ tables have an...

Question 13

Table Analyzer can create additional tables in your database.

Accepted Answer

A) True 
 B)False

Question 14

The Performance Analyzer lists three kinds of analysis results:
recommendations,suggestions,and ideas.

Accepted Answer

A) True 
 B)False

Question 15

Name two situations that violate 1NF.

Accepted Answer

Multiple values in the same fi

Question 16

How does Access handle multivalued fields?

Accepted Answer

A) Creates special invisible tables in the background 
B) Appear as repeating groups in the table 
C) Makes the multivalue field dependent on the primary key 
D) Removes dependencies on required fields 
A) Creates special invisible tables in the background 
B) Appear as repeating groups in the table 
C) Makes the multivalue field dependent on the primary key 
D) Removes dependencies on required fields

Question 17

________ 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 18

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

Accepted Answer

A) True 
 B)False

Question 19

A ________ is a tabbed menu system that ties the objects in the database together so that the database is easy to use.

Accepted Answer

A) navigation form 
B) switchboard 
C) command option 
D) ribbon 
A) navigation form 
B) switchboard 
C) command option 
D) ribbon

Question 20

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

Exam 35: Fine Tuning the Database: Analyzing and Improving Database Performance

The Database Splitter is not identified by name on the Access Ribbon.

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

A(n)________ occur when the value of one non-key field is functionally dependent on the value of another non-key field.

What is the main reason to split an Access database?

A ________ is a combination of the date and time that is encrypted as part of the digital signature.

The ________ contains the queries,forms,and reports of the database.

What does the Database Splitter do?

An inconsistency in a database is referred to as a(n)________.

What does the Database Documenter list?

Any field that is not part of the primary key is called a(n)________.

________ provides a brief description of a potential problem and its possible solution.

In the Navigation Pane,________ tables have an arrow icon to indicate they are linked to another Access database.

Table Analyzer can create additional tables in your database.

The Performance Analyzer lists three kinds of analysis results: recommendations,suggestions,and ideas.

Name two situations that violate 1NF.

How does Access handle multivalued fields?

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

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

A ________ is a tabbed menu system that ties the objects in the database together so that the database is easy to use.

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

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

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

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters