L
LBRT
I know it is highly recommended not to store a calculated field in a table -
I have read numerous questions and replies here similar to mine and I want to
ask anyway.
I am working in A2002 but will move it to A2007 within the year. Right now,
in 2002 (XP).
I have a tblData containing multiple records indexed by kid ID, date tested,
test ID, and scale (subtest) ID. A kid could have 4-5 raw scores on several
(test)x(scale) combos. For example, TestAbility with Scale1Rdg, Scale2Math,
Scale3Voc. Teachers test twice a year with some tests/scales; monthly with
others. I identify the testing events by the date tested.
Almost all test info is entered as a total raw score [number correct] on a
date using a test and scale. I have other tables used to translate the raw
score on a test/scale - based on the kid's age at testing - into various
normed equivalent scores. These other tables would function like large
look-up tables. In fact, I have not figured out the translation in Access yet
and am still using Excel to translate (recode) raw scores into the 5-7 scores
from the norms tables.
My question: one test has three scales - each scale gives a raw score. Let's
call it TestP, Scales 1, 2, and 3. Thirty-one items all together. Teachers
enter the raw "score" or value (a rating) for each of the 31 items into a
data entry form or mark a scan sheet that dumps similar data into a CSV file
for me to import. Each record in this tblDataEntryTestP represents one kid
for the entire test - all 3 scales represented in the 31 items - on a
specific date. This “testing†will be done 2-3 times per year.
My frmDataEntry accepts the individual item scores for all 31 items,
calculates in 3 fields the scale totals (Scale1Total, Scale2Total,
Scale3Total). What I want to do is create three records for tblData after all
31 item values are entered on this form: one record each for these three
scale totals using the kid's ID, date tested, and the test ID (TestP) and
each scale ID, and Scale[#]Total=RawScore in that tblData record.
I think I need to store these totals for that date tested because they are
meaningless until I translate each raw score (Scale[#]Total) into the 4-7
normed equivalent scores. I would maintain the raw scores with all those for
the other tests and scales in tblData, translate all raw scores to normed
equivalents when it comes time for reports and statistical analysis database
creation.
Right now I am asking what I need to do in the frmDataEntry to create these
three records (one for each scale score total) and write them to tblData. I
am guessing it involves AfterUpdate event but on the whole form? A field in
the form?
Your patience and attention in assisting me is deeply appreciated!
LBRT
I have read numerous questions and replies here similar to mine and I want to
ask anyway.
I am working in A2002 but will move it to A2007 within the year. Right now,
in 2002 (XP).
I have a tblData containing multiple records indexed by kid ID, date tested,
test ID, and scale (subtest) ID. A kid could have 4-5 raw scores on several
(test)x(scale) combos. For example, TestAbility with Scale1Rdg, Scale2Math,
Scale3Voc. Teachers test twice a year with some tests/scales; monthly with
others. I identify the testing events by the date tested.
Almost all test info is entered as a total raw score [number correct] on a
date using a test and scale. I have other tables used to translate the raw
score on a test/scale - based on the kid's age at testing - into various
normed equivalent scores. These other tables would function like large
look-up tables. In fact, I have not figured out the translation in Access yet
and am still using Excel to translate (recode) raw scores into the 5-7 scores
from the norms tables.
My question: one test has three scales - each scale gives a raw score. Let's
call it TestP, Scales 1, 2, and 3. Thirty-one items all together. Teachers
enter the raw "score" or value (a rating) for each of the 31 items into a
data entry form or mark a scan sheet that dumps similar data into a CSV file
for me to import. Each record in this tblDataEntryTestP represents one kid
for the entire test - all 3 scales represented in the 31 items - on a
specific date. This “testing†will be done 2-3 times per year.
My frmDataEntry accepts the individual item scores for all 31 items,
calculates in 3 fields the scale totals (Scale1Total, Scale2Total,
Scale3Total). What I want to do is create three records for tblData after all
31 item values are entered on this form: one record each for these three
scale totals using the kid's ID, date tested, and the test ID (TestP) and
each scale ID, and Scale[#]Total=RawScore in that tblData record.
I think I need to store these totals for that date tested because they are
meaningless until I translate each raw score (Scale[#]Total) into the 4-7
normed equivalent scores. I would maintain the raw scores with all those for
the other tests and scales in tblData, translate all raw scores to normed
equivalents when it comes time for reports and statistical analysis database
creation.
Right now I am asking what I need to do in the frmDataEntry to create these
three records (one for each scale score total) and write them to tblData. I
am guessing it involves AfterUpdate event but on the whole form? A field in
the form?
Your patience and attention in assisting me is deeply appreciated!
LBRT