Case 18-1 Emily, a professor, uses Microsoft Access 2016 to manage student information. She refines queries to display selected records and enters criteria using operators to filter the records and display required information.
To retrieve the details of all the students with an Age field value greater than 21 but less than or equal to 24, Emily should enter _____ in the Criteria row in the Age column in the design grid.
A)21 ||
B)Between 21 And 24
C)From 21 to 24
D)21 && 24

Question

Case 18-1 Emily, a professor, uses Microsoft Access 2016 to manage student information. She refines queries to display selected records and enters criteria using operators to filter the records and display required information.
To retrieve the details of all the students with an Age field value greater than 21 but less than or equal to 24, Emily should enter _____ in the Criteria row in the Age column in the design grid.
A)>21 ||
B)Between 21 And 24
C)From 21 to 24
D)21 && 24

Quizplus · Accepted Answer

The correct syntax in Access for defining a range of values is "Between...And...". Therefore, to retrieve records where the Age is greater than 21 but less than or equal to 24, the criteria "Between 21 And 24" should be used. This includes all numbers greater than 21 up to and including 24.

Case 18-1 Emily, a Professor, Uses Microsoft Access 2016 to Manage