A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

30 Questions & 300 Students



 
 
Thread Tools Display Modes
  #1  
Old September 4th, 2009, 10:29 PM posted to microsoft.public.access.tablesdbdesign
NFL
external usenet poster
 
Posts: 74
Default 30 Questions & 300 Students

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
  #2  
Old September 5th, 2009, 01:26 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 30 Questions & 300 Students

On Fri, 4 Sep 2009 14:29:01 -0700, NFL wrote:

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).


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).


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.
--

John W. Vinson [MVP]
  #3  
Old September 5th, 2009, 02:56 AM posted to microsoft.public.access.tablesdbdesign
Piet Linden[_2_]
external usenet poster
 
Posts: 280
Default 30 Questions & 300 Students

On Sep 4, 4:29*pm, NFL wrote:
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 would start by downloading At Your Survey, available at Roger
Carlson's website http://www.rogersaccesslibrary.com/f...osts.asp?TID=3

Then you can extend it from there.
  #4  
Old September 10th, 2009, 05:25 PM posted to microsoft.public.access.tablesdbdesign
NFL
external usenet poster
 
Posts: 74
Default 30 Questions & 300 Students

Thank you ... it sure helped a lot

"Piet Linden" wrote:

On Sep 4, 4:29 pm, NFL wrote:
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 would start by downloading At Your Survey, available at Roger
Carlson's website http://www.rogersaccesslibrary.com/f...osts.asp?TID=3

Then you can extend it from there.

  #5  
Old September 10th, 2009, 05:32 PM posted to microsoft.public.access.tablesdbdesign
NFL
external usenet poster
 
Posts: 74
Default 30 Questions & 300 Students

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!

"John W. Vinson" wrote:

On Fri, 4 Sep 2009 14:29:01 -0700, NFL wrote:

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).


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).


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.
--

John W. Vinson [MVP]

  #6  
Old September 10th, 2009, 07:14 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 30 Questions & 300 Students

On Thu, 10 Sep 2009 09:32:01 -0700, NFL wrote:

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?


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?
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.