Multiple Choice
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'
Correct Answer:

Verified
Correct Answer:
Verified
Q1: Which aggregate function supports the Yes/No field
Q3: A combination of database fields,constants,and operators that
Q27: Which view must be used to delete
Q35: The comparison operator,< >,is used to insert
Q36: Results of a query may be viewed
Q45: The process of rearranging records in a
Q66: The _ command removes the display of
Q70: Data may be sorted in a table
Q79: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9148/.jpg" alt=" In the accompanying
Q81: Identify the letter of the choice that