looking for an access database that will allow multi student / su.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im looking to set up a database of multiple students / multiple subjects,
anyone help??????
 
Im looking to set up a database of multiple students /
multiple subjects, anyone help??????
Click to expand...

The standard would have 3 tables:
Student, with StudentID(Primary Key), name address and phone fields
Subjects with SubjectID (Primary Key), and related info fields.

StudentSubject with StudentID, SubjectID (both are part of Primary
key and each is foreign key to respective table.

You may want additional tables for Teachers, TeacherSubject, and
StudentSubjectResults. The last is required only if you have
multiple tests throughout the course.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to finding student Rank and How to upload bulk marks of each student at a time. 1
Database for a Testing Center - Tracking dates 1
Looking for exam clashes in excel 0
Posted question converting .mdb to .accdb more info 2
register student to course 0
Sending email to multiple people at once 4
Access linking new student form to new course form 2
Help in setting relationships in Access 3

Back
Top