student advising database

[bluedevil23]

I'm working on a project where the student is advised. I've came up with
several tables but not sure how to link them. I have a STUDENT table which
has a subtype of undergraduate and grauate, ADVISOR table, MAJOR, DEPARTMENT,
COURSE, a linking table of STUDENTCOURSE, DEGREE, GRADE. I don't know if i'm
even on the right track. Can anyone help PLEASE?

 

[bluedevil23]

I am Develop a system that will support the Office of the Associate Dean and
College of Business Administration faculty in the process of advising
students pursing degrees within the College of Business Administration. I
should be able to do a degree audit where advisor look at transcript and give
credit for courses alrady take, advise students - tell students what they
should take, record grades, identify people failing (not satisfactory
progress), identify those ready to graduate, and update student records. Can
anyone lead me in the right direction.. Thanks

 

[John Vinson]

I am Develop a system that will support the Office of the Associate Dean and
College of Business Administration faculty in the process of advising
students pursing degrees within the College of Business Administration. I
should be able to do a degree audit where advisor look at transcript and give
credit for courses alrady take, advise students - tell students what they
should take, record grades, identify people failing (not satisfactory
progress), identify those ready to graduate, and update student records. Can
anyone lead me in the right direction.. Thanks

Your tables in the other post seem to be a good start... but you're
describing a full, complex application, probably involving many hours
of development work. What exactly do you want? Someone to build it for
you? If so you'll need to hire them, that's beyond the bounds of
what's reasonable for unpaid volunteers like us. Help implementing it?
That we can do - post what problems or roadblocks you're encountering
and we'll be glad to help you get around them.

You might want to look into some of the tutorials and support
resources at:

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson[MVP]

 

[bluedevil23 via AccessMonster.com]

Thank you. Those resource pages was very helpful. Thanks again

I am Develop a system that will support the Office of the Associate Dean and
College of Business Administration faculty in the process of advising

[quoted text clipped - 4 lines]

progress), identify those ready to graduate, and update student records. Can
anyone lead me in the right direction.. Thanks

Your tables in the other post seem to be a good start... but you're
describing a full, complex application, probably involving many hours
of development work. What exactly do you want? Someone to build it for
you? If so you'll need to hire them, that's beyond the bounds of
what's reasonable for unpaid volunteers like us. Help implementing it?
That we can do - post what problems or roadblocks you're encountering
and we'll be glad to help you get around them.

You might want to look into some of the tutorials and support
resources at:

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson[MVP]