Question 1

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 relating...

Question 2

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 3

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n)keyboard shortcut._________________________

Accepted Answer

A) True 
 B)False

Question 4

Identify the letter of the choice that best matches the phrase or definition.
-The process that occurs when the field Description (Optional)property is changed in Design View and the Property Update Options tool is used to update the entire database everywhere the field is used,including forms and reports.

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 5

The default Field Size for the Short Text data type is ____________________ characters.

Accepted Answer

The answer of The default Field Size for the Short...

Question 6

The way field values are stored,displayed,and processed in an Access database is determined by the ____________________.

Accepted Answer

The answer of The way field values are stored,displayed,and processed...

Question 7

Access automatically assigns the Number data type to all new fields.
_________________________

Accepted Answer

A) True 
 B)False

Question 8

Identify the letter of the choice that best matches the phrase or definition.
-An Access feature available from the FIELDS tab that allows the user to add a group of related fields to a table at the same time.

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 9

All fields in a database should be contained in one table.
_________________________

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

____ is the default name for a new table in an Access database.

Accepted Answer

A) My table 
B) Table1 
C) ADB Table 
D) TableA

Question 12

When choosing field names,it is best to choose names that ____.

Accepted Answer

A) include both numbers and letters in the name 
B) use only uppercase characters 
C) describe the content or purpose of the field 
D) use only lowercase letters and no spaces

Question 13

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 14

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 15

It is important that data being imported from a text file into Access are separated by a character,such as a comma,which defines the text file as a(n)____ text file.

Accepted Answer

A) imported 
B) readable 
C) delimited 
D) external

Question 16

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

Accepted Answer

A) July 4, 2016 
B) 07/04/16 
C) 7/4/2016 
D) Jul/04/16

Question 17

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

Accepted Answer

The answer of One rule of ____________________ is that Access...

Question 18

Which data type would be the best logical data type for a field named PaidDate?

Accepted Answer

A) Currency 
B) Number 
C) Memo 
D) Date/Time

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

The data type that allows both sequential and random numbering is the ____ data type.

Accepted Answer

A) Number 
B) Currency 
C) AutoNumber 
D) Long Date

Exam 2: Building a Database and Defining Table Relationships

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

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

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n)keyboard shortcut._________________________

The default Field Size for the Short Text data type is ____________________ characters.

The way field values are stored,displayed,and processed in an Access database is determined by the ____________________.

Access automatically assigns the Number data type to all new fields. _________________________

Identify the letter of the choice that best matches the phrase or definition. -An Access feature available from the FIELDS tab that allows the user to add a group of related fields to a table at the same time.

All fields in a database should be contained in one table. _________________________

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

____ is the default name for a new table in an Access database.

When choosing field names,it is best to choose names that ____.

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.

It is important that data being imported from a text file into Access are separated by a character,such as a comma,which defines the text file as a(n) ____ text file.

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

Which data type would be the best logical data type for a field named PaidDate?

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

The data type that allows both sequential and random numbering is the ____ data type.