Question 1

What do the Performance Analyzer Analysis Notes tell you?

Accepted Answer

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

Question 2

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  False

Question 3

To start a navigation form automatically on start up,change settings in the Options window.

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

A(n)________ is a primary key that is made up of two or more fields.

Accepted Answer

The answer of A(n)________ is a primary key that is...

Question 7

________ dependencies occur when the value of one non-key field is functionally dependent on the value of another non-key field.

Accepted Answer

The answer of ________ dependencies occur when the value of...

Question 8

A back-end database contains the queries,forms,and reports of the database.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

What are the three Performance Analyzer result types?

Accepted Answer

Recommenda

Question 12

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

Question 13

What is database security?

Accepted Answer

A) A specialty within computer security that protects a database application from unintended use 
B) Protecting assets you can touch,such as computers,storage devices,backup tapes,and office safe 
C) Protecting the information that resides on the physical devices,including databases and other computer software 
D) A tabbed menu system that ties the objects in the database together 
A) A specialty within computer security that protects a database application from unintended use 
B) Protecting assets you can touch,such as computers,storage devices,backup tapes,and office safe 
C) Protecting the information that resides on the physical devices,including databases and other computer software 
D) A tabbed menu system that ties the objects in the database together

Question 14

What is the main reason for splitting a database?

Accepted Answer

To improve development and maintenance o

Question 15

You cannot create an ACCDE file unless you have enabled the content in the database.

Accepted Answer

A) True 
 B)False

Question 16

A table that contains no repeating groups or repeating columns is in:

Accepted Answer

A) first normal form. 
B) second normal form. 
C) third normal form. 
D) fourth normal form. 
A) first normal form. 
B) second normal form. 
C) third normal form. 
D) fourth normal form.

Question 17

A certification authority is a commercial company that issues and validates identities using digital signatures for a fee.

Accepted Answer

A) True 
 B)False

Question 18

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 19

What is a certification authority?

Accepted Answer

A) A commercial company that issues and validates identities using digital signatures for a fee 
B) An electronic,encryption-based,secure stamps of authentication 
C) A guarantee that you are the only one using the database 
D) Altering digital information using an algorithm 
A) A commercial company that issues and validates identities using digital signatures for a fee 
B) An electronic,encryption-based,secure stamps of authentication 
C) A guarantee that you are the only one using the database 
D) Altering digital information using an algorithm

Question 20

A table is in ________ if it meets 1NF criteria and all non-key fields are functionally dependent on the entire primary key.

Accepted Answer

A) second normal form 
B) third normal form 
C) fourth normal form 
D) fifth normal form 
A) second normal form 
B) third normal form 
C) fourth normal form 
D) fifth normal form

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

What do the Performance Analyzer Analysis Notes tell you?

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

To start a navigation form automatically on start up,change settings in the Options window.

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

What does the Database Splitter do?

A(n)________ is a primary key that is made up of two or more fields.

________ dependencies occur when the value of one non-key field is functionally dependent on the value of another non-key field.

A back-end database contains the queries,forms,and reports of the database.

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

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

What are the three Performance Analyzer result types?

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

What is database security?

What is the main reason for splitting a database?

You cannot create an ACCDE file unless you have enabled the content in the database.

A table that contains no repeating groups or repeating columns is in:

A certification authority is a commercial company that issues and validates identities using digital signatures for a fee.

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

What is a certification authority?

A table is in ________ if it meets 1NF criteria and all non-key fields are functionally dependent on the entire primary key.

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