
July 10th, 2009, 08:34 AM
|
|
Registered User
|
|
Join Date: Jul 2009
Posts: 1
Time spent in forums: 10 m
Reputation Power: 0
|
|
MS Access questionnaire database!!
Hi
I have said yes to constructing a survey questionnaire type database in access 2007
It is for a mining company to asess the impact the mine is having on the community and whether they can create jobs for the locals. I have 28000 questionaires going to print as we speak. once these have been filled in they need to be captured.
I thought this was something easy to do but since I have changed my mind on that. I d/l the Access 2007 Bible and started learning what I can but its 1413 pages and I dont have enough time. I sorta know a bit so far. What I need help with is the basic structure of the database...what tables forms ect any ideas as to how you would go about designing such a database?
I have included a snapshot of a shortened version of the questionnaire that will be issued to 28000 residents of the area. I thought it might help give an idea of what i am dealing with.
I would also like my forms to look similar so the data captures will easily work with it. Then finally I will need to be able to ask questions like how many people who have a drivers license also have a degree in something...that kind of stuff.
thanks
|