Question 1

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 2

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 3

________ is electronic,encryption-based,secure stamps of authentication that confirms who created the file,that the file is valid,and that no changes have been made to the file after its authentication.

Accepted Answer

A)  Digital signature 
B)  Digital certificate 
C)  Package and sign 
D)  ACCDE 
A)  Digital signature 
B)  Digital certificate 
C)  Package and sign 
D)  ACCDE

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

An inconsistency in a database is referred to as a(n)________.

Accepted Answer

The answer of An inconsistency in a database is referred...

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Multivalued fields are created using the Input Mask Wizard.

Accepted Answer

A) True 
 B)False

Question 11

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 12

The Database Documenter creates a report that contains detailed information about the tables and other selected objects in your database.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

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 16

What do the Performance Analyzer Analysis Notes tell you?

Accepted Answer

It provides a brief

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Exam 21: Fine-Tuning the Database: Analyzing and Improving Database Performance

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

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

________ is electronic,encryption-based,secure stamps of authentication that confirms who created the file,that the file is valid,and that no changes have been made to the file after its authentication.

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

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

Which Performance Analyzer result requires manual changes?

An inconsistency in a database is referred to as a(n)________.

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

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

Multivalued fields are created using the Input Mask Wizard.

What is a certification authority?

The Database Documenter creates a report that contains detailed information about the tables and other selected objects in your database.

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

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

Which of the following can be tested by creating relationships?

What do the Performance Analyzer Analysis Notes tell you?

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

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

What is database security?

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.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

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

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

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

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

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Using Macros and SQL in Access: Advanced Techniques

Filters