
All data entered into a system is validated. Data validation is performed by a computer program. There are a variety of validation methods used on data to ensure accurate entry of data. Let’s look at some of the validation methods used:
In this validation technique, data entered is checked to make sure it is a particular length, for example 4 characters, if it’s greater or less than 4 characters it is detected as an error.
Here data is checked to lie within a specified range as in if integers (numerical values) were entered a range of 10 – 1000 may be specified in which case all entered data must be in between 10 & 1000.
This is a simple check performed to check if data has been entered into a field, it makes sure required fields are not left blank.
This checks if data entered is a particular character type, for example it may check that a ‘name’ field has only letters.
A check digit is a single digit generated from a complete number, for example an ISBN contains a check digit, the last digit of the ISBN is a check digit. It is calculated using the rest of the numbers in the ISBN, when checked, the check digit is recalculated, if it produces a different value an error has occurred during data transmission or entry.
Hash totals are meaningless totals calculated using a series of entered records, for example if you find the totals of all the record numbers of a collection of records it is a meaningless total. It could be used as a hash total to validate the records.
This is similar to a hash total except the total is a meaningful one, i.e. instead of totaling record numbers you might total the salaries of the employees in an employee database, this total provides some meaning and it can be used to validate data.
Well the above are some of the checks made when you enter data. So the next time you register for a service online remember most of these checks and maybe even a few more are made on each of the fields you fill in!
People who read this post also read:
Did you like this article?
Please Share This Article:
If you would like to make a comment, please fill out the form below.
Any "names" that are keywords will be deleted.
Hi,
Once a data validation has been done and errors found, how does one correct them?
Links to relevant sites or articles would be mush appreciated
Thank you
Reply
the computer program which validates the data detects the errors and prevents the entered data being processed and requests the user to enter correct values for the incorrect data notifying the user of the errors, the user then corrects the errors and enters the data into the system, hope that helps, thanks for the comment!
Reply
I’m trying to make a chart for a project, and it keeps popping up. I have tried to do what the help icon tells me to do (highlight area, go to data validation, and click “clear all”) but it still won’t go away. What am I doing wrong?
.-= ebook store´s last blog ..Hello world! =-.
Reply
My boss wants for me to try to figure out a way to have the drop down list on a separate page so you don’t have to look at it on the main page. Is there a way to do this?
.-= ebook store´s last blog ..Hello world! =-.
Reply
It had been some time since I visited website with such quality information. Thansk loads for the helpful information
Reply