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
According to the Field Properties in Figure Case 5-1-2, to which field has Janise assigned an input mask?
A) ID
B) State
C) Zip
D) PrimaryPhone

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
According to the Field Properties in Figure Case 5-1-2, to which field has Janise assigned an input mask?
A) ID 
B) State 
C) Zip 
D) PrimaryPhone

Quizplus · Accepted Answer

Janise has assigned an input mask to the Zip field to ensure consistent and accurate data entry. The input mask restricts the user to entering only five digits, which is the correct format for a ZIP code. She has also set the field size to five, which reinforces this restriction. Additionally, she has set the Validation Rule for the field to "Is Not Null," which ensures that a ZIP code is entered for each customer record. There is no input mask assigned to the ID, State, or PrimaryPhone fields.