• 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. Windows vs. Linux

    The ability to give the user enough control but to limit the damaging possibilities of what their actions can do. Linux is particularly good at giving the user control, the customizable qualities available in the OS enables the user to edit his/her interface at their own discretion.

  2. ICT PROJECT

    The user will never have access to this sheet. When the user select the chart that she requires the pivot table on the sheet will change to represent that choice. I will record macros sorting the pivot into three ways.

  1. ICT Report 2b: ICT in Organisations

    A major concern and disadvantage with these systems is when false alarms occur. A false alarm is when the alarms go off when a person passes through the gate without having stolen any merchandise. This most often is due to tags on merchandise not being properly deactivated.

  2. 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

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

    * It is easier to make changes to your document. You can move, change, delete, save, and format all your ideas in one handy file. * It frees you to express ideas more clearly and to let your thoughts flow because anything can be changed or deleted later.

  2. Database design.

    in alphabetical order or by numeric order. Click next and the following window will appear. This window will ask you what style you would like for your report and it also gives you a preview of the style, select one and click next. This window asks you to choose the layout of your report, if you want it in landscape or in portrait view.

  1. Database Analysis and Database Design Project - DVD library for moving images.

    will be store in to the system until the DVD has been return. REQUIREMENTS OF THE NEW SYSTEM Moving images is a DVD shop (to rent DVDs), as we been informed the company is growing and so are the numbers of DVDs and the number of customers which means the staff need access to this information faster than before.

  2. Bin-IT User Guide. The software on this CD provides a system to make ...

    In the event that this occurs, click 'Select a different list'. From this use Explorer to find the spreadsheet file in the location you saved it, select it and then choose Sheet 1. Glossary Mail merge - Mail merge is a software function describing the production of multiple (and potentially large numbers of)

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