You might want to start by studying a bit on normalization. There are a
couple samples that might get you started at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. Look at
both "At Your Survey" and "Employee Evaluation".
Each individual score should create its own record in your table. Don't
create 7 fields for 7 areas or 7 fields for 7 periods. If you do that, you
might want to stick with Excel.
I would expect your table of scores might look something like:
tblScores
===============
scoScoID autonumber primary key
scoDate date of scoring
scoStudentID
scoPeriodID
scoAreaID
scoScore value of score
This could be normalized to remove the date, student, and period to place in
a parent table.
tblScoreEvents
==============
sceScEID autonumber primary key
sceDate
sceStudentID
scePeriodID
sceEvaluator
Then replace the Date, Student, and Period fields from the previous table
with a field [scoScEID] to store the sceScEID value from tblScoreEvents.
--
Duane Hookom
Microsoft Access MVP
"DUNNER7" wrote:
> I am trying to create a form for my teachers to use to keep track of student
> behavior. The form has 7 periods (one for each class period) and 7 areas in
> which the child will be scored. So a 7x7 or 8x8 table, I want the teachers
> to be able to score the kids in the 7 areas for each period and be available
> (on-line) so that each of his/her next teachers can give their scores. The
> totals for each criteria/period would tally based on the assigned score.
> Then a daily total would be tallied taking the totals from each period and
> adding them together. I am assuming that it would have to be based on a
> server to give teachers access to input the information. Can someone give me
> a direction to start building this? I have the summer to experiment and work
> on it. Can I use Access, or can I design a form using infopath and have data
> saved into excel? I would appreciate someone getting me started and I will
> be able to plod along from there
>
> Thanks
> D. Dobbs
>
Similar Threads
