Evaluation Database

[LMB]

Hi Guys,


I use Access 2000.

I was asked to make an excel spreadsheet or a database to track preceptor
evaluations. There are 6 items/questions which the student will circle the
best answer and they can also add free text comments for each question (I
doubt comments will be written in but that's what they want on the
evaluation).

The choices for these questions are .... Very Poor = 1, Poor = 2, Good = 3,
and Very Good = 4.

In addition to these 6 questions, there 3 Free text fillin lines.

I found a survey database
http://www.rogersaccesslibrary.com/OtherLibraries.asp here made by Duane
Hookum (At your Survey 2000) and am currently looking through that and
reading the instructions to see if it will work. I need to get this done in
2 weeks and have a limited amt of time each day to dedicate to it. Has
anybody used this? Would it work for what I am doing? Is there something
else that is geared specifically for evaluations. Below is a sample of 2
questions and 1 free text questions.

The users of the database will print out reports for the preceptors so they
can see the accumulation of results and comments for a period of time.
Additionally, preceptors will be getting coached if an average item/question
total results in less than 3 or if a total of 3 evaluations average less
than 3.

1) Communicates well with all allied health personnel (Choices are above) +
Comments:_____________

2) Knowledgeable when answering questions (Choices are above)+
Comments:__________________

A. What are the strengths of the
preceptor?_______________________________________________

Thanks,
Linda
(e-mail address removed)

 

[Arvin Meyer [MVP]]

I believe it might work with some minor modifications. I've asked Duane to
answer this post if he has time.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[LMB]

Thanks. As I am going through it, I think I need to make the name of the
preceptor the name of the survey. After looking at the queries, I am a
little afraid to use this one because I have no idea for the most part what
is going on with some of them but I'll keep playing around with it.

Linda

 

[Duane Hookom]

I believe At Your Survey would work to create your survey and enter results.
Where you have a two part question with multiple choice followed by a
comment, just create two separate question in the survey. At Your Survey
allows you to create question groups or levels.

Also, you can feel free to do whatever you want with the user interface. The
key feature is the table structure and how it provides a good deal of
flexibility in creating, collecting, and reporting.

 

[LMB]

Thanks. I think I am getting somewhere. <g>

I believe At Your Survey would work to create your survey and enter
results. Where you have a two part question with multiple choice followed
by a comment, just create two separate question in the survey. At Your
Survey allows you to create question groups or levels.

Also, you can feel free to do whatever you want with the user interface.
The key feature is the table structure and how it provides a good deal of
flexibility in creating, collecting, and reporting.

 

[caloy]

Linda,
May I suggest "Rentacoder.com" if you're searching for help putting your
database in 2 weeks. I have had experience working with coders (especially
dannywareham from England) in this site. They are very professional and
inexpensive.

http://www.rentacoder.com/RentACoder/default.asp

 

[LMB]

Thanks, I'll take a look.

Linda

Linda,
May I suggest "Rentacoder.com" if you're searching for help putting your
database in 2 weeks. I have had experience working with coders (especially
dannywareham from England) in this site. They are very professional and
inexpensive.

http://www.rentacoder.com/RentACoder/default.asp