Booking System

  • Thread starter Thread starter Nick1966
  • Start date Start date
N

Nick1966

Hi

I have been requested to look at using Access to control bookings at a local
centre. The system would work on the principle that there are a maximum
number of spaces e.g. 30 for each two hour slot during the day. When a space
is booked by a student then the capacity for that time slot would be reduced
by one until all spaces have been booked.

Is Access is practical tool for this job, and can anyone suggest any
resources I can use to get me started.

Many thanks


Nick
 
There are many tools, including Access, that could do this job. My
preference is always for the tool I am most familiar with. To help refine
your options and determine whether an unfamiliar tool is worth the trouble
you need to be more specific with your requirements. For instance, will the
system need to keep track of which student has booked? If a booking is
cancelled, do you need to know which one, or just that the slot has become
available? Do you need to run reports on bookings, attendances,
cancellations and declined requests? What options should exist for
enquiries, such as being able to suggest an alternative available time, or
automatically extending a booking to a second time slot? Who will be
operating the system and how foolproof does it need to be?
 
Thank you for your reply,

At present I am am not sure of the details as a lot of things still need to
be decided, however most of the tasks you listed will need to be included as
the centre runs on an "open-learning" basis so students can book their own
time slots as long as there is a space available. The minimum requirements
will be that

1 Capacity is reduced when a booking is made
2 Space becomes available when a booking is cancelled
3 Bookings can be made in advance - 3 to 4 weeks
4 Session registers can be printed.
5 Records of sessions attended & cancelled can be run by session and by
student
6 Centre may have more than one type of session at a time e.g.assessment, or
Open session, so students need to book onto the appropriate session.
7 Students will need to be enrolled on a course




I am sure that other requirements will be included but these will form the
basis. My concern is that although I have some experience in creating
databases on Access these tasks may require complex queries and macros than
I have mastered so far.

Nick
 
Tracking bookings by student, and confirming that students are enrolled on a
course are both features of your system that would push you strongly towards
a database solution, such as Access. They will require queries and macros.
--
 
Back
Top