Question 1

The default character length for the Short Text data type is ____ characters.

Accepted Answer

A)  55 
B)  255 
C)  64 
D)  15

Question 2

Access does not allow data to be imported from sources other than another Access database. _________________________

Accepted Answer

A) True 
 B)False

Question 3

The common field between two tables in the Relationship window is indicated by a(n) ____.

Accepted Answer

A)  key icon 
B)  field name 
C)  join line 
D)  infinity symbol

Question 4

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

Accepted Answer

The answer of  Performing a(n) ____________________ is the process of...

Question 5

A field in an Access database table that has no value is determined by Access to have a ____ value.

Accepted Answer

A)  custom 
B)  zero 
C)  null 
D)  number

Question 6

By choosing the Definition Only option in the Import Objects dialog box,the ____ of a table is imported,but not the ____.

Accepted Answer

A)  data, structure 
B)  data type, structure 
C)  structure, data 
D)  structure, data type

Question 7

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

Accepted Answer

A)  AutoNumber 
B)  Short Text 
C)  Yes/No 
D)  Long Text

Question 8

In order to define table relationships,each table being joined must contain a common field._________________________

Accepted Answer

A) True 
 B)False

Question 9

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

Accepted Answer

The answer of  The "many" side of a one-to-many relationship...

Question 10

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

Accepted Answer

A)  Decimal Places 
B)  Input Mask 
C)  Default Value 
D)  Format

Question 11

The ____________________ data type is not subject to round-off error when calculated,unlike the Number data type with decimal values.

Accepted Answer

The answer of  The ____________________ data type is not subject...

Question 12

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

Accepted Answer

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

Question 13

Identify the letter of the choice that best matches the phrase or definition.
- A group of fields added all at once using the Data Type gallery.
A)Cascade Update Related Fields Option
B)Cascade Delete Related Records Option
C)Composite key
D)data redundancy
E)Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity

Accepted Answer

The answer of Identify the letter of the choice that...

Question 14

Field names in a table may only be changed in Design view. _________________________

Accepted Answer

A) True 
 B)False

Question 15

Which data type allows both positive and negative numbers as field values?

Accepted Answer

A)  Number 
B)  Date/Time 
C)  AutoNumber 
D)  Short Text

Question 16

Identify the letter of the choice that best matches the phrase or definition.
- A primary key that consists of two or more fields in a table.

Accepted Answer

A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity

Question 17

The Currency data type is accurate up to 4 digits on the right side of the decimal point._________________________

Accepted Answer

A) True 
 B)False

Question 18

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

Accepted Answer

A)  entered value 
B)  changed value 
C)  default value 
D)  permanent value

Question 19

Identify the letter of the choice that best matches the phrase or definition.
- The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.

Accepted Answer

A) Cascade Update Related Fields Option 
B) Cascade Delete Related Records Option 
C) Composite key 
D) data redundancy 
E) Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity

Question 20

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database. _________________________

Accepted Answer

A) True 
 B)False

Exam 2: Building a Database and Defining Table Relationships

The default character length for the Short Text data type is ____ characters.

Access does not allow data to be imported from sources other than another Access database. _________________________

The common field between two tables in the Relationship window is indicated by a(n) ____.

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

A field in an Access database table that has no value is determined by Access to have a ____ value.

By choosing the Definition Only option in the Import Objects dialog box,the of a table is imported,but not the .

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

In order to define table relationships,each table being joined must contain a common field._________________________

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

The ____________________ data type is not subject to round-off error when calculated,unlike the Number data type with decimal values.

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

Field names in a table may only be changed in Design view. _________________________

Which data type allows both positive and negative numbers as field values?

Identify the letter of the choice that best matches the phrase or definition. - A primary key that consists of two or more fields in a table.

The Currency data type is accurate up to 4 digits on the right side of the decimal point._________________________

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

Identify the letter of the choice that best matches the phrase or definition. - The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database. _________________________