• 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

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    This way, any problems or bugs can be corrected before full-scale implementation occurs. However, this is only possible in an organisation that has many departments or locations so obviously it's not going to be an option for the small family business that I'm looking at.

  2. Marked by a teacher

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

    This si done through manual calculations within his office. Ellis Redding as head of administration is in charge with all of the paperwork which comes through EVDOP Live. With the current system that EVDOP Live employs, Mr. Redding has o use a paper based system to complete the various forms of administration that he needs to do.

  1. System Analysis and Design Assignment

    learning centre library * Visual Basic is a powerful language and will allow me to create a visually appealing, easy to use program package for the staff to use * The program can be customised and updated as and when changes are required Disadvantages: * I do not have a

  2. A2 ICT CouseWork

    There are not just two platforms to test; there are hundreds of platform's to test, so it is important we try to test as many platform's as possible, as different platforms may not support certain aspects of my website which may make our website look different or just now work

  1. Using ICT to communicate

    details of what the page is, on the reverse of this page is Exclusions and clauses which takes up one quarter of the page and the rest of the page remains blank leaving the page looking very empty and unprofessional, there is footer to the page containing the address of the company in small grey text.

  2. ict as level coursework

    This is due to several reasons handwriting can be unclear, it can be difficult to understand all customers of the phone and also totals have to be calculated manually. Another major disadvantage is the fact that receipts are not given to customers as proof of their purchase in case they need it in the future.

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

    However, there are disadvantages to Just-in-time stock control. The first method is that it may not come in time, so may be risky. For example, if you're very close to selling out of Coca Cola, you will re-order a batch of say, 15 bottles.

  2. Free essay

    ICT organisation project

    If the reader wants to find out more regarding the scheme. Change each name so the font size is larger than the rest of the text -size 12 and embolden. Page 7 * Move the image of the rock climbing wall up to align with the top of the text

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