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?
?
?
After creating the query, Jorge must set criteria to have the query return only those plants that need full sun. Entries for the Amount of Sun field include: partial sun, little sun, and full sun. How should Jorge enter the criteria for the exact match of full sun?
A. =>full sun
B. <=fullsun
C. <> full sun
D. "full sun"
Answer: D
You might also like to view...
Information stored on a hard drive consists of programs and data. The proportion of data storage space to program storage space is 10:1. If the total storage space is 22 megabytes, how much will be allocated to programs and how much to data?
Let p= space for programs in MB Let d= space for data in MB Proportion of data to programs is d I p= 10 / 1 Total space for both data and programs is 22 MB Express data in terms of total and program space: Then: (22 —p) I p = 10 / 1 (22 —p)=10p 22 = 10p + 1p 22 = 1 1p p=22/11 p=2 MB d= 22 —p Find data: d= 22 —p d=20 MB
An Update query can only update (change) values in one field at a time.
Answer the following statement true (T) or false (F)
The YEAR function would return ________ on the value December 27, 2025.
Fill in the blank(s) with the appropriate word(s).
A range of cells containing results based on manipulating the variables.
What will be an ideal response?