Seat Booking System For Theatre

[Rossatron]

Hi hope someone can help me out here,

I have been asked to research and then produce a simple seat booking system for a movie showing in a small lecture theatre using MS Access. I'm a relative Access newbie and have had little luck in finding information on how to go about producing this system.

If anyone could provide or link me to anything which could be of use that would be great.

Many Thanks,
Ross.

 

[Pauldohert]

What do you need it to do - extra to what you could do by using the outlook calender or something else readily at hand??

 

[alastair69]

have a look at this link, if you need any help give me a call.

http://www.access-programmers.co.uk/forums/showthread.php?t=45004

 

[Rossatron]

Thanks for the replies.

It's for a school project (A-Level) so the system must be something I have researched and developed myself.

 

[The_Doc_Man]

Here is the problem you must face: Schedules on a printed calendar are easy because you have slots for every date. That is because calendars are fully populated. By contrast, scheduling databases tend to be sparse (lightly populated). Sparse databases don't have an entry for every date (usually). They have an entry for every booking.

They MIGHT have an entry (as reference) for every potentially bookable seat, without reference to dates, so that if someone wanted to book a group, you could at least identify locations and such. But so far as I know, there are very few GOOD ways to book seats except by trying to book them and then finding conflicts. It usually involves iteration, probably in VBA, and can often be enough to make you tear out hair.

Since you are trying to learn, all I can say is that searching the forum for "Bookings" might give you lots of food for thought even if you don't actually follow links to posted solutions.

 

[Dennisk]

Bookings systems tend to be one of the more difficult databases to design because of the concurrency issues.
You are booking into a finite resource abd it is essential to provide a mechanism to lock to database. (I'm working on a booking system at present.

The steps you need to take are

Lock something
Determine if you can add to the Aircraft/Hotel Room/Training course
If the limit is not exceeded add to the resource
release lock