• 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

    This shows that even one of the most trustworthy companies can't be trusted with their security. Summary of advantages * PS3 slim had a massive price drop, allowing the PS3 to be more available for a wider audience while Sony still made a profit due to how much cheaper the

  2. Creating a computer system for a video rental shop

    First name Text(50) Address Text (50) Town Text (50) DOB Date Phone Number Text(10) Customer Attribute name Comments Data type and length Validation Customer ID Automatically incremented Long Integer Unique Primary Key Title Combo box- Mr, Mrs or Miss Text (50)

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

    To convert decimal to hexadecimal or hexadecimal to decimal uses the same method as binary conversion, but 16 based. Eg converting 1980 into hexadecimal 1980 = 162 x 7 + 161 x 11 + 160 x 12 Therefore 1980 in hexadecimal is 7BC Eg converting 15FA into decimal 163 x

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

    phone for free so you don't need to be on a computer all the time. School Needs I can use e-mail to help me with my school work as I am able to send work-related files to myself and then access them at home and vice versa.

  1. My aim is to create a system to store on computer all the information ...

    need to be done to the current system. This will provide me with the opinion of the people who actually use the current system, and will show all the advantages/ disadvantages of the current system, and that of changing to a computerised system.

  2. Planning a system to handle school records.

    Software: Since a spreadsheet has been chosen as the most effective solution, which Spreadsheet package to use must now be considered. Lotus 1-2-3 is a popular spreadsheet program and would be quite suitable for Solving such a problem. Microsoft Excel (enterprise 2007) is the other latest alternative that I have.

  1. ICT Coursework (MarcoS)

    * In the cell D16 type in: =IF(L6="","",VLOOKUP(L6,Employers!B3:F6,2)) * In the cell D18 type in: =IF(L6="","",VLOOKUP(L6,Employers!B3:F6,3)) * In the cell D19 type in: =IF(L6="","",VLOOKUP(L6,Employers!B3:F6,4)) * In the cell E24 type in: =Order!C7 * In the cell E25 type in: =Order!F6 * In the cell E26 type in: =Order!F7 * In

  2. Database Coursework

    * Telephone number * Mobile number * Date of Birth * Address * Adding a DVD or game order to a customer * DVD and Game rental History 2) Managing DVDs and Games * Adding a new DVD * Edit details of the DVD or game * Price range *

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