30 Questions & 300 Students

  • Thread starter Thread starter NFL
  • Start date Start date
N

NFL

I'm sure I asked this same question in the past. Sorry for bringing it up
again.... I did make some progress (thank you for your input!)

I was able to create a many-to-many relationship between classes and
questionnaire. I was also able to create a one-to-many relationship between
student and classes (one student.. many classes). I have a student form
alson with a subform list of classes where you can schedule each student. I
also included another subform (tab) called assessment where there are a list
of questions along with courses that are required for training. There are no
relationships between questions & student though. I'm not sure how to create
a relationship between students and questions. What I like to do, if
possible create a relationship and then create a process where Access can
automatically create a new record of courses needed based on how the
questions are answered (yes/no).

Thank you again for your help
 
I'm sure I asked this same question in the past. Sorry for bringing it up
again.... I did make some progress (thank you for your input!)

I was able to create a many-to-many relationship between classes and
questionnaire. I was also able to create a one-to-many relationship between
student and classes (one student.. many classes).
Click to expand...

Surely that should be a many ao many? Or does each class accommodate one and
only one student?

The classic "school" database has three tables, which could be named Students
(StudentID, LastName, FirstName, other biographical data); Classes (ClassNo,
ClassName, other class data); and Enrollment (StudentID, ClassNo, information
about THIS student in THIS class).
I have a student form
alson with a subform list of classes where you can schedule each student. I
also included another subform (tab) called assessment where there are a list
of questions along with courses that are required for training. There are no
relationships between questions & student though. I'm not sure how to create
a relationship between students and questions. What I like to do, if
possible create a relationship and then create a process where Access can
automatically create a new record of courses needed based on how the
questions are answered (yes/no).
Click to expand...

You'll need an Append query and some VBA code to do this. Again, you surely
need another table - each Student will get many Questions, and each Question
will be asked of many Students.
 
I'm sure I asked this same question in the past.  Sorry for bringing itup
again.... I did make some progress (thank you for your input!)

I was able to create a many-to-many relationship between classes and
questionnaire.  I was also able to create a one-to-many relationship between
student and classes (one student.. many classes).  I have a student form
alson with a subform list of classes where you can schedule each student. I
also included another subform (tab) called assessment where there are a list
of questions along with courses that are required for training.  There are no
relationships between questions & student though.  I'm not sure how to create
a relationship between students and questions.  What I like to do, if
possible create a relationship and then create a process where Access can
automatically create a new record of courses needed based on how the
questions are answered (yes/no).  

Thank you again for your help
Click to expand...

I would start by downloading At Your Survey, available at Roger
Carlson's website http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

Then you can extend it from there.
 
I got the tables (relationships) to work. I'm not sure (understand)
what/how the append query works. However, I did create a query and a form
based on that query. Now I would like to add that information to a table
without removing any data already on that table. Is that possible?

Thank you!
 
I got the tables (relationships) to work. I'm not sure (understand)
what/how the append query works. However, I did create a query and a form
based on that query. Now I would like to add that information to a table
without removing any data already on that table. Is that possible?
Click to expand...

An Append query gets records from one place - a "source", which can be a query
or can be a list of values - and creates a new record in a table, the target.

Since I have no idea how your table is currently structured, nor any idea what
you want added and where you want it added to, I'm a bit flummoxed about how
to reply.

More details please?
 
Back
Top