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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Tables and Relationships Question



 
 
Thread Tools Display Modes
  #1  
Old March 12th, 2010, 08:05 PM posted to microsoft.public.access.gettingstarted
Lynn
external usenet poster
 
Posts: 428
Default Tables and Relationships Question

I'm wanting to generate evaluation forms for student assignments for a series
of dates. So far I've created the following tables:

Students Table
------------
Name
*StudentID


Assignments Table
--------------
StudentID
*Assignment
Work Location
Start Time

*=Primary key


The problem I can't get my head around is how to handle the table structure
and relationships for the series of dates on which the student will be
training on the assignment. Using a report, I'd like to generate one
evaluation sheet per student for each of the 7 dates they will be performing
the assignment. I know this can be done using separate reports for each date,
but our class sizes are large, and the instructor doesn't want to have to
collate all the evaluation forms for a given student. Is there a way to
accomplish this through table/relationship structure?


  #2  
Old March 12th, 2010, 09:46 PM posted to microsoft.public.access.gettingstarted
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Tables and Relationships Question

Start with the following tables ..........
TblInstructor
InstructorID
InstructorTitle
InstructorFirstName
InstructorLastName

TblStudent
StudentID
FirstName
MI
LastName
other student fields

TblAssignment
AssignmentID
StudentID
InstuctorID
AssignmentDescription
AssignmentLocation

TblAssignmentDate
AssignmentDateID
AssignmentID
AssignmentDate
AssignmentStartTime
AssignmentResult

Your report needs to be a report/subreport. Base your main report on a query
that includes th first three tables. Base the subreport on
TblAssignmentDate. Set the LinkMaster and LinkChild properties to
AssignmentID.

Steve



"Lynn" wrote in message
...
I'm wanting to generate evaluation forms for student assignments for a
series
of dates. So far I've created the following tables:

Students Table
------------
Name
*StudentID


Assignments Table
--------------
StudentID
*Assignment
Work Location
Start Time

*=Primary key


The problem I can't get my head around is how to handle the table
structure
and relationships for the series of dates on which the student will be
training on the assignment. Using a report, I'd like to generate one
evaluation sheet per student for each of the 7 dates they will be
performing
the assignment. I know this can be done using separate reports for each
date,
but our class sizes are large, and the instructor doesn't want to have to
collate all the evaluation forms for a given student. Is there a way to
accomplish this through table/relationship structure?




 




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 01:45 AM.


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