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

implementation report

Extracts from this document...

Introduction

Implementation report For Forms Main menu Form For me to design a main menu page I need to open Microsoft access first and then after I have opened Microsoft access I need to open my database, after this I clicked on create form in design view. Appendix 1 Appendix 1 shows the form in design view; you can manually design your form by going on create form in design view. Appendix 2 Appendix 2 shows that I am going to auto format my form so that the style looks different and it looks more professional Appendix 3 Appendix 3 shows the auto format wizard of the form this lets me decide what format and style I want the form to be like this will make the form look more attractive and therefore would be more appealing to the user Appendix 4 This is how my form looked in design view when I finished the auto format. Appendix 5 Appendix 5 shows that I added a title by first adding a textbox and then writing in the appropriate title, and then I changed the font and the style of writing. Appendix 6 Appendix 6 shows that I inserted the pictures either side of my title to make the form stand out and look more colourful. Appendix 7 Appendix 7 shows how I created a command button to link to my loans form, I first need to open the command button wizard, this wizard is shown in appendix 7, and I then clicked on open form Appendix 8 Appendix 8 shows that I chose the loans table open up as a form when I click on the command button. Appendix 9 Appendix 9 shows that I renamed my command button as loans so that it would be recognisable that the loans form would be opened. Appendix 10 Appendix 10 shows that when the command button wizard was finished a button appeared as loans which would then link to the loans page. ...read more.

Middle

This would only allow these items to be entered when Mr Patel writes something in the rating field. Also I wrote validation text. This would tell the user what to do if the data is invalid. This would have been the error message that would have appeared: After I had set up the 3 tables I created a relationship between these tables so the data can be linked the relationship was like this Implementation report for reports and queries Rating and Genre To make the rating and genre query, I firstly needed to open up Microsoft Access. I then had to browse to where the database and then open the database. After this, I clicked on the queries tab and then I double clicked on create query in design view. After I pressed this the following window appeared. Appendix 1 Appendix 1 shows the window that appeared when I clicked on create query in design view. As I needed to make a query regarding the rating and genre of the video, I only selected the members table; I then double-clicked on the members tab. Appendix 2 Appendix 2 shows that the following screen appeared when I added the videos table. I still haven't added any fields in the fields' column. The query is to do with videos and therefore I need to add all the fields to do with the videos. Appendix 3 Appendix 3 shows the screen when all the fields were added. Now that all the fields are added, I need to put a parameter query under a particular column. Because this query is regarding the Rating and the genre, I need to put a parameter query in each of these fields. Appendix 4 Appendix 4 shows the screen where I added the parameter query in both the fields. I put the following questions: [Please Enter Preferred Genre?] in the genre field and [What Rating Category Would You like to Watch?] in the rating field. ...read more.

Conclusion

I selected to use the current document, as I still need to write down the letter which needs to be sent to the members. After I selected this, I pressed next. This part of the wizard was asking me whether I wanted to use an existing list for the mail merge recipients, select a list from outlook contacts, or type in a new list, as I already had a query with all the names already on it, I selected use an existing list, and then clicked on 'browse' I then selected the video shop database and the following window appeared: As you can see both of the queries have come up for the mail merge letter, one is for the overdue videos, and unpaid videos, I chose the overdue one, as I needed to make a letter for this The wizard then confirmed that the query I chose was the right query by showing me a preview of the recipients. This is what it looked like: This shows that I picked up the right query, and now I have to continue by pressing 'ok'. When I pressed next the wizard asked me what items I wanted to include in my letter, so I clicked on more items so that it would show a list of all the fields I wanted to include in my letter. I added all the fields that were relevant in my letter. This is very useful to Mr Patel as he would not need to make al letter for each and individual member that has overdue items. This shows how the letter looked when I finished adding all the items, and structuring the letter, now I will add a title to it and the video shop logo, and also I will add Mr Patel's signature, so this will save Mr Patel signing the letters individually. As you can see the letter looks more attractive and professional, and it is also fully functioning. ...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 Software 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 Software essays

  1. Database design for a games shop.

    * The system should have information about customers. * The system should have information about transactions. * The system should be able to recover information by entering * Customer's name. * The system should be able to show overdue games. * The system should have a printable list of people who have an overdue game.

  2. Database Review of Document

    I would spend the time learning what reports involve and how to make them and then I would make the report to the best of my ability. II) The database did not identify the winner as there is no system in place to do this.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    I selected "COUNTIF" and pressed "ok". 3) Then a "Function Argument" box appeared on the screen, asking what I wanted it to count. In the range box, I clicked on the square icon in the far right corner; this minimised the whole box, so that I could high-light the range of cells I wanted it to look at, without difficulty.

  2. Website Report

    Design Over the following pages is the design for my website. HOME PAGE This page consists of a black background covered in falling raindrops. The 'Mobile Mania' logo is at the top of the page, which helps to liven up this first page and make it interesting and eye-catching for the visitor.

  1. Logo Report

    Logo Design Studio: this software is specifically for creating logos and it is a very advanced piece of technology. This is the most professional software and many companies already use it, but the software also costs a considerable amount.

  2. A02 Implementation Commentary

    * I had to cut the table which I produced in Microsoft Excel, make it the correct size and then place that into the presentation, moving it to the correct position. * I had to change the font and size of the policies writing and then make the background white

  1. ICT BTEC UNIT 2 - REPORT

    Linux 500Mhz Intel Processor 64Mb RAM 250Mb free HDD space CD-ROM drive All the advantages for Linux are as follows: low cost, performance- as it can with stand several users simultaneously and make old computers more responsive to become functional again, Easy to install and is quite fast, Linux has

  2. Spreadsheet Report

    Format 1 Registration Registration Number of Limo General 2 Name Name of Limo General 3 Number of commissions How many times been used General 4 Average per customer Average Cost Accounting Worksheet 3- Commissions The worksheets talk to each other and they talk to the graphs.

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