Hello dear people,
I studied Database design etc a decade ago and since then have done some amateur databases. However, i now find myself creating a database for a voluntary club. Details as follows:
1. Club has a list of person with his/her details (Name, Sex, Job, Date of birth,...)
2. The mailing address and phone numbers are recorded for each persons.
3. All the dates are recorded for a person, the date he joined, stopped, rejoined,...)
4. There is a contribution fee monthly if the member attended or not.
5. The club meets every wednesday (which may change down the line or not), so we have to track who attended each wednesdays of each month and so on.
I came up with a simple design and i tried to replicate the employees attendance etc designs.
When i was trying to create forms to fill in all the table at once (by someone who will manage the DB) and to make simpler forms for finance or attendance, i realised shortcomings. I would be grateful if someone could suggest ideas to improve the design and how to manage the data entries.
Though i have a programming backgroun, i have not done programming in the past decade nor do i know VBA. Thank you.