• 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

    WarlordtfGC5TB Nvidia500 WarlordtfGC900 Nvidia600 WarlordtfRAM10 Seagate1 WarlordtfRAM5 Seagate100 WarlordtfRAM5TB Seagate150 WarlordTFSP Create buttons Link to macros Create Final Page Check Test Save Close Test plan of up to 10 tests and expected results Macro Name Expected Result Predicted Result Aixam Go to sheet1 select insert value '1' in D4 Pass

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

    use, and as there are no booking systems, or show times, it is not very complicated. * If the system has been uploaded to the Internet, * Type in the address bar; www.BigMCinemas.com * This will take the user to the home page, * Follow the links to either, the Latest film review page or the Ticket prices page.

  1. a level ict project

    Now the table is in second normal form, as no column that is not part of the primary key is dependant on only part of the primary key. 3rd Normal Form After the reviewing the current table the vehicle name and customer name aren't dependant on the Job ID.

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

    her job being on the computer, it is very easy for her to procrastinate * She has to use a special keyboard to actually even be able to type properly, making typing quite a tedious task * Can be quite confusing to use Conclusion The computer is what allows Sarah to maintain a job.

  1. System requirements analysis

    The system that is used in the hospital does a number of things that make it more effective and easy to use as well as less time consuming. The system has a fairly big memory system to store number of things such as each patient's personal details such as their full name, age, birthday, as well as their medical history.

  2. Creating a computer system for a video rental shop

    * Processes - are operations performed on the data. In the following diagram there are five processes each named P1, P2 ...etc. * Data Stores - are logical stores for data, which are not physical in the following data, flow table they are labelled D1 and D2.

  1. Database design.

    top of the page as follows: After you click this button, this window will appear and you must link the fields to the others by clicking on the field name and dragging it to another table. When I drag a field across and unclick in a different table this window

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

    built a new computer system that will be compatible to run Windows Xp since this has good firewall and Norton Anti Security Suite which will be needed to scan for viruses block hackers and Trojans, since this is the first system being built I will not be putting in a

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