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

I am going to write my project on my local hardware shop, which is called B & K; it is based down the street just from where I live.

Extracts from this document...


Introduction Background information I am going to write my project on my local hardware shop, which is called B & K; it is based down the street just from where I live. The shop provides a range of hardware goods such as household to gardening for the community in Nottingham. In terms of sales the shop is doing well apart from the current system, which is paper based. Some customers have big orders in this type of situation if there isn't enough stock in the shop then we have to order the stock, which the customer wants and tell them to come on a certain day so that when the stock arrives at the shop the customer can come and obtain stock or B & K hardware staff can deliver stock if a customer wants their goods to be delivered to their door step. The products sold at the shop are of a good quality and value for money The shop has been opened since 1990; it is very successful for its hardware goods service this is because of the quality of hardware products. The shop generally has customers from all around the areas of Nottingham. The shop is open 7 days a week from 9:00am through to 6.00pm. Most importantly the hardware shop provides: > Goods in shop > Stock deliveries to customers for large orders > Hires stock to such as wallpaper remover machine, etc to people, especially builders. The need for a new system has arose because of competition from another hardware shop that has opened a few streets away from B & K. the new hardware shop called 'Dale Hardware' has a computerised system. Since this hardware shop has opened with a computerised system, it has been running successfully because customers do not have to wait long to obtain a receipt, items can be look up straight away to see if they are in stock or not, etc. ...read more.


only selects data that is available Data Verification & Validation > Input masks will be used so that Mr Hartij Singh does not accidentally enter incorrect details into the system. Data Processing > It must also be able to compile reports Output Required The system must produce a list of people in a table that have placed a big order User Interface > The system must be easy to use and navigate through > The system must look professional Security > Password protection must be used > Password will be changed on regular basis to maximize security e.g. every 2 weeks Data Backup & Archiving There must be an archive feature in the system The system must be backed up on a regular basis End Users Training Needs I will introduce the end user to the new system. The end user has a good understanding of ICT and he has the skills to use the system, so he will not require a lot of training, although I will run over the system with and give him a user guide, so if he does get stuck, then hw can use the user guide to help him through. The proposed System Overview My new system would do the following: > Store Stock Details (Table) > Store Customer Details (Table) > Store Employee Details (Table) > Store Suppliers Details (Table) > Store Sale By Stock Item (Table) > Store Ordering stock by looking at product tables and quantities (Table) > Store Employee Pay System (Table) > Delete items more than 2 years old (Query) > Show stock which has a quantity greater than 5 (Query) > Show all stock which has a quantity less than 5 (Query) > Workout employee pay (Employee Pay System - Hours Worked) (Query) > Customer Search (Query) (Query based on a form) > Employee Search (Query) (Query based on a form) > Product Search (Query) (Query based on a form) > Show sales by stock item (Query) > Show total sales (Query) ...read more.


8) Would you like mail merges in your system? Yes I would like mail merges such as employee work absent letter and also a holiday/bonus mail merge has well so if I want to give a holiday or a bonus to an employee I will use the mail merge. 9) Would you like macros in your new system? Yes, but I am not sure where about in the new system. 10) Would you like formulas to calculate anything? There will be 1 part in my system which I would only let my employees to use, this will be to workout the payment a customer has to pay example if a customer has bought a tin of paint and some gardening equipment I would like the system to calculate the price for the gods and the total payment for customer to pay. I want my employees to use the new system to calculate goods payments from customers instead of doing them on the till this will be easy to use and efficient. 11) Would you like color schemes in your system? I would prefer color but not too much only highlight some parts in the system, which are important. 12) Other than you would there be anyone else using your system? Yes I will let my employees use the system. 13) Are you or another person who will use the system color blind? No 14) For security purposes would you like your system to be password protected? Yes I would like to have my system password protected and give permission to employees to access and open up the system to use as a till system on PCs in the hardware store. 15) Would you prefer your company/business logo? Yes I would, put my existing logo on the system if possible or something else suitable. 16) Would you like to keep a work attendance record for employees to find out who is coming to work more often and who is not? Yes if it is possible for you to create one for me. ...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. Marked by a teacher

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    so people know when to expect a bus to arrive and at exactly what minute of the hour How it fails to meet the community's needs A lot of times, you naturally assume that the bus will stop. However, if there is no one needing to be picked up or


    She is an average user, which means she does not understand most of the advanced features. Such as Vlookup, IF Statement, Macros, etc. Project Constraints Ms Gammon uses school standard PC that I will be using to calculate percentages and grades for the new system.

  1. Creating a computer system for a video rental shop

    Reports are produced for all reserved and overdue videos. Member details information The purpose of the system * Information about Members, videos, borrowing, borrowing line and reservation information will be stored in five separate files. * Allows entry of information via data entry screens about members, videos and borrowing or reserving * Allows the updating and the deletion of

  2. ICT Report 2b: ICT in Organisations

    Microsoft Excel Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet program written and distributed by Microsoft for computers using the Microsoft Windows operating system and for Apple Macintosh computers. It features an intuitive interface and capable calculation and graphing tools which, along with aggressive marketing, have made Excel one of the most popular microcomputer applications to date.

  1. GCSE Excel Project ICT

    The backup file, which is to be copied increases in size every time a customer saves, the file increase is approximately 200kb a time, I theory if 20 customers a day were to use it the file size will approximately be Security strategy (e.g.

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

    same thing but on Microsoft Publisher Troubleshooting * As stated in the instructions, you may receive an error message when trying to enter in data in some cells on the spreadsheet. This is because a validation rule has been set on the specific cell(s).

  1. Computer project Alevels

    PATIENT_ID Text Like "MCP####" Text you entered is invalid in the field PATIENT_ID. The entry must be 7 characters long. The first letter must be the letter M, the second letter must be C, and the third letter must be P followed by 4 numbers.

  2. I am now going to analyse my clients current system in order to get ...

    * They might not give an honest answer, as they may be ashamed by some of the things they do. * They may misinterpret the question. * They might think that the questionnaire is a waste of time and may rush through it giving incorrect and random answers.

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