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

    Even when a system is up-and-running and fully operational, unforeseen circumstances can cause problems to arise. I will therefore need to be capable of addressing any problems that may arise in the system, as well as being able to make modifications should circumstances change.

  2. Marked by a teacher

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

    This is due to the fact that manual calculation can lead to erroneous mistakes, as people can have an ?Off Day?. A solution for this would be to computerise the current financial system onto a spreadsheet for example. This would allow the costs of the company to be calculated in an accurate and precise way.

  1. ict as level coursework

    has access to the files as they are not in a secure place meaning that customer information can be accessed by unauthorised people. The solution In order to overcome these fundamental problems I will create a user interface. The system will enable the user to choose one of the following

  2. A2 ICT CouseWork

    address The client receives an email stating the message from the customer, as well as a return email address so they can reply to the customer. Req. No. 4 As customer's are going to be using our service's there should really know what our company stands for and perhaps the history of the business.

  1. Wjec alevel ict Creating a mailmerge

    To do this I filled in two complete lots of information for two companies. This is a screen shot showing the mail merged fields after the data from the Access Database has been imported into the letter. As you can see from the screenshot below the data is well spaced

  2. From the e-commerce strategy you gave me earlier I understand that by having a ...

    the purpose and no more than what you need, you can do this by designing the forms, questionnaires or members' sign up page to only collect the information you need. Example: A website has a member's feature that allows you to sign up to receive extra information and services, if

  1. Implementation of ict project

    Also missing from the sheet is a main menu button, which allows the user to access other pages. There is no validation shown on the page so users can enter anything they want. The new updated order sheet is shown below: As you can see on the sheet all three

  2. This research that I've done will discuss about the effectiveness of the Light Railway ...

    As compensation for operating this low-density extension, STAR received approval for a 3-km extension northwards from Sultan Ismail to Sentul Timur into a high-density residential area.8 The southern extension (phase 2) between Chan Sow Lin and Sri Petaling was completed 2 months before the Commonwealth Games and KL took pride

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