Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Unanswered: Help! Guest History DB

    Hi Everyone,

    I'm newbie to database programming and have been trying to learn in order to update our company's current generic database. I was hoping I would be able to create one without out learning the language but found out would still be difficult. The original database was created several years ago using the standard contact template. This database is very limited because it allows duplicate data and is very inconsistent.

    I know hotel bookings have been done before, but my goal is somewhat different. I want to create a database centralized on our guests history & info, and email/phone inquiries of potential guests for marketing purposes. I thought of maybe using the guest ID as their email address since 99% of the time have email info so I can continue to add information. link other information, and quiry to a specific person. I would specifically like to be able find out:

    -the time frame if GuestA went from a potential guest to new guest to repeat guest.
    -how much revenue a specific travel agent brought in the last year.
    -where guests/potential clients heard about us.
    and so on...

    I have listed specific information that I would like in the database for the different types of contact information.

    New Guest:
    Contact Info
    Holding/confirmed/cancelled: property 1 or property 2 or both
    Travel Agent Contact info if used
    Occasion (vacation, wedding, reunion, ect)
    Referral (trip advisor, google search,, past guest, ect)

    Potential Guest:
    Contact Info
    Inquiring about property 1 or property 2 or both
    Specific Inquiry info (availability, general information, other)
    Occasion (vacation, wedding, reunion, ect)
    Referral (trip advisor, google search,, past guest, ect)

    Repeat Guests:
    Holding/confirmed/cancelled: property 1 or property 2 or both
    Travel Agent Contact info if used
    Occasion (vacation, wedding, reunion, ect)

    If I can tackle this then maybe add on the guests reservations and group party information.

    Can anyone help me on where to even start? I know exactly what I want but have no idea on where to begin.

    Thanks!

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Planning the design of your tables is the first thing... and the most important... and usually, the hardest.

    Since you appear to be clueless on where to start, perhaps you should consider getting a consultant in to assist. A little bit of investment now may save hundreds of hours of frustration later. Just a thought.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    StarTrekker is right.

    Moreover using the email address as an ID for the customers is a very, very bad idea:

    1. Not every customer has an email address (my neighbours are in their seventies, they travel a lot -at least 10 times every year- and they don't even have a computer).

    2. Many people have more than one email address (personally I currently use 9 different email addresses for various reasons and various purposes: private, professional, strictly private ... ).

    3. Email addresses can change over the time and what you want to do is to keep a history: the email address of a customer five years before could not be the same as the email address of the same customer today, not to talk about next year.

    If you cannot afford to hire a consultant you'll have to spend some (as in a lot) of your time learning how to properly design a database. It's all related to data normalization.

    You could find some valuable pieces of information at:
    Databases for Beginners
    The Relational Data Model, Normalisation and effective Database Design
    Microsoft Access help, tutorials, examples
    Roger's Access Library: Roger's Download Samples
    The great primary-key debate

    and many others...

    Good luck and have a nice day!

  4. #4
    Join Date
    Apr 2009
    Posts
    2

    Much thanks!

    Thanks everyone, and I really appreciate the suggestions. I was hoping to tackle on this project myself since I have a mathematical mind but it would definitely take a lot of time and frustration to put this together. Would it be a good idea to get an intern to do this kind of work for a summer job? If so any suggestions on what specifically I should be looking for?

    Thanks again!

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You need more than a mathematical mind to design good database software apps.

    However, I have no idea what an intern is, so I can only guess at what you should be looking for with one ^^

    I was thinking along the lines of a professional consultant.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •