my OS is win 7 prof 64 bit and I use Access 2007. I am trying to create for my non-profit temple a simple database. The project is for the distribution of pamphlets and booklets to people in the community. A few of the congregation meet at an intersection, and while one or two sing or dance, the other distributes pamphlets, booklets and flyers to the passer's by. But now the requirement is to capture what was distributed, at which location, date and time, and quantity of that document.
Most of the locations are at the cross junction of Street A and Road B, or at public square, say named Fenton Square located at Road B and Road C intersection.
The other information is the name of the participants, and their roles. Say Person A, played the drums, person B the flute and person C distributed the pamphlet X. So the idea is to capture the total amount that was distributed for that time period. They last about 2 or 3 hours. So a start time and end time field would be required, and probably another field to calculate the total time spent. And also a field for Notes, to enter if there was any special occasion, or a public holiday.
I wonder if anyone has come across a template that comes as close as possible to the above idea in Access 2007, since I am using this. Thank u for your response.