Microsoft Access

TV Land Data Base

Queries

You must show the queries.

1. Order the shows by their locales

1. What is the note about Loretta Swit’s character in MASH?

1. List the shows by the Network they were on.

1. List the shows by Genre.

1. List the shows that took place in “New York”

1. What actresses played housewives and what were the shows named?

1. Who were the two leading men who played the leading role in Bewitched?

1. List the actors by show, by Network.  That is all shows from each Network, with all actors in each show. Network, Show, Actor

1. List all the roles who were surgeons and the actors who played them.

1. What two TV shows had a character Rhoda Morgenstern and what network were they on?