Prev: Enforce Referential Integrity not available.
Next: ACCESS version migrating from 2003 to 2007
From: Mary on 17 Dec 2009 11:08
I am setting up a db to track the clients that access our pantry. At the end
of the month we produce a report showing non duplicated and duplicated
counts. We offer multiple services, food, clothes, furniture,
salon/barbershop, benevolence funds, parenting classes, thanksgiving
assistance, christmas assistance. I want to track how often they use our
services, zip codes using our service, services provided to a family,
children served from a particular school, and a who recieves what service.
Question: What tables and fields do you suggest as I start my database, or do
you know where a free template I should start with?
--
Positive Direction for Youth & Families, Inc. (www.pdfyinc.com)
From: Duane Hookom on 17 Dec 2009 12:06
Thanks for the good work that you do. Your question is quite broad. If I were
you, I would focus on a small part of the application and then expand as
needed. You might want to read Michael Hernandez's excellent "Database Design
for Mere Mortals, Second Edition"
http://www.viescas.com/Info/books.htm#Database%20Design

You have a lot of questions to answer about your services and clients and
the granularity of the information. Do you need to record only pounds of food
provided or information about each type of food (veggies, baked, fruit,...)?
Do you need to store based on a "household" or do you need information on
each member of the household?

I suggest you begin with some reading. Also, make sure you identify and use
a good naming convention. Check out
http://www.mvps.org/access/tencommandments.htm.

Then come back here with specific questions and ask for our input. If you
haven't had much experience with databases and/or programming, maybe you can
get some student help from UNC Greensboro or other local school.

--
Duane Hookom
Microsoft Access MVP


"Mary" wrote:

> I am setting up a db to track the clients that access our pantry. At the end
> of the month we produce a report showing non duplicated and duplicated
> counts. We offer multiple services, food, clothes, furniture,
> salon/barbershop, benevolence funds, parenting classes, thanksgiving
> assistance, christmas assistance. I want to track how often they use our
> services, zip codes using our service, services provided to a family,
> children served from a particular school, and a who recieves what service.
> Question: What tables and fields do you suggest as I start my database, or do
> you know where a free template I should start with?
> --
> Positive Direction for Youth & Families, Inc. (www.pdfyinc.com)
From: Fred on 18 Dec 2009 07:52
Of course Duane's is the good overall answer. But in parallel with that, you
might think the questions in his second paragraph and about what "entities"
you want to databases (e.g. people? families? services? instances of
services being provided?) and what you mean by a "count". And then repost
with some of the answers and the I think we could help get you specifically
started.


From: Roger Carlson on 18 Dec 2009 09:19
To follow up on Duane's suggestion of reading up on database design, I have
a Tutorial Page that explains what "normalization" is, why it's so
important, and steps you through the process. There are also links to other
normalization FAQs and tutorials at the bottom of the page. You can find it
here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=238

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


"Duane Hookom" <duanehookom(a)NO_SPAMhotmail.com> wrote in message
news:D24C14E5-F811-4FC6-A8D3-9A085D061C31(a)microsoft.com...
> Thanks for the good work that you do. Your question is quite broad. If I
> were
> you, I would focus on a small part of the application and then expand as
> needed. You might want to read Michael Hernandez's excellent "Database
> Design
> for Mere Mortals, Second Edition"
> http://www.viescas.com/Info/books.htm#Database%20Design
>
> You have a lot of questions to answer about your services and clients and
> the granularity of the information. Do you need to record only pounds of
> food
> provided or information about each type of food (veggies, baked,
> fruit,...)?
> Do you need to store based on a "household" or do you need information on
> each member of the household?
>
> I suggest you begin with some reading. Also, make sure you identify and
> use
> a good naming convention. Check out
> http://www.mvps.org/access/tencommandments.htm.
>
> Then come back here with specific questions and ask for our input. If you
> haven't had much experience with databases and/or programming, maybe you
> can
> get some student help from UNC Greensboro or other local school.
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "Mary" wrote:
>
>> I am setting up a db to track the clients that access our pantry. At the
>> end
>> of the month we produce a report showing non duplicated and duplicated
>> counts. We offer multiple services, food, clothes, furniture,
>> salon/barbershop, benevolence funds, parenting classes, thanksgiving
>> assistance, christmas assistance. I want to track how often they use our
>> services, zip codes using our service, services provided to a family,
>> children served from a particular school, and a who recieves what
>> service.
>> Question: What tables and fields do you suggest as I start my database,
>> or do
>> you know where a free template I should start with?
>> --
>> Positive Direction for Youth & Families, Inc. (www.pdfyinc.com)


 | 
Pages: 1
Prev: Enforce Referential Integrity not available.
Next: ACCESS version migrating from 2003 to 2007