Customizing Access 2003 Classroom Management Template

[Marin Hunter]

Hi,

I am working with the Access 2003 classroom management template and I am
trying to customize it to allow me to add classes to the student form via a
subform for classes. In my previous attempt to add subforms and tables I was
able to add classes on the student form, but the student was not reflected on
the class page. I am not sure if this is too specific of a question or not
specific enough. However, I appreciate any advice you can provide.
Thank you in advance for your help.

 

[Larry Linson]

I am working with the Access 2003 classroom management
template and I am trying to customize it to allow me to add
classes to the student form via a subform for classes. In my
previous attempt to add subforms and tables I was able to
add classes on the student form, but the student was not
reflected on the class page. I am not sure if this is too specific
of a question or not specific enough. However, I appreciate
any advice you can provide.

I haven't used the template you mention, but if you could be more specific
about the Tables (or Queries) involved, and the specifics of the forms,
perhaps we could help with issues regarding subforms.

And, yes, you are correct that the question is not at all clear to me from
"In my previous attempt to add subforms and tables I was able to add classes
on the student form, but the student was not reflected on the class page."
How did you attempt to show the student on the "class page" and how is the
relationship between students and classes shown?

A normalized design would likely have a Students table, a Classes table, a
ClassInstances table, and some junction/join tables to show the many-to-many
relationships between students and class instances. That is a Class might
be European History 201, and the instance be the session of that class that
meets at 10AM on Mondays, Wednesdays, and Fridays, in which multiple
students would be enrolled; another instance of that class might meet on a
different schedule, say 2PM on Tuesdays, Thursdays, and Saturdays.

Larry Linson
Microsoft Access MVP

Larry Linson
Microsoft Access MVP

 

[Michael Gramelspacher]

@microsoft.com>, =?Utf-8?B?TWFyaW4gSHVudGVy?= <Marin
(e-mail address removed)> says...

Hi,

I am working with the Access 2003 classroom management template and I am
trying to customize it to allow me to add classes to the student form via a
subform for classes. In my previous attempt to add subforms and tables I was
able to add classes on the student form, but the student was not reflected on
the class page. I am not sure if this is too specific of a question or not
specific enough. However, I appreciate any advice you can provide.
Thank you in advance for your help.

Here is something I did. It is not exactly like Classroom
Management, but it does have a form for assigning students to
classes.
http://www.psci.net/gramelsp/temp/Attendance2.zip