I'm in the process of building a grant tracking database. We currently have a small database on Excel, but it is not particularly helpful for keeping track of deadlines or filtering data as the various inputs are so variable across fondations.
Inspired by the various threads on PND Talk, I've begun to teach myself how to use Microsoft Access, but have been running into some trouble on how best to organize and relate the various databases in the most useful way. If anyone has any thoughts on how best to organize the tables, that would be excellent. Additionally, I am not quite sure how best to deal with grants that have rolling application deadlines with subsequent times that they are more likely to be reviewed.
Finally, has anyone had any experience with using Microsoft Project for organizing grant applications and keeping track of deadlines?
I would appreciate any thoughts people might have on these matters.
