Case 18-2 Ali, a Librarian, Uses Microsoft Access 2016 to Maintain

question 14

Multiple Choice

Case 18-2 Ali, a librarian, uses Microsoft Access 2016 to maintain information about the books in his library. He retrieves details about the books and authors and filters selected records using queries.
Ali retrieves a list of the authors whose names start with the letters "Jef." He wants to filter this result by including names that have only 5 letters. Which of the following should Ali use to retrieve the names that follow both criteria?

• A)="Jef**"
• B)>="Jef.."
• C)Like "Jef??"
• D)In ("Jef","$$")

---

Definitions:

Computerized Optical Scanning Equipment

Technology devices used for electronically converting images of text, handwriting, or printed documents into machine-encoded text or images.

Perpetual Systems

Inventory management systems that continuously update the record of inventory levels with each sale or purchase, providing real-time information.

Inventory Purchases

Transactions made by a business to acquire goods intended for sale during the normal course of operations.

Cost of Goods Sold

Direct costs attributable to the production of the goods sold by a company, including the cost of materials and labor.