Case-Based Critical Thinking Questions 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 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

Jorge should use the criterion of "Yes" in the Perennial field to filter the herbs that are perennials. This will only show the entries that have "Yes" in the Perennial field.

Case-Based Critical Thinking Questions Jorge Has Created a Database for the Herb