How To Create Quickly??

[Guest]

Hi All,

I am trying to create a Database to keep track of Employee Quarterly
Performance and Improvement. I’ve tried creating this thing at least 10
different ways and still can’t get what I’m looking for. I need the DB to
hold just 21 questions, Persons Full Name and Site supported. I’ve already
tried to create a table with all 21 questions but had to try and keep the
questions within 64 characters due to the limitations of the Field Name Size.
I also had a table with 4 option boxes to determine the progress of the
person, for example (Option Box 1 will be labeled as EE with a Value of 4,
Option Box 2 will be labeled as AE with a Value of 3 and so on. I just want
to create a form that has all 21 questions along with all 4 option box
choices for each question. In a nutshell I just want to create something
similar to an online survey. When I print a report, I would like the question
and the option picked to print out for that particular person.

I hope I’m not confusing anyone and hopefully some one is able to help me.

 

[Amy Blankenship]

Try this:

tblQuestions
===========
QuestionID: Unique Identifier of the question (autonumber)
QuestionStem: Text of the question

tblEmployees
==========
EmployeeID: Unique identifier of an employee (autonumber, probably, unless
you have something in place)
FirstName
LastName
Etc

tblSite
=====
SiteID:
SiteDescription
etc

tblEmployeeSites
===========
EmployeeID
SiteID

tblQuarters
========
QuarterID
QuarterStart
QuarterEnd

tblValues
=======
ValueID
ValueDesc (would be your AE, EE, etc.)

tblQuarterlyQuestionaire
=================
QuarterID : quarter this is for
EmployeeID : employee this is for
QuestionID : question asked
ValueID : value selected

Note this assumes there will ever only be one questionaire in play. If you
need more than one questionaire in the system, post back for modifications.

HTH;

Amy

 

[Duane Hookom]

Take a look at both the Employee Evaluation and At Your Survey demos found
at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. These
are both very similar and might get you headed in the normalized direction.

Come back here if you have other questions.