Question 1

The Database ________ tool divides your database into two files.

Accepted Answer

The answer of The Database ________ tool divides your database...

Question 2

The Database ________ can allow you to view details that are not necessarily apparent by looking at an object.

Accepted Answer

The answer of The Database ________ can allow you to...

Question 3

ACCDE stands for Access Database ________.

Accepted Answer

The answer of ACCDE stands for Access Database ________....

Question 4

A(n)________ is an error or inconsistency within a database.

Accepted Answer

The answer of A(n)________ is an error or inconsistency within...

Question 5

After using the Database Splitter tool,the tables in the back-end are replaced with ________ to those tables in the front-end.

Accepted Answer

The answer of After using the Database Splitter tool,the tables...

Question 6

________ is the process of efficiently organizing data so that the same data is not stored in more than one table,and that related data is stored together.

Accepted Answer

The answer of ________ is the process of efficiently organizing...

Question 7

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

Accepted Answer

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

Question 8

You should wait to create table relationships until after the ________ process is complete.

Accepted Answer

The answer of You should wait to create table relationships...

Question 9

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

Accepted Answer

The answer of A(n)________ dependency occurs when the value of...

Question 10

Adding a password and encryption to a database requires the database to be opened in ________ mode.

Accepted Answer

The answer of Adding a password and encryption to a...

Question 11

Match between columns
                        Premises: Index
Composite key
ACCDE
Anomaly
Non-key field

Accepted Answer

The Answer of Speeds up searches and A primary key is...

Question 12

Match between columns
                        Premises: Database Documenter
Database Splitter
Encryption
Analyze Performance
Analyze Table

Accepted Answer

The Answer of Helps to optimize your database and Divides is...

Question 13

Match between columns
                        Premises: Include for table: permissions by User and Group
Include for table: properties
Include for Fields: Names,Data types,and Sizes
Include for Fields: Names,Data types,Sizes,and properties
Include for Indexes: Names,Fields,and properties

Accepted Answer

The Answer of Includes the names of all indexes,the fields is...

Question 14

Match between columns
                        Premises: Include for table: properties
Include for table: relationships
Include for Fields: Nothing
Include for Indexes: Nothing
Include for Indexes: Names and Fields

Accepted Answer

The Answer of Includes no detail about the indexes in is...

Question 15

Match between columns
                        Premises: Open exclusive
Encrypt with Password
Database Documenter
Database Relationships
Database splitter

Accepted Answer

The Answer of File tab; Info and Database Tools tab; is...

Question 16

Match between columns
                        Premises: Database Documenter
Normalization
Table Analyzer
Encryption
Performance Analyzer

Accepted Answer

The Answer of Report of detailed information about selected objects is...

Question 17

Match between columns
                        Premises: Navigation form
Table Analyzer
Database Documenter
Functional dependency
Performance Analyzer

Accepted Answer

The Answer of Tabbed menu making the database easier to is...

Question 18

Match between columns
                        Premises: Front-end database
Composite key
Database Splitter
Back-end database
Index

Accepted Answer

The Answer of Contains the tables and Contains the forms,reports,and is...

Question 19

Match between columns
                        Premises: First normal form
Normalization
Normal forms
Third normal form
Second normal form

Accepted Answer

The Answer of All non-key fields are functionally dependent on is...

Question 20

Match between columns
                        Premises: Encryption
Transitive dependency
Anomaly
Access Database Executable
Non-key field

Accepted Answer

The Answer of When the value of one non-key field is...

Quiz 10: Fine-Tuning the Database

The Database ________ tool divides your database into two files.

The Database ________ can allow you to view details that are not necessarily apparent by looking at an object.

ACCDE stands for Access Database ________.

A(n)________ is an error or inconsistency within a database.

After using the Database Splitter tool,the tables in the back-end are replaced with ________ to those tables in the front-end.

________ is the process of efficiently organizing data so that the same data is not stored in more than one table,and that related data is stored together.

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

You should wait to create table relationships until after the ________ process is complete.

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

Adding a password and encryption to a database requires the database to be opened in ________ mode.

Match the following terms with their descriptions:

Match the following commands with their outcomes:

Match the following Database Documenter Options with their descriptions:

Match the following Database Documenter Options with their descriptions:

Match the following commands with where they are found on the ribbon:

Match the following tool or feature with how it might be used:

Match the following terms with their descriptions:

Match the following terms with their descriptions:

Match the following terms with their descriptions:

Match the following terms with their descriptions: