R
Registrar
Guest
Hello everyone, I am a self taught Access 2000 person and have not done any programming. I have designed a student records system or my small institution but now we are entering a new partnership with other colleges which needs a database which gives all the standard requirements however the modules which are taught will be taught in more than one teaching centre, possibly at the same time: for example Learning Skills could be taught by different tutors in different centres on the same day of the week. No centre will teach the same module at the same time. Students will have the option of studying at more than one centre - so they might do Tuesday night at north centre and Saturday afternoon in south centre.
Currently I select the modules which will be available each semester and make these available in a drop down menu so that when I click on each student I can register them on the module they require.
How can I most easily do this in my new environment. Should I give each seperate teaching of the Learning Skills Module a Code which identifies it, i.e., North Learning Skills, East Learning Skills and so on. I could see this becoming very unwieldy giving a drop down menu of 200+ items.
Or is there another way?
Currently I select the modules which will be available each semester and make these available in a drop down menu so that when I click on each student I can register them on the module they require.
How can I most easily do this in my new environment. Should I give each seperate teaching of the Learning Skills Module a Code which identifies it, i.e., North Learning Skills, East Learning Skills and so on. I could see this becoming very unwieldy giving a drop down menu of 200+ items.
Or is there another way?