Question 1

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 2

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 3

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 4

Multivalued fields are created using the Input Mask Wizard.

Accepted Answer

A) True 
 B)False

Question 5

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

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

Accepted Answer

A) True 
 B)False

Question 7

What is the purpose of a password?

Accepted Answer

To keep unauthorized

Question 8

What does the Table Analyzer do?

Accepted Answer

A) Analyzes the tables in a database and normalizes them for you 
B) Gives you notes and specifications recommended and then fixes them 
C) Provides a brief description of potential problems and possible solutions 
D) Lists three kinds of analysis results 
A) Analyzes the tables in a database and normalizes them for you 
B) Gives you notes and specifications recommended and then fixes them 
C) Provides a brief description of potential problems and possible solutions 
D) Lists three kinds of analysis results

Question 9

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 10

________ is the protection of data from unauthorized access,change,or destruction.

Accepted Answer

A) Computer security 
B) Improved performance 
C) Encryption 
D) Flexible Environment 
A) Computer security 
B) Improved performance 
C) Encryption 
D) Flexible Environment

Question 11

What are four ways to keep your database application safe?

Accepted Answer

Create a navigation form,encry

Question 12

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 13

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 14

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 15

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 16

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 17

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

Accepted Answer

The answer of ________ dependency occurs when the value of...

Question 18

Which of the following can be tested by creating relationships?

Accepted Answer

A) Normalization 
B) Anomaly 
C) Composite key 
D) Dependencies 
A) Normalization 
B) Anomaly 
C) Composite key 
D) Dependencies

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

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

How does Access handle multivalued fields?

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

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

Multivalued fields are created using the Input Mask Wizard.

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

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

What is the purpose of a password?

What does the Table Analyzer do?

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.

________ is the protection of data from unauthorized access,change,or destruction.

What are four ways to keep your database application safe?

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

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

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

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

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

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

Which of the following can be tested by creating relationships?

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

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?

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