MS access homework

profilezykidbbay
musiccollection.accdb
Home>Computer Science homework help>MS access homework
ArtistID ArtistName
ACUS Acustic Alchemy
ADAMS Adams, Bryan
AERO Aerosmith
ARIE India.Arie
BEATLES Beatles
BRAN Branch, Michelle
COLD Coldplay
DYLAN Dylan, Bob
EAGLES Eagles
EVAN EvaneScence
FOO Foo Fighters
GDAY Green Day
JOHNSON Johnson, Jack
JONES Jones, Norah
KREV Kreviazuk, Chantal
LAVI Lavigne, Avril
LEDZ Led Zeppelin
MANSA Mana
MATCH Matchbox 20
MATH Mathews, Dave
MAYER Mayer, John
MILES Davis, Miles
PFLOYD Pink Floyd
SLOWHAND Clapton, Eric
SUPER Supertramp
TRAIN Train
TRAVIS Travis
TWAIN Twain, Shania
U2 U2
ItemID Title ArtistID StyleID Rating MediaID YearIssued DatePurchased
18 18 Till the End ADAMS ROCK Good CD 1996 6/16/96
abba ABBA Gold AERO NEW Good CD 1992 5/16/95
abbey Abbey Road BEATLES ROCK Excellent CD 1969 6/16/86
accoustic Accoustic Soul ARIE ROCK Good CD 2001 3/15/02
acht Achtung Baby U2 ROCK Good CD 1991 6/16/91
against Against the Grain ACUS JAZZ Excellent CD 1994 10/16/95
allthat All That You Can't Leave Behind U2 ROCK Very Good CD 2000 3/1/01
ant2 Antology 2 BEATLES ROCK Very Good CD 1996 6/16/96
ant3 Antology 3 BEATLES ROCK Good CD 1996 11/15/96
arc Arcanum ACUS JAZZ Very Good CD 1996 6/16/96
back Back on the Case ACUS JAZZ Excellent CD 1991 10/18/95
before Before These Crowded Streets MATH ROCK Good CD 1998 6/16/98
blue Kind of Blue MILES JAZZ Very Good CD 1959 1/15/93
breakfast Breakfast in America SUPER ROCK Excellent CD 1979 6/16/86
brush Brushfire Fairytales JOHNSON FOLK Very Good CD 2000 6/6/03
comeaway Come Away With Me JONES JAZZ Very Good CD 2002 11/1/02
comeon Come on Over TWAIN ROCK Very Good CD 1997 12/24/98
cradle From The Cradle SLOWHAND JAZZ Good CD 1994 10/20/94
crash Crash MATH ROCK Very Good CD 1996 6/16/96
cream The Cream of Clapton SLOWHAND ROCK Very Good CD 1995 4/16/95
crime Crime of the Century SUPER ROCK Good CD 1974 6/16/86
cuando Cuando Los Angeles Lloran MANSA LAT Very Good CD 1995 2/23/96
dark The Dark Side Of The Moon PFLOYD ROCK Excellent CD 1973 6/16/86
donde Donde Jugaran los Ninos MANSA LAT Excellent CD 1992 2/18/94
drops Drops of Jupiter TRAIN ROCK Very Good CD 2001 6/16/01
even Even In The Quietest Moments SUPER ROCK Excellent CD 1977 6/16/86
fallen Fallen EVAN ROCK Very Good CD 2003 6/6/03
ghaero Greatest Hits - Aerosmith AERO ROCK Fair CD 1993 7/3/01
ghdylan Greatest Hits - Dylan DYLAN ROCK Good CD 1967 6/16/00
hard A Hard Day's Nignt BEATLES ROCK Very Good CD 1964 6/16/86
hell Hell Freezes Over, Concert EAGLES ROCK Excellent CD 1994 12/15/94
help Help BEATLES ROCK Very Good CD 1965 6/16/86
hotel Hotel California EAGLES ROCK Very Good CD 1976 1/8/96
houses Houses Of The Holy LEDZ ROCK Very Good CD 1973 6/16/89
invisible The Invisible Band TRAVIS ROCK Very Good CD 2001 9/21/01
joshua The Joshua Tree U2 ROCK Very Good CD 1987 6/16/87
journey Journeyman SLOWHAND ROCK Very Good CD 1989 6/16/89
ledz Led Zeppelin LEDZ ROCK Very Good CD 1971 6/16/89
letgo Let Go LAVI ROCK Very Good CD 2002 11/1/02
letitb Let It Be BEATLES ROCK Excellent CD 1987 6/16/86
love Love and Theft DYLAN ROCK Good CD 2001 9/22/01
magical Magical Mystery Tour BEATLES ROCK Very Good CD 1967 6/16/86
man The Man Who TRAVIS ROCK Very Good CD 1999 6/6/03
mana Mana Unplugged MANSA LAT Excellent CD 1999 6/15/99
moment A Momentary Lapse Of Reason PFLOYD ROCK Good CD 1987 6/16/87
nimrod Nimrod GDAY ROCK Good CD 1997 7/31/98
nothing There Is Nothing Left to Lose FOO ROCK Good CD 1999 5/20/00
on On and On JOHNSON FOLK Very Good CD 2003 6/6/03
one One by One FOO ROCK Good CD 2002 11/1/02
parachutes Parachutes COLD ROCK Very Good CD 2000 4/14/02
reptiole Reptile SLOWHAND ROCK Very Good CD 2001 6/16/01
revolver Revolver BEATLES ROCK Very Good CD 1966 6/16/86
room Room for Squares MAYER ROCK Excellent CD 2001 4/14/02
rubber Rubber Soul BEATLES ROCK Very Good CD 1965 6/16/86
rush A Rush of Blood to the Head COLD ROCK Excellent CD 2002 11/1/02
sargent Sgt Pepper's Lonely Heart Club Band BEATLES ROCK Excellent CD 1967 6/16/86
spirit The Spirit Room BRAN ROCK Very Good CD 2001 10/29/01
under Under the Table and Dreaming MATH ROCK Very Good CD 1994 5/27/95
unpladams Unplugged - Bryan Adams ADAMS ROCK Very Good CD 1997 12/31/97
unplclapton Unplugged - Eric Clapton SLOWHAND ROCK Excellent CD 1992 6/16/92
voyage Voyage to India ARIE ROCK Good CD 2002 2/15/03
waking Waking Up The Neighbors ADAMS ROCK Fair CD 1991 6/16/91
wall The Wall PFLOYD ROCK Excellent CD 1979 6/16/86
what What if it All Means Something KREV ROCK Very Good CD 2002 6/6/03
white White Album BEATLES ROCK Excellent CD 1968 6/16/86
wish Wish You Were Here PFLOYD ROCK Very Good CD 1975 5/9/00
with With the Beatles BEATLES ROCK Very Good CD 1963 11/3/93
yourself Yourself or Someone Like You MATCH ROCK Very Good CD 1996 6/16/98
MediaID Media
AUD Audio Tape
CD Compact Disc
DVD Digital Video Disc
VID Video Tape
Rating
Bad
Excellent
Fair
Good
N/A
Very Good
StyleID Style
CLAS Classical
CTRY Country/Bluegras
FOLK Folk
JAZZ Jazz
LAT Latin
N/A N/A
NEW New Age
ROCK Rock/Pop
SOUND Soundtrack
SELECT DISTINCTROW * FROM Ratings;
SELECT DISTINCTROW * FROM Artists;
SELECT DISTINCTROW * FROM Items;
SELECT DISTINCTROW * FROM Items;
SELECT Title, StyleID, YearIssued FROM Items WHERE Rating = [Which Rating?];
SELECT ArtistID, Title, StyleID, YearIssued FROM Items WHERE rating="Excellent";
SELECT Items.ArtistID, Items.Title, Styles.Style, Items.YearIssued FROM Styles INNER JOIN Items ON Styles.StyleID = Items.StyleID WHERE (((Items.Rating)="Excellent"));
SELECT * FROM Items ORDER BY DatePurchased DESC;
SELECT * FROM Items ORDER BY YearIssued DESC;