Need database help for food pantry

Discuss the database features

Need database help for food pantry

Postby alisona5 » Sun Apr 10, 2011 3:33 am

I am very new to openoffice and databases. I am trying to create a database for our local food pantry. I have created a form for client registration. It is a very simple form that we will use to put in all of the client's information. I need to create a form for client check in and I am completely stuck. We need to be able to search for the client and record the date. The clients will come in every week or every other week. This check in form will also have to tell us the last time the client came. I don't know how to continually add dates of service for the same person. I hope I am making sense. Does anyone have any ideas on how to do this. I really appreciate any help!
Openoffice 3.3.0
Mac OS 10.5 and Windows XP
alisona5
 
Posts: 1
Joined: Sun Apr 10, 2011 3:13 am

Re: need database help for food pantry

Postby therabi » Sun Apr 10, 2011 3:48 am

First suggestion is to get the documents at [1] and read thru to get a good background of database design. I think you will find what you need in there. If you have questions after that the come back and we can prove help fine tuning the database and forms.
OpenOffice.org v3.3, LibO v3.32 on Ubuntu 10.10 and Win7
User avatar
therabi
Volunteer
 
Posts: 763
Joined: Wed Sep 01, 2010 10:01 pm
Location: USA

Re: Need database help for food pantry

Postby Visa » Sun Jul 10, 2011 6:44 am

You need to understand the database structure design. First of all find out

1. what areas[fields] you need to do the search on.
2. what type of output (on the screen or print on a printer) you need.

Try to resolve the above and then do the database design. Once you do a good structure. Then it is a matter of bringing the data to the screen.
OpenOffice 3.2 on Windows xp pro
Visa
 
Posts: 1
Joined: Sun Jul 10, 2011 6:30 am

[Example] Filtering with Base Forms (using SubForm links)

Postby DACM » Tue Jul 12, 2011 7:23 am

AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
DACM
Volunteer
 
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am


Return to Base

Who is online

Users browsing this forum: No registered users and 4 guests