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

    Select cancel button To check if macro works properly Should return to main menu As expected Enter Marks This will accept numbers between 1 and 100 only Test and data used Purpose for test Expected result Results after testing 26.

  2. This project is designed to help non-computerized library to easily keep track of their ...

    * Searching for particular item is very arduous. * Large amount of information can get lost * Incorrect entry is difficult to find. The reader's card placed in wrong issuing tray pocket. Some times the librarian puts the reader's card in the wrong issuing tray pocket.

  1. IT system for local video store.

    mistakes will occur as information such as taking out a video will not be put on the wrong members, as when taking out the video staff can clearly see the details of the member, he also stated that a password for taking out a film is no longer required and

  2. Creating an I.T. System for the Al Shabah Publishing Group

    Also to help use features such as input masks * Links to sub forms extra data relating to a specific record on the same screen * Allow the creation of macros to perform virtually any task * Forms can be preformed in pre determined styles and designed manually Limitation of

  1. Benefits of using my IT system in the Travel Agents.

    Create template letter I will open Microsoft word then I will type whatever a letter needs then I will insert lines/dots where all the personal information goes. The template letter was created successfully. The only change should be that it would be easier if there was screenshots or images and besides that it doesn't need any changes.

  2. Features of a sports club database. The system has at least 1 table and ...

    record A4 - Example of one of the validation 1 A simple tip for the user 2. & 3. Scripts to show all records and unsort records 4. Header and the title of the field, clicking on the header can sort the record according to the sort order.

  1. Database design.

    At the bottom there are two windows one called general and one called lookup, click lookup and this window will appear and you then click combo box. When you fill this in and save it you can go to your form and the table you entered, as a combo box

  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