Question 1

The Performance Analyzer evaluates a database and makes recommendations for optimizing the database.

Accepted Answer

A) True 
 B)False

Question 2

________ is the process of altering digital information using an algorithm to make it unreadable to anyone except those who possess the key.

Accepted Answer

A) Encryption 
B) Open exclusive 
C) Password 
D) Selfcert 
A) Encryption 
B) Open exclusive 
C) Password 
D) Selfcert

Question 3

Which tool does NOT identify flaws in the design of the database?

Accepted Answer

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

Question 4

One reason why you may not be able to create a relationship is because there may be an issue with the way you have normalized the database.

Accepted Answer

A) True 
 B)False

Question 5

Which process guarantees that you are the only one currently using the database?

Accepted Answer

A) Open exclusive 
B) Encryption 
C) Password protect 
D) Selfcert 
A) Open exclusive 
B) Encryption 
C) Password protect 
D) Selfcert

Question 6

The formal process of deciding which fields should be grouped together into which fields is called ________.

Accepted Answer

The answer of The formal process of deciding which fields...

Question 7

A timestamp can prove that your database has or has not been modified since you applied your signature.

Accepted Answer

A) True 
 B)False

Question 8

Digital certificates are electronic,encryption-based,secure stamps of authentication.

Accepted Answer

A) True 
 B)False

Question 9

A(n)________ database contains only the tables of a database.

Accepted Answer

The answer of A(n)________ database contains only the tables of...

Question 10

Optimizing a database may affect the database in ways you might not consider as positive results.

Accepted Answer

A) True 
 B)False

Question 11

________ is the formal process of deciding which fields should be grouped together into which table.

Accepted Answer

A) Normalization 
B) Anomaly 
C) Second normal form 
D) Transitive dependencies 
A) Normalization 
B) Anomaly 
C) Second normal form 
D) Transitive dependencies

Question 12

The Table Analyzer analyzes the database and normalizes it for you.

Accepted Answer

A) True 
 B)False

Question 13

First normal form is a table that contains no repeating groups or repeating columns.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

What are the three kinds of analysis results of the Performance Analyzer?

Accepted Answer

A) Recommendations,suggestions,and ideas 
B) Recommendations,trade-offs,and ideas 
C) Suggestions,trade-offs,and ideas 
D) Ideas,suggestions,and solutions 
A) Recommendations,suggestions,and ideas 
B) Recommendations,trade-offs,and ideas 
C) Suggestions,trade-offs,and ideas 
D) Ideas,suggestions,and solutions

Question 16

A good password should be at least eight characters which combines uppercase and lowercase letters,numbers,and symbols to make the password more difficult for others to guess.

Accepted Answer

A) True 
 B)False

Question 17

Multivalued fields are created using the Input Mask Wizard.

Accepted Answer

A) True 
 B)False

Question 18

What do the Performance Analyzer Analysis Notes tell you?

Accepted Answer

It provides a brief

Question 19

One benefit of normalization is the improvement of referential integrity enforcement in relationships.

Accepted Answer

A) True 
 B)False

Question 20

The Database Splitter tool enables you to split a database into three files:
a back-end,middle,and front-end database.

Accepted Answer

A) True 
 B)False

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

The Performance Analyzer evaluates a database and makes recommendations for optimizing the database.

________ is the process of altering digital information using an algorithm to make it unreadable to anyone except those who possess the key.

Which tool does NOT identify flaws in the design of the database?

One reason why you may not be able to create a relationship is because there may be an issue with the way you have normalized the database.

Which process guarantees that you are the only one currently using the database?

The formal process of deciding which fields should be grouped together into which fields is called ________.

A timestamp can prove that your database has or has not been modified since you applied your signature.

Digital certificates are electronic,encryption-based,secure stamps of authentication.

A(n)________ database contains only the tables of a database.

Optimizing a database may affect the database in ways you might not consider as positive results.

________ is the formal process of deciding which fields should be grouped together into which table.

The Table Analyzer analyzes the database and normalizes it for you.

First normal form is a table that contains no repeating groups or repeating columns.

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

What are the three kinds of analysis results of the Performance Analyzer?

A good password should be at least eight characters which combines uppercase and lowercase letters,numbers,and symbols to make the password more difficult for others to guess.

Multivalued fields are created using the Input Mask Wizard.

What do the Performance Analyzer Analysis Notes tell you?

One benefit of normalization is the improvement of referential integrity enforcement in relationships.

The Database Splitter tool enables you to split a database into three files: a back-end,middle,and front-end database.

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