Antone said:
Comparatively speaking, I want to know how good a MS-
ACCESS program is.
A access program is only as good as the writer.
You are asking how good is a word processor, and will it let me write the
next great novel. You are getting confused of the differences of the tool,
and the results of the tool.
So, can a typewriter make a great novel? NO, but a typewriter can be used to
write a great novel. And, ms-word can also be used to write a great novel.
You can create, and write virtually anything you want with ms-access. You
can create a tour reservation system to take skiers to the mountains (done
that!). You can create a whole accounting system that runs a multi-million
dollar company.
You can create a payroll system in ms-access. You are essenticially only
limited by the skills of the developers using the product.
If your goal is to write a system that primarily stores defined data
elements, then ms-access is the right tool.
As for storing testing and scoring results? Sure, ms-access is great as long
as the results are in a defined format.
Are you trying to make a lesson planner here? Or are you trying to store the
results of lessons? Or, track the progress of each student progress along
the lesson plan?
If your problem is not defined, and you can't make a good set of paper forms
with boxes to define everything, then likely no computer system will be of
use. So, really, you are asking if computers are appropriate to solving your
problem?
Are you going to develop a lesson planning system? Hum, you think no one
else has done that yet? ;-)
Have you looked at the zillions of templates and ideas on the web, and found
anything to your liking? (or, were you actually looking for a access based
solution?, and, why does it have to be ms-access?). How much time and
development resources do you have? Depending on how complex, you could be
talking about a considerable investment in developer resources.
My bets that if you apply some good normalizing concepts here..you could
design a good relational system to manage your information requirements.