Microsoft Access

Student Data Base Exercise

After you have successfully created all the tables given, load the following data.

Students

1  The following students have elected the course entitled Wetlands Critters;

            Marge Trechle                         Sec 1

            Thomas Newburry

Cindy Crumple

Icculus McMan

Hope Wilson

Mary Calahan                         Sec 2

Beth Schavinsky

Todd Relve

Belinda Myers           

Keith Snyder

2  The following students have elected the course entitled Ocean Ecosystems;

            Marge Trechle

Todd Relve

Beth Schavinsky

Geoff Hamilton

Keith Snyder

Mary Schneable

Barbara  Schavinsky

3  The following students have elected the course entitled Endangered Habitats;

            Mary Calahan

            Icculus McMan

            Hope Wilson

            Cindy Crumple

Belinda Myers           

Instructors

Norm Salvadori will be teaching sect 1 of the Wetlands Critters course and the Ocean Ecosystems course.  Terry Smith will be teaching Section 2 of Wetlands Critters.  John Wagner will teach Endangered Habitats course.

QUERIES

1.     Print a list of classes that Mary Calahan will be taking.

2.     Make a class list for Ocean Ecosytems. Include the instructors name

3.     Make a class list for all classes and sort then by class name.

4.     Use the query developed in #3 but sort the students by First name , Last name