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

 


 

 

 

 

Students

 

 

 

 

 

firstName

lastName

 

Marge

Trechle

 

Thomas

Newburry

 

Cindy

Crumple

 

Icculus

McMan

 

Hope

McMan

 

Mary

Calahan

 

Beth

Schavinsky

 

Todd

 Relve

 

Belinda

Myers

 

Keith

Snyder

 

Geoff

Hamilton

 

Kenneth

Snyder

 

Hope

Wilson

 

Mary

Schneable

 

Barbara

Schavinsky

 

 

 

 

Courses

 

 

 

 

 

 

Course ID

Course Name

Sec #

Instructor Id

1

Wetland Critters

1

 

2

Wetland Critters

50

 

3

Ocean Ecosystems

1

 

4

Endagered Habitats

1

 

 

Instructors

 

 

 

 

Instuctor Id

First Name

Last Name

1

Norm

Salvadori

2

Terry

Smith

                3

John

Wagner