WEEK 7 MICROSOFT ACCESS DATABASE HOMEWORK

profilesquashyja
joshuafinal_db_week_6.accdb
Home>Computer Science homework help>WEEK 7 MICROSOFT ACCESS DATABASE HOMEWORK
Customer Name Contact ID Contact Title Contact Firstname Contact Lastname Contact Position Contact Phone Company Address City State ZIP Territory Active Status
0.0 0.0 true
Segal Inc. 100.0 Harry Segal Vice President (603) 555-0987 #11 - Hwy 16 Nashua NH 3060.0 2.0 true
Segal Inc. 125.0 Pablo Diaz CEO (703) 222-5678 4090 Lethbridge Street Vienna VA 33067.0 7.0 true
Fair Weather Enterprises 126.0 Naomi Mirada CFO (703) 222-5679 4090 Lethbridge Street Vienna VA 33067.0 7.0 true
Fair Weather Enterprises 200.0 Mary Ann Waters CFO (603) 555-0988 #11 - Hwy 16 Nashua NH 3060.0 2.0 true
Fair Weather Enterprises 250.0 Ann Zankoski Marketing Manager (207) 354-0099 7241 South Drive Thomaston ME 4778.0 4.0 true
Halston & Co. 251.0 Bob Zankoski Vice President (207) 354-0100 7241 South Drive Thomaston ME 4778.0 4.0 true
MMB Holdings 252.0 Aaron Zankoski CFO (207) 354-0101 7241 South Drive Thomaston ME 4778.0 4.0 true
MMB Holdings 331.0 Gary Twomey Vice President (805) 999-1090 1121 Lorne Drive Montrose NC 46777.0 8.0 false
Ward Co. 332.0 Brian Ross CEO (805) 999-1091 1121 Lorne Drive Montrose NC 46777.0 8.0 false
Bakertime Mobile 333.0 Michael Jackson CFO (805) 999-1092 1121 Lorne Drive Montrose NC 46777.0 8.0 false
Bakertime Mobile 335.0 Karen Harper-Willis Marketing Manager (617) 354-1234 345 Wiltshire Avenue Cambridge MA 2139.0 1.0 true
Classic Accents 336.0 Mark Stevenson CEO (617) 354-1235 345 Wiltshire Avenue Cambridge MA 2139.0 1.0 true
Classic Accents 337.0 Benjamin Yang CFO (617) 354-1236 345 Wiltshire Avenue Cambridge MA 2139.0 1.0 true
Classic Accents 444.0 Jonathan Reusche CEO (802) 455-1124 1255 Vollrath St South Glenn VT 45668.0 4.0 true
Summit Supply 487.0 Rachel Pappas Vice President (802) 455-1123 1255 Vollrath St South Glenn VT 45668.0 4.0 true
Summit Supply 490.0 Maxine Garrison Marketing Manager (802) 455-1122 1255 Vollrath St South Glenn VT 45668.0 4.0 true
Harper & Ronick 600.0 Dianne Lorenzo CEO (631) 757-3344 387 Roper Place Northport NY 11768.0 5.0 true
Professional Supply 850.0 Tom DiBono Vice President (201) 455-8765 759 East 31 Ave Trenton NJ 7882.0 5.0 true
Professional Supply 851.0 Ruth Schroeder CEO (201) 455-8766 759 East 31 Ave Trenton NJ 7882.0 5.0 true
Professional Supply 900.0 Jim Shelby COO (617) 344-6677 35-9087 14th Street Boston MA 2115.0 1.0 true
Silver Cloud 950.0 Jason Monte CFO (201) 233-4567 4949 Douglas Road Princeton NJ 12234.0 5.0 true
Ryssell Bros. 1200.0 Dave Burley CEO (781) 566-2233 324 Main Street Burlington MA 1803.0 1.0 true
Ryssell Bros. 1201.0 Connie Burley Vice President (781) 566-2234 324 Main Street Burlington MA 1803.0 1.0 true
Ryssell Bros. 1202.0 Teresa Perry Marketing Manager (781) 566-2235 324 Main Street Burlington MA 1803.0 1.0 true
Omega Distributions 1500.0 Gary Giovanetti CFO (304) 555-6677 Ridgeway Connector Stoney Bluff WV 35666.0 7.0 false
Omega Distributions 1501.0 John Kim CEO (304) 555-6678 Ridgeway Connector Stoney Bluff WV 35666.0 7.0 false
J&J Ltd. 1510.0 Marvin Gardens President & CEO (508) 433-6543 3535 Bank Road Gardner MA 1440.0 1.0 true
Dalhousie Inc. 1700.0 Lee Panetti CEO (206) 333-4455 288 Landsdowne Drive Nicola CT 23445.0 3.0 true
Larkspur Corp. 1780.0 Patty Glico Marketing Manager (603) 233-0099 675 Cinnamon Ridge Road Manchester NH 3101.0 2.0 true
Pro-Dist Co. 2100.0 Maria Shimano President & CEO (704) 566-7889 111 Rand Avenue Baltimore MD 27777.0 6.0 true
Pro-Dist Co. 2500.0 Paul Tomazewski President & CEO (305) 455-6778 32 Merrit Ave Orlando FL 35667.0 8.0 false
Pro-Dist Co. 2505.0 David Tonelli CFO (305) 455-6779 32 Merrit Ave Orlando FL 0.0 8.0 false
De Palma Supply 2750.0 Timothy Warren President (806) 333-4556 988 Laval Crescent Pemberton SC 53488.0 8.0 true
Cameron-Best 2800.0 Jackie Soupe President & CEO (203) 456-7790 2233 Southgate Avenue Southgate CT 23555.0 3.0 true
MPM Inc. 3400.0 Harriet Billingsley CFO (703) 233-5876 429 Mt Ida Drive East Gardom Va 33068.0 7.0 true
Customer ID Customer Name
1001 Segal Inc.
1002 Fair Weather Enterprises
1003 Halston & Co.
1004 MMB Holdings
1005 Ward Co.
1006 Bakertime Mobile
1007 Classic Accents
1008 Summit Supply
1009 Harper & Ronick
1010 Professional Supply
1011 Silver Cloud
1012 Ryssell Bros.
1013 Omega Distributions
1014 J&J Ltd.
1015 Dalhousie Inc.
1016 Larkspur Corp.
1017 Pro-Dist Co.
1018 De Palma Supply
1019 Cameron-Best
1020 MPM Inc.
Order ID Product Code Customer ID Rep ID Quantity Ordered Date of Order Date Filled Order Complete?
1 O12 1010.0 C02 250.0 11/30/02 12/4/02 true
2 P34T 1012.0 C02 980.0 8/1/02 8/10/02 true
3 P14 1014.0 C09 1200.0 6/19/02 6/24/02 true
4 P58 1007.0 A02 475.0 1/29/03 false
5 WP13 1018.0 C11 400.0 8/1/02 8/10/02 true
6 P58 1019.0 B05 975.0 1/20/03 false
7 YP243 1009.0 A14 875.0 7/18/02 7/21/02 true
8 YP24R 1010.0 C02 740.0 5/17/02 5/24/02 true
9 B12 1016.0 B02 300.0 2/5/02 2/10/02 true
10 DF14 1003.0 B02 250.0 4/7/02 4/17/02 true
11 SP210 1019.0 B05 1265.0 12/10/02 12/15/02 true
12 SP26S 1005.0 A02 550.0 6/19/02 6/24/02 true
13 WP18 1019.0 B05 345.0 2/5/02 2/10/02 true
14 YP242 1020.0 A02 190.0 3/12/02 3/15/02 true
15 SP16 1004.0 B05 1100.0 4/7/02 4/17/02 true
16 DF16 1020.0 A02 175.0 3/12/02 3/15/02 true
17 O38 1011.0 A05 1800.0 1/3/03 false
18 P38 1005.0 A02 650.0 8/20/02 9/3/02 true
19 YP24RG 1005.0 A02 550.0 1/29/03 false
20 DF210S 1019.0 B05 150.0 7/18/02 7/21/02 true
21 DF242 1005.0 A02 2000.0 8/1/02 8/10/02 true
22 DF24S 1006.0 B02 380.0 5/16/02 5/20/02 true
23 SP212 1002.0 A02 1100.0 1/23/03 false
24 SP243 1015.0 A14 1400.0 1/25/03 false
25 SP28S 1016.0 B02 880.0 7/1/02 7/11/02 true
26 YP210 1005.0 A02 282.0 4/7/02 4/17/02 true
27 P12 1012.0 C02 1750.0 1/10/03 false
28 P58 1001.0 C09 500.0 6/7/02 6/17/02 true
29 P34 1003.0 B02 1150.0 7/18/02 7/21/02 true
30 W12 1010.0 C02 900.0 7/18/02 7/21/02 true
31 P58 1020.0 A02 600.0 2/5/02 2/10/02 true
32 DF28 1009.0 A14 400.0 10/1/02 10/9/02 true
Product Code Description Category Size Finish List Price Discount
B12 Cab. Lumber Plywood 0.5 G2S ¤ 2.45 0.03
DF14 Ungraded lumber Board 1 X 4 RGH ¤ 1.90 0.025
DF16 Ungraded lumber Board 1 X 6 RGH ¤ 1.85 0.025
DF210S Standard lumber Dim. 2 X 10 S4S ¤ 2.10 0.035
DF242 2+ Oak Dim. 2 X 4 S4S ¤ 2.85 0.04
DF24S Standard lumber Dim. 2 X 4 S4S ¤ 2.10 0.035
DF24U Utility Pine Dim. 2 X 4 S4S ¤ 1.75 0.04
DF26 Standard lumber Dim. 2 X 6 S4S ¤ 2.10 0.035
DF28 Standard lumber Dim. 2 X 8 S4S ¤ 2.10 0.035
O12 Cab. Lumber Plywood 0.5 G2S ¤ 1.19 0.03
O38 Cab. Lumber Plywood 0.375 G2S ¤ 1.25 0.03
P12 Constr. Lumber Plywood 0.50 G1S ¤ 1.32 0.03
P12U Utility Pine Plywood 0.5 RGH ¤ 1.75 0.04
P14 Constr. Lumber Plywood 0.25 G1S ¤ 2.10 0.03
P34 Constr. Lumber Plywood 0.75 G1S ¤ 2.19 0.03
P34T Constr. Lumber Plywood 0.75 T&G ¤ 2.17 0.03
P38 Constr. Lumber Plywood 0.375 G1S ¤ 1.99 0.03
P58 Constr. Lumber Plywood 0.625 G1S ¤ 1.88 0.03
P58T Constr. Lumber Plywood 0.675 T&G ¤ 1.75 0.03
P58U Utility Pine Plywood 0.625 RGH ¤ 1.75 0.04
SP14 Ungraded lumber Board 1 X 4 RGH ¤ 1.85 0.025
SP14R Ungraded lumber Board 1 X 4 RGH ¤ 1.64 0.025
SP16 Ungraded lumber Board 1 X 6 RGH ¤ 1.52 0.025
SP18 Ungraded lumber Board 1 X 8 RGH ¤ 1.85 0.025
SP210 Standard lumber Dim. 2 X 10 S4S ¤ 2.10 0.035
SP212 Standard lumber Dim. 2 X 12 S4S ¤ 2.10 0.035
SP242 2+ Oak Dim. 2 X 4 S4S ¤ 2.85 0.04
SP243 3+ Ash Dim. 2 X 4 S4S ¤ 1.90 0.02
SP24U Utility Pine Dim. 2 X 4 S4S ¤ 1.75 0.04
SP26S Standard lumber Dim. 2 X 4 S4S ¤ 2.10 0.035
SP28S Standard lumber Dim. 2 X 8 S4S ¤ 2.10 0.035
W12 Cab. Lumber Plywood 0.5 G2S ¤ 2.45 0.03
W14 Cab. Lumber Plywood 0.25 G2S ¤ 2.45 0.03
WP110 Utility Pine Board 1 X 10 RGH ¤ 1.75 0.04
WP13 Utility Pine Board 1 X 3 RGH ¤ 1.62 0.04
WP14 Utility Pine Board 1 X 4 RGH ¤ 1.55 0.04
WP16 Utility Pine Board 1 X 6 RGH ¤ 1.80 0.04
WP18 Utility Pine Board 1 X 8 RGH ¤ 1.92 0.04
YP210 Standard lumber Dim. 2 X 10 S4S ¤ 2.10 0.035
YP242 2+ Oak Dim. 2 X 4 S4S ¤ 2.85 0.04
YP243 3+ Ash Dim. 2 X 4 S4S ¤ 1.98 0.04
YP24R Ungraded lumber Dim. 2 X 4 RGH ¤ 1.18 0.025
YP24RG Ungraded lumber Dim. 2 X 4 RGH ¤ 1.23 0.025
YP24S Standard lumber Dim. 2 X 4 S4S ¤ 2.10 0.035
YP24U Utility Pine Dim. 2 X 4 S4S ¤ 1.95 0.03
YP262 2+ Oak Dim. 2 X 6 S4S ¤ 2.85 0.04
YP26R Ungraded lumber Dim. 2 X 6 RGH ¤ 1.19 0.025
YP26S Standard lumber Dim. 2 X 6 S4S ¤ 2.10 0.035
YP28S Standard lumber Dim. 2 X 8 S4S ¤ 2.10 0.035
Customer Name Sales Rep ID Sales Rep Last Name Sales Rep First Name Sales Rep Phone Sales Rep Hours Sales Rep Date Hired
Segal Inc. C09 Bocelli Carl (603) 522-6487 38.0 9/20/01
Segal Inc. C09 Bocelli Carl (603) 522-6487 38.0 9/20/01
Fair Weather Enterprises A02 Duke Arthur (617) 336-5547 40.0 6/25/02
Fair Weather Enterprises A02 Duke Arthur (617) 336-5547 40.0 6/25/02
Fair Weather Enterprises A02 Duke Arthur (617) 336-5547 40.0 6/25/02
Halston & Co. B02 Bose Sally (207) 422-7411 38.0 4/10/00
MMB Holdings B05 van der Ham Lawrence (202) 844-6033 35.0 6/30/01
MMB Holdings B05 van der Ham Lawrence (202) 844-6033 35.0 6/30/01
Ward Co. A02 Duke Arthur (617) 336-5547 40.0 6/25/12
Bakertime Mobile B02 Bose Sally (207) 422-7411 38.0 4/10/00
Bakertime Mobile B02 Bose Sally (207) 422-7411 38.0 4/10/00
Classic Accents A02 Duke Arthur (617) 336-5547 40.0 6/25/02
Classic Accents A02 Duke Arthur (617) 336-5547 40.0 6/25/02
Classic Accents A02 Duke Arthur (617) 336-5547 40.0 6/25/02
Summit Supply B05 van der Ham Lawrence (202) 844-6033 35.0 6/30/01
Summit Supply B05 van der Ham Lawrence (202) 844-6033 35.0 6/30/01
Harper & Ronick A14 Fink Peter (860) 545-9823 30.0 10/25/99
Professional Supply C02 Bonham Earl (802) 455-9070 38.0 2/15/00
Professional Supply C02 Bonham Earl (802) 455-9070 38.0 2/15/00
Professional Supply C02 Bonham Earl (802) 455-9070 38.0 2/15/00
Silver Cloud A05 Louis-Hawkins Brenda (212) 224-3322 35.0 7/15/99
Ryssell Bros. C02 Bonham Earl (802) 455-9070 38.0 2/15/00
Ryssell Bros. C02 Bonham Earl (802) 455-9070 38.0 2/15/00
Ryssell Bros. C02 Bonham Earl (802) 455-9070 38.0 2/15/00
Omega Distributions C11 Masterson Janet (703) 342-4392 40.0 11/30/98
Omega Distributions C11 Masterson Janet (703) 342-4392 40.0 11/30/98
J&J Ltd. C09 Bocelli Charlotte (603) 522-6487 38.0 9/20/01
Dalhousie Inc. A14 Fink Peter (860) 545-9823 30.0 10/25/99
Larkspur Corp. B02 Bose Sally (207) 422-7411 38.0 4/10/00
Pro-Dist Co. C11 Masterson Janet (703) 342-4392 40.0 11/30/98
Pro-Dist Co. C11 Masterson Janet (703) 342-4392 40.0 11/30/98
Pro-Dist Co. C11 Masterson Janet (703) 342-4392 40.0 11/30/98
De Palma Supply C11 Masterson Janet (703) 342-4392 40.0 11/30/98
Cameron-Best B05 van der Ham Lawrence (202) 844-6033 35.0 6/30/01
MPM Inc. A02 Duke Arthur (617) 336-5547 40.0 6/25/02
Territory Code Territory Name
1.0 Massachusetts
2.0 New Hampshire
3.0 Connecticut
4.0 Maine / Vermont
5.0 New York / New Jersey
6.0 Washington DC / Maryland
7.0 Virginia / West Virginia
8.0 Southeast