To perform a range test on the hours worked data field in an Access database that requires the entry to be at least 0 and no more than 40, you should express this requirement as:
A)At least 0; Not more than 40
B)0

Question

To perform a range test on the hours worked data field in an Access database that requires the entry to be at least 0 and no more than 40, you should express this requirement as:
A)At least 0; Not more than 40
B)0<= X <= 40
C)Between 0 And 40
D)none of these

Quizplus · Accepted Answer

The correct expression to perform a range test in Access for a field to be at least 0 and no more than 40 is "Between 0 And 40". This syntax is specific to SQL and Access queries, allowing for the specification of a range that includes both boundary values.

To Perform a Range Test on the Hours Worked Data