Question 1

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

Question 2

Normalization rules indicate the current state of a table.

Accepted Answer

A) True 
 B)False

Question 3

Minimizing data redundancy is one of the benefits of normalization.

Accepted Answer

A) True 
 B)False

Question 4

When a file is saved as an Access Database Executable file,VBA code can be executed,but it cannot be modified.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

You should add a(n)________ to any field that will be searched because it reduces the time it takes to run queries and reports when it is added.

Accepted Answer

The answer of You should add a(n)________ to any field...

Question 7

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 8

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

Accepted Answer

First normal form removes repeating grou

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

Match between columns
                        Premises: encryption
anomaly
non-key field
composite key

Accepted Answer

The Answer of the process of altering digital information using is...

Question 12

What does a back-end database contain?

Accepted Answer

A) Tables of the database 
B) Queries,forms,and reports of the database 
C) Tables and queries of the database 
D) Tables,forms,and reports of the database 
A) Tables of the database 
B) Queries,forms,and reports of the database 
C) Tables and queries of the database 
D) Tables,forms,and reports of the database

Question 13

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 14

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

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

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 17

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

Which Performance Analyzer result requires manual changes?

Accepted Answer

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

Question 19

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

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

Accepted Answer

A) True 
 B)False

Exam 38: Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

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

Normalization rules indicate the current state of a table.

Minimizing data redundancy is one of the benefits of normalization.

When a file is saved as an Access Database Executable file,VBA code can be executed,but it cannot be modified.

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

You should add a(n)________ to any field that will be searched because it reduces the time it takes to run queries and reports when it is added.

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

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

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

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

What does a back-end database contain?

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

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

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

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

________ makes the database unreadable by encrypting the database.

Which Performance Analyzer result requires manual changes?

________ are not allowed in a normalized table.

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

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

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

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

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

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Filters