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

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

    All this helps in many ways. For example, when my computer encountered a problem which involved a message saying 'BOOTMGR is missing', I could use my PS3 to find out what exactly I had to do, which involved burning my own Windows Recovery Disk and using it on my computer.


    The system is in part updated as list-boxes are updated when a change is made to the student list. This was recognized during the Testing stage. The system will be able to correct mistakes that she might make during marking, this will make the system to be more neatly presented and pleasant.

  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. ICT Report 2b: ICT in Organisations

    Additionally, nearly all barcode readers currently produced contain decoder circuitry analyzing the barcode's image data provided by the photo conductor and sending the barcode's content to the scanner's output port. Boots' handheld barcode readers are housed in a handheld form factor.

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

    a mix of local official, knowledgeable individuals, members of impacted community regional officials, academic social officials academic social scientists.etc. - Can provide a broad analytical perspective on potential growth impacts - Can be used to reach consensus among groups hostile to each other Disadvantages * Judgements are those of a

  2. GCSE Excel Project ICT

    Written explanation of initial designs. Sheet6 The cell range C4:J6 will be merged into one cell, as will D7:K9 and C15:L20. This has been done to enable that the text "Custom Computer Parts � By WarlordTF � Click 'Next' TO Start Your Order" will be fitted in with this font

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