hotel booking system related

[Guest]

Hi,
I'm not an advance user, but just good enough for writing basic database.
Currently working on a college project which have to write a booking system
for a small hotel.

I've created certain tables, queries & forms, which work perfectly for
making booking and check availabity of rooms, now, I am seeking for help on:

I want to assign room no. for a booking (with unique booking reference) on
check in date, and port the booking informations into the billing table, and
release the room availability when check out.

Would you please kindly help ? For further information needed regarding the
current database please let me know. Thanks a million!!

 

[tina]

I want to assign room no. for a booking (with unique booking reference) on

check in date, and port the booking informations into the billing table, and
release the room availability when check out.

help with what? you haven't asked a specific question. how about telling us
what you've done so far to meet this goal, and specifically where you're
having a problem getting your setup to work.

hth

 

[Guest]

Sorry about that. These are what I've done:

Tables:
Room Type (RmTypeID, Type & Description)
Room (RmNo, RmTypeID, DailyRate)
Reservation (ReservationRef, ReservationDate, RmType, CheckInDate,
CheckOutDate, GuestInfo)
Guest (Guest ID, and all necessary info)

Query:
Room Availability (Criteria =[Check in Date], which use to check no. of
room & type that is available on requested date)

Forms:
Reservation Form

========

These work out quite ok and tested without error. And now as if a guest
check in, is it possible to use the reservation form to assign him a room no?
(add a function on the form) and what necessary table do I have to create? If
the room has checked-in, so it won't be available, and how can I release the
room to available while the guest has checked out?

Sorry about the confusion, I must admit that English is not my mother
language. Thanks again.


:

 

[Graham R Seach]

Tina,

I desgned such a system while studying at university, which means I'm far
from being an expert. This design I offer at 1:15AM after having taken
sleeping tablets for insomnia. But data modelling is data modlling, so the
principles involved should still be sound, even if I've omitted a couple of
atributes.

tblRoomType tblRoomProp
*RoomTypeID * TypeProperties
RoomType VariousProperty1
Decription VariousProperty2

tblRoomRate tblRoom
RateID *RoomID
Rate RoomTypeID
ValidFrom (DateTime) RateID
ValidTo (DateTime)

tblRservation tlRoomUsage
*ReservationID *RoomUsageID
RoomID PeriodStart
ReservationDate PeriodEnd
CheckInDate GuestID
CheckOutDate
GuestID

tblCustomer
*GuestID
GuestSurname
GuestOtherNames
''' other details, as apropriate

Relationships as follows:

tblRoomType --> tblRoom <--tblRoomRate
^ ^
|--------------| |------------|
| tblRoomProp |
tblReservation tblUsage


Sining a guest into a room is simply amatter of checking if *that*room is
available using the several SQL statements:

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[tina]

well, i usually try to avoid giving explicit solutions for a student's
assignment, because s/he is supposed to earn the grade by figuring it out,
which tells the instructor whether s/he understand the underlying principles
being taught. i try to give only general "train of thought" suggestions, and
hints; but that's just me.

 

[Graham R Seach]

Tina,

<<...avoid giving explicit solutions for a student's assignment...>>
Absolutely right! Given how tired I was, I didn't see the words "college
project".

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia