• 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
  36. 36
    36
  37. 37
    37
  • Level: GCSE
  • Subject: ICT
  • Word count: 4700

Creating a system - I will be solving a number of problems about the allocation of men to jobs. Currently jobs are written onto a white board and then the vehicles and the men's names are written on it.

Extracts from this document...

Introduction

Analysis Problem Statement Edes Removals UK Ltd is a commercial relocation company based in Wallington. It is a company that supplies specialised vehicles and labour to other companies. There is a large labour force made from full-time, part-time and contracted workers. As the business continues to grow and change the resources needed to operate the work involved must change with it. Due to the large and increasing workforce employees are becoming confused about where they should be going and what they need to do. I will be solving a number of problems about the allocation of men to jobs. Currently jobs are written onto a white board and then the vehicles and the men's names are written on it. This is very repetitive and takes a long time to do. This system works well but implementing a new database system will make the business run smoothly and more efficiently. Bob Piggott the operations manager believes that the use of a computer database system will make the employees more competent as they will be aware of what they are needed to do. There is confusion for the men as some are sent to the wrong jobs. This causes a loss of time, as there may not be enough men to complete a job. This causes problems for the customer, as some important jobs will take longer than necessary. If this continues the firms reputation will suffer. I will make a database that will show availability of suitable men for work, create timesheets for men, create invoices for customers charging them for the men they have used and create job sheets that will tell the men what job they are on and details of what to do. This database will save time and men will be informed of what job they are on more efficiently and clearly so no confusion occurs. To find out what the end user will need I have developed a questionnaire. ...read more.

Middle

I will ensure I abide by the data protection act laws by placing a password on the system so data cannot be deleted, making tables read only so they cannot be altered and design a handbook for employees so they know how to abide by the laws. Final Choice I intend to solve the current problems by creating a database in MS Access 2000. I will use Access as I will be able to produce forms and queries and I can sort information efficiently, unlike MS Excel and MS Word. By using Access I can meet the objectives I set for the system. I can meet the quantitative objectives by making a relational database, this means it will be a quick and easy task of finding information. The hardware that I am going to use is a, 15 inch monitor, keyboard, 233 MHz-processor, 64MB ram, 9GB hard disk, scanner, mouse, floppy and CD Rom drives and a laser jet printer. I am going to use this because it is available at home, college and at Edes. This means I can work on the project at all of these places. In the database there will be the option of using queries to find what customers are in need of the service that Edes supplies and what men are available. I will also use forms and reports to make job sheets for the men. This will make the job of the Transport Managers at Edes much easier because they will not have to manually produce everything. As customers book a job their name, contact details, date of job and what will be involved will be recorded. On the morning of the jobs worksheets will be printed off and given to the men. They will show the men what job they are on, where to go and what needs to be done. The computer system at Edes is linked over a network which means all employees at Edes will have access to the database. ...read more.

Conclusion

I have drawn up rough designs of the forms that can be used in my system. These designs will help me in the implementation stage. I have kept the design of the forms similar and consistent so the user will not be confused when looking at different forms. Employees Detail Form This form will show all the employees and their personal details. All new employees can be recorded through this form. Customer Detail Form This is a simple form that allows the user to check the customer details and also add new customers. Job Sheet Form Job Detail Form (job sheet sub form) This is a simple form that will be linked with the job sheet. Menu Design To make this project user friendly I need to make the navigation through the system clear and simple. The majority of employees at the firm have basic ICT skills and limited knowledge of computers. I want the system to be easy to find forms and reports, add new information and print the needed information. I have designed a main menu, which will create links to the forms, reports and queries in the system. To do this I will use the switchboard feature as it allows me to quickly and easily create a menu system for the whole database. Main Menu The background colour of the main menu will be army style green to match the company's colours. Form Menu Report Menu Reports The main output for my project will be from reports. I will discuss the use of reports with the end user, as I believe reports are a better out put then forms. Reports are made to be printed on A4 whereas forms are a different shape and do not print clearly due to coloured designs. Edes Removals UK Ltd DATABASE SYSTEM DESIGN APPROVAL SHEET Bob Piggott, If the design meets the requirements and the objectives set then please sign below in order for me to continue to the implementation stage of the project. Signed www.advanced-ict.info Table design: FIELD NAME DATA TYPE DESCRIPTION/VALUE Table Entities e.g. ...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. GCSE Excel Project ICT

    However there is an immediate problem, as it is covered by the button the user is not able to input the value, however the idea of the scheme is that the user will not input the value but the buttons (attached to macros)

  2. Design an advertisement or a web site for the cinema. Your advertisement or web ...

    This is an incredibly simple user documentation, but as the system is so simple to use, this is all that is required. If a booking system were incorporated, the user documentation would become more complex. Evaluation - The benefits of the system The benefits of the system I have developed

  1. a level ict project

    Work Plan * The view should be set as Form * The window mode shall be set as Normal Macro design to open the form of Employees: * Macro Action is to be OpenForm * The form name to select is Employees * The view should be set as Form

  2. System requirements analysis

    the nurse only needs to use the mouse to enter these vital pieces of information and the chances of her making a human error such as spelling or having a poor handwriting are instantly solved. The only piece of typing that the receptionist has to make is to enter in

  1. Creating a computer system for a video rental shop

    This will help to prevent data entry errors or syntax errors and acts as a form of validation. Safety Back up recommendations To insure the safety of the database I would suggest daily back ups are made so that if the system for some reason looses its integrity, the company will have a recent back up to fall back on.

  2. The impact of ICT on a person with special/particular needs

    She can find help where previously hard to find more to her needs. The word prediction eliminates the slow speed usually associated with something like this. Once Sarah gets used to it, the word prediction uses an algorithm to calculate most used and most associated words with certain combos of

  1. Creating a computer system.

    and when they click the OK button, their details will be copied into the invoice. The designer will also need a form to add a product to invoice. On this form the customer will choose a product from a drop down list, and then click the quantity that he/she want.

  2. Smarts Leisure Park Database Booking System

    Data Dictionary Field Name Data Type Comments/Notes ActivityCode Text (L10) Primary Key ActivityName Text (L12) R Venue Text (L10) Validated List Gym, Pitch. R Instructor Text (L10) Day Text (L10)

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