• 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

    insert value '1' in D10 Pass Divine Go to sheet1 select insert value '2' in D4 Pass FINALFINALFINAL Open backup, copy details, save, close, print, clear values in current document, return to sheet6, save and close Pass FirstNext Go to sheet 1 Pass GoToGC Go to sheet5 Pass GoToHDD Go

  2. ICT PROJECT

    Sheet 2-Enter Marks This system will contain list boxes, Vlookups and input boxes which will enable the user to choose each student personal details, enter assignment marks and maximum marks. The assignment and maximum marks will have an input box that will enable the user to enter the individual marks, which will be locate to a certain student.

  1. System requirements analysis

    The system also carries a number of different jobs for the receptionist to make her job a little bit easier as it uses combo boxes/drop down menus for information such as the time of the appointment, the patients full name and the doctor that they need to meet so that

  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.

  1. I will be analysing the problems defined by the management in the old system ...

    This backing up of data will ensure that there is no loss of important files. The printer is meant for producing hardcopies of the data. Some items such as reports are meant to be printed so the printer is capable of handling this job.

  2. Computing Project – Designing a Ticketing System for a Cinema.

    The system in use is not generally user friendly, the ability to undo mistakes is not taken into account. Objectives of the new system 3.1 General Objectives; * To create a more user-friendly interface. * To create a more appealing and eye-pleasing interface.

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

    rent the same movie at the same time and rentals will be rejected. This stops any overbooking rentals and prevents any unnecessary problems. The system will be much more efficient and faster than the old data storage systems as any details could be located in a matter of seconds rather than minutes.

  2. Business Requirement Analysis - On my paper, I will be discussing the analysis of ...

    What General Electric did to help overcome this misconception, they offered bonuses to anyone on the sales staff that helped the customers buy over the internet. They help make the staff understand how the internet can benefit them and the company as a whole and this calmed down the sales staff.

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