• 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
  64. 64
    64
  65. 65
    65
  66. 66
    66
  67. 67
    67
  68. 68
    68
  69. 69
    69
  70. 70
    70
  71. 71
    71
  72. 72
    72
  73. 73
    73
  74. 74
    74
  75. 75
    75
  76. 76
    76
  77. 77
    77
  78. 78
    78
  79. 79
    79
  80. 80
    80
  81. 81
    81
  82. 82
    82
  83. 83
    83
  84. 84
    84
  85. 85
    85
  86. 86
    86
  87. 87
    87
  88. 88
    88
  89. 89
    89
  90. 90
    90
  91. 91
    91
  92. 92
    92
  93. 93
    93
  94. 94
    94
  95. 95
    95
  96. 96
    96
  97. 97
    97
  98. 98
    98
  99. 99
    99
  100. 100
    100
  101. 101
    101
  102. 102
    102
  103. 103
    103
  104. 104
    104
  105. 105
    105
  106. 106
    106
  107. 107
    107
  108. 108
    108
  109. 109
    109
  110. 110
    110
  111. 111
    111
  112. 112
    112
  113. 113
    113
  114. 114
    114
  115. 115
    115
  116. 116
    116
  117. 117
    117
  118. 118
    118

Data Processing Task. Mr Peters, the man who runs this particular Samsung store has approached me and asked me to investigate his current system of usage for keeping records of customers buying products from the store.

Extracts from this document...

Introduction

Data Processing task 14 Bridge Street Banbridge Co. Down BT323NB Northern Ireland Contents Analysis Background Information: Page 5 Location: Page 6 Introduction: Page 7 Current System Page 8 Problems with the current system: Page 8 Objectives of the new system: Page 10 Inputs, Processes and Outputs: Page 11 Information Requirements: Page 13 Quantative and Qualitive Objectives Page 14 System Design Page 16 Design Entities with Attributes Page Possible Solutions Page Form Design Page Switchboard Design Page Report Design Page Calculations Page Mail Merge Page Queries Data Dictionary Page Macros Data Dictionary Page Testing Test introduction Page Test Plan Page Results Page User Guide Description of Package Page Hardware and Software Configuration Page Installation Guide Page Operating Instructions Page Switchboard Page Order Forms Page Macro Guidelines Page Reports Page Mail Merge Page Troubleshooting Guide Page Background Information Samsung is a Korean company that has risen to prominence in many fields over the years. Samsung is a Korean company that has risen to prominence in many fields over the years. The size and the scope of the company is almost unimaginable, as they are one of the largest and most diverse companies in the world. While the company is mostly known for their technology division [cell phones, radios, MP3 players, computer screens, and the like] they have many other divisions as well. The company has expanded from a humble storefront launched in the late 1930s to the largest company in Korea and the second largest company in the world. In addition to the electronics division, which is the most profitable and successful one in the world, the company also has forayed into finance, chemicals, retail, and straight-up entertainment-all with great degrees of success. The company was once even larger than it is now, but the government, concerned about the power that the company amassed, required the company to drop some of its sub-divisions. Because the company is so large and powerful, they have been accused of bankrupting some other companies - or worse, making the market so that other companies don't stand a chance at the start. ...read more.

Middle

If there are any problems with the products, please contact our store on 028 40625568. Thank for your shopping with us, it is greatly appreciated Yours Sincerely, Jim Peters Manager of Samsung Store, Banbridge Mail Merge 2: Order Details 14 Bridge Street Banbridge Co. Down BT323NB Northern Ireland Dear Mr John McColgan On behalf of Samsung, we are delighted that you chose us for your electrical goods. The details of your order are Order Number - 1 Products Ordered - Samsung RV510 15.6 inch HD notebook Amount Ordered - 1 = �366.39 �430.50 Inc VAT We hope the products have reached you in perfect condition. If there are any problems with the products, please contact our store on 028 40625568. Thank for your shopping with us, it is greatly appreciated Yours Sincerely, Jim Peters Manager of Samsung Store, Banbridge Queries Data Dictionary Customer Information: This is a query to display all of the Customers information; their names, addresses, telephone numbers; taken from the customer table. Customers by Location: This is a parameter query which asks you to enter a town. This is achieved by in the criteria for Town/City, entering [Enter Town/City]. This query may be useful if someone within Samsung wished to know where there customers are from to see where they get their best business from. Customers by Address This is a parameter query which asks you to enter a town. This is achieved by in the criteria for Address1, entering [Enter address]. This query may be useful if someone within Samsung wished to know where there customers are from to see where they get their best business from. Customers by Postcode This is a parameter query which asks you to enter a postcode. This is achieved by in the criteria for Postcode, entering [Enter Postcode]. This query may be useful if someone within Samsung wished to know where there customers are from to see where they get their best business from. ...read more.

Conclusion

Follow these instructions to back up the data: 1. Close the database. 2. Click on My Documents and then Samsung folder. 3. Locate the file called Samsung held within the file. 4. Insert the CD/USB Memory stick. 5. Right-click on the database file Samsung.mdb) and select copy. 6. Open up USB/CD and paste the database file. This is one method to back-up the database however within the main switchboard which can be seen below there is an option to back up on memory stick Troubleshooting Guide This section shall describe and resolve some of the potential difficulties encountered within this system. Problem Action Required When inputting the correct password a message appears saying "not a valid password". The password is case sensitive and must be typed in lower case letters. Take off the caps lock and retype the password. Certain fields in my order and product order tables appear as 0 in the table yet are correct in the forms. After data as been amended, always run the macro to update the tables in order to complete calculated fields. When some specific data is entered a message appears saying invalid data. There have been some specific validation rules set such as Postcode and Phone number to only be allowed a certain number of digits. To amend this make sure you have the correct number of digits used. To change or delete validation rules The user can go to the tables sections and go to the related tables and cut the rule out so it won't appear, or they can amend the numeric value. When opening a order, no data appears apart from #Error in the calculated fields. If Samsung has no orders for that week the order form will appear blank and therefore fields involving calculations will not be able to function. When I enter a number in a parameter query an error occurs or no data appears in my report. An incorrect number must have been entered. Check that for order number the order exists ?? ?? ?? ?? Mark McEvoy ICT Coursework 1 | Page ...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)

    Perfective maintenance is performed when the users of the system, through repeated use, become aware of certain changes that would enhance the performance of the system on one or more variables such as speed, accuracy or consistency. Whilst a system does not require such modifications, and will run adequately without them, they do improve the system.

  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. The Impact of Mobile Phones on social Interaction

    Once the school informed me that they had a group of volunteers for the focus group, I arranged the focus group discussion for approx. 1 hour after school on Friday 1st March 2002. I prepared for the focus group by preparing a list of questions in advance (see appendix 8.3)

  2. Threats to Data

    Many businesses with transactional websites use professional website designers and programmers to produce and host their sites. In these cases, sites are fully backed up onto another server, often in a different location, so that if there is a problem, there is minimal disruption to the business.

  1. Applied ICT - How Comet Stores could use ICT and a CCTV system.

    A series of vertical bars and half bars representing the ZIP Code printed underneath the address on a mail piece. The barcode facilitates automated processing by optical character reader equipment, Barcode is the a code that the scanner reads it and show the fully data about this product where it's

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

    If somebody is applying to you to amend their records, they cannot amend opinions, only facts. Any opinion which is obtained and kept on a person's record should be written in a way that it can be interpreted correctly and it should contain the date when it was written, the author's name and position.

  1. Discuss mobile phones and telecommunication developing in 21 century, focusing on the negative and ...

    Although a part of students can have a well-informed decision for using mobile phones during the lesson but not all the students can do that. Actually, students should have their responsibility and they should know what they can do and what they can't do.

  2. Business and Information Technology, What are the input, processing and output of UPS package ...

    The company spends more than $1 billion into technology and systems to keep a high level of customer service. Use of scan-able barcode attached with every single package has reduced the time and labor to find the useful information about it.

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