I need a Membership database in MS Access 2003/2007 format.
Quick description:
We need a member database for a non profit organization, our members are companies and each company have 1-3 registered company representatives who can attend events etc. Each company representative can have one or more assistants/contactperson. The members are invoiced annually, members can join and cancel at any time (no refund when cancel). The database should clearly indicate invoice renewals and reminders needed to be sent to the members. Reports of different sorts should be generated to show the standing of membership.
Companies are members of the organization, each company can have 1-3 Representatives. Representative can attend many events, some events are free others have a fee, Representative can have assistant(s), member are invoiced annually, staff can create, edit, delete companies, events, members, and assistants.
-There are two levels of membership (Standard/Premier)
-Membership is on annual basis and can start at anytime during the year.
THESE ARE SOME FIELDS TO BE USED, CHANGE AND/OR ADD NAMES/FIELDS IF NEEDED:
-Company fields: Company Name, Industry, Website, Address info, Phone info, Established year, Head quarter location, datejoined, comments, Corporate Representatives (link to represenatives)
-Representative fields: Salutation, Firstname, Middlename, Lastname, Jobtitle, birthdate (mm/yy), diet pref, email, phone, mobil, fax, affiliations, citizenship, Company (link), Assistant (link), companion, companiondietpref, companionname, companionbirthday,
-Assistant fields: Salution, firstname, lastname, title, email, phone, comment
-Event fields: Attendiees(link to represenatives registered for the event), Eventname, location, startdate, enddate, agenda, organizer, contactpeoplechart,
-Invoicing fields: memberlevel, invoicenumber, Payment status (Paid, Invoiced, unpaid, prospective), invoicedelivery method, overduedays, reminderinvoice30days, overdueinvoice60days, membercancelation90days, comments, termination/writeoff,