Ask Question
30 June, 17:29

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

+5
Answers (1)
  1. 30 June, 18:42
    0
    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.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “A range check that can be used in Microsoft access to calculate the data collected which is date and time ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers