access question?

H

houssam_ballout

New Member
Hello all,
I am doing my project for my university, The project is about making a registration in the university for students and also for tutors, I want for help on this question:
how could I translate the fact that a student have registered for many courses, I mean how could I make this implemented using MS Access?
Any suggestion, even if it is not related to this question.
Thanks for supporting.

houssam
 
access question2

Hi all,
If I have a form created on MS Access, could I copy it the same to VB, so that users could exactly perform operations the same on Access form?
thanks again for caring
mention: Any suggestion and comments are Acceptable
with my regards: Houssam
 
You will want to use a 1 to many relationship between your student number (or whatever unique student identification you're using) and the table that keeps track of course registration.
If I have a form created on MS Access, could I copy it the same to VB, so that users could exactly perform operations the same on Access form?
Click to expand...
I don't think that works. It's easy enough to create a similar form in VB and use the dataset control to control access.
 
yeah, I have made it, but how this could be implemeted in access, I mean what fields I must use to translate this fact
also a technique question: y my 2 questions have been collapsed here?
 
I don't understand what you're asking here
I mean what fields I must use to translate this fact
Click to expand...
I thought you were asking how to transfer a MS Access form to VB but your last post makes it sound like your going the other way.

As to why I answered both your questions in the same post: because I can address both in 1 post, there is no need for me to make 2.
 
okay got u , but for the first post: suppose that a student has registered for courses x and y,
how could I make it in access ? ( I am sorry I bother u(
 
houssam_ballout said:
Hello all,
I am doing my project for my university, The project is about making a registration in the university for students and also for tutors, I want for help on this question:
how could I translate the fact that a student have registered for many courses, I mean how could I make this implemented using MS Access?
Any suggestion, even if it is not related to this question.
Thanks for supporting.

houssam
Click to expand...


If you give each student a unique ID, one table can be used with the ID being a primary key with all of the students info... SS# address... phone numbers... then ANOTHER table were thr primary key is just an auto number and a foreign key which is the unique student ID. Each row in this table with have the foreign key and the class name and # that the student is registered in.

So there might be 5 rows with the same unique student ID but each row will have a different registered class name and ID...

Hi all,
If I have a form created on MS Access, could I copy it the same to VB, so that users could exactly perform operations the same on Access form?
thanks again for caring
mention: Any suggestion and comments are Acceptable
with my regards: Houssam
Click to expand...

Are you talking about VBA? VB 6.0? VB.NET? If you created Macros in MS Access, there is VBA (Visual Basic for Applications) code behind them. YOu can convert the Macro into VBA... But, if you are using Visual Studios 6.0 or .NET it will take a lot more than cut and paste....
 
I should really draw a picture but lets see if this helps first.

Code: 
Student Table
StudentID <- Primary Key---------
Name				|
...				|
whatever other fields		|
...				|
				|
Course Table			|
CourseID <-Primary Key------	|
CourseName		   |	|
...			   |	|
whatever other fields	   |	|
...			   |	|
			   |	|
CourseRegistration Table   |	|
CourseID <------------------	|
StudentID <----------------------
Link The fields with the relationship tool
 
well, I am using access for that database and VB for the interface for my application, but from ur info, I will use access and then using the macros I could create them.
thanks
but still I couldn't figure out how could I give for a student with ID 45 the courses x, y, z, do I need to create another table for that purpose?
 
Beat me to it Cromewell....

(I was going to use Visio if he did not understand.... :rolleyes: )
 
yeah, thats what I have done exactly
but going into implementing the system, if I have go for the username with ID 345 (for ex) , and I want to register her for 3 courses, do I need more fields for that ?

or do I need to create a table for each course????? (that's what I am looking for)??could it work?
 
You just insert every course into the courses table. Then to 'register' a student for a course you insert the student ID and course ID into the registered courses table.

Yeah, Visio is a good tool for drawing this stuff out. Does it have any automagic generation? (ie draw a DB out and it can export it to Access)
 
houssam_ballout said:
well, I am using access for that database and VB for the interface for my application, but from ur info, I will use access and then using the macros I could create them.
thanks
but still I couldn't figure out how could I give for a student with ID 45 the courses x, y, z, do I need to create another table for that purpose?
Click to expand...

I see. You CAN use VB just for the form. and ACCESS for the database. I did not understand your question the first time.

Are you using Visual Studios 6.0? They have a great tool that allows you to create an ACCESS database right from VS 6.0.


As for the database, you need multiple tables.. Cromewells previous post explains this perfectly.
 
I assume you don't need to consider support staff, but if you do it doesn't matter, all employees should have a common superclass
 
so for now, I will need to create a database that will hold the following (temporarly) tables: students (id, name, ...) tutor (id, name,....) course (title, major, ..) .....
by the way, I have to create a table for each course right???
 
houssam_ballout said:
by the way, I have to create a table for each course right???
Click to expand...

No, one table can hold all of the courses... each course should have a course ID which will be the primary key.
 
You must log in or register to reply here.
Back
Top