Tables and Relationships Question
in [Getting Started]
|
Prev: Import Multiple CSV Files Into Access 2007
Next: Best way to enter addresses, body of letter, closing, etc. Macros?
From: Lynn on 12 Mar 2010 14:05 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?
From: Steve on 12 Mar 2010 15:46
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 santus(a)penn.com "Lynn" <Lynn(a)discussions.microsoft.com> wrote in message news:68A49DFE-727E-4537-9E82-8C8C085EC07B(a)microsoft.com... > 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? > > |