Question 1

Compare and contrast a zero-length string with a null entry.

Accepted Answer

Both appear to be blank entries, but the

Question 2

Any form can act as a startup switchboard form.

Accepted Answer

A) True 
 B)False

Question 3

To move a field list in the Relationship window, drag its ____________________.

Accepted Answer

The answer of To move a field list in the...

Question 4

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt. 
Which window shows you how well the data has been normalized?

Accepted Answer

The answer of Kelsey and Matt are in an advanced...

Question 5

Which is NOT true of the Caption property?

Accepted Answer

A)  It is an optional property. 
B)  It is used as the default field name at the top of the field column in datasheets. 
C)  It is used as the default field name in labels that describe fields on forms and reports. 
D)  It must match the field name. 
A)  It is an optional property. 
B)  It is used as the default field name at the top of the field column in datasheets. 
C)  It is used as the default field name in labels that describe fields on forms and reports. 
D)  It must match the field name.

Question 6

You query for zero-length strings using Is Null criteria. _________________________

Accepted Answer

A) True 
 B)False

Question 7

With join operations " right " always refers to the "one" table of a one-to-many relationship. ____________________

Accepted Answer

A) True 
 B)False

Question 8

Checking the Automatically Update Related Fields check box means that if you change the primary key field value in the table on the "one" side of a one-to-many relationship, all foreign key values in the "many" table automatically update as well. ____________________

Accepted Answer

A) True 
 B)False

Question 9

You should strive to create databases that use ____ rules for normalization.

Accepted Answer

A)  zero normal form 
B)  first normal form 
C)  second normal form 
D)  third normal form 
A)  zero normal form 
B)  first normal form 
C)  second normal form 
D)  third normal form

Question 10

Checking the Cascade Delete Related Fields check box means that if you delete a record in the table on the "one" side of a one-to-many relationship, all related records in the "many" table automatically delete as well. ____________________

Accepted Answer

A) True 
 B)False

Question 11

Two tables have a ____ relationship when they are both related to the same intermediate table with one-to-many relationships.

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-one 
D)  many-to-many 
A)  one-to-one 
B)  one-to-many 
C)  many-to-one 
D)  many-to-many

Question 12

Use Variable Text fields when you need to store more than 256 characters in a field. ____________________

Accepted Answer

A) True 
 B)False

Question 13

A(n) ____________________  join operation is the default join that applies to one-to-many relationships between two tables in a query.

Accepted Answer

The answer of A(n) ____________________  join operation is the default join...

Question 14

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt. 
What is the first clue that data is not properly normalized?

Accepted Answer

You see a lot of rep

Question 15

A(n) _____ join means that records are selected only if a matching value is present in both tables.

Accepted Answer

A)  default 
B)  inner 
C)  right 
D)  left 
A)  default 
B)  inner 
C)  right 
D)  left

Question 16

When two fields are used in a Validation Rule expression, you should enter the rule in the ____.

Accepted Answer

A)  table's Property Sheet 
B)  individual field's Property Sheet 
C)  query Validation box 
D)  Current Record box 
A)  table's Property Sheet 
B)  individual field's Property Sheet 
C)  query Validation box 
D)  Current Record box

Question 17

You work in the registrar's office of a large university. You are responsible for creating a student database that contains students' ID numbers, names, addresses, phone numbers, and some medical information. 
Suppose the student health database includes two tables, one table called Students that contains student information such as StudentID, student name, address, and telephone number and the other table called Documentation that contains several records for each student and records the dates and descriptions of various medical documents required by the university. What type of relationship would need to be established between the two tables?

Accepted Answer

The answer of You work in the registrar's office of...

Question 18

To move a field list, drag its title bar.

Accepted Answer

A) True 
 B)False

Question 19

List three reasons why data normalization is valuable.

Accepted Answer

1. Reduces inaccurate data 
2. Reduces r

Question 20

Normalizing data means ____.

Accepted Answer

A)  analyzing database performance 
B)  structuring it for a relational database 
C)  creating clear and logical data entry forms 
D)  repeating data between two tables 
A)  analyzing database performance 
B)  structuring it for a relational database 
C)  creating clear and logical data entry forms 
D)  repeating data between two tables

Compare and contrast a zero-length string with a null entry.

Any form can act as a startup switchboard form.

To move a field list in the Relationship window, drag its ____________________.

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt. Which window shows you how well the data has been normalized?

Which is NOT true of the Caption property?

You query for zero-length strings using Is Null criteria. _________________________

With join operations " right " always refers to the "one" table of a one-to-many relationship. ____________________

Checking the Automatically Update Related Fields check box means that if you change the primary key field value in the table on the "one" side of a one-to-many relationship, all foreign key values in the "many" table automatically update as well. ____________________

You should strive to create databases that use ____ rules for normalization.

Checking the Cascade Delete Related Fields check box means that if you delete a record in the table on the "one" side of a one-to-many relationship, all related records in the "many" table automatically delete as well. ____________________

Two tables have a ____ relationship when they are both related to the same intermediate table with one-to-many relationships.

Use Variable Text fields when you need to store more than 256 characters in a field. ____________________

A(n) ____________________ join operation is the default join that applies to one-to-many relationships between two tables in a query.

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt. What is the first clue that data is not properly normalized?

A(n) _____ join means that records are selected only if a matching value is present in both tables.

When two fields are used in a Validation Rule expression, you should enter the rule in the ____.

To move a field list, drag its title bar.

List three reasons why data normalization is valuable.

Normalizing data means ____.

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

Compare and contrast a zero-length string with a null entry.

Any form can act as a startup switchboard form.

To move a field list in the Relationship window, drag its ____________________.

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt. Which window shows you how well the data has been normalized?

Which is NOT true of the Caption property?

You query for zero-length strings using Is Null criteria. _________________________

With join operations " right " always refers to the "one" table of a one-to-many relationship. ____________________

Checking the Automatically Update Related Fields check box means that if you change the primary key field value in the table on the "one" side of a one-to-many relationship, all foreign key values in the "many" table automatically update as well. ____________________

You should strive to create databases that use ____ rules for normalization.

Checking the Cascade Delete Related Fields check box means that if you delete a record in the table on the "one" side of a one-to-many relationship, all related records in the "many" table automatically delete as well. ____________________

Two tables have a ____ relationship when they are both related to the same intermediate table with one-to-many relationships.

Use Variable Text fields when you need to store more than 256 characters in a field. ____________________

A(n) ____________________ join operation is the default join that applies to one-to-many relationships between two tables in a query.

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt. What is the first clue that data is not properly normalized?

A(n) _____ join means that records are selected only if a matching value is present in both tables.

When two fields are used in a Validation Rule expression, you should enter the rule in the ____.

To move a field list, drag its title bar.

List three reasons why data normalization is valuable.

Normalizing data means ____.

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