• 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

  1. Database design for a games shop.

    you intend to find Run query Prompt appears 12 Overdue rentals sourced, correct overdue rentals information Open and check report Report should open with compulsory information 13 Button on menu open the correct sub menu Press button Correct menu opened 14 Customer details form runs customer search query and information

  2. Information and Communical technology

    This is because you can design the form to look anyway you want. * Include an icon to enable user to delete the customer * Produce a mail merge letter What are the different ways this problem could be solved?

  1. Powerpoint review project

    Data from graphs and charts will be added using excel and using the Insert > Chart button on the menu. Text information will be inputted by copying and pasting anything needed from the internet into the presentation then laying it out neatly to make it presentable.

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

    Use of formulae and macros in my database. 7. Do error corrections. 8. Make it easy for Mr. Hussaini to make any updates and searches for any information he needs to find in the database. 9. To make forms for the customers. 10. To create queries. 11. To create reports.

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

    Error messages when impossible data is typed e.g. an item is sold when the company has no more of that item left in stock. The spreadsheet itself is divided and split into many columns and sections. This section will for example include, a Description of Item column, Price, Trade Price, Profit or Loss and Validation checks like, Restock checks and validation checks, to check the quantity.


    ID Auto number Title Text Surname Text Other names Text Gender Text = Male or Female Date of Birth Date/Time Table 2 Records Validation Validation Key ID Auto number Address - 1st Line Text Address - 2nd Line Text Surname Text Table 3 Records Validation Validation Key ID Auto number

  1. Library system

    Data size Why is this data important Book ID Auto number Number Up to 100, 000 Each book has to have its own unique number to identify it in the database. Book title Text Text Up to 100 Each book must have a name in order for you to save time looking.

  2. The growth of the computer industry in business

    This brings to light the main advantage of word processing on a computer: The ability to save your work and come back to it later. An acronym for "What You See Is What You Get", WYSIWYG is a feature that lets you see the final version of an item on screen.

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