Background: We're a self-help group of about 250 individuals who help one another in case of emergencies. One becomes a member by paying a one time small fee. When a member has an emergency, we issue a check immediately with available funds, and then each member contributes a small fixed amount to replenish the account with a due date of about 2 weeks.
Project needed: I need a Microsoft Access(2010-2016 preferred) database to do three main things.
1) Have a form to enter member info with just first, middle initial and last name, phone #, and e-mail address.
2) Have a form to select one of the members with an emergency and select a due date for member contributions. Here is where most data entry goes because we need to add payments to individual members with the date that they make the payment. I hope to look them up by member ID or typing a few letters of a name. The membership fee goes here too.
3) Run reports that include members who missed a payment, or paid after the due date by selecting a time frame. Another report would show totals, coming in or going out.
Optional features would include a user login, and tracking changes by user.
I use excel but it's not as convenient.