Search results

jdraw, Yes, more new students to come and start at any level, brothers and sisters involved in the school system too.

Just a technical question, can I make the student register for the level first in separate junction table, then go to the StdCrseAtlvl. I tried to make many to many relation between Students and Levels and then link them (by their link table) to StdCrseAtlvl but I got error "No unique index in...

Many thanks jdraw, worked. However, You have touched the point that if the student doesn't pass the level, then how to handle it ? in my school, it is allowed for each student to fail three times per level. Please extend your model with some ideas.

Many thanks jdraw, Let me ask two questions about your model 1- How the data should entered to the system by the user? I mean how to organize my forms to make the user enter the information ? 2- There is no academic year in the all tables, can ?

Sorry, mike60smart ! I couldn't got your tips. Please suggest a general structure to me

And if not ? I have attached the table you asked

Before I upload it, could you just answer my question "By the way, I need to get the point her, could we consider the Math course in level 1 and level 2 as same ?"

They cover different subject. Subject of session can be examined at session 1, for session 2 there will be another subject to be examined.

This is a part of my problem. I would like to make it a user defined courses, because some courses shared by many levels but with different context. For example, level 1, level2 and level 3 all include English and Math courses, but the topics are no the same for sure. By the way, I need to get...

Thank you jdraw for the replay. In fact, my system is not student dependence but level dependence. So all students for level 1 for example will have same courses, and all courses are mandatory for each students of that level. Regarding the exams or test, yes you are right, for each course there...

jdraw, OK, I will clear it up to you. My database is about a student grades system in secondary school. The school include 6 levels (Level 1 to 6), each level has it won courses to register for. So, let say a student has joined the school, he/she has to start from level 1 for the first year...

I tried many approaches, but at each one I stuck in middle of the road. I have attached the database which include the tables and their relationships.

Hello everybody! I need help to move on on my database. It is a secondary school (as it called in my country) database which include 6 levels. A student join the school, and must to pass the 6 level (one level per year), so the student will stay at least 6 years. Then, at each year there are...

Hi Everybody, I'm using the following expression to find the sum of the current month sales. =DSum("[Price]*[Quantity]","QueryCurrentMonth Sales","[ORDDate]=Month (now())") However, it returns no result. Can anyone help please. Thank you. Note: the above expression is located on the control...

Hi everybody, I'm not very to Access. I'm trying to make a query to filter or show only those customers when it is the time for their monthly payment . The query I have consists of four fields which are 1- Order ID 2- Payment 3- Date (Default value set to Date ()) 4- Date for next time...