I. THE FIRST TABLE IS THE MUSIC TABLE (List of Recordings)
Music Table Fields - Design View
Field Name Data Type Description
Rec IDTextRecording ID (Primary Key)
Title Text Title of the Recording
ArtistText Primary Artist
BoughtDate/Time Date Purchased
CostCurrency Purchase Price
MediaText CD, Tape, Vinyl, Other
Company IDText ID for Company(Label) producing the recording
CategoryText Rock, Jazz, Blues, Hiphop, Eclectic, Acid Rock, Comedy, Country, Classical, Other

Music Table Data - Datasheet View
Rec ID     Title Artist Bought Cost Media Company Category
10 Todays Tunes (your name) 4/1/2005 $12.25 CD L0 Eclectic
11 Best of Animals The Animals 7/1/1977 $8.49 VINYL L1 Rock
12 Hell Freezes Over Eagles 2/1/1994 $16.49 CD L2 Rock
13 Fools on the Hill Capitol Steps 5/1/1992 $9.49 TAPE L3 Comedy
14 Phenomenon LL Cool J 10/1/1997 $13.99 CD L4 Rap
15 Bull of the Woods 13 Floor Elevators 1/7/1992 $11.49 CD L5 Acid Rock
16 Essential Bach St Martin in the Fields 3/9/1992 $15.00 CD L6 Classical
17 Always Patsy Cline 1/19/1980 $9.49 TAPE L7 Country
18 Dreamland Bob Marley 9/29/1998 $11.99 CD L8 Reggae


II. THE SECOND TABLE IS THE COMPANY TABLE (Music Publishers)
Company Table Fields - Design View
Field Name Data Type Description
Company ID Text Company ID (Primary Key)
Company Name Text Name of the Company(Label)
Location Text City, State, Country, etc
Web Site Text Web Site Address for Info

Company Table Data - Datasheet View
Company ID     Company Name(Label) Location Web Info
L0 My Own Music (your location) (web info if available)
L1 PGD/ABKCO - ABKCO.com
L2 UNI/GEFFEN Santa Monica Geffen.com
L3 Capitol Steps Virginia Capsteps.com
L4 Polygram Santa Monica UMusic.com
L5 Intl. Artists Holland International-Artists.com
L6 Decca New York Deccaclassics.com
L7 UNI/MCA California MCA.com
L8 Cleopatra Los Angeles Cleorecs.com