Question 1

Creating an Access Database Executable (ACCDE)file will remove all VBA source code from the database.

Accepted Answer

A) True 
 B)False

Question 2

To set a password,the database has to be opened in exclusive mode.

Accepted Answer

A) True 
 B)False

Question 3

________ makes the database unreadable by encrypting the database.

Accepted Answer

A) Password protect 
B) Make ACCDE 
C) Digital Signature 
D) Encryption 
A) Password protect 
B) Make ACCDE 
C) Digital Signature 
D) Encryption

Question 4

There are three normal forms;however,the majority of database designs only require the first two normal forms.

Accepted Answer

A) True 
 B)False

Question 5

What appears when you point to a table name of a linked table?

Accepted Answer

A) ScreenTip 
B) Splitter 
C) Table Analyzer 
D) Wizard 
A) ScreenTip 
B) Splitter 
C) Table Analyzer 
D) Wizard

Question 6

What is the purpose of a password?

Accepted Answer

To keep unauthorized

Question 7

What are three useful Access tools that database administrators can use to improve the performance of a database?

Accepted Answer

Database Documenter

Question 8

________ reduce the time it takes to run queries and reports.

Accepted Answer

A) Indexes 
B) Ideas 
C) Suggestions 
D) Recommendations 
A) Indexes 
B) Ideas 
C) Suggestions 
D) Recommendations

Question 9

Normalization rules indicate the current state of a table.

Accepted Answer

A) True 
 B)False

Question 10

The Performance Analyzer Tool creates a report that contains detailed information for each selected object.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

An Access tool that makes recommendations for optimizing the database is called the ________ tool.

Accepted Answer

Performanc

Question 15

The Database Documenter saves its report in a number of formats including PDF or XPS formats.

Accepted Answer

A) True 
 B)False

Question 16

What are the three Performance Analyzer result types?

Accepted Answer

Recommenda

Question 17

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

What is the best way to fix a table with repeating groups?

Accepted Answer

A) Either fix the repeating groups in Excel before importing to Access or alternately add rows in Access and separate repeating data into individual rows 
B) Export table to Excel,fix repeating groups,then import back to Access 
C) Create additional columns for repeating data 
D) Filter or query the table searching for repeating groups 
A) Either fix the repeating groups in Excel before importing to Access or alternately add rows in Access and separate repeating data into individual rows 
B) Export table to Excel,fix repeating groups,then import back to Access 
C) Create additional columns for repeating data 
D) Filter or query the table searching for repeating groups

Question 19

A method to encrypt a database is to assign a password to the file.

Accepted Answer

A) True 
 B)False

Question 20

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

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

Creating an Access Database Executable (ACCDE)file will remove all VBA source code from the database.

To set a password,the database has to be opened in exclusive mode.

________ makes the database unreadable by encrypting the database.

There are three normal forms;however,the majority of database designs only require the first two normal forms.

What appears when you point to a table name of a linked table?

What is the purpose of a password?

What are three useful Access tools that database administrators can use to improve the performance of a database?

________ reduce the time it takes to run queries and reports.

Normalization rules indicate the current state of a table.

The Performance Analyzer Tool creates a report that contains detailed information for each selected object.

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

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?

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

An Access tool that makes recommendations for optimizing the database is called the ________ tool.

The Database Documenter saves its report in a number of formats including PDF or XPS formats.

What are the three Performance Analyzer result types?

________ are not allowed in a normalized table.

What is the best way to fix a table with repeating groups?

A method to encrypt a database is to assign a password to the file.

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

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