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

    We have a lot of documents to look after in our company and that means that if we are looking for a certain document it will be hard to find as our organisation is not very good. Sometimes staff have very messy hand writing and they write a memo on a piece of paper for other staff to read.

  2. ICT notes

    The benefits to the health centre for having a computerised system: 1. It is quicker and more accurate than calculating wages manually. 2. The added security that wages are paid straight into bank accounts i.e. Electronic Funds Transfer (EFT) money is transferred from the health centres account to the individual staff members account.

  1. 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.

  2. 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

  1. Access Database

    in Microsoft Access * Make database user friendly so it can be used I will ask people about my database by giving them a questionnaire, if they think it user friendly * To show the stock of the videos in the library I will check in my forms that there

  2. 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

  1. Creating a computer system for a video rental shop

    This type of a daily back up is called a differential backup. This will insure that the majority of customer's orders will not be affected and therefore the company will not lose customers. The regular backup should be made to a floppy disk, there should be a floppy disk for daily back ups done on Saturdays, Tuesday s and Thursday.

  2. Creating a computer system.

    > There will be other macros they will need to click on for example saving, clearing, and printing the invoice. The users will also need to click on the update stock button when they are finished, and the main menu button to return to the main menu.

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