Search results

You're right. I really want to get the structure right before doing anything. Please bear with me guys. How much data? I'd say around 500 learners across (500 records in the Learners table) 1200 course instances (1200 records in the Courses table). It's probably around 30-40 unique courses...

Yes, a course have multiple learners and a learner multiple courses. The Courses table that is given to me has (among others) the following fields: LearnerID, CourseID, CourseStartDate, CourseEndDate, etc. 001,C12,... 001,B14,... 002,C12 002,A12 So as such, it's not a list of courses but...

I would still need a third table with the "Progress", "Teacher", "Status" fields, as they are not part of the original linked tables, right? Now by what unique value would I make reference to the original tables? A course has multiple learners/cohorts, a learner has multiple courses.

How to create a table with autopopulated information Edit: Apologies for the generic title 'How' - looks like I pressed Submit before finishing writing the full title:) Hi I'm new to Access. I have been using it for a few months producing simple queries on data generated by the college's...