Case 18-3 Anna, the Manager of a General Store, Uses

question 64

Multiple Choice

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 with a 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.

---

Definitions:

Nonconforming Goods

Items delivered under a sale contract that fail to match the quality, specification, or conditions as agreed upon by the buyer and seller.

Notice

In legal terms, notice refers to the formal communication of information or a fact to an individual or entity, ensuring they are aware of certain conditions or changes.

Perfect Tender Rule

A principle in commercial law that allows buyers to reject goods if they do not meet all contract specifications, regardless of how minor the defect may be.

Material Breach

A substantial breach of a significant term or terms of a contract that excuses the nonbreaching party from further performance under the contract and gives the nonbreaching party the right to recover damages.