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

    After the book has arrived librarian will calculate the total money and will cut the book from the stock list. The stock file and the Books Master File are updated. E.g. more barcodes of the book is written * There should be use of paper and pencils extensively and there should be vast amount of paper and pencils.

  2. ICT helping someone with special needs

    the computer and as he goes to any website then the computer and the Braille Notetaker will tell him and he buys clothes of the internet but the compute tell him all the details of the clothes and the looks and colour and sizes.

  1. Create a power point presentation for people who dont understand cricket so I can ...

    you to the previous slide No effect 17 Clicking on the background The title should appear Diamond 17 Clicking on the background The three websites from where I got the information should appear one by one Diamond 17 Clicking on the left button and clicking on the end presentation button

  2. System requirements analysis

    do and don't 02-10-06 Date of birth is not in correct format The date of birth is not understandable on the spreadsheet, digits appear Right click on cell and click on format cells, make sure that it is set to the date.

  1. System administration report

    discussing new ways of increasing profit and upgrading each department to enhance performance of the business such as the ICT additional needs of hardware and software. After thorough discussions of the different proposals between the departmental heads, the proposal will be sent to the manager who will review and then make a decision.

  2. Database design.

    You choose which fields you want to be in the form. Click next and the next window will appear. This window will ask what set up you want your form to be in I selected justified Basically this window asks you to select a background.

  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.

    Search a Book database will be able to do all the work that a library database should do plus 1. It will allow students and teachers to add books and also comment on the books that are already added. (Not necessary that the book should be in the library.) 2.

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