4a.
SELECT T5COFInstructor.Instructor, T5COFInstructor.COF
FROM T5COFInstructor
ORDER BY T5COFInstructor.Instructor;

4b.
SELECT T5COFInstructor.Instructor, T5COFInstructor.COF, T1CourseOffering.Course
FROM T1CourseOffering INNER JOIN T5COFInstructor ON T1CourseOffering.COF=T5COFInstructor.COF
WHERE ((T1CourseOffering!COF=T5COFInstructor!COF))
ORDER BY T5COFInstructor.Instructor;

(or)

SELECT T5COFInstructor.Instructor, T5COFInstructor.COF, T1CourseOffering.Course
FROM T1CourseOffering, T5COFInstructor
WHERE ((T1CourseOffering.COF=T5COFInstructor.COF))
ORDER BY T5COFInstructor.Instructor;

4c.
SELECT T5COFInstructor.Instructor, T1CourseOffering.Course, T2Course.Title
FROM (T2Course INNER JOIN T1CourseOffering ON T2Course.Course = T1CourseOffering.Course) INNER JOIN T5COFInstructor ON T1CourseOffering.COF = T5COFInstructor.COF
WHERE (([T1CourseOffering]![COF]=[T5COFInstructor]![COF] And [T2Course]![Course]=[T1CourseOffering]![Course]))
ORDER BY T5COFInstructor.Instructor;

(or)

SELECT T5COFInstructor.Instructor, T1CourseOffering.Course, T2Course.Title
FROM T2Course, T1CourseOffering, T5COFInstructor
WHERE T1CourseOffering.COF=T5COFInstructor.COF And T2Course.Course=T1CourseOffering.Course
ORDER BY T5COFInstructor.Instructor;

4d.
SELECT T5COFInstructor.Instructor, T3Subject.Term
FROM T3Subject INNER JOIN (T2Course INNER JOIN (T5COFInstructor INNER JOIN T1CourseOffering ON T5COFInstructor.COF = T1CourseOffering.COF) ON T2Course.Course = T1CourseOffering.Course) ON T3Subject.Subject = T2Course.Subject
WHERE (([T5COFInstructor]![COF]=[T1CourseOffering]![COF] And [T1CourseOffering]![Course]=[T2Course]![Course] And [T2Course]![Subject]=[T3Subject]![Subject]))
ORDER BY T5COFInstructor.Instructor;

(or)

SELECT T5COFInstructor.Instructor, T3Subject.Term
FROM T3Subject, T2Course, T5COFInstructor, T1CourseOffering
WHERE T5COFInstructor.COF=T1CourseOffering.COF And T1CourseOffering.Course=T2Course.Course And T2Course.Subject=T3Subject.Subject
ORDER BY T5COFInstructor.Instructor;