• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 3020

the driving school would like a system to be put in place on the head office computer that is able to store all the information about the members and instructors

Extracts from this document...

Introduction

Dorking Driving School Geoffrey Golding established Dorking Driving School in 1928. When Geoffrey established the school he had been a driving instructor for thirty-six years. When Geoffrey passed away in early 2000, his wife, Gloria, took charge of the business. Since the driving school was established it has blossomed into a very well known school and has a good reputation. The school has nineteen full-time, five part-time instructors and only one office staff at the current time. The number of members varies at different times of the year, but most of the instructors are busy for the majority of the time. However, students that join the school are entered into the database and remain there for 12 months after they have finished their lessons, presuming that they passed their test. The receptionist, Sarah Davis, is responsible for entering the new customers into the database and arranging which instructors will be assigned to teach the lessons, as well as dealing with the other paperwork. It is the main driving school in the county of Surrey. As a result of the schools position and reputation in the area it is a very profitable company. The school has a test center that is attached to the main driving school, so when the customers have finished their lessons they can just go straight for the test. This makes it a quick and easy process for them. The problem The Dorking Driving School, despite its past success, is having a few problems. One problem is that the school is encountering is that sometimes they have students that are due to have driving lessons, but no instructor to teach them because the planning of distributing the instructors has not been done accurately enough. Other problems that the school encounters often is that they have a lot of trouble keeping track of their members and instructors and in the event of double booking, however, this does not often happen as Sarah can see if the required slot is already taken. ...read more.

Middle

6. The member tells Sarah and she looks in the lesson and test book and finds the particular test. 7. She confirms with the member that they want cancel the test and erases the booking. 8. That particular test now becomes available for other members to book a test. 9. The call between Sarah and the member is ended. 10. Sarah gets up from the desk and walks over to the shelf on the other side of the room and places the lesson and test book back on the shelf. 11. Sarah walks back to her desk to continue with her previous work. Resources available * Software available The main type of software that the school need on their head office computer is a database application system. They need a piece of software like Microsoft Access because it is very good for solving the problems, such as, you can create relationships between tables, filters, and store and search a huge amount of data. The driving school needs these qualities from their system in order to store details about their customers, instructors and lessons and practice tests. Relationships between tables is very important because when a member books a lesson, and Sarah enters their surname, it should appear with the appropriate details needed about the member on the form for booking a lesson. Filters are needed in the event of when an instructor needs his lesson timetable printed out, Sarah can just filter through all lessons that the particular instructor is going to teach and then print them out. In order to solve the problems that the driving school are experiencing at the moment the new database needs to store a lot of data, for example, the details of all members and instructors, lesson and test timetable, etc. The Windows XP home edition will provide the required services demanded by the school. * Hardware available Dorking Driving School will need a new computer and basic printer in order to run this system. ...read more.

Conclusion

on input form to activate: Macro (mReturnToMain) to take user back to main menu. Add a new instructor to the database This process can be started by selecting the option add new instructor from the main menu screen (switchboard). Button (bAddInstructor) on main menu to activate: Macro (mAddInstructor) to open input form. Form (fAddInstructor) for data to be entered through from source document (possibly a membership application form). Table (Instructors) on which the form is based and where data will be added. Button (bReturnToMain) on input form to activate: Macro (mReturnToMain) to take user back to main menu. View the lesson and test timetable This process can be started by selecting the option view lesson and test timetable from the main menu screen (switchboard). Button (bLessonTestTimetable) on main menu to activate: Macro (mLessonTestTimetable) to open input form. Form (fLessonTestTimetable) for data to be entered through from source document (possibly a membership application form). Table (LessonTestTimetable) on which the form is based and where data will be added. Button (bReturnToMain) on input form to activate: Macro (mReturnToMain) to take user back to main menu. Book a lesson This process can be started by selecting the option book a lesson from the main menu screen (switchboard). Button (bBookLesson) on main menu to activate: Macro (mBookLesson) to open input form. Form (fBookLesson) for data to be entered through from source document (possibly a membership application form). Table (Lessons) on which the form is based and where data will be added. Button (bReturnToMain) on input form to activate: Macro (mReturnToMain) to take user back to main menu. Book a Practice Test This process can be started by selecting the option book a practice test from the main menu screen (switchboard). Button (bBookPracticeTest) on main menu to activate: Macro (mBookPracticeTest) to open input form. Form (fBookPracticeTest) for data to be entered through from source document (possibly a membership application form). Table (PracticeTests) on which the form is based and where data will be added. Button (bReturnToMain) on input form to activate: Macro (mReturnToMain) to take user back to main menu. Alex Chown 1 Dorking Driving School coursework ...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. Different types of technology How I use ICT at home and at school

    two wires * Controllers are easily rechargeable and still as fully playable when recharging * Quite silent compared to other consoles due to a much more efficient cooling fan Summary of disadvantages * Although having a massive price drop, still the most expensive out of all its competitors * Games

  2. Creating a computer system for a video rental shop

    Key Date Rented Date/Time Date of Return Date/Time Cost of Rental Currency Design of Input Forms Four Data Input Forms are needed * Customers * Staff * Videos * Rentals Customers Form This will be needed to input and update the Members of Video World.

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

    book which indicates that it is a book of this library * When a member wants to borrow a book he takes out the book card from the pocket of the book he manually writes his name, the issuing date and his ID number.

  2. Use of IT in schools

    In 2000, state schools in this country spent �21m on phone bills and/or line rental charges due to use of the Internet. For some of the schools, this is draining their budget, and they have to limit the amount that the Internet is used in their schools.

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

    Eg 255 have 8 digits in binary but only 2 in hexadecimal. It is used for large value numbers such as in the case of html colour panels. Hexadecimals are 16 digit based; 10 - 15 is replaced with A - F respectively.

  2. This report I will be writing, will be on the way I do activities ...

    The use of e-mail and IM, socially, means hassles like friends arriving at place too early or late can be avoided because we can tell each quickly and simply through this technology. Evaluate Social Needs E-mail and IM meets my needs for social uses very well because I am able

  1. Database Coursework

    Refer to test number 5 for extra proof. Editing customers within 2 minutes: the new system should be able to edit the person's record. The time may vary depending on how many things are going to be changed, but at the most, it would take 2 minutes.

  2. Planning a system to handle school records.

    * The system should automatically calculate the cumulative marks, percentage and graph of individual student in every subject, * The system should allow user to gain accurate result in calculation. * The user should able to enter all the data and easily view it.

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