I would really appreciate any help I can get with this problem. I am a newbie user of MS Access. I’m working on Windows Vista Business OS, 32 bit PC System, and MS Access 2007.
I am building a school database for a small university where I work; the aim is to help simplify my workload. This database is intended to store basic student bio-data, student courses and course plan (by semester and by session year), student fees payments per semester, and finally, student results per semester.
I am still at the tables planning stage (where you would normally create tables and have them linked to each other) but I am stuck and encountering problems with how to create course plans for every single student for every session and for every semester, and then tie these students to results from those courses.
I’ve tried creating a table called course to house all courses and course codes offered by the school but there are many courses offered and I just can’t figure out how to pick out 10 courses out of nearly 200 every semester for a single student. I also tried creating a course-plan table to be a bridge between students table and course table, but that didn’t help much. I’ve worked day and night trying different table designs but I need help. I am not good with programming languages and now I feel I might need a lot of VB to get this database working.
I have attached a picture of my current architecture and the zipped database for you to look at and test. No data within it is sensitive; it’s just dummy data really. I would really appreciate any suggestions.StudentsDB.zip