Results 1 to 4 of 4
  1. #1
    matthewjones108 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    3

    Help with making airport booking system

    Hi Guys,



    Relatively inexperianced with access, so I just need a bit of help. I need to make an airport booking system with 3 tables, these are:

    PERSONAL DETAILS(CustomerNumber, Title, First Name, Last Name, Address, Town, County, Postal code, Phone, Emails, DOB, Flying to)
    FLIGHT DETAILS (Flight Number, Flying to, Flying from, Time leaving, Time arriving, Lengh of flight)
    BOOKING DETAILS (Booking Number, Customer Number, Flight Number)

    So I have relationships from PERSONAL DETAILS and FLIGHT DETAILS to the BOOKING DETAILS. I'm just a bit confused, is what I'm doing right? Are my relationships right? I also need to make a form with sub form, so what do I have to do there? THANKS PEOPLES FOR ALL YOUR HELP BEFOREHAND! I can send you my database if need be

    Matthew

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Before getting too deep into Access, confirm your Tables and Relationships.

    Here are some links to videos and site that should help. These are geared to database design.

    http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

    http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

    http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

    http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

    http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

    http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

    http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

    http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

    http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

    The first few topics are well worth the read.

    http://www.rogersaccesslibrary.com/forum/topic238.html

    For help with access generally, this link has been referenced often
    http://www.accessmvp.com/strive4peace/ Lots of Access Syntax, rational, samples etc.

    For your programming, you may want to adopt a naming convention that does NOT allow spaces in field and object names to prevent headaches in future.

    Good luck
    Last edited by orange; 03-13-2012 at 08:05 AM. Reason: spelling and more Access info

  3. #3
    R_Badger is offline Knows a few tricks
    Windows XP Access 2003
    Join Date
    Feb 2012
    Location
    Suffolk, UK
    Posts
    262
    The only suggestion i would make for normalisation is remove the [Flying to] field from [PERSONAL DETAILS] as this field can be extracted from a query with the flight details via the booking details. This would also remove confusion should the same person book several different flights, otherwise I would say you are off to a solid start.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I agree with R. Badger with respect to the Flying To field in [PERSONAL DETAILS]. However, we don't know the extent of what you are dealing with and without knowing the full scope of your intended application, it makes further comments/options etc difficult.

    There is a data model for airlines reservation at
    http://www.databaseanswers.org/data_...ions/index.htm
    It may be overkill for your needs, but may give you additional info regarding your application and scope.

    Good luck with your project.

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

Similar Threads

  1. Appointment Booking Database
    By richie2837 in forum Access
    Replies: 1
    Last Post: 07-16-2011, 01:39 AM
  2. Automatic Price for Booking - Access 2007
    By doquan0 in forum Queries
    Replies: 1
    Last Post: 08-27-2010, 11:34 AM
  3. Automatic traffic count on small airport.
    By methosmen in forum Access
    Replies: 1
    Last Post: 06-11-2010, 07:32 AM
  4. booking in form
    By yoma in forum Forms
    Replies: 1
    Last Post: 07-31-2009, 05:40 PM
  5. Make a booking availibility checker - please see pseudocode!
    By sirantonycartwright in forum Programming
    Replies: 0
    Last Post: 09-03-2007, 10:07 AM

Tags for this Thread

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