• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Using Information Technology to Develop a Restocking System for a Grocery Store.

Extracts from this document...


Using Information Technology to Develop a Restocking System for a Grocery Store. Background Over the years of retail, only one thing has become a main objective and that is to make the customer happy, ways of doing this is to have a fast service and make sure what the customer is looking for is available in the shop. My project will be to make restocking shelves in a grocery shop more efficient, and money saving process. This is chosen mainly because of the simplicity of the problem and many outcomes that can be achieved. A database is to be made because this project is about recording changes of the stock in a shop of which there is plenty of. Analysis of Current System The way that my client restocks shelves is to walk around the shop and look at all the shelves, and note down items which are low in numbers or which have totally run out. ...read more.


A. I want it to save me time and money. There are times when a certain item totally finishes, and because there are so many items in the shop I forget what was there on the shelf, I want the database to overcome that problem for me. Q. Are you computer literate? A. Only a little I do not know how to use programming packages or graphical packages, I do know how to work mainly all word processing packages I should have no major problems with Access. Q. Do you think there should be any restricted areas on the database? A. Possibly I may want to hold some customer's addresses, as they want deliveries, I may hold those addresses on the database, if I decide to, then yes I will need a password system to protect their personal information. Q. Therefore do you know about the data protection act? A. Yes, I will need to look into it more as I will need to abide by it. ...read more.


It works by the owner walking around the shop and looking at the shelves, the problem here is that there maybe some items in the wrong place. The database will overcome this by knowing how many items there were when it was bought from the cash and carry. When items that there are a lack of are come across they are noted in a book then the owner goes to the cash and carry. The database will eliminate this by providing a print out of items that have finished or will be finishing soon, this totally eliminates walking around the shop. An addition to the project will possibly to make the cash and carry receive an email from the database and so all the products are waiting to be paid for and taken away. The database should have simple theme to it, such as fill in the field about a certain topic, like name, price and quantity when bought. The target audience will be a slightly computer literate user but in case for a new user the database should be simple. ...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 Software 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 Software essays


    Validation needed for Address - 1st Line - - - - No Validation needed for Address - 2nd Line - - - - Medical Information Purpose Test Data Expected Result Actual Result Screenshots Validation required for Medical History = Yes or No When I enter in the fields I expect

  2. The aim of my project is to make the task of the allocation of ...

    The seating income area changed correctly, and showed the correct amount of people sitting in each area and how much they had to pay and their total. It will show clearly whether or not the show has been a success.

  1. A new IT system in a Dubai Marauders Rugby Football Club

    Making a new databse in Microsoft Access will do this. The Design View will be utilized to make the headings of the database. The following headings will be required to produce a comprehensive database: * First Name and Surname * Sex * Date of Birth * Street * Region *

  2. Database design for a games shop.

    * The system should have information about customers. * The system should have information about transactions. * The system should be able to recover information by entering * Customer's name. * The system should be able to show overdue games. * The system should have a printable list of people who have an overdue game.

  1. Hire Shop - creating a database.

    Once again the data can not be linked and by doing it this way it doesn't have a very professional approach. Specification I have decided that a relational database would be the best system for the musical hire shop. The reason why I have chosen to use a database is

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    and "Merit" columns, each with their own formula; to create a formula I selected "formula is" from the first box, this then allowed me to type my own formula. In each of these formulas I only wrote one condition, as I did not want the worksheet to become chaotic with

  1. Database analysis of 'a video lending library'.

    We can also do many calculations in the database. We can store as much as we want in the single database, we don't require much space to store this information, as all this information is stored in the computer by the click of a button, unlike the manual way in which, we need to put all the files, cards,

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    TASK C: Spreadsheet coursework page 1 C: Specification of Solution From the information I gathered I could now finally begin to design my system. I am hoping to produce a spreadsheet that will help, with the organisation of the computer shop.

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