will anyone help me?

[dreamdelerium]

hey guys, i also have another request. i created a program with access and was wondering if anyone would be willing to look at it. i would like to get feedback on:



1. Table/DB design

2. User freindlyness/form design

3. anything else that you might find



I am working with an NGO doing research on health facilities throughout Botswana, africa. we will be conducting surveys (about a 1000 of em). My boss wanted something that would collect all the info in a DB (to clean and normalize the data so that it can be exported to SPSS).

My boss wanted the following features:



1. forms that would ensure data is entered into the tables correctly (prevent user from entering answeres that dont fit the question)

2. store info in tables

3. allow past saved questionaires to be loaded, reviewed, and save changes

4. look at simple trends in responses (using reports)



If anyone is willing to help me, i can send you the database with a more detailed write up on what it is suppose to do. thanks



jason

[Hack]

Is this strickly Access VBA?

[dreamdelerium]

yeah. its all done with access VBA. interested?

[Ecniv]

Basic survey system I am using atm in one app - still need to tweak it more


Tables
- Surveys
---- name of survey, start / expiry date etc (yes/no text - if not yes and no)

- SurveyQuestions
---- each question with a number (to order/display), survey id

- SurveyPerson
---- info on person completing (if required - if not just the id will do!)

- SurveyPersonResponses
----- the person id, survey id, question id, and the response

- QuestionTypes
---- types of answer... I have gone with text, text and number, yes/no + text


That should do for most - the only type it doesn't cater for is multi choice, but I am sure you could get around this with a second text box and values on the check boxes.... bit difficult to display tho.



Only an option tho - there are softwares already out there that do this plus stats... depends on money and if you can get them.

[dreamdelerium]

thanks, but i already created it. i just wanted some one to take a look at it before we start using it, to check to see if everythings looks good and spot any forseeable disasters. i would also like feedback on the database/form/vba design