Help with MS ACCESS Database

[Ruddy]

Hello All, I am new to MS ACCESS databases, my organization (not for profit) is providing home base care to people living with HIV, we are currently using paper based forms to collect this information and we would like to switch to a database. The information collected on the forms include: Provider name, Provider number, Supervisor name, Date etc. on the client side it's client number, age, sex and the services and supplies given. The services include. Family planning counseling, Nutrition counseling and others, as for supplies, they include, family planing pills, condoms, gloves, water purification reagents etc.. I am trying to make a database that will collect all this information per client for every visit they receive from the provider and what they were given in terms of services and supplies. Can any one help me on how to start this and finally finish it ??? am really running short of time... Thanks in Advance..

[maximus]

Yeah sure will be glad to help out. Need more details regarding what you want to do. You can contact me on my gmail address.

[burrina]

Have you got help yet? Provide as much details as possible so we can help build your table structure and populate the tables with the correct fields for your data.
So far I see 4 tables; tblproviders tblclients tblservices tblsuppliers
I have since come up with a table design for you, but still no answer back from you? I will not build your complete database for you but I am glad to help. Which version of access do you have? Can a provider have many clients? Any other criteria you can think of?