Mar 18 2022 12:39 PM
Mar 18 2022 05:19 PM
Identify each of the entities you need to track and create tables for them. Based on this summary of the goals for your relational database application, that will include at least the following tables.
Donors--the people who give you things.
Donations--transactions in which people have given you things.
Donation Details -- items included in each donation (one or more, e.g. a box of pencils, three boxes of crayons).
I can think of a few other possibilities for tables, but since I have no idea what else you need to track for sure (tax status for example), I'll have to leave that to your analysis.
Now, with each of the tables, identify the pertinent attributes you need to track. For people, for example, that will include FirstName, LastName, contact information, etc.
For donations, attributes will include the date of the donation, the ID field identifying the donor and any tax related information you might need to keep, if any.
For donation items, attributes will be type of item (pencils, crayons, garden hoses, etc), quantity, probably EstimatedValue and whatever else matters to your record keeping.
Make each of the attributes a field in the table.
Now, decide how to relate the tables. THIS IS THE SINGLE MOST IMPORTANT STEP. Invest some time learning about normalization, which is the process by which the descriptions above are turned into tables in a relational database application.
There are many, many resources on Normalization on the internet. Search up a few and dig in.
Mar 18 2022 11:47 PM
Mar 19 2022 05:38 AM
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.
Mar 19 2022 07:25 AM