Access Database Help

[grant_cpt]

Good day

I need help with access. I need to create a database that will later be used in VB.Net program.

See below screenshot


My question is how to I connect the STUDENT table to the COURSE table. So that when I enter the COURSEID in the student table that the student is then registered on that course.

I'm really struggling at the moment, and my brain is siff gedink.

Will appreciate any feedback

Regards
Grant

 

[scudsucker]

You would have a student-course mapping table.

StudentCourseMap
--------------------
StudentCourseMapId (int, primary key)
StudentNo
CourseID


Simple. Allows a Student to be on multiple courses, which is something I assume you want.

Else you may want to map it to Subject, if a Student does not need to take all Subjects in a Course.

Edit - for the love of all that is holy, try not to use Access. it has a few uses, notably learning basic DB use, but the limitations will drive you insane. SQL Server Express is free and way, way nicer to work with.

Once you've got your Access DB working I strongly recommend you migrate to SQL Server

 

[grant_cpt]

You would have a student-course mapping table.

StudentCourseMap
--------------------
StudentCourseMapId (int, primary key)
StudentNo
CourseID


Simple. Allows a Student to be on multiple courses, which is something I assume you want.

Else you may want to map it to Subject, if a Student does not need to take all Subjects in a Course.

Edit - for the love of all that is holy, try not to use Access. it has a few uses, notably learning basic DB use, but the limitations will drive you insane. SQL Server Express is free and way, way nicer to work with.

Once you've got your Access DB working I strongly recommend you migrate to SQL Server

Thank you for your advice. I will try it out now. And yea, Access is driving me insane. But we are required to use Access as it forms part of my ISAT for College.

I will also have a look at SQL Server Express.

Thanks
Grant

 

[Kosmik]

And please don't learn the naming convention 1Student, 2Course etc. Think of them as objects, Student, Course , Subject.

 

[grant_cpt]

And please don't learn the naming convention 1Student, 2Course etc. Think of them as objects, Student, Course , Subject.

Don't worry about that. The final database will have the correct naming convention.

It just there for now to that I can remember the flow of information. Just hate that Access cannot do what I envisioned how I would have liked it to be.

 

[DA-LION-619]

You're learning VB.Net?

 

[grant_cpt]

You're learning VB.Net?

Yip