The AES Company found the five queries already created to be very useful. Of course, you know what that means. The AES Company is ready to have you add even more.

Please add the following to your database you created in Unit 7:

1. Create a query that shows all instructors and the courses that they teach. All instructors need to be shown, regardless if they teach any courses or not.

Include the following fields in this query:

a. Instructor ID

b. Instructor First Name

c. Instructor Last Name

d. Course Number

e. Course Name

f. Save this query as U8_query_Instructor Assignments

2. Use the above query to create a report that displays the same fields.

a. Save this report as: U8_report_Instructor_Assignments.

3. Create a query that displays the highest and lowest Instructor Pay Scale.

a. Save this query as: U8_query_pay_scale.

4. Create a query that displays only those instructors that make more than $25/hr. and teach a 200 level course.

a. Save this query as: U8_query_Instructor_200_level.

5. Create a query that displays only instructors that have a last name that begins with the letter "S."

Display the courses they teach in your results.

a. Save this query as: U8_query_Lastname_S.

6. Create a form that displays all of the information from the Instructor Information table.

a. Save this form as: U8_Form_Instructor_Information