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

    Oyster cards are small and can be lost quite easily. They also cost quite a bit to replace and take up to a week for a new one to arrive. This can put a halt to travelling plans or force you to spend extra on buying tickets.

  2. GCSE Excel Project ICT

    Range("D14").Select End Sub This macro changes the value in D13 to the number 1 which changes the values of the VLOOKUPS which reference from it to the data on the row marked with the '1' and the column referenced would be displayed.

  1. Produce a net cash flow for an Italian restaurant called The Pizza Palace.

    �3500 August - �2500 September - �3000 -->Wages - �2500 per month -->Loan repayments - �300 per month -->Rent - �250 per month -->Quarterly Bills :- Gas and Electricity - �500 for May and �400 for August :- Business Rates - �400 for June and �400 for September -->Local advertising - �2000 in May 2c)

  2. Video Rental Shop I.T. System


  1. a level ict project

    having a search bar or being able to ask the database queries. * On average Victor and his employees have minimal IT literacy skills, as a result the complexity of the database has to be limited, since they are the ones who have to analyse problems and repair faults if the system has troubles.

  2. Spreadsheet Project - computer system for a video hire shop.

    The expenditure and overheads of the business are collated in another book. These figures are calculated at the end of each month. The figure varies each month as the company does have unforeseen expenses which vary from month to month, such as new shelving, removal of graffiti etc.

  1. Creating a computer system for a video rental shop

    Also it does not have a palm rest. * 128MB SDRAM this may not be enough memory for some applications the leisure centre may use. Software: Office XP which includes word excel, access and PowerPoint. Member requirements Purpose of process The purpose of the process is to record all information

  2. System requirements analysis

    They are also very good according to costs as they are much cheaper than LCD's. The disadvantage of using a CRT monitors are that they consume a lot of space and they are also quite heavy. CRTs are not as bright s LCD's and are not as sharp.

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