• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 4762

Task 2 - Access Database - ICT CW

Extracts from this document...


Task 2 - Access Database Specification Organisation The business that I am looking at is CM Electrical. The most important aim of the business is to provide good quality lighting at cheap prices. The company is operating in a very competitive market where it is constantly competing with other lighting companies and stores such Selfridges. Current System The firm at the moment is using a very basic system using a variety of databases, this is a problem because the data is not all on one system and this causes problems wasting value time for workers. The system is not very helpful as it not easy to use and take time to understand. The system holds information of the stock that the company has and the prices of each item and where they are within the building. At the moment the current system is back up every week on storage disk, CM electrical use a grandfather father son method. There is no real form of security; an id is required which is made up from any two letters. They work 8.30am to 6pm Mon- Fri and Saturday 9 am - 5.30 pm and in this time they use the system regularly. Users They users of the system are all the staff that currently work at CM electrical, these include all the administration whom have the responsibility of keeping the system and insuring all the information regarding accounts is up to date. The other users are the end users these are the staff that use the system to look up information regarding stock and customers. Problems The problem with the system is that it very basic and is time consuming for the employees to use, the employees find it hard to keep track of stock levels and the fact that the system is not updates as regular as it should often the database is out of date. ...read more.


There are cameras already fitted in the offices for security reasons, this will also look after the computers and allow surveillance of the area. This will make is very hard for people to be able to steal property of the company. The company will have to install a anti virus software, this is very important as this will prevent any viruses from destroying important information on the computer each computer will have to have there own separate method of checking for viruses. Analysis An interview was carried out with the owner of Cm electrical, this was done to try and suggest intentions for the new systems. The company at the moment is using a paper based filing system which they feel is preventing them from going forward and they know want to implement this new system and make it computerised compared to there current manual system. At the moment the staff have to search record by looking through large filing cabinets this is very time consuming and it can lead to files being misplaced or destroyed, the firms has a lot of information and data which they have they have collected over the years they have been open, there is a lot of paper work with in the office are invoices credit notes delivery notes and these all need to be sorted out. There are new customer everyday who wish to take out an account with the company, the company has take their details and record them and create a folder for them and their invoices. They're several ways for the system to be implemented: Manuel System: This is the system they are currently using, so this I not really an option because this is what the company feel it wants to move away from toward a computerised method. It is can be very easy to make mistakes so it time consuming and can be run poorly by human error. ...read more.


It now may allow the company to push on and become more efficient and speed up the business. The company know has many more options within the company in terms of their filing and organisation they can re-structure their system around the software to make there jobs easier and hassle free. Economic Implications The new ICT system should save the company money in the long run by saving money on expenditure such filing cabinets and paper. The initial cost will be high with the set up cost and implementation and then the training of the staff to be able to use the software. This should all be worthwhile in the long run when it saves the company money. Moral implications There will be very few if any jobs that are lost as many staff will be re-trained for use with the new system. Social Implications Unemployment was the major factor in terms of social implications, the problem here would that the introduction of computer in to this company may lead to the loss of jobs with in the company to some employees. However in CM electrical there are few jobs if any that would be lost with the introduction of computers in the work place. It is more likely to create jobs such as systems administrator, he would be in charge of the whole ICT system and he would be important if the system is big enough to need one. The company has not made anyone redundant and instead has created new jobs with system admin and another full time worker to use the system. Alterations The alteration I would make would to the design of the system, I would make it more aesthetically pleasing for the users. Also the actual sophistication of the design could be enhanced to improve the systems. Also the relationship between other application or options could be better. Dev-Inder Bhambra 1 ICT Task ...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. Hardware & Software Requirements for Database

    RAM is called "random access" because any storage location can be accessed directly and the word "random" refers to the fact that any piece of data can be returned quickly, and in a constant time, regardless of its physical location and whether or not it is related to the previous piece of data.

  2. Different types of technology How I use ICT at home and at school

    But then, the PS3's extremely useful ability to buy another external hard-drive for it solves this problem completely. The PS3 is compatible with various external hard drives meaning I have the potential to get as much space as I want.

  1. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    input mask, first click on this then you type in the following (00/00/0000;0;;) Using input mask (post code etc.) The way you use this is by first you go on Microsoft Access then you go on your information that you created from before and you right click, after you have


    Graph and charts should be generated quickly and easily to compare boys and girls performance, All student and by form. 8. It should automatically use colour code for student grades. It should be able to add and delete/ edit students if required.

  1. Health and Safety Issues in ICT

    Comfort Users should be comfortably positioned, with easy access to all equipment. Whilst sitting, it is essential that the user can adjust their position in relation to the equipment as appropriate. Users should take frequent short breaks from computer work.

  2. This project is designed to help non-computerized library to easily keep track of their ...

    Publisher Name Authors Name Purchase Price Edition # Subject Stock Level Date of Purchase Pages Shop Name Shelf # ISSUE FORM: used when ever the member borrows a book Member ID Book ID Date of issue Due date RETURN QUERY SUB FORM First Name Last Name Date of Issue Due

  1. The use of ict has changed the way in which people work. Explain the ...

    Pneumatics are not as powerful as the hydraulic robots but the movements are much faster. Electric motors-The most common type of electric motor used in controlling the movement of robots is a stepper motor. These motors rotate an exact amount for each pulse of electricity sent to the motor and provide very precise movements for the robot.

  2. ICT Report 2b: ICT in Organisations

    each branch was to have touch screen systems on the shop floor. Perhaps Trackball mice could be used; where a ball is housed in a socket contained sensors to detect rotation of the ball about two axes. Although this solution would reduce pricing, it would significantly slow down command selection,

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