• 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
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  56. 56
    56
  57. 57
    57
  58. 58
    58
  59. 59
    59
  60. 60
    60
  61. 61
    61
  62. 62
    62
  63. 63
    63

ICT AS-Level Coursework

Extracts from this document...

Introduction

Coursework Background I am representing a top of the range designer clothing chain store situated I the heart of London's park lane. This is the most popular designer chain store in the UK it has a range of celebrity clients from David Beckham to FHM cover girl caprice. This designer chain store has been repeatedly referred to as the home of fashion it has designer labels from the Italian fashion idols Dolce & Gabanna to Burberry London. The chain store managers have direct connections to all top designers all over the world like Versace, Armani, Prada, Gucci, D&G and of course Louis Vuitton, the stores all have exclusive clothing not available anywhere else worldwide. Problem The problem that they are facing is that the current system is very limited to responses it doesn't do much at all it can do is store bits of information and it has very limited functions built into it therefore they are very anxious to get a program that can fulfil everyone of our needs including data recollection and stock level adjusting, and so on, this is why they require simple yet effective receipt system. The solution needed to solve the needed and requirements of Unique fashions plc. 1. The first requirement is to have a full-computerised digital database which holds of the product that they stock. 2. There must be some sort of secure login facility, which will allow the user to login to the secure area. 3. The program must have a self-updating receipt which updates the user add or delete things off the receipt. 4. The receipt automatically deletes the previous customer's information and allows the system to continue. 5. The receipt must also have a self-updating date and time on it, 6. If any information is mistyped the computer can fix this, because it has an auto correct function built into for spelling and grammar it as well as a thesaurus and dictionary complete with definitions. ...read more.

Middle

The user may repeat this in order to add more items when all the items have been added, the user may then type in the cash tendered and then press enter so that the change is shown. After all this is completed finally the user may click on send to receipt which will enable all this information to be shown on the receipt. The new customer command button clears the receipt so that the next customer may be served. The print receipt command button allows the receipt to be printed. This is a preview receipt screen this shows the user the contents of the receipt without him/her having to go back to the excel document. The exit button will allow the user to return to the enter page. I will enter the following pseudo codes:- Quantity field:- 'Private Sub TbQuantity_AfterUpdate() Sheets("sheet1").Range("e1") = _ UserForm1.TbQuantity.Value UserForm1.TbSubTotal.Value = _ Sheets("sheet1").Range("e3") End Sub' This will update the receipt. I will put no pseudo codes in the item, colour, size, price, MSL, stock and finally sub-total fields as they are not needed. Product combo box:- 'Private Sub CbProductID_Change() Sheets("sheet1").Range("A2") = _ UserForm1.CbProductID.Value UserForm1.TbItem.Value = _ Sheets("sheet1").Range("B2") UserForm1.TbColour.Value = _ Sheets("sheet1").Range("C2") UserForm1.TbSize.Value = _ Sheets("sheet1").Range("D2") UserForm1.TbPrice.Value = _ Sheets("sheet1").Range("E2") UserForm1.TbMSL.Value = _ Sheets("sheet1").Range("F2") UserForm1.TbStock.Value = _ Sheets("sheet1").Range("G2") End Sub' This will transfer the entire stock list, which has been put into the spreadsheet to the receipt system. It will show the product ID in this combo box and when an item is selected it will show all the details into the following fields: item, colour, size, price, MSL, and finally the stock.. Cash tendered field:- 'Private Sub TBCashTendered_AfterUpdate() Sheets("sheet1").Range("cash") = _ UserForm1.TBCashTendered.Value' Once the user has typed in the cash tendered and pushed the enter key then it will show up on the receipt. Change field:- 'Private Sub TBChange_Enter() UserForm1.TBChange.Value = _ Sheets("sheet1").Range("change")' Once the item is sent to the receipt the change will be shown. ...read more.

Conclusion

If I were to repeat this project I would do the following: - 1. I would create a working credit card system as well as the cash only system. This would make it even more of a practical system. 2. I would also make another user from that would allow all the users to change their passwords. This would make everything more secure than it already is, and it will be a lot more professional and more impressive than it already is. 3. I would create a refund system that allowed the customers to get refunds a lot easier than they are now at the moment the refund system is all manual, and they involve paperwork. 4. I would also modify the current 'Transaction Record' sheet I would add to it the user who sold the item and the time and date at which it was sold. 5. I would also add on to the receipt more information such as VAT registration number, and I would also add on to the receipt the user's name that sold the item. 6. If I were to redo this I would also add on a search system that searches through the stock list, and or transaction records for the required bits of information that was asked for, by the manager or some other authority figure of the company. Also the codes that I put into my user forms took me a long time but in the end they all do exactly what they are supposed to do. I have now learnt in which kind of language these codes work, if you will. Overall my receipt system's creation has been successful, even though there are a few changes that I would make but I am happy with what I have done with it. My receipt system does precisely what I want it to d, and as the creator I am proud of it. I have learnt many new things along the way and hope, that my client company can use my receipt system successfully. ?? ?? ?? ?? Sajil Khan Page 1 17/03/2008 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Information Systems and Communication 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 AS and A Level Information Systems and Communication essays

  1. Marked by a teacher

    I have been asked to create an ICT solution for a local events and ...

    of ICT systems is somebody or someone who requests a solution to an outstanding ICT system problem. An example of this would be someone who requests a solution for a dysfunctional spreadsheet, so contacts somebody to fix the problem. With reference to the task that I?ve been given the clients

  2. I have been asked to write a report on current working practice and I ...

    To design their product they create concept art during meeting with client and evolve the concepts and quickly start implementing the design using design specification because they don't have time for proper storyboard and design interactions. As they charge on daily rate so time is very important over the life of the project.

  1. The aim of this task is to produce a report for the managing director ...

    An average DVD disk can hold 4.7 GB and this can increase depending on the type of disk wanted. A disadvantage of DVD's is that like CD's, they can be scratched very easily and are expensive to replace unlike to older version, VHS.

  2. ICT in Retail and the advantages to the shop and the customer.

    If sales depreciate in Coca Cola over the next week then they won't be at too much of a disadvantage as they bought it in low quantities, whilst if you order in high quantities you may loose profits considerably as you're wasting store room space with bottles of Coca Cola know body is buying.

  1. Data Processing Task. Mr Peters, the man who runs this particular Samsung store ...

    will have a print out copy of their orders rather than the more unprofessional way of just handwriting it. This shop sells all the things you would expect to find in an electronic shop. It features TV's, laptops, cameras, phones and tablets.

  2. Discuss the Causes and Effects of the Digital Divide

    There are many Benefits of this like Internet would be free so even if a household cannot afford to pay monthly internet they can always connect to internet free of charge. It would also encourage people to use the internet seeing as it is free of charge, more people will be interested in it.

  1. Businesses now have to take certain precautions to ensure theirs and customer data is ...

    Back-ups of the information should be in different places, if it?s in the same place it will be affected anyway, so by backing it up in other places can make it easier to restore. Also available are back up sites known as hot and cold site.

  2. Features of database design

    For example if a customer called John Smiths ID is changed in the customers table then the change must also be applied in the accounts table in the foreign key column so that the data links. The account table doesn?t hold information about customers apart from the Customer_ID as a foreign key.

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