Data Validation

By

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:

  1. Length Checks

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.

  1. Range Checks

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.

  1. Presence Checks

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.

  1. Character Checks (or Character Type Check)

This checks if data entered is a particular character type, for example it may check that a ‘name’ field has only letters.

  1. Check Digit

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.

  1. Hash Totals

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.

  1. Control Totals

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:

  • How data is checked for errors
  •  

  • Data Transfer in a Network
  •  

  • Modes of Data Transmission
  •  

  • Ways of retrieving data from unreadable CD/DVD’s
  •  

  • How to Remove the Windows Genuine Advantage Notifications
  •  

     

    Did you like this article?

     

    Please Share This Article:

    http://www.computer-realm.net/wp-content/plugins/sociofluid/images/digg_48.png http://www.computer-realm.net/wp-content/plugins/sociofluid/images/reddit_48.png http://www.computer-realm.net/wp-content/plugins/sociofluid/images/stumbleupon_48.png http://www.computer-realm.net/wp-content/plugins/sociofluid/images/delicious_48.png http://www.computer-realm.net/wp-content/plugins/sociofluid/images/technorati_48.png http://www.computer-realm.net/wp-content/plugins/sociofluid/images/google_48.png http://www.computer-realm.net/wp-content/plugins/sociofluid/images/facebook_48.png http://www.computer-realm.net/wp-content/plugins/sociofluid/images/twitter_48.png

      Subscribe for future updates for free by RSS or Email

    About The Author

    is a Software Developer and the main writer behind Computer Realm.

    5 Comments so far
    1. Pat May 10, 2008 6:27 am

      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

        luq reply on May 10th, 2008 11:53 am:

      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

    2. ebook store June 22, 2009 3:37 pm

      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

    3. ebook store June 22, 2009 3:39 pm

      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

    4. Patrica Jupiter January 11, 2011 1:06 am

      It had been some time since I visited website with such quality information. Thansk loads for the helpful information

      Reply

    Leave a Comment

    If you would like to make a comment, please fill out the form below.

    Any "names" that are keywords will be deleted.

    Name (required)

    Email (required)

    Website

    Comments

    Terms & Privacy | Copyright (c) 2012 Luqmaan Ameen, - WordPress Themes by DBT