• 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. GCSE Excel Project ICT

    AlienWARE Go to sheet1 select insert value '3' in D4 Pass Back Go to sheet 1 Pass Button123_Click Go to sheet 7 Pass Corsair1 Go to sheet1 select insert value '2' in D10 Pass Corsair2 Go to sheet1 select insert value '3' in D10 Pass Corsair512 Go to sheet1 select

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

    For everyday police Work it is vital for police officers to be able to access information on known Criminals. The information held includes , A personal description ,Last known address,Details of the offence committed , Methods used to carry out the offence ,Details of the arrest ,Previous convictions and prison sentences ,Known aliases ,Known accomplices.

  1. The Social, Moral and Cultural Effect of Introducing ICT to a system

    It has also changed and improved technology. Teleworking is when people work from home instead of travelling to work. From the office, or the leisure center, an internet link can be allowed to access and upload work as required. E-mail and messenger services can be used to send messages to other staff members or customers.

  2. ICT notes

    It may contain a company logo, search box etc Menu System This area provides navigation around the site Content Area The main content of the web page is here. It may contain, text, images, sound etc. Footer This area will often contain copyright notices, terms and conditions etc.

  1. AO4 ICT c/wk 2008-9

    However, companies release offers and promotions on a daily basis, so this problem is easily solved. Phone cards also work out to be cheaper sometimes as well. * Talking to someone is not always the same as a face-to-face meeting as this promotes a healthier conversation.

  2. Impact of ICT on the community

    Internet - Learn Direct Explanation of the Technology Learn direct is a program run by a company for the people aged over 16. It a service for people who wants to learn online and doesn't has time to go physically and study.

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

    These are the ways that I am going to chose between my employees which to hire and which to fire. Documentation There are two types of documentation: User Documentation and Technical Documentation. These two documentation depends on how experience the user is for example user documentation is used for beginners whereas technical documentation if for expert user.

  2. Hardware & Software Requirements for Database

    a lot of expense will go under one part of a computer. ==> A hard disk drive (HDD), commonly referred to as a hard drive or hard disk, this is a non-volatile storage device which stores digitally encoded data on rapidly rotating platters with magnetic surfaces or a non-renewable disk

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