creating forms for compiling evaluations

[demolitionwoman]

I should preface this with the fact that I am NOT a techie at all - but I'm
pretty decent at poking around and figuring things out.

Here's my situation: I work for a company that offers workshops. We have
our customers fill out an evaluation form for the workshop they attend. So
we'll typically have at least 15-20 feedback forms for each workshop; we
offer 10-12 workshops a year. I want to start compiling these in Access, so
that I can run reports on things like where they found out about us, their
satisfaction level, how many coupons were used, etc.

I'm having some confusion about creating tables and forms for this purpose.
Do I just create one table and one form, so that each individual feedback
form gets entered and then I can create queries from that? Or should each
workshop get its own table and form?

I'm feeling overwhelmed by options - any info/help is greatly appreciated

 

[Randy Harris]

I should preface this with the fact that I am NOT a techie at all - but I'm
pretty decent at poking around and figuring things out.

Here's my situation: I work for a company that offers workshops. We have
our customers fill out an evaluation form for the workshop they attend. So
we'll typically have at least 15-20 feedback forms for each workshop; we
offer 10-12 workshops a year. I want to start compiling these in Access, so
that I can run reports on things like where they found out about us, their
satisfaction level, how many coupons were used, etc.

I'm having some confusion about creating tables and forms for this purpose.
Do I just create one table and one form, so that each individual feedback
form gets entered and then I can create queries from that? Or should each
workshop get its own table and form?

I'm feeling overwhelmed by options - any info/help is greatly appreciated

If the data structure is the same from workshop to workshop and you might
wish to do some sort of summary reporting later on (end of year or whatever)
then the data should all be in one table.

 

[John Vinson]

I should preface this with the fact that I am NOT a techie at all - but I'm
pretty decent at poking around and figuring things out.

Here's my situation: I work for a company that offers workshops. We have
our customers fill out an evaluation form for the workshop they attend. So
we'll typically have at least 15-20 feedback forms for each workshop; we
offer 10-12 workshops a year. I want to start compiling these in Access, so
that I can run reports on things like where they found out about us, their
satisfaction level, how many coupons were used, etc.

I'm having some confusion about creating tables and forms for this purpose.
Do I just create one table and one form, so that each individual feedback
form gets entered and then I can create queries from that? Or should each
workshop get its own table and form?

I'm feeling overwhelmed by options - any info/help is greatly appreciated

Check out Duane Hookum's "At Your Survey" sample database: it's very
close to what it sounds like you want.

www.rogersaccesslibrary.com/duanehookom/AtYourSurvey.zip


John W. Vinson[MVP]

 

[demolitionwoman]

That's definitely helpful - thank you!

Check out Duane Hookum's "At Your Survey" sample database: it's very
close to what it sounds like you want.

www.rogersaccesslibrary.com/duanehookom/AtYourSurvey.zip


John W. Vinson[MVP]

 

[Duane Hookom]

You're welcome.

--
Duane Hookom
MS Access MVP

That's definitely helpful - thank you!