New to Access, Need to Design Database for Non-Profit

[oatsybob]

Greetings!



I'm the new outreach coordinator at a non-profit that provides daycare to low income kids and adults. I've been trying to map and organize our community relationships, but the data I inherited is totally disorganized. I have a huge mess of flyers and half-concocted Excel databases that I need to get organized into a clear, coherent, searchable database. I need to be able to search by date of last contact, type of relationship (media, other non-profits etc), organization name, primary contact first/last name, etc. It seems like Access is the best tool to get this job done. Is someone kind enough to point me in the right direction? How many tables should I have and what distinctions about the data should I separate tables into? I have an idea of how Access's table/field system works, but am unsure how to make the correct separations.

Thanks in advance!

[June7]

Review
http://forums.aspfree.com/microsoft-...es-208217.html
http://forums.aspfree.com/microsoft-...os-197463.html
http://www.developerbarn.com/communi...-database.435/
http://www.developerbarn.com/communi...-tutorials.18/