Need a custom donation database for a non-profit organization. Preliminary analysis has been completed. Will need some minor VBA coding along with creating tables, queries, and forms. Will require three levels of security access. Will need to design custom data entry forms.
The needs are to :
- track the contact information of CONTRIBUTORS.
- track each DONATION, including CONTRIBUTOR made it, what was the donation, when the donation was made.
Number of records is expected to be 1000 to 3000.
Must be coded in Microsoft Access 2000.
## Deliverables
During the preliminary analysis this possible DONATION cases list was produced.
1) Home Depot #530, lumber department
donates lumber and has contact John Doe.
2) Home Depot #530, plumbing department
donates sprinker parts and has contact John Smith.
3) Home Depot #745, lumber department
donates lumber and has contact Jane Printer.
4) What if Home Depot #530, lumber department contact changes. Do we preserve old records with old contact or allow old records to change to have the new contact? YES
5) John Doe makes personal donation of labor.
6) John Doe makes personal donation of cash.
7) John Smith makes personal donation of cash in the name of buried relative.
8) Jane Reed makes personal donation of cash at 2007 Founders day event.
9) John Reed, the estate conservator, donates cash for client Ralph Crampton.
10)Sally Printer donates cash, but wants all correspondence to go to her book keeper.
11)John and Jane Read make a cash donation together.
Also a preliminary structure of 4 tables was developed. However, the expertise of the coder will determine the final tables/fields/forms/queries/ect.