Using Microsoft Access, I would like to
create a database for a school
w/student count=500, and staff count=30.
The school's administrators should be able
to INPUT, then SAVE, EACH occurrence
of policy violation by ANY student. Said
administrators should also have capability
to RETRIEVE, VIEW, EDITand REPORT
a student's record of policy violation.
Help!!
What is your specific question? (For good suggestions on effective use of
newsgroups, see the FAQ at
http://www.mvps.org/access/netiquette.htm.)
To help you get started, you'll likely need tables for
Students, with fields
StudentID
StudentLastName
StudentFirstName
(... other student information)
Administrator
AdminstratorID
AdminstratorLastName
AdministratorFirstName
(... other adminstrator information)
PolicyViolation (this table contains the
possible kinds of policy violations, not
specific violations by a particular student)
PVID
PolicyViolationDescription
(... other information about policy violations
StudentPolicyViolation
StudentID (foreign key to Student table)
PVID (foreign key to PolicyViolation
Date/Time of Violation
AdminstratorID (foreign key to Adminstrators
table -- Adminstrator making entry)
(... other information about this specific policy violation)
What actual information you keep, and what you do with it, will depend on
your specific requirements. I've never heard of a "standard policy violation
database", but that doesn't mean there isn't one.
Larry Linson
Microsoft Access MVP
