• 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. IT system for local video store.

    Queries Queries will be essential so that the database can run and so that video store can get the most out of the database, the user requirements state that queries are essential is the system is to meet the end users requirements.

  1. Designing a system to help a leisure centre

    and collects data, he told me about some of the problems he and his staff faced. He told me that they had six large filing cabinets in their office filled with their member's personal information and data. He explained how they were running out of space and he said that

  2. ICT notes

    * Repetitive finger, hand or arm movements. * Poor posture. * Badly designed workstations. * Ensure wrists are straight and elbows are close to your sides when typing. * Ensure posture is correct. * Take regular breaks. Eye strain * Staring at the VDU for long periods.

  1. Features of a sports club database. The system has at least 1 table and ...

    record A4 - Example of one of the validation 1 A simple tip for the user 2. & 3. Scripts to show all records and unsort records 4. Header and the title of the field, clicking on the header can sort the record according to the sort order.

  2. System requirements analysis

    hospital every day and the system uses all of this data about the staff and it uses it to work out their salary at the end of each month and the system also creates a payslip for each of the staff members in the hospital.

  1. Database design.

    You choose which fields you want to be in the form. Click next and the next window will appear. This window will ask what set up you want your form to be in I selected justified Basically this window asks you to select a background.

  2. Create an IT system for my karate club.

    The key field has to be unique and be able to identify the right data and a good key field would be a number e.g. 1 or F12. I have decided to set this table up this way so the information is easy to view by someone with little knowledge

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