courses query

[pal]

hi everybody

i have database about a college and i want to build up a queriy that help me to find out the student who can take a specific coures depend on the pre requisit for the coures (if there is)

so the quiry shoud have one input (ID course) and search for the students that can take it who take the prereqisit of this course already


the database consist from this tables:
*courses
contain the courses of the college
*prereqisit
contain the prerequisit courses
*students
information about the students
*enrolment
contain the courses that the students have it


the db is attach

plz i need ur helps


waiting

 

[MStef]

Look at "demoStudentsCoursesA2000.mdb" (attachment, zip).
Look at tables, queries, forms, Module1.
Open MainForm and try.
Important:
You must have all the Courses in the table Courses.
???? cours 103322 or 101322 ??? the same name ???
I think it is what you need.

 

[pal]

hi

thanx alot MStef for ur reply

i will view it carfully,then i will let u know if it is or not

so plz keep on touch : )

thanx

 

[pal]

hi
first thanx alot Mr. Mstef
The solution was perfect and exactly what i need
just i need additional thing to add for the db
there are some courses that dosent depend on other courses to be taken
it just need the student to complete a specific cridet houres
to be taken
the courses are the following:
101408 Ethical Aspects of Eng. & CS >70 hrs.
101461 IT/ Marketing Research >70 hrs.
101490 Computer Software Lab >70 hrs.

101493 CS Seminar >80 hrs.
101494 Senior Project I >80 hrs.
101495 Training >80 hrs.

102594 Senior Project I >100 hrs.
102595 Training >100 hrs.
102493 CE Seminar >100 hrs.

so i need to ckech if this student complete the demand hours inorder to
take this courses in the same query(if that possible)

thanx alot in advance for ur help

 

[pal]

plzzzz


any help