Creating a DB for a gym.

[BwillieS]

I currently have a small gym and the number of members is starting to grow. Currently I used excel to do all my data. I want to use access. I have a general idea of access and I want to try to make it myself.

I guess I want to know the best way to set it up.

For tables should I go with
- Customer Bio (address, phone number, )
- Employer bio (address, phone number)
- Bank info (for pulling money out of the account)

When I pull a report how do I link these tables together so I know that the bank info is correct for the customer Bio. Previously I used to just make one big table with all this info in it but I was told it is sloppy.

Any help would be greatly appreciated.

[orange]

I recommend you read the first few topics at this site to get an understanding of what you are trying to do.
http://www.rogersaccesslibrary.com/forum/topic238.html
Good luck