I have designed my own database to collect student test scores and convert them to a level (numerical)
The problem is there are a number of tests and each test is different.
the students sit one of three assessments. Each assessment has its own grade boundaries which are too random to create formulae.
I'm wondering if it would be more effective to create (in excel - then upload to access) 12 tables each with 100 rows, two fields (score and grade)
For example
Lower test1
lower test2
lower test3
medium test1
medium test2
and so on
or whether anyone can think of a more effective idea.
Its a fairly long term project and any ideas would be greatly appreciated. My main weakness as a novice is that I don't see the full potential