ACCESS LNC

profilesquashyja
joshuafinal_db_week8.accdb
Home>Computer Science homework help>ACCESS LNC
CustomerID CustomerName CustomerAddress CustomerCity CustomerState CustomerZip CustomerTerritory SalesRepID Active
1004.0 MMB Holdings 4090 Lethbridge Street Vienna VA 33067 7 B05 false
1008.0 Summit Supply Ridgeway Connector Stoney Bluff WV 35666 7 B05 false
1013.0 Omega Distributions 32 Merrit Ave Orlando FL 35667 8 C11 false
1017.0 Pro-Dist Co. 1121 Lorne Drive Montrose NC 46777 8 C11 false
1018.0 De Palma Supply 988 Laval Crescent Pemberton SC 53488 8 C11 false
1019.0 Cameron-Best 429 Mt Ida Drive East Gardom VA 33068 7 B05 false
ContactID ContactFirstname ContactLastname ContactPosition ContactPhone ContactTitle Company CustomerID
100.0 Harry Segal Vice President (603) 555-0987 Mr Segal Inc. 1001.0
125.0 Pablo Diaz CEO (703) 222-5678 Mr Segal Inc. 1001.0
126.0 Naomi Mirada CFO (703) 222-5679 Mrs Fair Weather Enterprises 1002.0
200.0 Mary Ann Waters CFO (603) 555-0988 Mrs Fair Weather Enterprises 1002.0
250.0 Ann Zankoski Marketing Manager (207) 354-0099 Mrs Fair Weather Enterprises 1002.0
251.0 Bob Zankoski Vice President (207) 354-0100 Mr Halston & Co. 1003.0
252.0 Aaron Zankoski CFO (207) 354-0101 Mr MMB Holdings 1004.0
331.0 Gary Twomey Vice President (805) 999-1090 Mr MMB Holdings 1004.0
332.0 Brian Ross CEO (805) 999-1091 Mr Ward Co. 1005.0
333.0 Michael Jackson CFO (805) 999-1092 Mr Bakertime Mobile 1006.0
335.0 Karen Harper-Willis Marketing Manager (617) 354-1234 Mrs Bakertime Mobile 1006.0
336.0 Mark Stevenson CEO (617) 354-1235 Mr Classic Accents 1007.0
337.0 Benjamin Yang CFO (617) 354-1236 Mr Classic Accents 1007.0
444.0 Jonathan Reusche CEO (802) 455-1124 Mr Classic Accents 1007.0
487.0 Rachel Pappas Vice President (802) 455-1123 Mrs Summit Supply 1008.0
490.0 Maxine Garrison Marketing Manager (802) 455-1122 Mr Summit Supply 1008.0
600.0 Dianne Lorenzo CEO (631) 757-3344 Mrs Harper & Ronick 1009.0
850.0 Tom DiBono Vice President (201) 455-8765 Mr Professional Supply 1010.0
851.0 Ruth Schroeder CEO (201) 455-8766 Mrs Professional Supply 1010.0
900.0 Jim Shelby COO (617) 344-6677 Mr Professional Supply 1010.0
950.0 Jason Monte CFO (201) 233-4567 Mr Silver Cloud 1011.0
1200.0 Dave Burley CEO (781) 566-2233 Mr Ryssell Bros. 1012.0
1201.0 Connie Burley Vice President (781) 566-2234 Mrs Ryssell Bros. 1012.0
1202.0 Teresa Perry Marketing Manager (781) 566-2235 Mrs Ryssell Bros. 1012.0
1500.0 Gary Giovanetti CFO (304) 555-6677 Mr Omega Distributions 1013.0
1501.0 John Kim CEO (304) 555-6678 Mr Omega Distributions 1013.0
1510.0 Marvin Gardens President & CEO (508) 433-6543 Mr J&J Ltd. 1014.0
1700.0 Lee Panetti CEO (206) 333-4455 Mr Dalhousie Inc. 1015.0
1780.0 Patty Glico Marketing Manager (603) 233-0099 Mr Larkspur Corp. 1016.0
2100.0 Maria Shimano President & CEO (704) 566-7889 Mrs Pro-Dist Co. 1017.0
2500.0 Paul Tomazewski President & CEO (305) 455-6778 Mr Pro-Dist Co. 1017.0
2505.0 David Tonelli CFO (305) 455-6779 Mr Pro-Dist Co. 1017.0
2750.0 Timothy Warren President (806) 333-4556 Mr De Palma Supply 1018.0
2800.0 Jackie Soupe President & CEO (203) 456-7790 Mrs Cameron-Best 1019.0
3400.0 Harriet Billingsley CFO (703) 233-5876 Mrs MPM Inc. 1020.0
CustomerID CustomerName CustomerAddress CustomerCity CustomerState CustomerZip CustomerTerritory SalesRepID Active
1001.0 Segal Inc. #11 - Hwy 16 Nashua NH 3060 2 C09 true
1002.0 Fair Weather Enterprises 345 Wiltshire Avenue Cambridge MA 2139 1 A02 true
1003.0 Halston & Co. 387 Roper Place Northport NY 11768 5 B02 true
1004.0 MMB Holdings 4090 Lethbridge Street Vienna VA 33067 7 B05 false
1005.0 Ward Co. 35-9087 14th Street Boston MA 2115 1 A02 true
1006.0 Bakertime Mobile 759 East 31 Ave Trenton NJ 7882 5 B02 true
1007.0 Classic Accents 324 Main Street Burlington MA 1803 1 A02 true
1008.0 Summit Supply Ridgeway Connector Stoney Bluff WV 35666 7 B05 false
1009.0 Harper & Ronick 288 Landsdowne Drive Nicola CT 23445 3 A14 true
1010.0 Professional Supply 7241 South Drive Thomaston ME 4778 4 C02 true
1011.0 Silver Cloud 111 Rand Avenue Baltimore MD 22777 6 A05 true
1012.0 Ryssell Bros. 1255 Vollrath St South Glenn VT 45668 4 C02 true
1013.0 Omega Distributions 32 Merrit Ave Orlando FL 35667 8 C11 false
1014.0 J&J Ltd. 675 Cinnamon Ridge Road Manchester NH 3101 2 C09 true
1015.0 Dalhousie Inc. 2233 Southgate Avenue Southgate CT 23555 3 A14 true
1016.0 Larkspur Corp. 4949 Douglas Road Princeton NJ 12234 5 B02 true
1017.0 Pro-Dist Co. 1121 Lorne Drive Montrose NC 46777 8 C11 false
1018.0 De Palma Supply 988 Laval Crescent Pemberton SC 53488 8 C11 false
1019.0 Cameron-Best 429 Mt Ida Drive East Gardom VA 33068 7 B05 false
1020.0 MPM Inc. 3535 Bank Road Gardner ma 1440 1 A02 true
CustomerID CustomerName CustomerAddress CustomerCity CustomerState CustomerZip CustomerTerritory SalesRepID Active
1001.0 Segal Inc. #11 - Hwy 16 Nashua NH 3060 2 C09 true
1002.0 Fair Weather Enterprises 345 Wiltshire Avenue Cambridge MA 2139 1 A02 true
1003.0 Halston & Co. 387 Roper Place Northport NY 11768 5 B02 true
1005.0 Ward Co. 35-9087 14th Street Boston MA 2115 1 A02 true
1006.0 Bakertime Mobile 759 East 31 Ave Trenton NJ 7882 5 B02 true
1007.0 Classic Accents 324 Main Street Burlington MA 1803 1 A02 true
1009.0 Harper & Ronick 288 Landsdowne Drive Nicola CT 23445 3 A14 true
1010.0 Professional Supply 7241 South Drive Thomaston ME 4778 4 C02 true
1011.0 Silver Cloud 111 Rand Avenue Baltimore MD 22777 6 A05 true
1012.0 Ryssell Bros. 1255 Vollrath St South Glenn VT 45668 4 C02 true
1014.0 J&J Ltd. 675 Cinnamon Ridge Road Manchester NH 3101 2 C09 true
1015.0 Dalhousie Inc. 2233 Southgate Avenue Southgate CT 23555 3 A14 true
1016.0 Larkspur Corp. 4949 Douglas Road Princeton NJ 12234 5 B02 true
1020.0 MPM Inc. 3535 Bank Road Gardner ma 1440 1 A02 true
OrderID ProductCode CustomerID RepID QuantityOrdered DateOfOrder DateFilled OrdeComplete
4 P58 1007.0 A02 475.0 1/29/03 false
6 P58 1019.0 B05 975.0 1/20/03 false
17 O38 1011.0 A05 1800.0 1/3/03 false
19 YP24RG 1005.0 A02 550.0 1/29/03 false
23 SP212 1002.0 A02 1100.0 1/23/03 false
24 SP243 1015.0 A14 1400.0 1/25/03 false
27 P12 1012.0 C02 1750.0 1/10/03 false
OrderID ProductCode CustomerID RepID QuantityOrdered DateOfOrder DateFilled OrdeComplete
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
ProductCode Description Category Size Finish ListPrice 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
SalesRepID SalesRepLastName SalesRepFirst_Name SalesRepTerritory SalesRepPhone SalesRepHours SalesRepDateHired
A02 Duke Arthur 1 (617) 336-5547 40.0 6/25/02
A05 Louis-Hawkins Brenda 6 (212) 224-3322 35.0 7/15/99
A14 Fink Peter 3 (860) 545-9823 30.0 10/25/99
B02 Bose Sally 5 (207) 422-7411 38.0 4/10/00
B05 van der Ham Lawrence 7 (202) 844-6033 35.0 6/30/01
C02 Bonham Earl 4 (802) 455-9070 38.0 2/15/00
C09 Bocelli Carl 2 (603) 522-6487 38.0 9/20/01
C11 Masterson Janet 8 (703) 342-4392 40.0 11/30/98
TerritoryCode TerritoryName
1 Massachusetts
2 New Hampshire
3 Connecticut
4 Maine / Vermont
5 New York / New Jersey
6 Washington DC / Maryland
7 Virginia / West Virginia
8 Southeast
SELECT tblCustomer.CustomerID, tblCustomer.CustomerName, tblContacts.ContactFirstname, tblContacts.ContactLastname, tblContacts.ContactPhone FROM tblCustomer INNER JOIN tblContacts ON tblCustomer.[CustomerID] = tblContacts.[CustomerID] WHERE (((tblCustomer.Active)=Yes)) ORDER BY tblCustomer.CustomerName, tblContacts.ContactFirstname, tblContacts.ContactLastname;
SELECT tblCustomer.CustomerID, tblCustomer.CustomerName, tblCustomer.CustomerTerritory, tblSalesRep.SalesRepID, tblSalesRep.SalesRepLastName, tblProducts.ProductCode, tblProducts.Description FROM tblProducts INNER JOIN ((tblSalesRep INNER JOIN tblCustomer ON tblSalesRep.SalesRepID=tblCustomer.SalesRepID) INNER JOIN tblOrders ON tblCustomer.CustomerID=tblOrders.CustomerID) ON tblProducts.ProductCode=tblOrders.ProductCode WHERE (((tblCustomer.CustomerTerritory)="1" Or (tblCustomer.CustomerTerritory)="5") AND ((tblProducts.Description)="Standard lumber")) OR (((tblCustomer.CustomerTerritory)="3")) ORDER BY tblCustomer.CustomerName, tblProducts.Description;
SELECT tblCustomer.CustomerName, tblProducts.Description, tblProducts.ProductCode, tblOrders.QuantityOrdered, tblOrders.DateOfOrder FROM tblProducts INNER JOIN (tblCustomer INNER JOIN tblOrders ON tblCustomer.[CustomerID] = tblOrders.[CustomerID]) ON tblProducts.[ProductCode] = tblOrders.[ProductCode] WHERE (((tblOrders.DateOfOrder)>=#1/1/2003#));
SELECT tblProducts.Description, tblProducts.ProductCode, tblCustomer.CustomerName, tblOrders.QuantityOrdered, tblProducts.ListPrice, tblProducts.Discount, [QuantityOrdered]*[ListPrice] AS [Base Cost], [Base Cost]-[Multiple] AS [Discounted Cost] FROM tblProducts INNER JOIN (tblCustomer INNER JOIN tblOrders ON tblCustomer.CustomerID=tblOrders.CustomerID) ON tblProducts.ProductCode=tblOrders.ProductCode ORDER BY tblProducts.Description, tblCustomer.CustomerName;
SELECT [qry#4TotalProductCost].CustomerName, Sum([qry#4TotalProductCost].[Discounted Cost]) AS [SumOfDiscounted Cost] FROM [qry#4TotalProductCost] GROUP BY [qry#4TotalProductCost].CustomerName ORDER BY [qry#4TotalProductCost].CustomerName;
SELECT tblTerritories.TerritoryName, tblSalesRep.[SalesRepLastName] & ", " & [SalesRepFirst_Name] AS Expr1, tblCustomer.CustomerName, tblContacts.ContactFirstname, tblContacts.ContactLastname FROM tblCustomer INNER JOIN ((tblTerritories INNER JOIN tblSalesRep ON tblTerritories.[TerritoryCode] = tblSalesRep.[SalesRepTerritory]) INNER JOIN tblContacts ON tblTerritories.[TerritoryCode] = tblContacts.[ContactID]) ON tblCustomer.[CustomerID] = tblContacts.[CustomerID] ORDER BY tblTerritories.TerritoryName, tblCustomer.CustomerName;
SELECT tblOrders.[CustomerID], tblCustomer.[CustomerName], tblProducts.Description, tblOrders.[QuantityOrdered], tblOrders.[DateOfOrder] FROM tblProducts INNER JOIN (tblCustomer INNER JOIN tblOrders ON tblCustomer.[CustomerID]=tblOrders.[CustomerID]) ON tblProducts.[ProductCode]=tblOrders.[ProductCode] WHERE (((tblOrders.[CustomerID])=[Enter the product description:]) And ((tblOrders.[DateOfOrder])=[Enter the start date:])) ORDER BY tblOrders.[DateOfOrder];
INSERT INTO tblArchiveInactive (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerZip, CustomerTerritory, SalesRepID, Active) SELECT tblCustomer.CustomerID, tblCustomer.CustomerName, tblCustomer.CustomerAddress, tblCustomer.CustomerCity, tblCustomer.CustomerState, tblCustomer.CustomerZip, tblCustomer.CustomerTerritory, tblCustomer.SalesRepID, tblCustomer.Active FROM tblCustomer WHERE (((tblCustomer.Active)=No));
DELETE tblCustomerBackup.CustomerID, tblCustomerBackup.CustomerName, tblCustomerBackup.CustomerAddress, tblCustomerBackup.CustomerCity, tblCustomerBackup.CustomerState, tblCustomerBackup.CustomerZip, tblCustomerBackup.CustomerTerritory, tblCustomerBackup.SalesRepID, tblCustomerBackup.Active FROM tblCustomerBackup WHERE (((tblCustomerBackup.Active)=No));
SELECT tblOrders.OrderID, tblOrders.ProductCode, tblOrders.CustomerID, tblOrders.RepID, tblOrders.QuantityOrdered, tblOrders.DateOfOrder, tblOrders.DateFilled, tblOrders.OrdeComplete INTO tblIncompleteOrders FROM tblOrders WHERE (((tblOrders.OrdeComplete)=No));