• 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)

    a period of time to compare and contrast the results of each system in terms of accuracy, speed, consistency and efficiency. This is a safe changeover method since if a failure arises in the new system; the old system is still there.

  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. A2 ICT CouseWork

    No. 5 All the links must work on the website. The customer clicks the "Contact Us" Link. The customer is then transferred over to the contacts page. Our "contact Details" are displayed on the contact page, therefore giving the customer an option to email our company or ring up our company Req.

  2. System Analysis and Design Assignment

    to the improvements of the improved manual system * This would be the least expensive and fastest option. Disadvantages: * The system will continue to operate manually and tasks will continue to be completed by hand * Time will be spent making improvements to a system which will have little

  1. 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.

  2. Unit 1 business at Work How ICT is used within the Organisation

    * Intranet - Employees of Sainsbury's also have access to the Sainsbury's Intranet site at any time and can view information for example sent from the Chief Executive to all employees on different topics. Also materials from the site may help employees become more motivated in their work and gain job satisfaction such information on bonuses or special employee discount.

  1. Cunha & Ribeiro Ltd: Stock Control & Invoice Database

    Cunha & Ribeiro Ltd is a furniture shop owned by a Mr. Antonio Ribeiro and has been the owner of the business for the past 10 years. It is a fairly successful company that has set itself high standards and has always met customer needs and demands.

  2. Using ICT to communicate

    Page 2 of the booklet has no logo on it and is a page full of text. The top half of the page has an orange background with white coloured text on it. The page is started with a large italic sized font for the title, it then continues with smaller text (Not Italic)

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