Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2013
    Posts
    3

    Unanswered: Membership Database tables Help

    Hi I need to create a membership database for a fitness centre that is relational in access. I know how to make the forms and reports, I just need help setting up the initial tables with primary keys and foreign keys, and relationships, as well as calculated fields, although I've heard it's better to have a query instead of a calculated field.
    Here is the design for my tables, the fields might need changing:
    MemberTbl

    MemberID (Primary key)
    Forename
    Surname
    Title
    Date of Birth
    Address
    Town/City
    Post Code
    Telephone Number

    Membership TypesTbl

    Membership Type ID (primary key)
    Name (The name of the type of membership, e.g swimming)
    Description
    Cost per month, probably a drop down box?

    MembershipOpportuinitesTbl = what the members membership entails basically

    Opportunity ID (Primary key)
    MemberID (foreign key)
    Membership type ID (foreign key)
    Length
    Join Date
    Renewal Date (calculated field)

    I have attached my database, most the relationships are screwed up as well as other things.

    Help would be much appreciated as I barely understand this side of Access and my coursework is due this Wednesday :l
    Thank you!
    Attached Files Attached Files

Posting Permissions

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