Ask Question
28 July, 14:44

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

+5
Answers (1)
  1. 28 July, 15:33
    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?
Find 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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers