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","$$")

Question

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","$$")

Quizplus · Accepted Answer

The correct choice is C) Like "Jef??" because in Microsoft Access, the Like operator is used to find data that matches a specified pattern. Here, "Jef??" specifies a pattern where the names start with "Jef" and are followed by any two characters, effectively filtering names that are exactly 5 letters long.

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