• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 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

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.

Middle

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.

Conclusion

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)

    This allows you to plan a safe, fast journey with no obstacles delaying you. This helps people to be punctual on their journey. The site also allows you to log on and view your information. Using this, you can check the money on your Oyster Card and top it up using a credit card.

  2. ICT PROJECT

    * The system should be able to produce average performance percentage of each student for her class. * It should have the ability to Edit and Delete students' details if required, thorough the use of data forms.

  1. GCSE Calculator Project

    colour of the buttons could be better to make it clearer * Overall they found it a lot more useful than the Microsoft Calculator If I were to do this project again I would find a new and better way to design the buttons.

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

  1. ICT Report 2b: ICT in Organisations

    The me mory is stored as digitally encoded data. Typical data capacity is between 10 and 40GB. However, in the Boots R&D Department, their computers have a minimum of 60GB memory in their hard drives. It is essential that Boots have a large memory capacity as the research they put

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

    Step 4 explains how to change the validation rules if they do not meet the criteria of some of your employees. * On Step 7, you may have a problem with the Microsoft Word document not being properly linked to the spreadsheet with your data in.

  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