This is direct toward Duane Hookam developer of the At Your Survey template database but would appreciate any other contributions
First I would like to thank Duane for his contribution to the world of Databases. I work for an non profit organisation that runs many different workshops, training courses, and information sessions, which aim to improve the sustainability of our community. I am building a database to track the evaluations and surveys carried out at the workshops. Using Access I have used Duane’s excellent At Your Survey database a basis for this using a normalised structure.
I would like to design the database so that it allows multiple surveys to use the same questions. The reason being that I need to report how workshops are being received overall and at the individual workshop level across a long period of time and many surveys. All of our evaluations have some standard question I need to survey across, i.e. demographics, and questions that rate course delivery e.g. Was the course enjoyable? In addition to some workshop specific questions e.g. Do you compost.
I need to be able to report across all our workshops over time so we can learn if the public are getting the best value from what we do i.e report across the generic questions, and also across specific workshop types. The At Your Survey design is set up for each survey to be stand alone I need to be able to reuse the survey and the questions, I have tried to incorporate a linking table e.g below that joins a separated survey table and question table.
LinkID | QstnID | SrvID | Question Type
1 | 5 | 3 Generic
2 | 5 | 2 Generic
3 | 6 | 3 Generic
4 | 7 | 3 Workshop Specific
5 | 6 | 2 Generic
6 | 8 | 2 Workshop Specific
Where survey 3 is linked to questions (5,6,7) and survey 2 is linked to questions (5,6,8), However I have run into problems with non updateable queries. I also want to be able to reuse the same survey for many dates. Any suggestions for revised table design and structure or approach that would help me achieve what I want and retain the normalised structure.
Any suggestions most appreciated
Ben
First I would like to thank Duane for his contribution to the world of Databases. I work for an non profit organisation that runs many different workshops, training courses, and information sessions, which aim to improve the sustainability of our community. I am building a database to track the evaluations and surveys carried out at the workshops. Using Access I have used Duane’s excellent At Your Survey database a basis for this using a normalised structure.
I would like to design the database so that it allows multiple surveys to use the same questions. The reason being that I need to report how workshops are being received overall and at the individual workshop level across a long period of time and many surveys. All of our evaluations have some standard question I need to survey across, i.e. demographics, and questions that rate course delivery e.g. Was the course enjoyable? In addition to some workshop specific questions e.g. Do you compost.
I need to be able to report across all our workshops over time so we can learn if the public are getting the best value from what we do i.e report across the generic questions, and also across specific workshop types. The At Your Survey design is set up for each survey to be stand alone I need to be able to reuse the survey and the questions, I have tried to incorporate a linking table e.g below that joins a separated survey table and question table.
LinkID | QstnID | SrvID | Question Type
1 | 5 | 3 Generic
2 | 5 | 2 Generic
3 | 6 | 3 Generic
4 | 7 | 3 Workshop Specific
5 | 6 | 2 Generic
6 | 8 | 2 Workshop Specific
Where survey 3 is linked to questions (5,6,7) and survey 2 is linked to questions (5,6,8), However I have run into problems with non updateable queries. I also want to be able to reuse the same survey for many dates. Any suggestions for revised table design and structure or approach that would help me achieve what I want and retain the normalised structure.
Any suggestions most appreciated
Ben
