Students Database

[Abdulaym]

Good day friends, please am new in Ms Access DB. I have a table data contains students biodata, Classes(combo drop-down) & payments. Please do I promote students who are in Class1 to Class2, and Class 2 to Class3 continuously.

[Welshgasman]

Depends on your structure?
If you have Year table, then you would just change the keys that link the Years to the Students.

[madpiet]

What do you mean by Class1 and Class2? Is this a students and classes database? (Oh that done to death database!)
Without an explanation how the different things are related (Students, Classes, Payments), it's impossible to help you.

[Bulzie]

Oh that done to death database!

Yep we should have a goto "Student Database" to point folks to, probably the most requested ask on here .

Abd, good table structure for your database is very important. Without much details on what you are trying to do, think about what data is a solo record (like student demo/bio info, main Classes table), and what data could be multiple records like classes taken per student, payments etc. You will link the Classtaken table and Payment table to your Student table by a StudentID key field (one to many relationship). If you only have a single payment per class you can include that maybe in the Class table instead of a separate table. So tables might be tblStudent(StudendID, StudentName, StudentBirthdate, etc.) tblClass(ClassID, ClassName, ClassDescription, etc.), tblClassTaken(ClassTakenID, StudentID, ClassID, Payment, etc.) So that last table will like to the Student table by StudentID and the Class table by ClassID.