• 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
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  • Level: GCSE
  • Subject: ICT
  • Word count: 1952

Designing a database to manage stock in a clothes shop.

Extracts from this document...


IdentifY 1.1 The problem and how I discovered it I discovered the problem when I saw that the files of customer orders were unorganized and customer were angry for late stock arrivals. I also noticed that some of the buyers or consumers were taking this product although it was outdated. 1.2 The Business This business is of a big company which is located in Jandia in Fuerteventura in the south of the Island. I was doing a survey on the shops as a consumer when I discovered that some of the products were from previous seasons and old. I told the manager about the problem they asked me for help. 1.3 The real User The manager is the in charge of dealing with these types of problems. Although in this case Ms.Sara, the manager is not able to find the solution to this problem. In this case I have decided to help her and to provide a better service to the customer. 1.4 The current problem and inefficient The current main problem is that the manager or the employees aren't getting to know when the clothes are outdated or is from old seasons. I'm being asked to create or to find some kind of solution to solve this major problem. There are many problems with the method that the employees are using now which is to go around and looking at other people's clothes and see the fashion. ...read more.


2.3 Data input Data Type Collection Input Validation Photographs image Memory card or camera roll USB Google images Bar-code Information Product Bar-code reader 8 digits Supplier address Text Phone directory Keyboard Phone or address directory Product info. Text Supplier Keyboard Supplier 2.4 Data processing fffggg 2.5 Back up and security As the Document we are doing is very important we must always remember to save it, this could save us a lot of typing because if there is a power cut documents won't get erased. We should remember to save our document every 5-10 minutes, also we need to save it when we change or insert something manually. You should save it on your PC's desktop or in 'My Documents' also it would be intelligent to save documents on two other or external hard disks or send it to your own e-mail. The size of the file depends on the type, for example if it is done in access,word or PowerPoint, it would also effect the size of the document if there is fancy colored writing, outstanding writing or lots of pictures. Normally a word document of 10 -12 pages with three to four colored pictures would weigh 294 KB (302.026 bytes), this means you would be able to save three thousand more files like this on a one gigabyte pen drive. Yes, I will set up passwords to my document incase a hacker or spammer brakes in and steals my data, this way I will be sure to have a unique solution to the problem. ...read more.


This would also be an invalid test. Screenshot n� 2 Test number 3- This test result is invalid because the wrong currency was inserted and therefore that dialogue box appeared. Screenshot n�3 Test Number 5- This test has been accomplished because it has a valid result. Screenshot n�4 Test number 7- Update supplier name, Valid test as the result is positive. Screenshot n�5 Test number 13- Update employee name- Invalid result as a dialogue box appears saying that the test is too long. Screenshot n�6 Test number 17- Add new ticket- Valid test as every field is created properly. Test number 12- Update change field- Valid test result as all the requirements are accomplished without any problems. Screenshot n� 7 Test number 9- Update supplier name- Invalid result as no more characters can be introduced Screenshot n� 8 Test number 19- Update supplier ID- Invalid test result as a dialogue appears asking to enter a new value. Objectives Completed *Create main menu for easy navigation through the queries *Create a Report to show products bought taken. *Create a Database with queries to manage orders more quickly. * Add buttons and make sure they work so that we can see the forms easily and briefly. * Include dates sold and bought *Add supplier name, address and ID Not completed * Also include an image of the item * Create a new table for every order and name it after the customer. ?? ?? ?? ?? Rishi Wadhwani 10b Access Coursework 1 ...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. Creating a computer system for a video rental shop

    E.g. if you wanted to change the format of the customer data entry forms on a computer it could be done in a few minutes but manually on a non computerised system it would take a very long time to rewrite the records if they were held on card.

  2. I will design a new video database for the video shop that will also ...

    * Many web developers feel that FrontPage creates "messy" HTML, especially when using its more advanced features, and may rearrange existing code. This should not be a problem if you use FrontPage to do all of your web page editing, but it may be an annoyance if you also wish to edit the HTML directly.

  1. ICT Coursework (MarcoS)

    In the cell C19 type in: =C17+C5 * For the macros named with the months, when you are recording, for example "January", first copy the cell C7 that is next to Marketing, and then paste special, select values in the new window that appear, in the cell C18 in the

  2. Ict Powerpoint Coursework

    Microsoft Office - PowerPoint For PowerPoint there are many advantages including; you can insert clip art , videos , sound clips , movies etc ... Also you can make a slide show automatic so there will be less hassle and most things would be at ease.

  1. Database Coursework

    There are two types of monitors: - LCD monitors and CRT monitors. When using a LCD Monitor, there are many advantages. Apart from looking much better than CRT monitors, they are also much less space consuming. They are not as wide as the CRT monitors, so this makes it possible for the computer to be used in almost any place.

  2. Designing a database for a supermarket. The current main problem is that the manager ...

    I'm being asked to create or to find some kind of solution to solve this major problem. There are many problems with the method that the employees are using now which is to go around checking each and every product for there date of expiry.

  1. task2-report-template 3

    the owner to arrange an appointment Questions used in the interview How and where do you store information? What information do you store? What experience of using computers do you have? How many people are working in your shop? What common problem do you usually have in your shop?

  2. Organising the database at Costsloadsless.

    be able to read it o The files won't get deleted like on a computer. o It is complicated you have to write down what customer has lent what DVD o It takes less time than getting the data programme on o It is inefficient Using a swipe card The

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