MotelBooking.mdb

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   The sample db demonstrates reservation of rooms in a small motel. Some of the interesting features covered in this db are outlined below. 

Status of bookings at a glance (Style 1) Latest status of room bookings is displayed with rooms appearing across columns. Period to be viewed can be selected by entering the start & end dates in the text boxes provided for the purpose. The display keeps changing in keeping with the period selected. Status of bookings at a glance (Style 2) Similar to Style 1 above, with the difference that dates are displayed across columns. At any given stage, the status for a period of one month w.e.f start date (as entered) is displayed. 

Reports are available for both styles (1 &2), in corresponding layouts. Data entry - In order to facilitate allotment of rooms, latest status of vacant rooms is displayed in the lower half of data entry form. As soon as the start & end dates of proposed stay are entered, free rooms available during this period get highlighted in the display below. More-over, the drop down list of rooms for the combo box is limited only to such rooms as are free. 

Versions - Access XP & 2K (both in Access 2000 File Format) References - DAO 3.6 

Download Access XP & 2K: uploads/37/MotelBooking.zip

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
A.D. Tejpal Members Profile Send Private Message Find Members Posts Add to Buddy List Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192	Post Options Post Reply Quote A.D. Tejpal Report Post Thanks(0) Quote Reply Topic: MotelBooking.mdb Posted: 08 Jul 2008 at 10:26pm
	The sample db demonstrates reservation of rooms in a small motel. Some of the interesting features covered in this db are outlined below. Status of bookings at a glance (Style 1) Latest status of room bookings is displayed with rooms appearing across columns. Period to be viewed can be selected by entering the start & end dates in the text boxes provided for the purpose. The display keeps changing in keeping with the period selected. Status of bookings at a glance (Style 2) Similar to Style 1 above, with the difference that dates are displayed across columns. At any given stage, the status for a period of one month w.e.f start date (as entered) is displayed. Reports are available for both styles (1 &2), in corresponding layouts. Data entry - In order to facilitate allotment of rooms, latest status of vacant rooms is displayed in the lower half of data entry form. As soon as the start & end dates of proposed stay are entered, free rooms available during this period get highlighted in the display below. More-over, the drop down list of rooms for the combo box is limited only to such rooms as are free. Versions - Access XP & 2K (both in Access 2000 File Format) References - DAO 3.6 Download Access XP & 2K: uploads/37/MotelBooking.zip
	-- Email: adtejpal@gmail.com

Sponsored Links	> Want a good read? Try The Summer of His Life (available on Amazon!)