The difficult I do immediately, the impossible takes a little bit longer.
Data Model ~ Clubs or Associations...
This data model was designed to handle Club or Associations. (Note, there only tables included in this database the balance is up to you!)
Groups will have different Levels (ie: Beginner, Intermediate, Advanced)
Groups may have Group Leaders
Groups will have varying Beginning/Ending Dates and Times
There will be multiple Members
Each Member may or may not belong to a Group
Members may have one or more Roles
Groups will have Types
Clubs will have one or more Groups
Members could belong to one or more Groups
Groups may become inactive
Download Sample (Access 2007 and up and an unzipping program needed)