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.