Help with school record keeping

[Dennis]

I am a new user of Access 2003 and am looking for some information for a
record keeping project at an elementary school. I need to set up tables for
teachers to record scores on assignments and tests. These scores should also
be used to determine the meeting of state standards as shown in another
table. Sometimes, a number of scores must be combined to determine
proficiency on a standard. Can I do this in Access. If so, what do I need to
read in order to set this up?

 

[apenwarr]

I am a new user of Access 2003 and am looking for some information for a
record keeping project at an elementary school. I need to set up tables for
teachers to record scores on assignments and tests. These scores should also
be used to determine the meeting of state standards as shown in another
table. Sometimes, a number of scores must be combined to determine
proficiency on a standard. Can I do this in Access. If so, what do I needto
read in order to set this up?

Microsoft actually makes an Access template specifically for this:

http://office.microsoft.com/en-us/templates/TC010184071033.aspx

Good luck!

Avery

http://eqldata.com - instantly publish any Access database on the web

 

[Dennis]

Avery,

Thanks for the link. This will help me set up a gradebook table. I will also
need to learn how the cells in one table can determine the input for cells in
a different table.

 

[John W. Vinson]

Thanks for the link. This will help me set up a gradebook table. I will also
need to learn how the cells in one table can determine the input for cells in
a different table.

Well.... your first step is to "unlearn" what are apparently concepts holding
over from Excel. Databases are NOT spreadsheets; they do NOT have cells; and
you would very rarely if ever use "cells in one table to determine input for
cells in a different table". The fields (not cells!) in a Table (not a sheet!)
should NOT depend on any other table; if you can calculate a value in a field
based on other fields (in this table or another table), then that field should
simply not exist. The table should contain only "real" data; any calculated or
dependent values would NOT be stored in the table at all, but would instead be
calculated or looked up on the fly in a Query.

See these references, particularly Crystal's and Allen's tutorials:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials