Case-Based Critical Thinking Questions Case 3-2 Jorge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial. He needs to answer the following questions using his database.
Which plants need full sun?
Which plants are Perennials?
To create a datasheet that lists all herbs that are Perennials, Jorge will create a new query. The Perennial field has a data type of Yes/No. Which criterion should Jorge use in the query for the Perennial field?
A) Yes
B) No
C) check=yes
D) 'yes'

Question

Case-Based Critical Thinking Questions Case 3-2 Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial.  He needs to answer the following questions using his database.
Which plants need full sun?
Which plants are Perennials?
To create a datasheet that lists all herbs that are Perennials, Jorge will create a new query.  The Perennial field has a data type of Yes/No.  Which criterion should Jorge use in the query for the Perennial field?
A) Yes
B) >No
C) check=yes
D) 'yes'

Quizplus · Accepted Answer

A is the correct criterion as the data type for the Perennial field is Yes/No. By selecting "Yes" as the criterion, only the plants that are Perennials will be listed. B, C, and D are incorrect because they do not match the data type of the Perennial field.

Case-Based Critical Thinking Questions Case 3-2 Jorge Has Created a Database