ACCESS DB homework

profilesquashyja
final_project_data2_1.xls
Home>Computer Science homework help>ACCESS DB homework

Customers, Contacts & Reps

Customer ID Customer Name Contact ID Contact First Name Contact Last Name Contact Position Contact Phone Company Address City State ZIP Territory Active? Sales Rep ID Sales Rep Last Name Sales Rep First Name Sales Rep Phone Sales Rep Hours Sales Rep Date Hired
1001 Segal Inc. 100 Harry Segal Vice President (603) 555-0987 #11 - Hwy 16 Nashua NH 03060 2 Yes C09 Bocelli Carl (603) 522-6487 38 9/20/01
1001 Segal Inc. 200 Mary Ann Waters CFO (603) 555-0988 #11 - Hwy 16 Nashua NH 03060 2 Yes C09 Bocelli Carl (603) 522-6487 38 9/20/01
1002 Fair Weather Enterprises 335 Karen Harper-Willis Marketing Manager (617) 354-1234 345 Wiltshire Avenue Cambridge MA 02139 1 Yes A02 Duke Arthur (617) 336-5547 40 6/25/02
1002 Fair Weather Enterprises 336 Mark Stevenson CEO (617) 354-1235 345 Wiltshire Avenue Cambridge MA 02139 1 Yes A02 Duke Arthur (617) 336-5547 40 6/25/02
1002 Fair Weather Enterprises 337 Benjamin Yang CFO (617) 354-1236 345 Wiltshire Avenue Cambridge MA 02139 1 Yes A02 Duke Arthur (617) 336-5547 40 6/25/02
1003 Halston & Co. 600 Dianne Lorenzo CEO (631) 757-3344 387 Roper Place Northport NY 11768 5 Yes B02 Bose Sally (207) 422-7411 38 4/10/00
1004 MMB Holdings 125 Pablo Diaz CEO (703) 222-5678 4090 Lethbridge Street Vienna VA 33067 7 Yes B05 van der Ham Lawrence (202) 844-6033 35 6/30/01
1004 MMB Holdings 126 Naomi Mirada CFO (703) 222-5679 4090 Lethbridge Street Vienna VA 33067 7 Yes B05 van der Ham Lawrence (202) 844-6033 35 6/30/01
1005 Ward Co. 900 Jim Shelby COO (617) 344-6677 35-9087 14th Street Boston MA 02115 1 Yes A02 Duke Arthur (617) 336-5547 40 6/25/02
1006 Bakertime Mobile 850 Tom DiBono Vice President (201) 455-8765 759 East 31 Ave Trenton NJ 07882 5 Yes B02 Bose Sally (207) 422-7411 38 4/10/00
1006 Bakertime Mobile 851 Ruth Schroeder CEO (201) 455-8766 759 East 31 Ave Trenton NJ 07882 5 Yes B02 Bose Sally (207) 422-7411 38 4/10/00
1007 Classic Accents 1200 Dave Burley CEO (781) 566-2233 324 Main Street Burlington MA 01803 1 Yes A02 Duke Arthur (617) 336-5547 40 6/25/02
1007 Classic Accents 1201 Connie Burley Vice President (781) 566-2234 324 Main Street Burlington MA 01803 1 Yes A02 Duke Arthur (617) 336-5547 40 6/25/02
1007 Classic Accents 1202 Teresa Perry Marketing Manager (781) 566-2235 324 Main Street Burlington MA 01803 1 Yes A02 Duke Arthur (617) 336-5547 40 6/25/02
1008 Summit Supply 1500 Gary Giovanetti CFO (304) 555-6677 Ridgeway Connector Stoney Bluff WV 35666 7 No B05 van der Ham Lawrence (202) 844-6033 35 6/30/01
1008 Summit Supply 1501 John Kim CEO (304) 555-6678 Ridgeway Connector Stoney Bluff WV 35666 7 No B05 van der Ham Lawrence (202) 844-6033 35 6/30/01
1009 Harper & Ronick 1700 Lee Panetti CEO (206) 333-4455 288 Landsdowne Drive Nicola CT 23445 3 Yes A14 Fink Peter (860) 545-9823 30 10/25/99
1010 Professional Supply 250 Ann Zankoski Marketing Manager (207) 354-0099 7241 South Drive Thomaston ME 04778 4 Yes C02 Bonham Earl (802) 455-9070 38 2/15/00
1010 Professional Supply 251 Bob Zankoski Vice President (207) 354-0100 7241 South Drive Thomaston ME 04778 4 Yes C02 Bonham Earl (802) 455-9070 38 2/15/00
1010 Professional Supply 252 Aaron Zankoski CFO (207) 354-0101 7241 South Drive Thomaston ME 04778 4 Yes C02 Bonham Earl (802) 455-9070 38 2/15/00
1011 Silver Cloud 2100 Maria Shimano President & CEO (704) 566-7889 111 Rand Avenue Baltimore MD 22777 6 Yes A05 Louis-Hawkins Brenda (212) 224-3322 35 7/15/99
1012 Ryssell Bros. 490 Maxine Garrison Marketing Manager (802) 455-1122 1255 Vollrath St South Glenn VT 45668 4 Yes C02 Bonham Earl (802) 455-9070 38 2/15/00
1012 Ryssell Bros. 487 Rachel Pappas Vice President (802) 455-1123 1255 Vollrath St South Glenn VT 45668 4 Yes C02 Bonham Earl (802) 455-9070 38 2/15/00
1012 Ryssell Bros. 444 Jonathan Reusche CEO (802) 455-1124 1255 Vollrath St South Glenn VT 45668 4 Yes C02 Bonham Earl (802) 455-9070 38 2/15/00
1013 Omega Distributions 2500 Paul Tomazewski President & CEO (305) 455-6778 32 Merrit Ave Orlando FL 35667 8 No C11 Masterson Janet (703) 342-4392 40 11/30/98
1013 Omega Distributions 2505 David Tonelli CFO (305) 455-6779 32 Merrit Ave Orlando FL 35667 8 No C11 Masterson Janet (703) 342-4392 40 11/30/98
1014 J&J Ltd. 1780 Patty Glico Marketing Manager (603) 233-0099 675 Cinnamon Ridge Road Manchester NH 03101 2 Yes C09 Bocelli Charlotte (603) 522-6487 38 9/20/01
1015 Dalhousie Inc. 2800 Jackie Soupe President & CEO (203) 456-7790 2233 Southgate Avenue Southgate CT 23555 3 Yes A14 Fink Peter (860) 545-9823 30 10/25/99
1016 Larkspur Corp. 950 Jason Monte CFO (201) 233-4567 4949 Douglas Road Princeton NJ 12234 5 Yes B02 Bose Sally (207) 422-7411 38 4/10/00
1017 Pro-Dist Co. 331 Gary Twomey Vice President (805) 999-1090 1121 Lorne Drive Montrose NC 46777 8 No C11 Masterson Janet (703) 342-4392 40 11/30/98
1017 Pro-Dist Co. 332 Brian Ross CEO (805) 999-1091 1121 Lorne Drive Montrose NC 46777 8 No C11 Masterson Janet (703) 342-4392 40 11/30/98
1017 Pro-Dist Co. 333 Michael Jackson CFO (805) 999-1092 1121 Lorne Drive Montrose NC 46777 8 No C11 Masterson Janet (703) 342-4392 40 11/30/98
1018 De Palma Supply 2750 Timothy Warren President (806) 333-4556 988 Laval Crescent Pemberton SC 53488 8 Yes C11 Masterson Janet (703) 342-4392 40 11/30/98
1019 Cameron-Best 3400 Harriet Billingsley CFO (703) 233-5876 429 Mt Ida Drive East Gardom VA 33068 7 Yes B05 van der Ham Lawrence (202) 844-6033 35 6/30/01
1020 MPM Inc. 1510 Marvin Gardens President & CEO (508) 433-6543 3535 Bank Road Gardner MA 01440 1 Yes A02 Duke Arthur (617) 336-5547 40 6/25/02
&L&"Arial,Bold"&12Customers, Contacts and Reps
Page &P of &N

Territories

Territory Code Territory Name Sales Rep
1 Massachusetts Duke, Arthur
2 New Hampshire Bocelli, Carl
3 Connecticut Fink, Peter
4 Maine / Vermont Bonham, Earl
5 New York / New Jersey Bose, Sally
6 Washington DC / Maryland Louis-Hawkins, Brenda
7 Virginia / West Virginia van der Ham, Lawrence
8 Southeast Masterson, Janet

Products

Product Code Description Category Size Finish List Price Discount
B12 Cab. Lumber Plywood 0.5 G2S $2.45 3.0%
DF14 Ungraded lumber Board 1 X 4 RGH $1.90 2.5%
DF16 Ungraded lumber Board 1 X 6 RGH $1.85 2.5%
DF210S Standard lumber Dim. 2 X 10 S4S $2.10 3.5%
DF242 2+ Oak Dim. 2 X 4 S4S $2.85 4.0%
DF24S Standard lumber Dim. 2 X 4 S4S $2.10 3.5%
DF24U Utility Pine Dim. 2 X 4 S4S $1.75 4.0%
DF26 Standard lumber Dim. 2 X 6 S4S $2.10 3.5%
DF28 Standard lumber Dim. 2 X 8 S4S $2.10 3.5%
O12 Cab. Lumber Plywood 0.5 G2S $1.19 3.0%
O38 Cab. Lumber Plywood 0.375 G2S $1.25 3.0%
P12 Constr. Lumber Plywood 0.50 G1S $1.32 3.0%
P12U Utility Pine Plywood 0.5 RGH $1.75 4.0%
P14 Constr. Lumber Plywood 0.25 G1S $2.10 3.0%
P34 Constr. Lumber Plywood 0.75 G1S $2.19 3.0%
P34T Constr. Lumber Plywood 0.75 T&G $2.17 3.0%
P38 Constr. Lumber Plywood 0.375 G1S $1.99 3.0%
P58 Constr. Lumber Plywood 0.625 G1S $1.88 3.0%
P58T Constr. Lumber Plywood 0.675 T&G $1.75 3.0%
P58U Utility Pine Plywood 0.625 RGH $1.75 4.0%
SP14 Ungraded lumber Board 1 X 4 RGH $1.85 2.5%
SP14R Ungraded lumber Board 1 X 4 RGH $1.64 2.5%
SP16 Ungraded lumber Board 1 X 6 RGH $1.52 2.5%
SP18 Ungraded lumber Board 1 X 8 RGH $1.85 2.5%
SP210 Standard lumber Dim. 2 X 10 S4S $2.10 3.5%
SP212 Standard lumber Dim. 2 X 12 S4S $2.10 3.5%
SP242 2+ Oak Dim. 2 X 4 S4S $2.85 4.0%
SP243 3+ Ash Dim. 2 X 4 S4S $1.90 2.0%
SP24U Utility Pine Dim. 2 X 4 S4S $1.75 4.0%
SP26S Standard lumber Dim. 2 X 4 S4S $2.10 3.5%
SP28S Standard lumber Dim. 2 X 8 S4S $2.10 3.5%
W12 Cab. Lumber Plywood 0.5 G2S $2.45 3.0%
W14 Cab. Lumber Plywood 0.25 G2S $2.45 3.0%
WP110 Utility Pine Board 1 X 10 RGH $1.75 4.0%
WP13 Utility Pine Board 1 X 3 RGH $1.62 4.0%
WP14 Utility Pine Board 1 X 4 RGH $1.55 4.0%
WP16 Utility Pine Board 1 X 6 RGH $1.80 4.0%
WP18 Utility Pine Board 1 X 8 RGH $1.92 4.0%
YP210 Standard lumber Dim. 2 X 10 S4S $2.10 3.5%
YP242 2+ Oak Dim. 2 X 4 S4S $2.85 4.0%
YP243 3+ Ash Dim. 2 X 4 S4S $1.98 4.0%
YP24R Ungraded lumber Dim. 2 X 4 RGH $1.18 2.5%
YP24RG Ungraded lumber Dim. 2 X 4 RGH $1.23 2.5%
YP24S Standard lumber Dim. 2 X 4 S4S $2.10 3.5%
YP24U Utility Pine Dim. 2 X 4 S4S $1.95 3.0%
YP262 2+ Oak Dim. 2 X 6 S4S $2.85 4.0%
YP26R Ungraded lumber Dim. 2 X 6 RGH $1.19 2.5%
YP26S Standard lumber Dim. 2 X 6 S4S $2.10 3.5%
YP28S Standard lumber Dim. 2 X 8 S4S $2.10 3.5%

Orders

Product Code Customer ID Rep ID Quantity Ordered Date of Order Date Filled Order Complete?
B12 1016 B02 300 2/5/02 2/10/02 Yes
DF14 1003 B02 250 4/7/02 4/17/02 Yes
DF16 1020 A02 175 3/12/02 3/15/02 Yes
DF210S 1019 B05 150 7/18/02 7/21/02 Yes
DF242 1005 A02 2,000 8/1/02 8/10/02 Yes
DF24S 1006 B02 380 5/16/02 5/20/02 Yes
DF28 1009 A14 400 10/1/02 10/9/02 Yes
O12 1010 C02 250 11/30/02 12/4/02 Yes
O38 1011 A05 1,800 1/3/03
P12 1012 C02 1,750 1/10/03
P14 1014 C09 1,200 6/19/02 6/24/02 Yes
P34 1003 B02 1,150 7/18/02 7/21/02 Yes
P34T 1012 C02 980 8/1/02 8/10/02 Yes
P38 1005 A02 650 8/20/02 9/3/02 Yes
P58 1001 C09 500 6/7/02 6/17/02 Yes
P58 1019 B05 975 1/20/03
P58 1020 A02 600 2/5/02 2/10/02 Yes
SP16 1004 B05 1,100 4/7/02 4/17/02 Yes
SP210 1019 B05 1,265 12/10/02 12/15/02 Yes
SP212 1002 A02 1,100 1/23/03
SP243 1015 A14 1,400 1/25/03
P58 1007 A02 475 1/29/03
SP26S 1005 A02 550 6/19/02 6/24/02 Yes
SP28S 1016 B02 880 7/1/02 7/11/02 Yes
W12 1010 C02 900 7/18/02 7/21/02 Yes
WP13 1018 C11 400 8/1/02 8/10/02 Yes
WP18 1019 B05 345 2/5/02 2/10/02 Yes
YP210 1005 A02 282 4/7/02 4/17/02 Yes
YP242 1020 A02 190 3/12/02 3/15/02 Yes
YP243 1009 A14 875 7/18/02 7/21/02 Yes
YP24R 1010 C02 740 5/17/02 5/24/02 Yes
YP24RG 1005 A02 550 1/29/03