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 wants to retrieve a record of books whose unit price is not between $30 and $60. Which of the following should Ali use in the Criteria box to retrieve a record that contains a value that is beyond the given range?
A)30; 60
B)= (30||60)
C)60
D)IN(30 && 60)

Question

Quizplus · Accepted Answer

Ali should use "60" in the Criteria box to retrieve records of books whose unit price is not between $30 and $60, as this would filter out the records with prices within the range.

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