Student Grades

[BDevil15]

I am looking for a way to grade students in several behavioral categories up to 2 times per day and every day, but not all students will be graded in the same areas. Obviously I need a student table. My categories are called Target Behaviors. And then I need to have grades for each target behavior. I just cant seem to figure out how to link target behaviors to students and then have a form for each student which will have their target behaviors listed and then just plug in points for that day. I hope that makes sense. Ive tried several ways but just cant see it.

Thanks for any help you guys might provide.

[June7]

Students can have many behaviors and each behavior can be associated with many students. You need a table for student info and then probably a table of behaviors info. Then another table that will associate students with behaviors - a 'junction' table.

What have you tried?

Cross post: http://forums.aspfree.com/microsoft-...ng-539103.html

[orange]

Sounds like you may need

tblStudent
StudentId PK
StudentName

tblBehavioralArea
BehaviorID PK
BehaviorName
BehaviorDescription

Because you have many students and many behavior areas you have a Many to Many relationship.
To resolve you need a junction table.

tblJunctionStudentBehaviorByDatePeriod (allows many ratings per day per student per behavior)
studentBehaviourDateID PK
StudentID FK to tblstudent
BehaviorID FK to tblBehavior
RatingDate
RatingValue

The fields with Green first letter should form a composite unique index to prevent duplicates.

This could work if you mean on a given day you rate different categories say 01 in the morning and 05 in the afternoon.
If you rate the same behavior twice on one RatingDate, this structure will not work. I'm not clear on what

several behavioral categories up to 2 times per day

means in real terms. If I have misunderstood, please clarify.

[BDevil15]

What Im hoping for is to have a form that when I open the form it is pre populated with each students target behavior so all I have to do is go down the list and plug in the points for the day.

This is a mockup of what I was hoping for.

http://www.mediafire.com/view/ypx4et...cfa/Access.png

Thanks

[June7]

So you need the junction table that associates students with targets. Then you need another table that records daily points. 'Pre-populating' the daily form with records based on the student/target associations will require running an INSERT SELECT query. You can build this as a query object and run it manually or write a VBA procedure that will run the sql action. Something like:

CurrentDb.Execute "INSERT INTO DailyTable(StudentID, TargetID, DateEnter) SELECT StudentID, TargetID, Now() AS DateEnter FROM StudentTargets;"

The real trick is figuring out what event to put this code into (maybe a button click) and then somehow making sure it isn't accidentally run multiple times when it isn't desired to. And if you want to create records for only a particular student or class, then include filter criteria in the SELECT clause. The issue with this approach is it will create a record for each and every target, even if you don't need to enter points for each and every.