• 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...

Introduction

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.

Middle

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.

Conclusion

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.

    This can be found at the left-hand side of the screen. This is my customers data entry form to fill it in you must use the next customer ID which is 3 digits long then fill in the customers surname it will automatically start with a capital letter because there is an input mask in.

  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

    4. How would you sum up your IT skills? Fairly Poor 5. In your view what do you feel are wrong with how you keep the data at the moment? Difficult to keep up with the current scheme, not organised. Time consuming. 6. Do you need any data protection against certain people seeing what is on the database?

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