Question 1

Match between columns
                        Premises: A process of structuring data into a well-defined database
A property that displays the default field name at the top of the field column
A sample database template
A blank entry
An intentional "nothing" entry

Accepted Answer

The Answer of Normalizing and Caption and Null and Zero-length is...

Question 2

A normalized database increases redundant data.

Accepted Answer

A) True 
 B)False

Question 3

A text field allows you to calculate a(n) ____ statistic in the Totals cell.

Accepted Answer

A)  Average 
B)  Sum 
C)  Count 
D)  All of the above 
A)  Average 
B)  Sum 
C)  Count 
D)  All of the above

Question 4

Describe third normal form.

Accepted Answer

Third normal form builds on se

Question 5

First normal form means that redundant data in the original table is extracted, placed in a new table, and related to the original table. _________________________

Accepted Answer

A) True 
 B)False

Question 6

A(n) ____________________ keeps track of the order of the values in the indexed field as data is being entered and edited.

Accepted Answer

The answer of A(n) ____________________ keeps track of the order...

Question 7

The "one" table in a relationship is also called the parent table.

Accepted Answer

A) True 
 B)False

Question 8

The Allow Multiple Values property is found on the Lookup tab in Table Design View.

Accepted Answer

A) True 
 B)False

Question 9

When you use the LookupWizard, you create both a one-to-many relationship and entity integrity. ____________________

Accepted Answer

A) True 
 B)False

Question 10

To add a total to a datasheet column, click the Totals button in the _____ group on the Home tab.

Accepted Answer

A)  Record 
B)  Data 
C)  Properties 
D)  Sort & Filter 
A)  Record 
B)  Data 
C)  Properties 
D)  Sort & Filter

Question 11

A switchboard form can have a a maximum of 100 command buttons, labels, or other controls.

Accepted Answer

A) True 
 B)False

A normalized database increases redundant data.

A text field allows you to calculate a(n) ____ statistic in the Totals cell.

Describe third normal form.

First normal form means that redundant data in the original table is extracted, placed in a new table, and related to the original table. _________________________

A(n) ____________________ keeps track of the order of the values in the indexed field as data is being entered and edited.

The "one" table in a relationship is also called the parent table.

The Allow Multiple Values property is found on the Lookup tab in Table Design View.

When you use the LookupWizard, you create both a one-to-many relationship and entity integrity. ____________________

To add a total to a datasheet column, click the Totals button in the _____ group on the Home tab.

A switchboard form can have a a maximum of 100 command buttons, labels, or other controls.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Filters

Exam 16: Completing a Database Application

A normalized database increases redundant data.

A text field allows you to calculate a(n) ____ statistic in the Totals cell.

Describe third normal form.

First normal form means that redundant data in the original table is extracted, placed in a new table, and related to the original table. _________________________

A(n) ____________________ keeps track of the order of the values in the indexed field as data is being entered and edited.

The "one" table in a relationship is also called the parent table.

The Allow Multiple Values property is found on the Lookup tab in Table Design View.

When you use the LookupWizard, you create both a one-to-many relationship and entity integrity. ____________________

To add a total to a datasheet column, click the Totals button in the _____ group on the Home tab.

A switchboard form can have a a maximum of 100 command buttons, labels, or other controls.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Filters