Case 18-3
Anna, the manager of a general store, uses Microsoft Access 2016 to maintain product information. She uses multiple criteria to retrieve specific details about products. She combines two or more conditions to filter the records based on her requirement.
Anna types Like "a*" in the Criteria row in the ProductName column and 25 in the same Criteria row in the RetailPrice column. In this case, the query datasheet, created by Anna, will include the records for products witha ProductName field value that:
A. ?begins with "a" or a RetailPrice field value not equal to 25.
B. ?ends with "a" or a RetailPrice field value equal to 25.
C. ?ends with "a" and a RetailPrice field value not equal to 25.
D. ?begins with "a" and a RetailPrice field equal to 25.
Answer: D
You might also like to view...
Identify a difference between raw data and information
Criminal cases have more stringent evidence-gathering requirements because ________________
a. Only civil cases fall under constitutional guidelines. b. Criminal cases are generally handled by Federal judges. c. The Constitution protects the rights of citizens being tried in criminal proceedings. d. Civil cases do not involve jail time or possible capital punishment. e. They don't. Civil cases have the most stringent requirements.
Autoglobals are associative arrays whose elements are referred to with a(n) ____ key instead of an index number.
A. numeric B. alphanumeric C. symbolic D. alphabetic
?You create a Sway by adding text and media content into a Storyline selection, or
Fill in the blank(s) with the appropriate word(s).