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

Construction of a Membership Table

Extracts from this document...


Design Proposed Solution Computerised V Manual? The current system that Project use is a manual system and it has proved inefficient, and very easy to lose. Therefore, I propose a computerised database system. Package V Programming Solution For ease, and speed of use, I propose to use the package option. I choose this because the options for everything the database needs are already there, and rather than waste time trying to find a way to make these options in my own programming solution, I will save much time and effort using the package MS ACCESS 97. Also, my programming skills are next to nothing. The Package: Advantages: * Easier to learn as very little programming is involved * The tools for creating the user interface are already available, built into the program which makes construction of the database far quicker. Disadvantages * Depending on the package, this option could be far more difficult, due to problems such as a lack of flexibility, lack of options etc. The self-programmed solution Advantages: * Program will be specific - all options can be created so that it will do exactly what it needs to do. ...read more.


This is down to insurance reasons. Helmets, however, are not the most fashionable piece of clothing you could ever wear, and many members try to find a way out of getting out of wearing them. Therefore, careful attention must be paid when taking down members' details to make sure that the data is checked against any valid form of identification I.D. number: This is automatically created by the database as a key field. This has a default value of 000, but will increase in value for each new member. Name: This can be checked against any forms of identification, e.g. bus passes, library cards, national insurance cards (if applicable) Date of birth: There is an obvious mistake if someone gives a birth date making them out to be 102. However, minor mistakes, such as a year or two out, can be checked against the DOB's on bus passes, national insurance cards etc. The format will also have to be correct, as it is being entered in the format DD/MM/YY. ...read more.


Name of product supplied: Not only does Project have a large list of suppliers, each supplier also has a list of products supplied to Project. This means that there is a lot of data to do with stock needing to be entered correctly. Again, the only way to do this is visually - making sure there is no mistake when entering in the data. Item number: Every product has a different item number. This insures the "uniqueness" of each product, so that the stock system knows exactly what product is sold. Type of product: Project doesn't just sell skateboards. They sell shoes, clothes, accessories, hardware, safety gear and more. Rather than have to check in the storeroom what a product is, the database can simply tell them. This must have the type entered correctly. The only chance of a typo occurring in this is if I make a mistake during the implementation. The data in this field is selected from a drop-down list. Price of product: If the price is wrong, customers will be over/under charged. This will not be good for Project. If they undercharge, they lose money. If they overcharge, they lose customers. Therefore it is greatly important that the price is entered correctly. ...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


    User Form 2 The user Form will appear when the Add New Student macro is triggered. The form will have spaces to enter the student personal details. The gender and form will be combo boxes. The combo boxes on the user form will make it easier for the user to enter information.

  2. Computer project Alevels

    You can also create a table by clicking on "Create table by using wizard". Here you can follow the wizard and create the table. Or else you can "Create table by entering data", here the data can automatically added to a table that has been already created by the system.

  1. GCSE Database Project ICT

    2. On the same design, the user wanted the two buttons entitled 'Go to appointments Table' and 'Got to Treatment Table', To be removed as they would be incorporated within the other two forms. 3. There was an issue to the title of the form as the initial 'Menu' was updated to 'NSDAP Menu'.

  2. ICT Project 1A

    And here is how it appeared on my Website. Tokio hotel are very famous in their homeland and many of their singles have reached number 1 in Germany and the surrounding countries. But they have broken into England too! So far they have released 3 singles in English, 2 of them getting into the top 100 in the UK!

  1. Evaluation of a membership card design

    field * There must be a command button linking back to the main page. I have met this by putting a back button on all of my forms so that by pressing this button, it will allow the user to go back to the main page.

  2. System requirements analysis

    For example a doctor can only view their patient's history but not another doctor's patient's history. The important files such as patient history and salary are password protected to enter and view and only the receptionist can view them. Research The aim of this research is to compare what inputs are needed in a medical centre and a travel agency.

  1. a level ict project

    Moreover, the numerous repetitive manual operations does strain the morale of the employees because performing the same task repeatedly is boring since it carries little variation. As a result workers become demoralised and more prone to making mistakes whilst performing task in garage.

  2. ICT car insurance quotation System Coursework

    dealer manager has asked me to make the best professional looking system I possibly can. Will any logos be used? Answer: The Vauxhall Logo and their slogan ("Customers for life") will be imprinted onto each processed output, from the system.

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