Case Based Critical Thinking Questions Case 5-1

question 39

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

---

Definitions:

Alcohol Spray

A sanitizer product typically containing a significant percentage of alcohol used to kill germs and bacteria on surfaces.

Wilcoxon Signed Rank Test

An alternative to the paired t-test, this test is utilized to determine whether two paired samples come from the same distribution when the normal distribution assumption is not met.

Significance Level

A threshold chosen by the researcher in hypothesis testing that determines the probability of rejecting the null hypothesis when it is true.

Diet

The sum of the food consumed by an individual or organism, which can be tailored for health, cultural, or weight management reasons.