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

    * Provide skillful workers for error free library system PROBLEMS * It is very much time consuming. Updating file during the lending of the book is very time consuming * Error may arise the librarian may put the book card in the wrong pocket of the issuing tray.

  2. a level ict project

    All links are marked with clear and concise descriptions so there is no confusion when choosing a button and links are easily comprehended. The switchboards also have a consistent layout to avoid confusion and make it easier for the user to recognise the menu and know what action to take,

  1. System requirements analysis

    one page to another and save appointments then I did not have to write out any of the codes for the macros. All I had to do was to go through the steps that I wanted the macro to take and all of the steps that I took were recorded and Microsoft Excel automatically coded the macro.

  2. Creating a computer system for a video rental shop

    This is better than fonts such as Algerian which although is fancy, is difficult to read. Forms Methods of Data Entry The user only needs to enter data into the database about the customer, parcel, destination and order. To make data entry easy I have written instructions for the user

  1. Database design.

    The line shows they are joined. Creating the forms To create the form you click new and this window will appear at this click form wizard and choose the table or query where the data comes from at the bottom of the window When you fill in the data's table or query this window will appear.

  2. Smarts Leisure Park Database Booking System

    To find the right booking or the bookings that the customer has made I will enter [Please Enter Date] in the criteria box of Date Field. Outputs My next output is to create a report about the customer details. I will design it and send it to the customer for conformation.

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

    previous slide No effect 4 Clicking on the background The heading should appear Split 4 Clicking on the background The titles of the rules should come up one by one Peek in 4 Clicking on the background The buttons should come up Fly in 4 Clicking on the left and

  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