Question 1

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

Accepted Answer

A)  Row Source 
B)  Limit to List 
C)  Allow Value List Edits 
D)  Display Control

Question 2

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2016 as: ____.

Accepted Answer

A)  09/06/2016 
B)  9/6/2016 
C)  9/6/16 
D)  09/06/16

Question 3

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber . _________________________

Accepted Answer

A) True 
 B)False

Question 4

Each field must be given an associated field description.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is NOT shown on a Relationship report?

Accepted Answer

A)  table names 
B)  field names 
C)  primary key field data values 
D)  one-to-many relationship lines

Question 8

The table that joins to other tables that have many-to-many relationship is called the ____ table.

Accepted Answer

A)  junction 
B)  linking 
C)  primary 
D)  relational

Question 9

Where do you modify field properties?

Accepted Answer

A)  In Table Layout View. 
B)  In Table Design View. 
C)  In Database Design View 
D)  As you are entering data in a form.

Question 10

The ____ property determines whether users can add or edit the list of items in a Lookup field.

Accepted Answer

A)  Row Source 
B)  Limit to List 
C)  Allow Value List Edits 
D)  Display Control

Question 11

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

Accepted Answer

The answer of The Row ____________________ Lookup property stores the...

Question 12

The . j p g file extension is short for JPEG , an acronym for the Joint Photographic Experts Group. _________________________

Accepted Answer

A) True 
 B)False

Question 13

In the accompanying figure, identify the "one" and "many" tables.  Identify the "parent" and "child" tables.

Accepted Answer

The answer of  In the accompanying figure, identify the...

Question 14

In the accompanying figure, explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Accepted Answer

The answer of  In the accompanying figure, explain why...

Question 15

Which of the following is NOT true about field properties?

Accepted Answer

A)  Modifying them helps ensure database accuracy. 
B)  Some are required, and some are optional. 
C)  They are the same for each data type. 
D)  They can be used to change the way data is displayed.

Question 16

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

Accepted Answer

The answer of The ____________________ property provides an easy-to-use visual...

Question 17

For a Date/Time field, use the Format property to display the date 1/17/2015 as January 17, 2015.

Accepted Answer

A) True 
 B)False

Question 18

In an Access relational database, to tie the information from one table to another, a(n) ____ must be common to each table.

Accepted Answer

A)  record 
B)  field 
C)  object 
D)  property

Question 19

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

Accepted Answer

A) True 
 B)False

Exam 5: Modifying the Database Structure

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2016 as: ____.

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber . _________________________

Each field must be given an associated field description.

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

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

Which of the following is NOT shown on a Relationship report?

The table that joins to other tables that have many-to-many relationship is called the ____ table.

Where do you modify field properties?

The ____ property determines whether users can add or edit the list of items in a Lookup field.

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

The . j p g file extension is short for JPEG , an acronym for the Joint Photographic Experts Group. _________________________

In the accompanying figure, identify the "one" and "many" tables. Identify the "parent" and "child" tables.

In the accompanying figure, explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Which of the following is NOT true about field properties?

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

For a Date/Time field, use the Format property to display the date 1/17/2015 as January 17, 2015.

In an Access relational database, to tie the information from one table to another, a(n) ____ must be common to each table.

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