Membership Database tables Help

[elitehass]

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, as well as calculated fields.


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!

[alansidman]

First. Your foreign keys need to be the same data type as the primary keys that they are being linked to. In your case you need to change these to Integers.

I would avoid using calculated fields in tables (unless this is a requirement of the class)

Read about calculated fields in tables here. http://allenbrowne.com/casu-14.html

do that calculation in a query or report.

BTW: Here is a good study on RDBMS designe http://www.deeptraining.com/litwin/d...aseDesign.aspx

good luck with your assignment.

[alcapps]

I think there are microsoft database templates for this already done. Try looking on the microsoft site for access templates.