• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  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...


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.


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.


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


    These are by gender, Form -by-form and Year group attained (all students). The chart will be created on sheet 5 for whichever setting is on the pivot table. Sheet 5-Pivot chart This chart will be connected to the pivot table A.

  2. ICT Report 2b: ICT in Organisations

    In some older systems electronic devices have been known to set off alarms. False alarms are embarrassing not only for honest customers who accidentally set off an alarm, but for the business as well - who now have an upset customer on their hands.

  1. Write up an Analysis for an ICT solution for an organisation that has a ...

    This might reduce the number of regular customers since is poor customer service. Outline of task to solve - solutions The two problems defined in the last section are my tasks to solve. Since the week to week lists of the items used are hand written, not legible, contain errors

  2. I will design a new video database for the video shop that will also ...

    Recommendations for Development The first thing to decide is what software is required to make and run the database. The main two choices are: Word Advantages: If you are skilled in the use of a computer word processor, you can appreciate its many advantages.

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

    to send any number of files but it has to be done all separately, this is very time consuming as I have to upload each individual file into an attachment and then I have to download each file onto the computer when I get home .

  2. Database design.

    This window will appear where you can change the layout, add in a title and buttons. Creating A Report To create a report to need to go to reports and new, this window will appear highlight report wizard then choose the table you want to create a report for.

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