Functional Checklist Survey in Microsoft Word 2010 (part 1 of 9) - Demonstration

This video shows the final end product of a Checklist Survey built in Microsoft Word 2010. IN the next videos, we will show how to make a functional checklist in Microsoft Word. Document is built using Visual Basic Editor and is saved as a Macro Enabled Document (.docm). VBA ActiveX Controls Used: Checkbox, Label, Commandbutton. Survey has checkbox options for a customer satisfaction survey checklist. Commandbutton allows user to clear the survey and all data is auto-calculated.

---

Closed Caption:

hello everybody in this video I'm going
to show how you can create a survey or
check was at microsoft word that is
completely functional
functional meaning that as you go to the
through the checklist or survey
it starts calculating data for you at
the on the survey screen
so the way this one works the customer
satisfaction survey
please raise the level of service using
a scale of one to five
one being an acceptable fi be an
exceptional so
I'm gonna go on to go through these
questions were quick number one how
would you rate the level of Curtis you
experienced buyer service
representatives
I wanna go on that score them as a want
it was completely unacceptable
now I'm gonna show you as a click that
this service statistics when I moved
already
averages I the averages point 33 now
that's a completely accurate because
the way I have this information
calculating on the back and
is that it gets all he gets the bout the
thumb
up the numbers he have selected and
divided by three
so one divided by three we have point 33
that's not the real average but again
I'm so you just for the purpose of the
video on
and how's this gonna work towards the
right on these numbers right here
this is the count once the counter to
use that the release
the fours and fives more like the some
so many gonna go to number two
I'm reflect three so now we have 11
selected and 13 selected
and I'm gonna go on and have
most likely a number and another three
sometime this is actually the count so
we have 11
02 use two threes your fours and your
fives
the total average for 13 in 3s to tie
3-3
now what we can do it once you're done
with this you could clear survey
and it's going to come up are you sure
you want to clear the survey
go if you select no nothing will happen
if we click Clear serving hit yes
the screen is completely cleared and
we're off to a fresh start if this is
something that you're interested in
making
I'm gonna show you how to do that in the
next coming videos now
it's not very challenging to do it it
does require a little bit of programming
but I'm gonna show you step by step on
how to do that and I'm gonna do that
ATO love I've nine different videos and
to give it a break down a bit
the video its the videos are not long
but
and a I'm gonna stress to you it's not
challenging to do
the only the only key is that patients
it does take patience to make
a document like this because you do have
to work program in work
but the way I'm gonna break it down for
you is a Minnesota number one
how to create this page using it i've
you know you
having the checkboxes these these caps
is right here in the butt on the show
you how to do that
I'm a show you how to save the file as a
document that supports macros
and then at their body armor show you
how to set up the developers have
for the Visual Basic Editor which is
that have AC appear you have the
developers have
you probably won't see that on the
screen if you've never than any kinda
Visual Basic programming Microsoft Word
but I must say how how to add this to
your screen number four
I'm gonna give you up the fourth but I'm
gonna show you a little break down on
these controls what these checkboxes art
how to add this but in these are called
ActiveX controls on the show you how to
do that
and number five the fifth video I'm a
show you how to add the coding
the programming code for that the check
boxes and what all do just to make it
easy is the
on that video all this break down into
one video just how to show you how to do
the two boxes for question number one
and I'm gonna do another video for you
were also you had to do two checkboxes
and then the last two and then in the
seventh video
I'm a show you how to add the code for
the clear survey but in in the eighth
video I'll show you how to do the
calculations on how we calculate all the
state in the back end
and then of course number nine the last
things I was just right out putting it
all together
again it may sound challenging but it
really isn't as long as you follow me
step by step
in the next videos you'll be able to get
a survey like this going for your
organization
or for your business whatever they
trying to accomplish I will show you how
to complete this kind of survey or
checklist
I hope to see you next videos thank you
for watching