Question 1

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 2

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 3

By definition,a table cannot be in 1NF unless it is already in 2NF,and it cannot be in 3NF unless it is in 2NF.

Accepted Answer

A) True 
 B)False

Question 4

When a primary key is made up of more than one field,it is known as what type of key?

Accepted Answer

A) Foreign 
B) Primary 
C) Compound 
D) Composite 
A) Foreign 
B) Primary 
C) Compound 
D) Composite

Question 5

If the problem is important enough,the Performance Analyzer tool will inform you of required changes that must be made to your database.

Accepted Answer

A) True 
 B)False

Question 6

Before running the Documenter,you should narrow the options so only the pertinent information is displayed.

Accepted Answer

A) True 
 B)False

Question 7

Creating relationships is not an effective way to test your normalization.

Accepted Answer

A) True 
 B)False

Question 8

Removing a password is also known as decrypting.

Accepted Answer

A) True 
 B)False

Question 9

The Database ________ tool creates a detailed report for each selected object.

Accepted Answer

The answer of The Database ________ tool creates a detailed...

Question 10

Which of the following statements is not true about suggestions displayed by the Performance Analyzer tool?

Accepted Answer

A) They carry no risk at all. 
B) They are identified by a question mark. 
C) They have potential trade-offs that need to be considered. 
D) They can be fixed automatically by the tool. 
A) They carry no risk at all. 
B) They are identified by a question mark. 
C) They have potential trade-offs that need to be considered. 
D) They can be fixed automatically by the tool.

Question 11

The Database Documenter tool becomes less important the larger the database becomes.

Accepted Answer

A) True 
 B)False

Question 12

After using the Database Splitter tool,the tables are found in the back-end file.

Accepted Answer

A) True 
 B)False

Question 13

Navigation forms are only for forms and/or reports,not for tables or queries.

Accepted Answer

A) True 
 B)False

Question 14

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 15

If a table contains no repeating groups or repeating columns,it is said to be in compliance with which normal form?

Accepted Answer

A) First 
B) Second 
C) Third 
D) Fourth 
A) First 
B) Second 
C) Third 
D) Fourth

Question 16

You should wait until the normalization process is complete before creating relationships between tables.

Accepted Answer

A) True 
 B)False

Question 17

A(n)________ form is a tabbed menu system which makes the database easier to use.

Accepted Answer

The answer of A(n)________ form is a tabbed menu system...

Question 18

When should table relationships be created?

Accepted Answer

A) As soon as tables which can be related are created 
B) After completing first normal form optimization 
C) After completing second normal form optimization 
D) After normalization is complete 
A) As soon as tables which can be related are created 
B) After completing first normal form optimization 
C) After completing second normal form optimization 
D) After normalization is complete

Question 19

Navigation forms are only for forms and ________.

Accepted Answer

The answer of Navigation forms are only for forms and...

Question 20

Most of the time,when a table violates the second normal form,the solution involves the creation of one or more new tables.

Accepted Answer

A) True 
 B)False

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

By definition,a table cannot be in 1NF unless it is already in 2NF,and it cannot be in 3NF unless it is in 2NF.

When a primary key is made up of more than one field,it is known as what type of key?

If the problem is important enough,the Performance Analyzer tool will inform you of required changes that must be made to your database.

Before running the Documenter,you should narrow the options so only the pertinent information is displayed.

Creating relationships is not an effective way to test your normalization.

Removing a password is also known as decrypting.

The Database ________ tool creates a detailed report for each selected object.

Which of the following statements is not true about suggestions displayed by the Performance Analyzer tool?

The Database Documenter tool becomes less important the larger the database becomes.

After using the Database Splitter tool,the tables are found in the back-end file.

Navigation forms are only for forms and/or reports,not for tables or queries.

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

If a table contains no repeating groups or repeating columns,it is said to be in compliance with which normal form?

You should wait until the normalization process is complete before creating relationships between tables.

A(n)________ form is a tabbed menu system which makes the database easier to use.

When should table relationships be created?

Navigation forms are only for forms and ________.

Most of the time,when a table violates the second normal form,the solution involves the creation of one or more new tables.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Enhanced Database Techniques

Filters

Exam 10: Fine-Tuning the Database

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

By definition,a table cannot be in 1NF unless it is already in 2NF,and it cannot be in 3NF unless it is in 2NF.

When a primary key is made up of more than one field,it is known as what type of key?

If the problem is important enough,the Performance Analyzer tool will inform you of required changes that must be made to your database.

Before running the Documenter,you should narrow the options so only the pertinent information is displayed.

Creating relationships is not an effective way to test your normalization.

Removing a password is also known as decrypting.

The Database ________ tool creates a detailed report for each selected object.

Which of the following statements is not true about suggestions displayed by the Performance Analyzer tool?

The Database Documenter tool becomes less important the larger the database becomes.

After using the Database Splitter tool,the tables are found in the back-end file.

Navigation forms are only for forms and/or reports,not for tables or queries.

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

If a table contains no repeating groups or repeating columns,it is said to be in compliance with which normal form?

You should wait until the normalization process is complete before creating relationships between tables.

A(n)________ form is a tabbed menu system which makes the database easier to use.

When should table relationships be created?

Navigation forms are only for forms and ________.

Most of the time,when a table violates the second normal form,the solution involves the creation of one or more new tables.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Enhanced Database Techniques

Filters