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

Smarts Leisure Park Database Booking System

Extracts from this document...

Introduction

nhdhdhdh Smarts Leisure Park Database Booking System Introduction Smarts Leisure Park has a booking system which is inefficient. They would like an improved booking system preferably by computerising it. I will design and build this booking system for them. Aim My aim is to design and create a computerised booking system for Smarts Leisure Park using a Database, using MS Access. The User Smarts Leisure Park is a park near Southampton which provides many outdoor and indoor activities for young children aged below or in their teens and family's 7days a week. Activities include water sports, running and football. It receives many visitors per year and could use a computerised booking system to register all of the visitors that go there, especially as it is located in a well populated area. The park is organised with different departments and I will be directly working for Ronnie Starr (SLP), in the sports hall to create this booking system. If my system is successful it may be adapted for use in the whole park. The Current System The current system is very inefficient, for example: Making a booking will be as follows. The customer will come up to the desk and ask to make a booking for an activity. The receptionist will then get the book out and search for the date of which the person wants to make the booking. They will then write their name in the book and the details of the activity booked. The customer will then have to produce a receipt for their booking, all hand written. When cancelling a booking, the customer will come up to the desk and want to cancel. The receptionist will have to find the booking and then cross their name off an refund the fee paid. To change a booking, the customer will have to go up to the desk and, like cancelling, the receptionist will have to not only cross their name out on the day that they booked but then put it in the new date. ...read more.

Middle

I am now going to save my table. This is the Customer Details Table. I have saved it as "tblCustomer" Table 2 - Activity Details Now I have created "tblCustomer" I must now create the table showing all of the Activity details. I will create this table in a similar way as "tblCustomer" I will also save it as "tblActivity" When I entered the cost for the Activity it came up with dollars "$". I realised that I needed to change it to a pound sign "�". To do this I had to enter a formula. In the rule I entered the following: Now when I looked at the table normally, the cost was in pounds: I am now going to link the Instructor table that I created with the Activity Table. I have shown the fields for the Instructor table in the Design in a data dictionary. In the field for Instructor on the Activity table, I used a lookup wizard to link this to show different instructors. I then selected the fields, and now when I enter an instructor I pick from a list Table 3 - Booking Details Now that I have created "tblCustomer" and "tblActivity" I must now create the booking table. I will call it "tblBookings" Here is proof of the saved name. I have created the table as I did with "tblCustomer" and "tblActivity". Now that I have created all of my tables, the link allows me to access all of the bookings via the activity table: Linking the Tables Now that I have created all of the tables for my database, I must now link them. In the specification I produced this link diagram. It was called an ERD, it is shown below. I must now link the tables in accordance to this. The first thing that I did was to click on the relationships key. I then linked all of the tables as it is shown in the ERD. ...read more.

Conclusion

I did this by Clicking on the Command button icon: I must then select the button type and create the link. The button is now inserted and links to one of my forms/reports. I did this for all of the forms and reports and now I have a list of them on the menu: That is now my finished menu. Startup When the user clicks the icon for the database, I want it to show the Menu maximised after I enter the password. I will do this by entering a macros. I clicked on the new macros icon: It then came up with this menu: I clicked on Maximise and savced it at "maximise" I clicked on tools>startup and then set the Switchboard to open after the password has been entered: The macros will ensure that it will maximise, once it is shown. User Guide I must now create my user guide. I am going to create it using Macromedia Dreamweaver. This is what my user guide will consist of: Page 1 - Main Menu Page 2 - Customer Form Page 3 - Activity Form Page 4 - Bookings Form Page 5 - Customer Report Page 6 - Bookings Report Page 7 - Cancellation Report It will also have to following links on the side of the page. Link 1 - Main Menu Link 2 - Customer Form Page Link 3 - Activity Form Page Link 4 - Activity Form Page Link 5 - Customer Report Page Link 6 - Bookings Report Page Link 7 - Cancellations Report Page Link 8 - SLP Homepage Website Page One The main Menu: Page Two - Customer Form Page Three - Activity Form Page Four - Booking Form Page Five - Customer Report Page Six - Bookings Report Page Seven - Cancelling Report As you can see, these are all of the pages in my user guide, as I have said. I also have all of the links that I described also. ?? ?? ?? ?? Cand. Name: David Richardson Page 1 of 86 Centre 26148 No. 5049 ...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. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    Problems with the current system Everything above will be ideal for us if we had money to spend on better devices. But as the company is gradually getting bigger, it is costing us more to invest into the company. The paper backup we are printing is using up a lot

  2. ICT notes

    * Have regular eyesight tests. * Take regular breaks. Back/Circulation problems * Poor posture. * Sitting all day in front of a computer. * Ensure posture is correct. * Take regular breaks and walk to improve circulation. The use of ICT when Paying Staff WagesStaff at the health centre are paid using a computerised system and their wages are paid straight into their bank account.

  1. System requirements analysis

    Also one of the main things that she found quickened her speed was the fact that she had an ear phone and this meant that both her hands were free to type on the computer and this really sped her up as her typing quickened and it was easier for

  2. Database design.

    Which I have called close window as shown below. Creating the main menu To create the main menu I had to go to tools and add ins, then switchboard manager. This window will appear, you then click edit to add in the actions you want carried out.

  1. I will be analysing the problems defined by the management in the old system ...

    * A query which displays items whose price is greater than Dhs. 15,000. * A query which displays repairs by a user-defined collection date. * A query which displays repairs by a user-defined technician name and submission date. * A query which displays the repairs to be handled by Andy (technician).

  2. I will design a new video database for the video shop that will also ...

    However, if you do edit your web pages or upload files to your web outside of FrontPage, you will need to run FrontPage's Recalculate Hyperlinks command the next time you open the web in FrontPage. This will assure that FrontPage's internal indexes are up to date.

  1. ICT Report 2b: ICT in Organisations

    Furthermore, many modern day printers can directly connec t to media such as memory sticks or memory cards, or to image capture devices such as digital cameras. Some printers are combined with a scanners and/or fax machines in a single unit, these are called all-in-one printers and can also operate as photocopiers if necessary.

  2. Camelot Restaurant Bookings System - computer system design

    To make sure that the system is easy to use, and that all of the staff can use the new system, this may include trying to keep the system as similar to the original as possible. Design Performance Indicators * It should not take more than 30 seconds to enter a booking.

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