Results 1 to 3 of 3
  1. #1
    SarKap is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    1

    Question Database for a Club

    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.
    Click image for larger version. 

Name:	layout.PNG 
Views:	22 
Size:	54.1 KB 
ID:	41417

    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.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    quite a bit - more to question your logic and whether you are trying to create or need history files

    contact details and person - looks like should be a one to one relationship - so contact details can be included with persons, no need for the contact details - unless structure was more like

    CommunicationsID
    IDPerson
    CommunicationType (mobile/landline/email/fax/etc)
    CommunicationValue

    address can then go to persons table. But if you need to keep a history of addresses, either include in the communications table as a comma separated string or a separate table and include a 'fromdate' field

    finance table - suggest needs a date paid field

    dates table - don't understand what its about but should not need a rejoined field, that would be another record

    persons table - people change jobs so that should be in a separate table

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Consider:

    Move "DatePaid" FROM DATES table to FINANCE table.


    tblDates
    --------------
    DatesID_PK (Autonumber)
    ActivityTypeID_FK (Long)
    ActivityDate (Date/Time)



    (New Table)
    tblActivityTypes
    ----------------
    ActivityTypeID_PK (Autonumber)
    ActivityType (Text)
    ActivityAvalible (Y/N) - (Yes - option available, No - option not available)


    ActivityType Data would be:
    Joined
    Stopped
    Rejoined
    Advance Eligible
    AdvShifted
    Add_WA
    Rem_WA
    Change_WA

    This way you can add/change Activities and not have to edit the whole database.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database for 4h club and yearly fair
    By lbaumeister in forum Access
    Replies: 4
    Last Post: 09-06-2016, 01:24 PM
  2. Replies: 11
    Last Post: 05-15-2016, 07:38 AM
  3. Club Member Database
    By butterbescotch in forum Access
    Replies: 4
    Last Post: 04-04-2013, 02:53 AM
  4. Tennis Club Database
    By ecenaz90 in forum Database Design
    Replies: 2
    Last Post: 04-19-2011, 03:50 PM
  5. Need help designing a database for a club
    By tsuchong in forum Database Design
    Replies: 5
    Last Post: 01-31-2011, 12:39 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums