Cancelled

Access Member Database

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,

Skills:

See more: two levels, staff one, quick sorts, payment status pending, ms companies, member one, free access membership database, yy, standing, prospective, paid comment, mm, member, event organizer, database info, database email, companion, companies database, cancel payment, c access, access delete, create member, diet website, create access database reports, industry database

About the Employer:
( 0 reviews ) Hong Kong, Hong Kong

Project ID: #195942

8 freelancers are bidding on average $260 for this job

dataconsultants

Please check PMB for details, Thank You

$300 USD in 6 days
(176 Reviews)
2.1
codeexp10

please see pmb

$300 USD in 14 days
(0 Reviews)
0.0
kachhapbk2

Sir, Please see PMB. Regards,

$180 USD in 10 days
(24 Reviews)
0.0
nasrullar

Greetings. I am an expert in MS Access database development. I can deliver you a quality expert solution with in a time frame of 07 days. Please see PMB. Best regards.

$200 USD in 7 days
(0 Reviews)
0.0
excelcozumleri

We are googd at Excel and Access VBA from Turkey

$300 USD in 6 days
(0 Reviews)
0.0
nkarthick

I am VBA developer I can do it. Please give me a chance.

$250 USD in 7 days
(0 Reviews)
0.0
msasoft

I am working from last 4 years on Access projects...Please check My PBM

$250 USD in 7 days
(0 Reviews)
0.0
jamSoft

I am reliable designer-programmer. Please email.

$300 USD in 14 days
(0 Reviews)
0.0