Info Systems for Managers Spring 2007

Home  |  Syllabus |  Access  |  Excel  |  Visual Basic  |  Research
 

Tables

Agents
Agents First Name Agents Last Name Agents Code Address City State Zip code
Eric Karabell 022 3046 Red Ridge Dr Rockwall TX 75032
Peter Gammons 025 111 West St Englewood NJ 07631
Buster Olney 027 2017 E Grande Ave Laramie MY 82070
Keith Law 029 Black Lake Rd Hammond NY 13646
Jayson Stark 031 1282 Hague Ave Saint Paul MN 55104
 

 

Players
Sport Teams Players First Name Players Last Name Players Contract Players Pay Player's Agent Agents Code
Royals John Bale 2 $45,000,000.00 Eric Karabell 022
Twins Juan Rincon 4 $14,000,000.00 Eric Karabell 022
Braves Chipper Jones 4 $12,000,000.00 Eric Karabell 022
Mets Pedro Martinez 2 $9,000,000.00 Eric Karabell 022
Mets Alay Soler 2 $56,000,000.00 Peter Gammons 025
Royals Zack Greinke 2 $25,000,000.00 Peter Gammons 025
Twins Dennys Reyes 4 $22,000,000.00 Peter Gammons 025
Yankees Alex Rodriguez 2 $100,000,000.00 Peter Gammons 025
Mets Damion Easley 4 $5,500,000.00 Peter Gammons 025
Royals Ross Gload 4 $34,000,000.00 Buster Olney 027
Twins Glen Perkins 2 $13,000,000.00 Buster Olney 027
Braves Manny Acosta 2 $6,000,000.00 Buster Olney 027
Cardinals Gary Bennett 4 $5,000,000.00 Buster Olney 027
Mets Scott Schoeneweis 3 $5,000,000.00 Keith Law 029
Royals Esteban German 2 $46,000,000.00 Keith Law 029
Yankees Andy Pettitte 2 $10,000,000.00 Keith Law 029
Mets Jorge Sosa 4 $60,000,000.00 Jayston Stark 031
Yankees Derek Jeter 4 $18,000,000.00 Jayston Stark 031
Cardinals Albert Pujols 2 $8,000,000.00 Jayson Stark 031

 

Queries

 

agents code
Sport Teams Players First Name Players Last Name Players Contract Players Pay Player's Agent Agents Code
Royals John Bale 2 $45,000,000.00 Eric Karabell 022
Twins Juan Rincon 4 $14,000,000.00 Eric Karabell 022
Braves Chipper Jones 4 $12,000,000.00 Eric Karabell 022
Mets Pedro Martinez 2 $9,000,000.00 Eric Karabell 022

SELECT Players.[Sport Teams], Players.[Players First Name], Players.[Players Last Name], Players.[Players Contract], Players.[Players Pay], Players.[Player's Agent], Players.[Agents Code]
FROM Players
WHERE (((Players.[Agents Code])=[enter agents code]));

 

contracts and agents
Players First Name Players Last Name Players Contract Agents First Name Agents Last Name Agents Code
John Bale 2 Eric Karabell 022
Juan Rincon 4 Eric Karabell 022
Chipper Jones 4 Eric Karabell 022
Pedro Martinez 2 Eric Karabell 022
Alay Soler 2 Peter Gammons 025
Zack Greinke 2 Peter Gammons 025
Dennys Reyes 4 Peter Gammons 025
Alex Rodriguez 2 Peter Gammons 025
Damion Easley 4 Peter Gammons 025
Ross Gload 4 Buster Olney 027
Glen Perkins 2 Buster Olney 027
Manny Acosta 2 Buster Olney 027
Gary Bennett 4 Buster Olney 027
Scott Schoeneweis 3 Keith Law 029
Esteban German 2 Keith Law 029
Andy Pettitte 2 Keith Law 029
Jorge Sosa 4 Jayson Stark 031
Derek Jeter 4 Jayson Stark 031
Albert Pujols 2 Jayson Stark 031

SELECT Players.[Players First Name], Players.[Players Last Name], Players.[Players Contract], Agents.[Agents First Name], Agents.[Agents Last Name], Agents.[Agents Code]
FROM Players INNER JOIN Agents ON Players.[Agents Code] = Agents.[Agents Code];

 

Stark's players
Sport Teams Players First Name Players Last Name Players Contract Player's Agent Agents Code
Mets Jorge Sosa 4 Jayston Stark 031
Yankees Derek Jeter 4 Jayston Stark 031
Cardinals Albert Pujols 2 Jayson Stark 031

SELECT Players.[Sport Teams], Players.[Players First Name], Players.[Players Last Name], Players.[Players Contract], Players.[Player's Agent], Players.[Agents Code]
FROM Players
WHERE (((Players.[Agents Code])="031"));

 

Total pay
Sport Teams Players First Name Players Last Name Players Contract Players Pay Player's Agent Agents Code Total Pay
Royals John Bale 2 $45,000,000.00 Eric Karabell 022 $90,000,000.00
Twins Juan Rincon 4 $14,000,000.00 Eric Karabell 022 $56,000,000.00
Braves Chipper Jones 4 $12,000,000.00 Eric Karabell 022 $48,000,000.00
Mets Pedro Martinez 2 $9,000,000.00 Eric Karabell 022 $18,000,000.00
Mets Alay Soler 2 $56,000,000.00 Peter Gammons 025 $112,000,000.00
Royals Zack Greinke 2 $25,000,000.00 Peter Gammons 025 $50,000,000.00
Twins Dennys Reyes 4 $22,000,000.00 Peter Gammons 025 $88,000,000.00
Yankees Alex Rodriguez 2 $100,000,000.00 Peter Gammons 025 $200,000,000.00
Mets Damion Easley 4 $5,500,000.00 Peter Gammons 025 $22,000,000.00
Royals Ross Gload 4 $34,000,000.00 Buster Olney 027 $136,000,000.00
Twins Glen Perkins 2 $13,000,000.00 Buster Olney 027 $26,000,000.00
Braves Manny Acosta 2 $6,000,000.00 Buster Olney 027 $12,000,000.00
Cardinals Gary Bennett 4 $5,000,000.00 Buster Olney 027 $20,000,000.00
Mets Scott Schoeneweis 3 $5,000,000.00 Keith Law 029 $15,000,000.00
Royals Esteban German 2 $46,000,000.00 Keith Law 029 $92,000,000.00
Yankees Andy Pettitte 2 $10,000,000.00 Keith Law 029 $20,000,000.00
Mets Jorge Sosa 4 $60,000,000.00 Jayston Stark 031 $240,000,000.00
Yankees Derek Jeter 4 $18,000,000.00 Jayston Stark 031 $72,000,000.00
Cardinals Albert Pujols 2 $8,000,000.00 Jayson Stark 031 $16,000,000.00

SELECT Players.[Sport Teams], Players.[Players First Name], Players.[Players Last Name], Players.[Players Contract], Players.[Players Pay], Players.[Player's Agent], Players.[Agents Code], Players![Players Contract]*Players![Players Pay] AS [Total Pay]
FROM Players;
 

 

two year contracts
Sport Teams Players First Name Players Last Name Players Contract Players Pay Player's Agent Agents Code
Mets Alay Soler 2 $56,000,000.00 Peter Gammons 025
Royals John Bale 2 $45,000,000.00 Eric Karabell 022
Royals Zack Greinke 2 $25,000,000.00 Peter Gammons 025
Royals Esteban German 2 $46,000,000.00 Keith Law 029
Twins Glen Perkins 2 $13,000,000.00 Buster Olney 027
Yankees Alex Rodriguez 2 $100,000,000.00 Peter Gammons 025
Yankees Andy Pettitte 2 $10,000,000.00 Keith Law 029
Braves Manny Acosta 2 $6,000,000.00 Buster Olney 027
Cardinals Albert Pujols 2 $8,000,000.00 Jayson Stark 031
Mets Pedro Martinez 2 $9,000,000.00 Eric Karabell 022

SELECT Players.[Sport Teams], Players.[Players First Name], Players.[Players Last Name], Players.[Players Contract], Players.[Players Pay], Players.[Player's Agent], Players.[Agents Code]
FROM Players
WHERE (((Players.[Players Contract])=2));

 

yankee players
Sport Teams Players First Name Players Last Name Players Contract Players Pay Player's Agent Agents Code
Yankees Alex Rodriguez 2 $100,000,000.00 Peter Gammons 025
Yankees Andy Pettitte 2 $10,000,000.00 Keith Law 029
Yankees Derek Jeter 4 $18,000,000.00 Jayston Stark 031

SELECT Players.[Sport Teams], Players.[Players First Name], Players.[Players Last Name], Players.[Players Contract], Players.[Players Pay], Players.[Player's Agent], Players.[Agents Code]
FROM Players
WHERE (((Players.[Sport Teams])="yankees"));

 

Forms

 



 

 


 

 

 

Hosted by www.Geocities.ws

1