• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  • Level: GCSE
  • Subject: ICT
  • Word count: 7583

Create an IT system for my karate club.

Extracts from this document...

Introduction

1 Task Statement For my project I have decided to create a system for my karate club, which I attend. The karate club is in desperate need of an organised system, which will be able to organise the information of the students and also sort out the taking of their details. Competitions take place regularly and the instructor would like a list of the people taking part in each competition and a bill produced for each member so they pay their fees. For this project I have a real end user who happens to be the instructor at the karate club. Sub Tasks I have to firstly design my database and have to find which entities I have to add in and what tables I will need to set up. I will have to make sure that all the information my end user wants in my system is accessible. So I will also have to design queries so that there can be searches for particular data within the database without having to scroll through all the information available in every table in the database. I will also have to design reports for the queries as this makes them look more presentable and easier for the end user to understand and so the results are presented in a clearly way. So my end user can use the system a lot better without having to go through the back end of access I will have to create a front end which is known as the human computer interface. This will allow the user to simply click on buttons such as add a record and they will be able to do that instead of having to search through the system as this is time wasting and means the end user will have to learn how to use the whole of the system. In order to do this I will have to create the buttons in the form of macros and command buttons so the end user is able to use the database I design in this way. ...read more.

Middle

I will also use the lookup wizards provided in the software. I will use the lookup wizard in this table to assist me in anything and make things easier and clearer for the end user. For my second table, which is the parent's details, I am going to add the fields Title, Surname, First name, Work telephone number. I will add the work telephone number as their children's information is already added in the first table and has the home number, so is needs be the Sensei can contact them at work about anything. I will obviously format the table in a similar way too which I did before in the first table so that there is enough space to view all the details and that the text is readable, understandable and clear to see by anyone. I have taken into consideration that one of the people using this wears glasses, so I haven't made the text too fancy or too small. I will be using an input mask in this table to make sure the phone number is inputted correctly and does not exceed a specific length. I will also add in default values and make the time a short time e.g. 13:00 (meaning 1:00pm). The third table I will create is going to be a table called events. This will allow the end user to check which people are doing competitions and will also bring up their details. The third table is for people in the club taking part in the competitions this year (2003). The data will be displayed under the field names competition ID, Type, Time, and Date. I will use a lookup wizard for the field called 'type' as this means the type of competition they want to go in for. So I will create a drop down list with the options of sparring, routine and both. That way there will be a clear indication of who is doing what without the end user having to type in the options over and over again. ...read more.

Conclusion

value to show this: As my end user wants to search for specific details about members, I needed to set up queries to allow my system to be used by a person with limited IT capabilities, I set up four major queries within the system like so: When designing the query to find the members details I set it up as shown below: This is how it appears when the query is opened: This is how the tables are now linked: Forms To enable a novice to use the system I have created forms, which display the information clearly and allow the user to find the information required efficiently. This is how I set up the form: I created all my forms in the same way, yet, I had to create a main menu which creates a friendly user interface, this is how I created my main menu: Macro Buttons I added command buttons known as macros to each of my forms allowing my end user to just click a button and it will take him to the relevant information. This is how I set up my macro button to take you from the main menu to the member's details: Reports To show the details of my form and to show the members how much they owe for competitions, I created reports. I created two separate reports, one for the adult members of the club and one for the children. These display the results separately as in one member per page and look more organised. This is how I created my reports: This is the next stage and it allows you to group the data to make it more organised. The report is then created and then I customized them to make then look attractive and user friendly. When doing the report the results showed two copies of everything i.e. a persons surname appeared twice so to stop this from happening I had to change the setting "hide duplicates" to yes as shown below: ...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. This project is designed to help non-computerized library to easily keep track of their ...

    With this system it is difficult to differentiate between a member of the library or any one else * The files can be easily lost. Important paper might be considered as scrap and be disposed of. This would be very dangerous to the outlet.

  2. ICT PROJECT

    Enter cat To see how validation system reacts to erroneous data Data should not be accepted. User will be told to enter correct data As expected, warning message box appears Data entry form Test and data used Purpose for test Expected result Results after testing 11.

  1. System requirements analysis

    A02.31 Before computers and other electronic based methods were introduced in health centres, manual systems had to be used. This meant that the appointments, the doctor's details, the other employees' information, patient records, etc, had to be handwritten. Using a handwritten system was and still is very time consuming and just not suited for hospitals.

  2. Database design.

    form so I select this in the action I then have to select which for I want opened. I can also select the format in which the window is opened in. When I am finished I must save it as you can see I have saved it as Mcrvideo.

  1. Computing Project – Designing a Ticketing System for a Cinema.

    The system in use is not generally user friendly, the ability to undo mistakes is not taken into account. Objectives of the new system 3.1 General Objectives; * To create a more user-friendly interface. * To create a more appealing and eye-pleasing interface.

  2. Design and Produce a Monthly Account System For the Hazeldene Sub-Aqua Club.

    Information to Output Three different printouts of a database that shows the list of members in alphabetical order by surname. Those with outstanding medical inspections will be highlighted in the list. The first printout will be for the members' aged 40 and under, the second printout will be for those

  1. Introduction to information skills and system. An information system is a system that accepts ...

    system uses binary decimals to represent different characters. Each digit takes up memory of 1 bit; it takes 8 digits i.e. 8 bits i.e. 1byte to form a character. 1024bytes (210 bytes) = 1KB; 1024KB (220 bytes) = 1MB; 1024MB (230 bytes)

  2. Computer study project outline - library and book club database.

    2. It will allow students and teachers to see what their friends are reading or already read.

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