Tina, a teacher, uses Microsoft Access 2016 to manage student information. To retrieve the details of all the students who have a TotalScore field value of greater than 70 but less than or equal to 85, she should enter the condition _____ in the Criteria row in the TotalScore field.
A)70 ||
B)70 && 85
C)From 70 to 85
D)Between 70 And 85

Question

Tina, a teacher, uses Microsoft Access 2016 to manage student information. To retrieve the details of all the students who have a TotalScore field value of greater than 70 but less than or equal to 85, she should enter the condition _____ in the Criteria row in the TotalScore field. ​
A)>70 ||
B)70 && 85
C)From 70 to 85
D)Between 70 And 85

Quizplus · Accepted Answer

The correct syntax in Microsoft Access for specifying a range of values is "Between [lower value] And [higher value]". Therefore, to retrieve records where the TotalScore is greater than 70 but less than or equal to 85, the condition should be "Between 70 And 85".

Tina, a Teacher, Uses Microsoft Access 2016 to Manage Student