• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

ICT A02b Validation and Verification

Extracts from this document...

Introduction

Validation and Verification! Validation: When you are entering data into a database, it is important that the data is as accurate as possible. Validation techniques can be used to try to reduce the number of errors in the data being entered. The validation is performed by the computer at the point when you enter data. It checks the data against the set of validation rules which you set up when developing your new database. Definition: Validation aims to make sure that data is sensible, reasonable and allowable. Validation can help to reduce the number of errors when entering data, it cannot stop them. Types of Validation: Type Check: Sometimes you only want data of a certain type entered into a field. ...read more.

Middle

Presence check: There might be an important piece of data that you want to make sure is always stored. For example, a school will always want to know an emergency contact number, a video rental store might always want to know a customer's address, a wedding dress shop might always want a record of the brides wedding date. A presence check makes sure that a vital field cannot be left blank, it must be filled in. Picture or format check: Some things are always entered in the same format. Think about postcode, it always has a letter, letter, number, number, letter and letter e.g. BB1 9PB. There may be the odd occasion where it differs slightly e.g. a Birmingham postcode B19 8WR, but the letters and numbers are still in the same order. ...read more.

Conclusion

If both match, it means the data was entered correctly. Verification: It was mentioned earlier that validation cannot make sure data that you enter is correct, it can only check that it is sensible, reasonable and allowable. However, it is important that the data in your database is as accurate as possible. Verification can be used to help make sure that the data in your database contains as few mistakes as possible. Definition: Verification means to check the data that you have entered against the original source data. It can be done in a number of ways: * Entering the data twice. * Checking the data on the screen against the original paper document. * Printing out a copy of the data and comparing the printout to the original paper document. How to create a validation?: ?? ?? ?? ?? ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. a level ict project

    Evidently, this objective has been accomplished in numerous respects. The new system uses advanced computer hardware whilst utilising the most current Microsoft office software, i.e. Microsoft Access 2003. The previous system took up an excessive amount of physical space when storing paper-based records and files, the new system eliminates this

  2. Creating a computer system for a video rental shop

    This form will be accessed from the Main Menu. There will be a button for return videos and a button to delete videos and a list box will be used to view details of videos already allocated. There will also be three subforms that will show data once the IDs of staff, customers and videos are entered.

  1. Different types of technology How I use ICT at home and at school

    It makes a very convenient and efficient program to use and saves a lot of time. How it affects my needs Advantages (How it meets my needs) The first and biggest advantage of MSN is its main feature-instant messaging.

  2. GCSE Database Project ICT

    Droplet size 3 Pl (minimum) with Variable-sized Droplet Technology Ink system Epson DURABrite(tm) Ultra Ink Print resolution Up to 5760 x 1440 optimised dpi on suitable media using RPM (Resolution Performance Management) Print speed Black text A4 Up to 37 ppm (Fastest), 25 ppm (Business quality)* Colour text A4 Up to 20 ppm (Fastest), 11 ppm (Business quality)* Photo 10x15 cm Approx.

  1. Data Validation and Verification

    Once I have got all his or hers details and allocated them a GP, I will check the data over again to confirm that its all correct. This will all be inserted directly into the system. When a patient calls over the phone I will use the same method of

  2. Main aims and functions of Buckingham Bingo.

    to do a stock check and then re-order if he has too. * The money is then totalled up and handed in to the cash office. Floor * This is where most of the money is made. This department is split into four sections which are; the cash desk; the

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work