• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1325

Data Manipulation.

Extracts from this document...

Introduction

Data Manipulation The tables required in the system will be Customer, Products, Staff and salary. The individual fields in each table will be as follows: CUSTOMER (CustomerID, Surname, FirstName and customer address) PRODUCTS (ProductID, Title, Description, Type and Amount) STAFF (StaffID, Name, address and contact number) STAFF SALARY (wages per hour, hours per day and days per week) There will be two reports produced. To produce a report for the products purchased; a query will be run to combine the data from the customer table and the product table. The user will be able to specify the products bought by a customer with the entire amount calculated to give the customer benefits of getting more offers. The second report will print the amount of salary each staff earns per hour, hours/day and days/week. The user is asked to enter the StaffID and name to enter its database. Output The two reports should be able to be viewed on screen with an option of printing it as well. The product purchased report should be printed so that they can give some discounts on particular customers who shop a lot at the store. The staff salary report should also be printed before any meetings so that they can decide on who to get paid more and who shouldn't. ...read more.

Middle

The product types should include which category it is in such as racing, shooting. It would also be easier and helpful if everytime you don't have to type in what category it is in. 2) Can the 2 reports be printed all together with a click of a button because it can be time consuming 3) Can you also do something that can calculate the amount of the products and salary for the staff Final Design Table design Four tables are required in this system. They are related as follows: The tables are defined as follows: Form Design The form designs were amended in accordance with Mr. Smith's suggestions and final designs are shown below. There is a combo box added for the category of the product, which can be easier to select the category instead typing it all the time. Query Design I will need to create 2 different queries. These will form the sources for my reports. QryCustomerlist This query will combine data from 2 tables. Using the customer table and product table. It will ask the user to give the customer name. This will then be asked to find out the customer details or the product details. For e.g. ...read more.

Conclusion

To check if these formula's work I will now test the system After seeing the amount formula working I will now need to save the work and so I will: This is how it will look like when it closes the query For the same way I need to create another query, which relates with staff salary and after it has been done it will look like this Now that Tables and Query's are finished I now need to create forms. Now need to align these in order Now I need to create title for the form . so I need to open the toolbox. It will look like this when I open the toolbox then where it says "Aa" click on it and make a box on the form Now I need to type in the title name. Now I have to organize the font and the font size Now I need to create command buttons for the system. After creating the commands I now need to create a the background colour now I need to save this form For the same way I will create another 4 forms and after I created it, it looks like Now I need to create reports Now finally I need to create a Main Menu, which indicate the user to use the system easily. Main Menu will also be create in the Form ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Explain the difference between primary and secondary sources of data, with examples.

    This could be the only method of finding out information about young children as they could not fill in questionnaires or take part in an interview. The observer may miss important information while they are note taking about other information.

  2. Database design.

    Here I clicked new to name the items on the switchboard and select its actions. This is the window where I can type in the name, action and where it will take you to when you click on it. This is what the main switchboard looks like.

  1. System administration report

    Administrative procedures: How consumables and other equipments is purchased or organised and how they are kept, and the general work of the system administrator. Backup procedures: What data is backed up, and how and when, is at regular intervals or the end of every working day.

  2. In this section I shall design my database. I will make a total of ...

    For example, I will create all my 'Phone Number' fields as text fields. This would also allow the preceding zero at the beginning of the number to be stored, since in a number field it will be eliminated. It will also allow the area code to be contained in brackets,

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