• 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 is not accurate and creates various errors within the system itself, occasionally inducing losses into the company. Additionally the financial aspects of the business are completed on paper and by manual calculation, which in turn creates errors for the company in the calculation of costs etc.

  1. ict as level coursework

    Number will show up on invoice Oil Drop down menu of available oil will be selected by user. Jasmine Oil Shea butter oil Wheat germ oil Quantity Desired number of product wished to be purchased. Number will show up on invoice User Requirements * 10% discount on products are automatically calculated once the total is made.

  2. A2 ICT CouseWork

    As the person may not require our services. Req. No. 3 To have a way to contact the company A customer can use and online form, filling in their name, email and message before clicking submit The contents of the form are then formatted and emailed to a specific email

  1. Database Analysis & Design

    Functional Model Iteration This section will have a description about Functional Model Iteration. Within this section there are different stages which need to be assessed and completed, these stages should all be completed before moving onto the next full stage, these are, * Agree plan The plan which has been

  2. Implementing a new system for Mastercare.

    be repaired at the workshop and also queries used to search for stock that is below a required level in order to be able to generate an order form to order the new stock. Regular backups of the system will need to be made so that any data loss does not destroy weeks of information.

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

    The PUTRA LRT was established on 15 February 1994 with a 60-year concession to design construct and operate a 29-km LRT from Subang Depot via KL Sentral to PUTRA terminal at Taman Melati. The mostly elevated route runs through many high-density residential and commercial areas on a dual-track guideway.

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