Results 1 to 7 of 7
  1. #1
    jasgra2015 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    5

    Post Seeking Help Designing Hotel PMS

    Hey guys im looking for an expert in Access to help me design a database system for a Hotel. This is part of a project that I intend to eventually package and sell but would pay who ever helps me when I sell the product and I would credit them of course. I know it will take time to develop but I am hoping to learn more about access and have a fun experience designing such a system.

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    I think your request for help is far beyond what you will find here at this point in your project. You're not yet in the design stage?

  3. #3
    jasgra2015 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    5
    I am in the middle of design I know what features I need just need some help at integration.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I agree with davegri --seems way to early in your project to be talking about Access or any physical database.
    Do you have a list of requirements?
    Please tell us more about
    the middle of design
    and
    just need some help at integration

  5. #5
    jasgra2015 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    5
    This is my current design and issues im having with it.... I know there are many many other things to include and will provide updates to it as I fix issues but this is so far.


    Current Tables:

    - Guest Information
    o Houses guests info such as chcck in date, checkout date
    - Rates
    o Tracks current rates for rooms as well as numberof rooms available on property by type . Includes weekend rate as well asweekday rate
    - Rooms
    o A list of rooms sorter by number and type ofroom.
    - Check in Transactions
    o List of check ins sorted by id number
    - Check out transactions
    o list ofcheckouts sorted by id number
    Current forms:
    - Guest Information
    o Allows reservation of guest along with option toadd searchability once other stuff is done.

    Features Needed:
    - Guest list / Reservations
    o A simple and efficient way to make reservationsand to cancel reservations.
    - Room List
    o A master room list that allows viewing ofoccupied and vacant rooms along with out of order status
    - Check in/out feature
    o A simple form used to check in and out guest andprint registrations cards from.
    - Ability to give options
    o Ability to assign different room options basedon availability by date
    - Ability to save customer rate
    o Ability to save the rate a customer has based onthe rate they were given upon reservation.
    Issues Encountered:
    - Way to mark rooms as unavalible and ability tosee vacant/occupied rooms as well as those needing cleaning. Along with way totrack amount of available room types.
    Information to remember:
    - Rate changes
    o Rates are different by weekday and weekend

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  7. #7
    jasgra2015 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    5

    Copy of current file

    Thank you for providing this information but im not sure how to incorporperate any of this into my current database.... prehaps I could upload a version of it so you as well as other posters can see where im at and help me understand how I add these things into it.


Please reply to this thread with any new information or opinions.

Similar Threads

  1. Hotel to filter in Report
    By Erictsang in forum Reports
    Replies: 1
    Last Post: 09-20-2017, 07:46 AM
  2. Replies: 7
    Last Post: 12-15-2015, 06:33 PM
  3. Hotel Availability
    By masterdaave in forum Queries
    Replies: 4
    Last Post: 01-26-2015, 06:47 PM
  4. Hotel database
    By femiores in forum Database Design
    Replies: 1
    Last Post: 03-24-2012, 01:13 PM
  5. hotel reservation, please help
    By forgotten in forum Database Design
    Replies: 1
    Last Post: 08-12-2009, 10:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums