Multiple Choice
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
The State field in Figure Case 5-1-1 illustrates which of the following?
A) an Autofilter
B) a conditional value
C) a lookup field
D) an input mask
Correct Answer:

Verified
Correct Answer:
Verified
Q13: Which of the following pattern match selection
Q16: A _ query uses functions,such as Sum
Q18: An input mask may be created for
Q26: The _ comparison operator is used to
Q42: To avoid the display of a security
Q46: In an input mask,the letter _ indicates
Q51: When creating an input mask, the _
Q54: The Top Values query property allows the
Q62: A standard language used in querying,updating,and managing
Q67: A value of true will be returned