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 that all telephone numbers are entered in a consistent manner. An input mask is a predefined format that restricts the data entry to a specific pattern. In this case, the mask ensures that all phone numbers are entered in the format of (000) 000-0000.