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

IT GCSE Project 1: Validation

Extracts from this document...


Validation In Order to make my system much more successful. I shall implement validation checks on my dental practise database system. Compulsory Fields The fields with this check makes sure that a patient or member of staff has filled in the necessary information, if the field is not filled in they will receive an error message telling them to input the important information. But this type of validation check does not check for mistake made by the staff/patient therefore this will result in contacting them to give the correct information. I have evidence that this checks for compulsory information. This Evidence shows you that I have not filled in the last name resulting in an error message saying "Field 'LastName' must be filled in". I have applied this check too: LastName, FirstName, Emergency No, Post Code, and House No. I thought it was appropriate to apply this check into these fields because these are the most vital parts of the information needed. This will help to prevent certain errors like making them unable to input anymore information until they fill in the field and will also give us the minimum information to allow us to contact either the staff of patient in order to get the correct information. ...read more.


Check Fields This checks each field for a unique number for example: if you want it so a specific field can only use from numbers 1-100 you would use this check to make this possible. Here is evidence to show that this check works. I applied this check to the following fields: "Patient ID" and set it from 1 to 99. I also applied this check to "Dentist ID" and "Appointment No." For "Dentist ID" I set it from 100 to 200, and for "Appointment No." I set it from 1000 to 9999. the reason I thought it was appropriate to add this check to theses fields is because for "Appointment No." I put a big range because there won't be a limit of how many appointments the dental practice can have but there will always be a limit of how many dentists and how many patients there will be. This check will help to prevent errors. For example, if the person filling the data in was for a patient record and they added a wrong value in that was used in another table such as Dentist or Appointment. ...read more.


to get all of the details from that record and it will be added into the patient link value list automatically same with the dentist link field. The evidence for the dentist and patient link is here. These are the fields from the appointment table when you insert the patient link number from the value list the other details are filled in automatically. This is the part of the record from the patient table this has to be filled out manually but the data is used in other parts to make the database easier to use. The errors this would help to prevent are that it would make it much easier for the person to pick the Name Title just in-case there is a spelling error. It would also help the person making the appointment because they can gather the patient/dentist information into the appointment record without inputting all the information again. The evidence is given in images above. This is not fool proof there is still some errors that can occur because you do not have to use the value list it is just there to help you can still make spelling errors in the field. ?? ?? ?? ?? ...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


    It will have 8 options. These are to add new student, enter marks, create report summary, edit or delete student, chart summaries, create parent report, edit grade boundary and exit. The worksheet would not be opened manually; in its place the macros would be programmed to open the sheet automatically.

  2. Computer project Alevels

    1800 MHz CPU(Central Processing Unit) Reason - Fast loading of programs. Fewer computer crashes. At present people are used to computers with a processor more than 2500 MHz, but in the proposed Medi Care Hospital system it doesn't need much speed because it uses simple application which are being used in daily life.

  1. GCSE Database Project ICT

    to be sent out to remind patients who have not booked for 5 to 6 months prior. The user needs the patients Telephone Number, ID, reminder date, Time, Title, Past Treatment Description, Forename, Surname, Address (Town and Postcode) and to print out a report to enable the user to 'tick´┐Ż off the people who have re-booked.

  2. Database project

    7 7 22/03/2006 06/04/2006 Yes 8 8 8 22/03/2006 06/04/2006 Yes 9 9 14 22/03/2006 06/04/2006 Yes 10 10 10 22/03/2006 06/04/2006 Yes 11 11 12 22/03/2006 06/04/2006 Yes 12 12 11 22/03/2006 06/04/2006 Yes 13 13 6 22/03/2006 06/04/2006 Yes 14 14 13 22/03/2006 06/04/2006 Yes 15 15 1

  1. ICT Project 1A

    Their second single, "Schrei" ("Scream"), climbed to the #5 position in the German charts. Their debut album, Schrei, was released on 19 September 2005; the album later received a platinum certification [4]. All songs were written by hired song writers, but Bill Kaulitz, the band's singer, brought in some ideas.


    Do you have any additional questions? End User Requirement Statement of user requirements Mr Shah feels a computerized system will solve some of her current problems as she thinks she has some knowledge about Excel. She feels I will be able to create an effective, fast, and easy to use automated system to calculate her student's

  1. GCSE Calculator Project

    Perform the basic arithmetic functions (of add, multiply, subtract and divide). 2. The font size should be big for people with peer eye sight. 3. The difference between the foreground and background colour should make it easy for the user to read.

  2. GCSE Book DataBase Project

    It is quicker to input information about books, staff, students, and the students' form. Making the database can be time consuming on the computer, as it takes longer to input all the students and books names. The computer is very quick when you're looking to find a particular book.

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