Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - MotelBooking.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

MotelBooking.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.