Access Database for Donations

rotze55 

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.