a09c1Cards M9 Assignment: Baseball Trading Cards Access

profileAaronPlusOne
a09c1Cards.accdb
Home>Computer Science homework help>a09c1Cards M9 Assignment: Baseball Trading Cards Access
Brand Brand ID
Topps B001
Other B002
Fleer B003
Donruss B004
Bowman B005
Year Brand ID PlayerName Team NumInStock Rarity ID CardNo
1993 B001 Harold Reynolds SEA 1 1 C084
1992 B003 Mark Lemke ATL 1 1 C170
1993 B004 Shane Mack MIN 2 2 C190
1993 B004 Ryne Sandberg CHC 1 1 C195
1992 B001 Henry Cotto SEA 1 2 C005
1993 B003 Kevin Seitzer MIL 3 3 C019
1992 B003 Marquis Grissom MON 2 1 C021
1993 B002 Harold Reynolds SEA 1 3 C047
1992 B002 Scott Livingstone DET 3 2 C055
1993 B005 George Bell CHW 1 3 C063
1993 B005 Greg Gagne MIN 3 1 C064
1993 B001 Eric Anthony HOU 1 1 C070
1993 B003 Reggie Sanders CIN 2 2 C081
1992 B004 Tony Fernandez SDP 2 1 C085
1992 B002 Dwight Smith CHC 2 1 C086
1993 B004 Scott Leius MIN 1 3 C112
1992 B005 Jeff Bagwell HOU 3 1 C113
1992 B005 Moises Alou MON 3 2 C123
1992 B001 Mitch Webster LAD 2 2 C131
1993 B005 Andre Dawson CHC 2 3 C141
1993 B004 Willie Wilson OAK 1 1 C147
1992 B002 Tony Pena BOS 3 1 C150
1992 B002 Eddie Murray NYM 1 3 C157
1992 B005 Mickey Tettleton DET 2 2 C179
1993 B003 Scott Cooper BOS 1 2 C188
1993 B001 Mike Bordick OAK 2 2 C191
1992 B003 Harold Baines OAK 3 3 C192
1992 B001 Rafael Belliard ATL 3 1 C193
1993 B004 Paul Sorrento CLE 3 1 C194
1993 B001 Roberto Kelly NYY 2 2 C196
1993 B002 Randy Velarde NYY 2 1 C197
1992 B004 Ron Gant ATL 1 3 C198
1993 B001 Mike Devereaux BAL 3 2 C199
1993 B003 Robin Ventura CHW 2 2 C200
1993 B001 Jerald Clark SDP 3 3 C001
1993 B002 David Justice ATL 3 2 C002
1993 B002 Kent Hrbek MIN 1 2 C003
1992 B001 Chad Curtis CAL 1 1 C004
1992 B003 Mark Lemke ATL 1 3 C006
1992 B004 Mike Sharperson LAD 1 3 C007
1993 B002 Joe Orsulak BAL 1 3 C008
1992 B005 Luis Gonzalez HOU 1 1 C009
1992 B005 Casey Candaele HOU 2 1 C010
1993 B001 Kelly Gruber TOR 1 1 C011
1993 B004 Ozzie Smith STL 3 3 C012
1992 B005 Dante Bichette MIL 3 2 C013
1992 B005 John Vander Wal MON 3 1 C014
1992 B003 Herm Winningham BOS 2 1 C015
1992 B003 Mark McGwire OAK 3 1 C016
1993 B001 Dave Martinez CIN 1 1 C017
1992 B003 Gary Varsho PIT 2 3 C018
1992 B003 Shane Mack MIN 1 1 C020
1993 B003 Terry Pendleton ATL 2 1 C022
1992 B001 Scott Livingstone DET 2 1 C023
1993 B004 Dave Martinez CIN 2 3 C024
1993 B004 Craig Biggio HOU 2 1 C025
1992 B001 Glenn Davis BAL 3 3 C026
1993 B002 Jerald Clark SDP 2 2 C027
1992 B004 Randy Velarde NYY 1 1 C028
1992 B003 Rafael Belliard ATL 2 2 C029
1993 B003 Terry Steinbach OAK 3 3 C030
1992 B002 Tim Wallach MON 3 2 C031
1993 B005 Henry Cotto SEA 2 2 C032
1992 B002 Willie McGee SFG 2 3 C033
1992 B001 Jeff Bagwell HOU 2 2 C034
1993 B003 Darrin Jackson SDP 2 1 C035
1992 B005 Tim Raines CHW 2 3 C036
1993 B005 Dave Valle SEA 3 2 C037
1993 B004 Chris James SFG 2 1 C038
1993 B002 Paul O'Neill CIN 2 3 C039
1992 B004 Ron Karkovice CHW 2 2 C040
1993 B004 Eddie Murray NYM 3 2 C041
1993 B005 Travis Fryman DET 1 2 C042
1992 B004 Travis Fryman DET 3 2 C043
1992 B002 Mitch Webster LAD 1 2 C044
1993 B004 Scott Cooper BOS 3 1 C045
1992 B004 Bobby Bonilla NYM 1 1 C046
1993 B005 Danny Tartabull NYY 3 2 C048
1992 B002 Robin Yount MIL 2 1 C049
1992 B005 George Bell CHW 1 2 C050
1993 B003 Carney Lansford OAK 2 2 C051
1992 B003 John Olerud TOR 1 1 C052
1993 B003 Luis Polonia CAL 1 2 C053
1992 B002 Jeff Huson TEX 3 3 C054
1992 B002 Luis Sojo CAL 1 3 C056
1993 B001 Frank Thomas CHW 3 1 C057
1992 B003 Jeff Huson TEX 1 1 C058
1992 B005 Omar Vizquel SEA 2 1 C059
1992 B003 Rickey Henderson OAK 3 2 C060
1993 B002 Mark McGwire OAK 2 1 C061
1993 B005 Kirt Manwaring SFG 1 2 C062
1993 B001 Chili Davis MIN 2 1 C065
1993 B002 Leo Gomez BAL 3 3 C066
1993 B003 Will Clark SFG 1 2 C067
1992 B003 Lou Whitaker DET 1 2 C068
1993 B004 Jim Eisenreich KCR 3 2 C069
1993 B003 Danny Tartabull NYY 3 1 C071
1992 B002 Dante Bichette MIL 2 3 C072
1993 B005 Dave Hollins PHI 1 3 C073
1992 B001 Luis Sojo CAL 2 1 C074
1992 B003 Pat Kelly NYY 1 1 C075
1992 B004 Luis Polonia CAL 1 3 C076
1992 B001 Lou Whitaker DET 3 3 C077
1992 B005 Gene Larkin MIN 1 1 C078
1992 B005 Steve Finley HOU 3 2 C079
1992 B001 Kurt Stillwell SDP 3 3 C080
1992 B001 Roberto Kelly NYY 3 3 C082
1992 B004 Tino Martinez SEA 1 1 C083
1992 B003 Mike Bordick OAK 2 2 C087
1993 B002 Mike Macfarlane KCR 2 2 C088
1992 B001 Jerry Browne OAK 2 3 C089
1993 B003 Luis Gonzalez HOU 2 3 C090
1992 B004 B.J. Surhoff MIL 1 1 C091
1993 B002 Andre Dawson CHC 1 1 C092
1993 B003 Ron Karkovice CHW 2 1 C093
1992 B003 Mike Scioscia LAD 1 3 C094
1992 B002 Danny Tartabull NYY 2 2 C095
1992 B001 Felix Jose STL 2 1 C096
1993 B001 Frank Thomas CHW 2 2 C097
1993 B002 Jim Eisenreich KCR 3 3 C098
1992 B003 Mike Scioscia LAD 3 1 C099
1992 B005 Devon White TOR 3 1 C100
1992 B001 Jeff King PIT 1 3 C101
1993 B002 Jerald Clark SDP 2 2 C102
1992 B004 Marquis Grissom MON 1 1 C103
1992 B005 Kelly Gruber TOR 1 3 C104
1993 B002 Matt Williams SFG 3 1 C105
1993 B004 Kent Hrbek MIN 2 1 C106
1993 B005 Dave Hansen LAD 2 1 C107
1992 B005 Robby Thompson SFG 1 3 C108
1992 B003 Luis Gonzalez HOU 3 3 C109
1993 B005 Wade Boggs BOS 2 3 C110
1992 B004 Ozzie Smith STL 2 2 C111
1993 B005 Lance Blankenship OAK 2 2 C114
1992 B005 George Brett KCR 3 3 C115
1992 B002 Robby Thompson SFG 1 3 C116
1993 B004 Mariano Duncan PHI 2 1 C117
1992 B004 Cecil Fielder DET 2 2 C118
1993 B001 Tom Brunansky BOS 3 2 C119
1993 B002 Carney Lansford OAK 2 1 C120
1993 B003 Cory Snyder SFG 3 2 C121
1992 B003 Eric Anthony HOU 1 1 C122
1992 B004 Scott Livingstone DET 2 3 C124
1993 B004 Jeff Bagwell HOU 2 1 C125
1993 B003 B.J. Surhoff MIL 3 3 C126
1992 B003 Tony Phillips DET 3 1 C127
1992 B003 David Justice ATL 2 2 C128
1993 B004 Bob Zupcic BOS 3 1 C129
1993 B001 Gary Varsho PIT 1 3 C130
1992 B002 Devon White TOR 2 2 C132
1992 B005 Marquis Grissom MON 1 1 C133
1992 B001 Brian McRae KCR 2 3 C134
1992 B001 Tom Pagnozzi STL 3 1 C135
1992 B004 Harold Baines OAK 2 2 C136
1993 B004 Kevin Seitzer MIL 3 2 C137
1993 B001 Pete Incaviglia HOU 2 2 C138
1992 B001 Dan Gladden DET 3 3 C139
1993 B002 Hal Morris CIN 2 1 C140
1992 B003 George Brett KCR 3 2 C142
1992 B001 Wally Joyner KCR 2 1 C143
1992 B004 Mike Scioscia LAD 1 1 C144
1992 B002 Steve Finley HOU 1 1 C145
1993 B005 Gary Sheffield SDP 3 3 C146
1993 B003 Randy Velarde NYY 2 3 C148
1993 B003 Felix Jose STL 3 2 C149
1993 B005 Mike Macfarlane KCR 3 1 C151
1993 B003 Gary Disarcina CAL 1 3 C152
1992 B003 Luis Sojo CAL 1 2 C153
1992 B004 Harold Reynolds SEA 3 2 C154
1993 B001 Eddie Murray NYM 1 2 C155
1992 B001 Herm Winningham BOS 1 3 C156
1993 B001 Paul Sorrento CLE 3 3 C158
1992 B003 Dave Hollins PHI 2 3 C159
1992 B003 Omar Vizquel SEA 3 3 C160
1993 B005 Mike Felder SFG 1 1 C161
1992 B005 Jerry Browne OAK 2 3 C162
1992 B003 Paul Molitor MIL 3 1 C163
1993 B003 Larry Walker MON 3 2 C164
1992 B005 Kurt Stillwell SDP 3 3 C165
1993 B001 Matt Williams SFG 3 2 C166
1993 B001 Walt Weiss OAK 1 1 C167
1993 B004 Charlie Hayes NYY 1 1 C168
1993 B002 Dwight Smith CHC 2 1 C169
1992 B002 Robin Ventura CHW 3 1 C171
1992 B001 Kurt Stillwell SDP 3 1 C172
1992 B004 Mickey Morandini PHI 3 2 C173
1993 B003 Robby Thompson SFG 2 3 C174
1992 B005 Pete O'Brien SEA 3 2 C175
1992 B002 Greg Vaughn MIL 1 1 C176
1992 B001 Ken Caminiti HOU 1 3 C177
1993 B004 Pete Incaviglia HOU 1 2 C178
1993 B001 John Vander Wal MON 3 3 C180
1993 B005 Bernard Gilkey STL 2 2 C181
1993 B005 Leo Gomez BAL 1 1 C182
1993 B002 Bernard Gilkey STL 3 2 C183
1993 B001 Mark Lemke ATL 2 3 C184
1992 B002 Chuck Knoblauch MIN 2 1 C185
1992 B002 Henry Cotto SEA 2 1 C186
1992 B005 Mo Vaughn BOS 3 2 C187
1992 B002 Ivan Rodriguez TEX 1 1 C189
Rarity Desc Rarity ID
Common 1
Rare 2
Very Rare 3
SELECT Cards.CardNo, Cards.Year, Cards.[Brand ID], Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID] WHERE (((Cards.PlayerName) Like "*" & [Enter Name] & "*"));
SELECT DISTINCTROW * FROM Cards;
SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID] WHERE (((Brands.Brand)="Bowman"));
SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID] WHERE (((Brands.Brand)="Donruss"));
SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID] WHERE (((Brands.Brand)="Fleer"));
SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID] WHERE (((Brands.Brand)="Topps"));