I'm emailing to inquire how a VBA-based application be maybe be made in
Excel or Access that helps to schedule students in classes. For
example, the app should allow the following:

Inputting and removing students.
Inputting and removing classes/teachers.
Assigning students to classes, based on 6 classes per day (quarter
system).
Notification of class conflicts if students are omitted or scheduled
multiple times, or class sizes become too large.
Reporting of class schedules per hour and grade.

Additional features that would be handy:
Track the classes that students had been in previously (in data tables
or other sheets).
Drag & drop of student names into class slots.

This would be for a very small school, with 150 students max and 15-20
classrooms, 15-20 teachers.

Online, I've seen several apps that have this functionality, but no
templates in Excel or Access. Thanks for any advice/assistance.

Arnold