Case Based Critical Thinking Questions Case 5-1
Janise is creating a database to keep track of her customers for her pet sitting business. She is in the process of creating the Customer table. She would like to design the table so that data entry is as consistent and accurate as possible. Using the figures below, determine which Access features Janise used to ensure consistent and accurate data entry.

Figure Case 5-1-1

Figure Case 5-1-2
To ensure that all telephone numbers are entered in a consistent manner, Janise assigned a(n) ____ to the PrimaryPhone field as illustrated in Figure Case 5-1-2.
A) lookup field
B) input mask
C) data type
D) propagation property

Question

Case Based Critical Thinking Questions Case 5-1
Janise is creating a database to keep track of her customers for her pet sitting business. She is in the process of creating the Customer table. She would like to design the table so that data entry is as consistent and accurate as possible. Using the figures below, determine which Access features Janise used to ensure consistent and accurate data entry.

Figure Case 5-1-1

Figure Case 5-1-2
To ensure that all telephone numbers are entered in a consistent manner, Janise assigned a(n) ____ to the PrimaryPhone field as illustrated in Figure Case 5-1-2.
A) lookup field 
B) input mask 
C) data type 
D) propagation property

Quizplus · Accepted Answer

Janise used an input mask to ensure consistent entry of telephone numbers in the PrimaryPhone field. The input mask is illustrated in Figure Case 5-1-2, and ensures that all phone numbers are entered in the format of (999) 999-9999.