The following query
SELECT CoursesIndividuals.ID, CoursesIndividuals.FirstName, CoursesIndividuals.LastName, Courses.Date, CoursesIndividuals.CourseName, CoursesIndividuals.Attendee, Courses.Venue, CoursesIndividuals.StartTime
FROM CoursesIndividuals, Courses
WHERE...