Forum Discussion
rotze55
Mar 18, 2022Copper Contributor
Access Database for Donations
I am tracking donations made by people, what i am having problems with is if multiple people donated pencils I want to be able to see what each individual person donated
George_Hepworth
Mar 19, 2022Silver Contributor
In the interest of attributing authorship of products to their creator, I thought I should point out that the original version of the charitable contributions template linked in that third-party site is actually one of the templates Microsoft offers in MS Access.
Many of the templates are not that good, but this one does seem to have some useful ideas.
Beware of all Microsoft templates. Their naming conventions are mediocre.
They use "ID" for the name of the AutoNumber Primary Key in tables. While some developers do that, more will use a name that reflects what that ID is for, e.g. "CampaignsID", or "DonationsID".
In addition, while the MS templates seldom do this, most developers avoid names with spaces or non-standard characters in them. This works, but complicates a lot of references. E.g., not "Campaign Name", instead "CampaignName".
Other than that, this template appears to be a good one to get some ideas from, although being a template, it will have to be modified to fit your needs.
- George_HepworthMar 19, 2022Silver ContributorActually, on further review, it appears that website primarily offers Microsoft templates. And although they admit they are not the creators of the templates, I don't see any attribution to Microsoft directly for using their templates. That would only be a problem I suppose if Microsoft decided to object for some reason.
George- rotze55Mar 21, 2022Copper ContributorGeorge
Thank you for all your help. I really appreciate.
Rich- George_HepworthMar 21, 2022Silver ContributorGood luck with your project.