Creating a training package and interactive questionnaire

[EliseFreedman]

Hi There

I have been asked by my boss if I am able to create a training package and short questionnaire for one of our initiatives that is currently being rolled out across the company.

I think I can do most of what I want using Powerpoint - interactive slides etc. My main snag is that I'm not sure how to store the results that are obtained from the questionnaire. Would I be better off using a specialised computer package. The trouble is I dont know whether there would be a budget for this. I think my boss was thinking more along the lines of something simple.

 

[combo]

Personally I'd prefer excel:
- it's easy to store results in single hidden worksheet,
- you can navigate between sheets using macros or hyperlinks,
- you can hide tabs and unused rows and columns, protect cells, so you will get focus on active part of worksheet,
- you can use controls from 'forms' toolbar, it can sometimes allow to build interactive workbook without macros (sufficient for single questionnaire),
- you can build a simple code to consolidate results in case of one workbook - one questionnaire solution.

combo

 

[fumei]

I would have to agree. It depends on your actual requirements, but Excel may be best. Especially if you are intended to retain data from the questionnaire. I am decidely more of a Word person, but in this case - if it is a simple questionnaire - then Excel sounds like your best bet.

Gerry

 

[SkipVought]

Geez, I have to agree with Gerry?

Reluctantly, but wholeheartedly with combo!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

Geez, I have to agree with Gerry?

That must be a first.

I can see why you would be reluctant. I agree - but then I usually DO agree with you - I would be as well, but all things considered, it is likely the best route.

You certainly can store data from a Word document questionnaire. Either within the document itself with DOCVARIABLE, or writing to a separate wee text file.

As stated, it depends on the requirements. If the questionnaire has even a moderate amount of text, then I would be tempted to go the Word route, as Excel handles text....sorry....badly. Word for the questionnaire, Excel to hold the data.

Gerry

 

[dhookom]

Personally I'd prefer excel:
- it's easy to store results in single hidden worksheet,
- you can navigate between sheets using macros or hyperlinks,
- you can hide tabs and unused rows and columns, protect cells, so you will get focus on active part of worksheet,
- you can use controls from 'forms' toolbar, it can sometimes allow to build interactive workbook without macros (sufficient for single questionnaire),
- you can build a simple code to consolidate results in case of one workbook - one questionnaire solution.

Looks like a good case for justifying Access ;-)
I suppose if all you have is a hammer than everything becomes a nail.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

Ooof! Ouch!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

Ouch indeed.

Gerry