Some Background on the Missoula Foodbank
|Some Background. Missoula is a small city of about 100,000 people
in the western portion of Montana. It is not exactly the most
dynamic place I've lived when it comes to economic activity.
The area has a foodbank that barely helps stem the tide of hunger.
Their basic setup is that food is collected from individual and institutional donors. It is placed in the foodbank so that people can come through and shop for free. There are definitely restrictions placed on how they must shop. Standard policy is that a single household can only come to the foodbank once each month. Though, there are situations where someone from a household can come a couple additional times.
The MFB has a paper form they have people fill out when they are looking to get food. The basic contents of the form include the following.
The people that administer the MFB like to have at least some reports about who they are serving. Obviously, there is a fair amount of data that accumulates.
Database Organization. So how should one develop the database?
The director of the MFB was already fairly familiar with Access when I met with her. She had already decided that the database and appropriate user interfaces should be developed in Access.
The director also told me that there had been a variety of volunteers over the years who had tried to develop this in Access, but they had never gotten it completely working. One of their main difficulties had to do with searching through past records to make sure they were updating the appropriate clients. Apparently no one had been able to implement this or other features.
I tried to point out that using Access like she planned was going to guarantee that the database could only be used on one machine. The director definitely didn't want to be dealing with networking computers or network capable databases.