• 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. ICT in the leisure centre

    Communication with the employees and members/customer s of the leisure centre is very important. Telephone numbers, which customers can ring or vice versa the leisure centre can ring them. The Internet is also the way forward in communication, a web site that can be accessed to see local events that

  2. ICT Leisure Center

    following which tells us about the current system of some places In the Leisure Centre. Area of centre Equipment in place What it does? Does it meet the need? Sports Shop Electronic tills Keeps a record of the sales and gives customer a receipt Yes at the moment.

  1. Hardware & Software Requirements for Database

    The costs involved are in varies of prices depending on the size of the memory. If the hospital computers contain a RAM of 256 MB then they would need to buy a extra 256 MB for my database but if they have more then that then they could run my database very effectively.

  2. Access Database

    check if they work properly in Microsoft Access * Create Queries to search for data I will open the queries and check if they work properly in Microsoft Access * Create Reports to show the output from your queries I will open the reports and check if they work properly

  1. System requirements analysis

    and also this saves the doctor time so that they can see as many patients as they can in a day. The receptionist sends this information to the doctor via an e-mail system in which the doctor has access to very easily.

  2. Creating a computer system for a video rental shop

    Entity-Relationship diagrams Entity-relationship diagrams are diagrams, which show the relationship between entities in a database. Entities are things of interest to an organization about which data is held. In order to be able to draw an entity-relationship diagram you need to know the degree and the name of the relationship.

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