• 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)

    The main problem is that our documents are not professional looking. Many people don't look at our documents because they are not very appealing to the eye. We need to make the design more appealing to people in order to attract them to Capital FM.

  2. ICT Report 2b: ICT in Organisations

    Through computers, you place the CD, label side up on a disc tray that then rewinds into the computer where it is read by a CD Drive. Boots also use CD ROMs in the R&D department as storage devices, however once data is burned onto a CD, it can not

  1. Analysis of my completed database and documents for the Extreme Sports Club

    When the data has been entered and the ok button has been clicked, the data entered will automatically be placed in the appropriate location in the document. Once the data has been entered into the payment reminder, the formulae will automatically calculate: subtotal, VAT, total, grand total.

  2. Database design.

    I then must see if it is working. To do this I go to my form and go to the design of it, I then add in a button and select run macro when this is finished I can name the button.

  1. Database Analysis and Database Design Project - DVD library for moving images.

    (50% surcharge of the original price, it could either be daily or as the total without counting how many days the DVD was late) BOLD = POSSIBLE ENTITIES ADVANTAGES OF COMPUTER BASED SYSTEM There are many advantages of using a computerized system for Moving Images they are: The files can

  2. Benefits of using my IT system in the Travel Agents.

    After that I will click on postcode. Finally I will click on input mask and type in (LL0\ 0LL). The method for using input mask worked really well. The only change should be that it would be easier if there was screenshots or images. Using Validation rules and text (gender)

  1. Ict Powerpoint Coursework

    Photoshop costs quite a lot of money; this isn't such a big problem as the quality of the software just pas for itself. The advantages are you could basically edit anything which is really good as Mr Akram is trying to find a good way to present the promotions etc...

  2. Computer Studies Past paper definitions

    printer out of paper, pressing break key [2] (d) buffer any two points from: temporary store/memory allows speed of CPU/devices to be matched to hold data being transferred between peripherals and CPU e.g. pages stored waiting to be printed [2] (e)

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