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

Evaluation of design of a data capture sheet.

Extracts from this document...


For task one I was asked to design a data capture sheet for new customers to fill in with their information and to build a database for the Megavideo employees to fill in with the customer's details. I had to make an input mask for the telephone number, a validation rule for gender, set a default value for county and finally had to create a report of all the Megavideo members. The target audience for my data capture sheet was the new Megavideo customers as they would have to fill it in and the target audience for my database was the Megavideo employees as they would be using the database to search for detail, add new members ect. I had to make my data capture sheet easy to fill in as new customers would be using it and I had to make my database easy to use for the employee. ...read more.


This will validate the data going into the database using validation checks. It will ensure the data is the correct type, checking to see if the data is reasonable, sensible, appropriate and allowable. * Selecting a key field (eg. a membership number) so that each record can be uniquely identified. * Printing records, for example all members in alphabetical order grouped by membership type. * Coding data. By doing this I will take up less memory space. For example f=female m=male. Doing this will allowed quick entry. The advantages of using Microsoft Access are: * Takes up less space than a filing cabinet * Easier and quicker to search records than having to sort through a lot of records in a filing cabinet * Easier to edit data on screen than using tippex on paper * Easy and quick to edit the database The advantages of using Microsoft Word are: * Makes documents seem more professional as they are word processed. ...read more.


I did not because I could use features such as wordart, autoshapes and spell check on Microsoft Word. My chosen solution for the data capture sheet was effective as the information in it quite was clear and easy to read, as was the font. The information was also easy to read. I think that I could have improved how clear the information was in the data capture sheet as it was printed out in black and white but I had made it in colour, meaning it was quite hard to read. On the database, I think I could have improved it by putting the information in a more logical order. Doing so would have made it easier to fill in. If I could do this task again I would have put the information in the database in a different order to make it easier to use. I would also of changed the colours on the data capture sheet so it was easier to read. ...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. Database Design Guideline

    Fields Used Doctor ID, forename, surname, specialist and ward. Query Design - this is what the 8th query will look like in my Microsoft access database document: Field: Doctor ID Forename Surname Specialist Ward Tables: doctors doctors doctors doctor doctor Sort: Show: ? ? ? ? ? Criteria: "red" Or: o Query 9 Table Used Patient Query Criteria All

  2. Database design.

    Deleting a record To delete a record I placed a button on the forms as shown below When I click delete a record a message comes up and asks if you are sure you want to delete the record like so: To Delete a record click the delete record button.

  1. IT Project Evaluation. The design part of my wages system, data capture form, letterhead ...

    screen has the same headings as the information on the original paper copy. I will also check that the hyperlinks all work and link to the correct pages. Data Processing In order for the information that I have researched and collected from the sources named above to be inputted into

  2. Log Sheet

    * I didn't evaluate my progress after every iteration. * I hadn't put a sitemap to show how each page would be structured. * I evaluated my progress after the logo section. * I inserted a sitemap to show how each section would be structured.

  1. Critical evaluation of my design - MillionAir.

    Therefore, I can determine that my logo was effective for my company, as they require high quantities of paper stock, and as shown below, the logo does not utilize as much ink as a colour copy of the logo would.

  2. System design

    I want to allow the students to see the database but not able to change any of my inputs if possible. 7. Would you like to be able to feed back to the students? Yes, showing them graphs and weak points if this is possible.

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