Exam/Results Template

[Guest]

I don't know whether someone can help me but here goes..

I'm looking for an access template which I can use to capture students test
and exam results.

I've tried to build on efrom scratch but it's not working very well. It
would save me a great deal of development time if I could find a template
which already does the job.

I've searched the template site of Microsoft but can't find anything.

Can anyone point me in the right direction?

 

[Guest]

Rob,

I'm unaware of any templates, but if you can describe what you plan to store
(inputs) and how you'd like to use it, including reports, queries, etc.
(outputs), I'm sure one of us can point you in the right direction. The key
is to define your needs as accurately as possible at the outset, so that
well-normalized tables can be defined to suit your needs.

For a discussion of "normalization", see the following links.

ACC: Database Normalization Basics
http://support.microsoft.com/?id=100139
http://support.microsoft.com/?id=209534
http://support.microsoft.com/?id=283878

Database Normalization Tips by Luke Chung
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html

Support WebCast: Database Normalization Basics
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc060600/wcblurb060600.asp

Database Normalization:
http://burks.bton.ac.uk/burks/foldoc/35/28.htm

5 Rules of Database Normalization:
http://www.datamodel.org/NormalizationRules.html

"Understanding Relational Database Design" Document Available in Download
Center:
http://support.microsoft.com/?id=283698
http://support.microsoft.com/?id=164172

ACC2000: "Understanding Relational Database Design"
http://support.microsoft.com/?id=234208

Fundamentals of Relational Database Design:
http://support.microsoft.com/?id=129519

Database Deisgn Principles:
http://msdn.microsoft.com/library/en-us/dndbdes/html/ch04DDP.asp

Sprinks