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

question 57

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.
To retrieve details of all the products with a RetailPrice field value equal to $10 and an OfferPrice field value not equal to $8, Anna should enter:

• A)={10} in the Criteria row in the RetailPrice column and !={8} in the same Criteria row in the OfferPrice column.
• B)10 in the Criteria row in the RetailPrice column and 8 in a different Criteria row in the OfferPrice column.
• C)={10} in the Criteria row in the RetailPrice column and !={8} in a different Criteria row in the OfferPrice column.
• D)10 in the Criteria row in the RetailPrice column and 8 in the same Criteria row in the OfferPrice column.

---

Definitions:

NLRB

The National Labor Relations Board, an independent U.S. federal agency that protects employees' rights to organize and to determine their labor relations representatives.

Adjudicating Office

An official institution or body empowered to make legal judgments or decisions, often in the context of disputes.

General Counsel's Office

The department within an organization responsible for providing legal advice, handling lawsuits, and ensuring compliance with laws.

Exclusive Representation

A labor union's sole authority to represent and negotiate on behalf of all employees in a designated group or workplace, regardless of union membership.