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

    So the member and the librarian have to face difficulty. * There is a lot of paper used. This increases the expenses of the company. * At the present system any one can come in side the library and intelligently steal a book when the library is opened.

  2. ICT PROJECT

    updated chart showing by gender As expected, I have showed the chart below. 19. Select summary chart by form button To check if macro works correctly Should go and refresh chart showing by form As expected 20. Select summary chart for all student To check if macro works correctly Should

  1. System requirements analysis

    - The receptionist will need to create something that wil store the patients records and also the appointments. - He/She will need to have the name, address, doctor, d.o.b, date of the app. - If there is a new patient the receptionist will need to make give them a paper based form.

  2. Database design.

    Creating a macro To create a macro you go to macros and this window will open up. It is blank now but when you fill in the actions you want the macro to carry out it will be complete. As you can see I want my macro to open a

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

    The text output displayed on the monitor is sometimes hard to recognise; it is all in one font that is fairly narrow. The output onto the monitor can also be an eyestrain. The system makes use of only three colours; black, white and blue, not very appealing atall.

  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.

    To encourage students to read more. 9. To help them find people with similar book interest. PLANNING- Choosing the idea (Topic Planning)- Before choosing this topic I thought of making a database on a book club but after few days an idea struck me why not make a database

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