Question 1

A(n) Number data type is used to store values that represent money. _________________________

Accepted Answer

A) True 
 B)False  False

Question 2

-Using the accompanying figure, explain the term "orphan record" and how to avoid creating one in the Donations table.

Accepted Answer

An orphan record is a record in the "many" table in a one-to-many relationship that doesn't have a matching record in the linking field of the "one" table. If you enforce referential integrity when you are creating one-to-many table relationships, rules will be applied that prevent you from creating orphan records.
In the figure above, an orphan record would be a record in the Donations table that doesn't have a matching record in the Employees or Hospitals tables.

Question 3

-In the accompanying figure, item 1 points to a(n) ____.

Accepted Answer

A)  primary key field 
B)  foreign key 
C)  field property 
D)  table name 
A)  primary key field 
B)  foreign key 
C)  field property 
D)  table name D

Question 4

-In the accompanying figure, how does the Enforce Referential Integrity option relate to the creation of orphan records?

Accepted Answer

Enforce Referential Integrity is a set o

Question 5

The Field Properties pane displays information for how many fields at the same time?

Accepted Answer

A)  Only the selected field. 
B)  However many are visible in the window. 
C)  All of the fields in that particular table. 
D)  All of the fields in the entire database. 
A)  Only the selected field. 
B)  However many are visible in the window. 
C)  All of the fields in that particular table. 
D)  All of the fields in the entire database.

Question 6

____ properties allow you to supply a drop-down list of values for a field.

Accepted Answer

A)  Key 
B)  Relationship 
C)  Lookup 
D)  Junction 
A)  Key 
B)  Relationship 
C)  Lookup 
D)  Junction

Question 7

To quickly remove all Lookup properties, change the Display Control property to Combo Box.
_________________________

Accepted Answer

A) True 
 B)False

Question 8

What data type sequences each new record with the next available integer?

Accepted Answer

A)  Yes/No 
B)  Memo 
C)  Attachment 
D)  AutoNumber 
A)  Yes/No 
B)  Memo 
C)  Attachment 
D)  AutoNumber

Question 9

Field descriptions may be entered in Table Design View. _________________________

Accepted Answer

A) True 
 B)False

Question 10

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is NOT a principle of relational database design?

Accepted Answer

A)  Design each table to contain fields that describe only one subject. 
B)  Identify a primary key field or key field combination for each table. 
C)  Data should be entered before table relationships are built. 
D)  Build one-to-many relationships between the tables of your database using a field common to each table. 
A)  Design each table to contain fields that describe only one subject. 
B)  Identify a primary key field or key field combination for each table. 
C)  Data should be entered before table relationships are built. 
D)  Build one-to-many relationships between the tables of your database using a field common to each table.

Question 12

When a Caption property is not entered, the field name is used to label the field.

Accepted Answer

A) True 
 B)False

Question 13

Match the following common Number field properties with the correct description.
-Determines the largest number that can be entered in a field

Accepted Answer

A) Long integer 
B) Single 
C) Byte 
D) Field size 
E) Double 
A) Long integer 
B) Single 
C) Byte 
D) Field size 
E) Double

Question 14

The Enforce Referential Integrity button is found on the DESIGN tab of the ribbon.

Accepted Answer

A) True 
 B)False

Question 15

The Validation Rule property is not used with Text or Date/Time fields.

Accepted Answer

A) True 
 B)False

Question 16

The Input Mask property contains how many parts?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 17

The ____ key field is the linking field on the "many" side of the relationship.

Accepted Answer

A)  record 
B)  table 
C)  link 
D)  foreign 
A)  record 
B)  table 
C)  link 
D)  foreign

Question 18

Which of the following is NOT a possible entry for the Field Size property of a Number field?

Accepted Answer

A)  Currency 
B)  Byte 
C)  Long Integer 
D)  Single 
A)  Currency 
B)  Byte 
C)  Long Integer 
D)  Single

Question 19

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

Accepted Answer

A)  indexes 
B)  tables 
C)  links 
D)  properties 
A)  indexes 
B)  tables 
C)  links 
D)  properties

Question 20

-Anne Michael is working with the table in the accompanying figure. Explain what will happen when she works with the PaymentNo field in Datasheet View.

Accepted Answer

The PaymentNo field is an Auto

A(n) Number data type is used to store values that represent money. _________________________

-Using the accompanying figure, explain the term "orphan record" and how to avoid creating one in the Donations table.

-In the accompanying figure, item 1 points to a(n) ____.

-In the accompanying figure, how does the Enforce Referential Integrity option relate to the creation of orphan records?

The Field Properties pane displays information for how many fields at the same time?

____ properties allow you to supply a drop-down list of values for a field.

To quickly remove all Lookup properties, change the Display Control property to Combo Box. _________________________

What data type sequences each new record with the next available integer?

Field descriptions may be entered in Table Design View. _________________________

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

Which of the following is NOT a principle of relational database design?

When a Caption property is not entered, the field name is used to label the field.

Match the following common Number field properties with the correct description. -Determines the largest number that can be entered in a field

The Enforce Referential Integrity button is found on the DESIGN tab of the ribbon.

The Validation Rule property is not used with Text or Date/Time fields.

The Input Mask property contains how many parts?

The ____ key field is the linking field on the "many" side of the relationship.

Which of the following is NOT a possible entry for the Field Size property of a Number field?

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

-Anne Michael is working with the table in the accompanying figure. Explain what will happen when she works with the PaymentNo field in Datasheet View.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 6: Modifying the Database Structure

A(n) Number data type is used to store values that represent money. _________________________

-Using the accompanying figure, explain the term "orphan record" and how to avoid creating one in the Donations table.

-In the accompanying figure, item 1 points to a(n) ____.

-In the accompanying figure, how does the Enforce Referential Integrity option relate to the creation of orphan records?

The Field Properties pane displays information for how many fields at the same time?

____ properties allow you to supply a drop-down list of values for a field.

To quickly remove all Lookup properties, change the Display Control property to Combo Box. _________________________

What data type sequences each new record with the next available integer?

Field descriptions may be entered in Table Design View. _________________________

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

Which of the following is NOT a principle of relational database design?

When a Caption property is not entered, the field name is used to label the field.

Match the following common Number field properties with the correct description. -Determines the largest number that can be entered in a field

The Enforce Referential Integrity button is found on the DESIGN tab of the ribbon.

The Validation Rule property is not used with Text or Date/Time fields.

The Input Mask property contains how many parts?

The ____ key field is the linking field on the "many" side of the relationship.

Which of the following is NOT a possible entry for the Field Size property of a Number field?

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

-Anne Michael is working with the table in the accompanying figure. Explain what will happen when she works with the PaymentNo field in Datasheet View.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters