Question

A range check that can be used in Microsoft access to calculate the data collected which is date and time

Answer 1

A range check is often used when a person works with data consisting of numbers, dates and times, or currency, ensuring that a number is within a specific range.

Explanation:

• Range checks allow a person to set suitable boundaries.
• In microsoft (example) : Accept letters (a - z) only : Is Null OR Not Like "*[!a-z]*" : Any character outside the range A to Z is rejected. (Case insensitive.)
• An example of a range check is checking to see if the value of a 16-bit integer is within the capacity of a 16-bit integer. When a range check is performed, upper and lower boundaries are specified.
• Range check is a validation check which can be applied to numeric fields. This is done to ensure that only numbers within a certain domain can be entered into a field. Remember that this does not necessarily mean that the data entered will be correct. But it will certainly lie within reasonable limits.
• A method of validation which checks that data falls between an upper and lower acceptable value.