• 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

    For example 'Doctors ID' witch will be common in both tables in my database. Then on one of the two tables I will have to click on the 'Doctor's ID' and drag it to the other table where it says Doctor's ID and, then I can find any other relationship if so between the two tables.

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

  1. Database design.

    I think a table will give the advantages and disadvantages: Advantages Disadvantages Organised. If the employee is not computer familiar they will need trained. Easy to search for a record. Expensive to get installed. When printing it, it will be professional looking.

  2. Database design for a farmers herd book.

    All things aren't entities - only those about which information should be captured. Information about an entity is captured in the form of attributes and/or relationships. If something is a candidate for being an entity and it has no attributes or relationships, it isn't an entity.

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

    Data collection All of my data will be obtained from either the internet or text book sources so that it will be relatively reliable. I intend to collect it by searching for key terms either in a web browser such as Google, or in the index of hard copies of books, such as textbooks, encyclopaedias and newspapers.

  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.

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