Question 1

Multivalued fields are created using the Input Mask Wizard.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Which normal form requires that all non-key fields are functionally dependent on the entire primary key?

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 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

You would use the ________ to evaluate a database and produce results 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 7

Table Analyzer can create additional tables in your database.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Access 2013 incorporates encryption methods to keep databases secure.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

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

Accepted Answer

A)  Database Documenter 
B)  Performance Analyzer 
C)  Database Splitter 
D)  Oracle 
A)  Database Documenter 
B)  Performance Analyzer 
C)  Database Splitter 
D)  Oracle

Question 13

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

Accepted Answer

Performanc

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

The Database Splitter is not identified by name on the Access Ribbon.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

Question 18

A timestamp can prove that your database has or has not been modified since you applied your signature.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Multivalued fields are created using the Input Mask Wizard.

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

Which normal form requires that all non-key fields are functionally dependent on the entire primary key?

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.

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

You would use the ________ to evaluate a database and produce results for optimizing the database.

Table Analyzer can create additional tables in your database.

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?

Access 2013 incorporates encryption methods to keep databases secure.

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

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

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

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

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

The Database Splitter is not identified by name on the Access Ribbon.

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

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

A timestamp can prove that your database has or has not been modified since you applied your signature.

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

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

Introduction to Access: Finding Your Way Through an Access Database

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

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

Multivalued fields are created using the Input Mask Wizard.

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

Which normal form requires that all non-key fields are functionally dependent on the entire primary key?

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.

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

You would use the ________ to evaluate a database and produce results for optimizing the database.

Table Analyzer can create additional tables in your database.

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?

Access 2013 incorporates encryption methods to keep databases secure.

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

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

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

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

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

The Database Splitter is not identified by name on the Access Ribbon.

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

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

A timestamp can prove that your database has or has not been modified since you applied your signature.

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

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

Introduction to Access: Finding Your Way Through an Access Database

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters