ACCESS LNC

profilesquashyja
source1.accdb
Home>Computer Science homework help>ACCESS LNC
strBidNumber dtmBidDate dtmExpires strDefinition strAddress strCity strState strZIPCode strPrincipal strTelephone memNotes strAwardDate strWorkOrder# strCustomerID
98-101 1/1/03 5/2/03 New Fireplace 2115 Jasper St. Boston MA 02115 McCoy, John (617) 555-3986 2/15/03 001 1032
98-102 1/15/03 3/1/03 Replace Waterheater 176 3rd St. Boston MA 02115 Brown, Mary (617) 555-8732 Overbid Material Lost
98-103 2/3/03 6/1/03 Install 3 Attic Vents 329 Mt. Auburn St. Cambridge MA 02139 Jones, David (617) 555-4673 3/1/03 002 1033
98-104 2/25/03 3/25/03 New Garage Doors 560 Barker St. Cambridge MA 02140 Martin, Dean (617) 555-8766 High Labor Lost
98-105 3/3/03 7/2/03 Install A/C 2478 Tremont St. Boston MA 02115 Rogers, Ohykkis (617) 555-2479 4/1/03 003 1034
98-106 3/15/03 5/15/03 Repair Driveway 1510 Harrison St. Lowell MA 01854 Norr, James 9785559888 High Labor Lost
98-107 3/20/03 7/19/03 Replace Countertops 319 Walker St. Boston MA 02115 Perry, Oliver (617) 555-6544 4/10/03 004 1035
98-108 3/28/03 7/27/03 Move Washer & Dryer 2115 Jasper St. Boston MA 02115 McCoy, John (617) 555-2345 5/1/03 005 1036
98-109 3/28/03 5/28/03 Garden Window 156 Milk St. Boston MA 02115 Moran, Gary (617) 555-4500 High Labor Lost
98-110 4/3/03 5/3/03 TV Wiring 2743 Foster Rd. Boston MA 02115 Melvin, Cole (617) 555-8673 Withdrawn
98-111 4/10/03 5/10/03 Ceiling Fans 186 Garland St. Burlington MA 01803 Brown, Agnes 7815554766 5/5/03 006 1037
98-112 4/15/03 6/15/03 Sprinklers 322 Main St. Burlington MA 01803 Lofton, May 7815552228 Withdrawn
98-113 4/25/03 5/25/03 Finish Basement 1520 Harrison St. Burlington MA 01803 Selms, Harry 7815556489 5/20/03 007 1038
98-114 5/2/03 6/2/03 Attic Bedroom 815 Cromwell St. Boston MA 02115 Keiner, Evelyn (617) 555-8977 Pending
98-115 5/13/03 7/13/03 New Bathroom 621 Commonwealth Ave. Boston MA 02115 Cornell, John (617) 555-2433 Pending
98-116 5/13/03 6/13/03 Garden Window 329 Mt. Auburn St. Cambridge MA 02139 Jones, David (617) 555-4673 6/10/03 008 1033
98-117 5/18/03 8/18/03 SPA Heater 952 Chapin St. Lowell MA 01854 Anders, Bob 9785553335 6/18/03 009 1039
98-118 5/18/03 6/18/03 DSS Install 560 Barker St. Cambridge MA 02140 Martin, Dean (617) 555-8766 High Labor Lost
98-119 5/24/03 6/24/03 Replace Toilet 2115 Jasper St. Boston MA 02115 McCoy, John (617) 555-2345 6/25/03 010 1032
98-120 5/26/03 6/26/03 Repair Driveway 1510 Harrison St. Lowell MA 01854 Norr, James 9785559888 6/25/03 011 1040
98-121 5/28/03 6/28/03 Erect Tool Shed 329 Mt. Auburn St. Cambridge MA 02139 Jones, David (617) 555-4673 6/30/03 012 1033
98-122 6/3/03 7/3/03 Bay Window 2115 Jasper St. Boston MA 02115 McCoy, John (617) 555-2345 7/1/03 013 1032
98-123 6/5/03 7/5/03 Porch Roof 560 Barker St. Cambridge MA 02140 Martin, Dean (617) 555-8766 High Labor Lost
98-124 6/5/03 7/5/03 Soaker System 186 Garland St. Burlington MA 01802 Brown, Agnes 7815554766 7/1/03 014 1037
98-125 6/7/03 7/7/03 Install Dish Washer 952 Chapin St. Lowell MA 01854 Anders, Bob 9785553335 7/1/03 015 1039
strEmployeeID strFirstName strMI strLastName strSSN strSpecialty strWorkExtension strPager curHourlyRate sngHours dtmHireDate ysnHealth memComments dtmCurrentDate
12 Rick J. O'Brien 327001437 Carpentry 788 (718) 788-2345 ¤ 15.00 25.5 2/1/99 false 9/11/02
13 Barbara A. Benson 211990123 Administration 289 ¤ 9.00 30.5 8/12/01 false 9/11/02
14 Charles B. Adams 356770912 Electrical 871 (617) 355-8722 ¤ 25.25 40.0 6/10/00 true Union member 9/13/02
15 John R. Kordel 233556789 Labor 998 (617) 354-9999 ¤ 45.00 40.0 5/12/01 true 9/15/02
16 Richard A. Sherwood 400983477 Masonry 298 (617) 666-2345 ¤ 18.50 32.0 1/15/01 false Union 9/15/02
17 Dawn G. Culhaney 077895466 Administration 567 ¤ 10.75 40.0 4/18/01 true 9/15/02
18 Calvin R. Hobbs 788561222 Electrical 667 (617) 354-0111 ¤ 20.00 28.0 8/10/00 false 9/18/02
19 David C. Tomaszewski 988113466 Engineering 789 ¤ 25.00 40.0 2/18/99 true 9/18/02
20 Andy P. Wilson 304001369 Engineering 123 ¤ 32.00 40.0 3/5/95 true 17+ years experience in the field 9/18/02
21 George F. Jamison 455667811 Admin Asst 742 ¤ 25.00 32.0 3/10/01 false 9/20/02
22 Paul B. Byron 677803354 Electrical 886 ¤ 10.00 40.0 5/12/00 true 9/21/02
23 Bryan V. Ferrell 822945777 Engineering 624 ¤ 15.00 40.0 6/18/98 true 9/21/02
24 Benjamin J. Cloud 744018433 Engineering 815 ¤ 12.25 38.0 8/1/99 true 9/21/02
25 Selma R. Gunderson 455770922 Carpentry 616 ¤ 10.00 38.0 3/8/99 true 9/23/02
26 David L. Miller 366821199 Finishing 722 ¤ 25.00 32.5 2/12/00 false 9/23/02
27 Fred C. Connelly 288667100 Plumbing 227 ¤ 30.00 40.0 9/12/00 true 9/27/02
28 John C. Carrington 677113455 Electrical 354 ¤ 35.00 40.0 4/30/97 true 9/27/02
29 Don S. DeSalle 699001827 Masonry 445 ¤ 14.00 18.5 12/15/00 false 10/10/02
30 Richard C. Howell 720002040 Labor 229 ¤ 18.50 28.0 11/21/02 false 10/10/02
31 Harry M. Taylor 890335678 Labor 753 ¤ 29.00 35.0 3/6/99 true 10/13/02
32 David E. Dobbins 729112150 Labor/Driver 934 ¤ 25.00 38.0 2/4/02 true 10/13/02
33 Mary R. James 619003477 Administration 467 ¤ 28.25 38.5 6/8/01 true 10/13/02
strEmployeeID strAddress strCity strState strZIP strHomePhone dtmCurrentDate
10 256 Barkley Way Burlington ma 01803 7812881298 12/3/03
11 19 Waverly Street Cambridge ma 02140 6173546789 12/3/03
12 2705 Franklin St. Burlington ma 01803-5344 7812738944 9/11/03
13 38 Karen Drive Lowell ma 01854-2344 9783546666 9/11/03
14 490 Rogers St. Boston ma 02116-5678 6172994000 9/13/03
15 388 Walker St. Cambridge ma 02139-6789 6173546622 9/15/03
16 12 Garfield St. Boston ma 02115 6172449876 9/15/03
17 877 Twomey Rd. Lowell ma 01854 9782725555 9/15/03
18 344 Arthur St. Cambridge ma 02140 6173549111 9/18/03
19 27 Antioch St. Lowell ma 01854 9782881234 9/18/03
20 316 South St. Boston MA 02115 6172884567 9/18/02
21 10 Lamp Post Rd. Andover ma 01810 9787490124 9/20/03
22 1529 Mount Auburn St. Cambridge ma 02140 6173546098 9/21/03
23 3163 Chapin St. Boston ma 02117 6172885577 9/21/03
24 2015 3rd St. Burlington ma 01803 7812724700 9/21/03
25 1800 Northfield St. Cambridge ma 02140 6173546888 9/23/03
26 209 Parker St. Boston ma 02115 6172994567 9/23/03
27 1415 Tremont St. Boston ma 02115 6172998711 9/27/03
28 902 1st Ave. Cambridge ma 02139 6173544489 9/27/03
29 2005 5th Ave. Burlington ma 01803 7812724702 10/10/03
30 3560 Harrison Blve. Boston ma 02111 6173775588 10/10/03
31 61 Oak St. Andover ma 01810 9784756110 10/13/03
32 3291 Barbara Way Lowell ma 01854 9782729876 10/13/03
33 1500 Lincoln Ave. Lowell ma 01854 9782721175 10/13/03
34 18 Faulkner Place Lowell ma 01854 9782724567 12/3/03
strPager curHourlyRate sngHours dtmHireDate dtmCurrentDate ysnHealth strEmployeeID strFirstName strMI strLastName strSSN strSpecialty strAddress strCity strState strWorkExtension strHomePhone memComments lngZIP
(718) 788-2345 ¤ 15.00 25.5 2/1/99 9/11/02 false 12 Rick J. O'Brien 327001437 Carpentry 2705 Franklin St. Burlington ma 788 7812738944 1803
¤ 9.00 30.5 8/12/01 9/11/02 false 13 Barbara A. Benson 211990123 Administration 38 Karen Drive Lowell ma 289 9783546666 1854
(617) 355-8722 ¤ 25.25 40.0 6/10/00 9/13/02 true 14 Charles B. Adams 356770912 Electrical 490 Rogers St. Boston ma 871 6172994000 Union member 2116
(617) 354-9999 ¤ 45.00 40.0 5/12/01 9/15/02 true 15 John R. Kordel 233556789 Labor 388 Walker St. Cambridge ma 998 6173546622 2139
(617) 666-2345 ¤ 18.50 32.0 1/15/01 9/15/02 false 16 Richard A. Sherwood 400983477 Masonry 12 Garfield St. Boston ma 298 6172449876 Union 2115
¤ 10.75 40.0 4/18/01 9/15/02 true 17 Dawn G. Culhaney 077895466 Administration 877 Twomey Rd. Lowell ma 567 9782725555 1854
(617) 354-0111 ¤ 20.00 28.0 8/10/00 9/18/02 false 18 Calvin R. Hobbs 788561222 Electrical 344 Arthur St. Cambridge ma 667 6173549111 2140
¤ 25.00 40.0 2/18/99 9/18/02 true 19 David C. Tomaszewski 988113466 Engineering 27 Antioch St. Lowell ma 789 9782881234 1854
¤ 32.00 40.0 3/5/95 9/18/02 true 20 Andy P. Wilson 304001369 Engineering 316 South St. Boston MA 123 6172884567 17+ years experience in the field 2115
¤ 25.00 32.0 3/10/01 9/20/02 false 21 George F. Jamison 455667811 Admin Asst 10 Lamp Post Rd. Andover ma 742 9787490124 1810
¤ 10.00 40.0 5/12/00 9/21/02 true 22 Paul B. Byron 677803354 Electrical 1529 Mount Auburn St. Cambridge ma 886 6173546098 2140
¤ 15.00 40.0 6/18/98 9/21/02 true 23 Bryan V. Ferrell 822945777 Engineering 3163 Chapin St. Boston ma 624 6172885577 2117
¤ 12.25 38.0 8/1/99 9/21/02 true 24 Benjamin J. Cloud 744018433 Engineering 2015 3rd St. Burlington ma 815 7812724700 1803
¤ 10.00 38.0 3/8/99 9/23/02 true 25 Selma R. Gunderson 455770922 Carpentry 1800 Northfield St. Cambridge ma 616 6173546888 2140
¤ 25.00 32.5 2/12/00 9/23/02 false 26 David L. Miller 366821199 Finishing 209 Parker St. Boston ma 722 6172994567 2115
¤ 30.00 40.0 9/12/00 9/27/02 true 27 Fred C. Connelly 288667100 Plumbing 1415 Tremont St. Boston ma 227 6172998711 2115
¤ 35.00 40.0 4/30/97 9/27/02 true 28 John C. Carrington 677113455 Electrical 902 1st Ave. Cambridge ma 354 6173544489 2139
¤ 14.00 18.5 12/15/00 10/10/02 false 29 Don S. DeSalle 699001827 Masonry 2005 5th Ave. Burlington ma 445 7812724702 1803
¤ 18.50 28.0 11/21/02 10/10/02 false 30 Richard C. Howell 720002040 Labor 3560 Harrison Blve. Boston ma 229 6173775588 2111
¤ 29.00 35.0 3/6/99 10/13/02 true 31 Harry M. Taylor 890335678 Labor 61 Oak St. Andover ma 753 9784756110 1810
¤ 25.00 38.0 2/4/02 10/13/02 true 32 David E. Dobbins 729112150 Labor/Driver 3291 Barbara Way Lowell ma 934 9782729876 1854
¤ 28.25 38.5 6/8/01 10/13/02 true 33 Mary R. James 619003477 Administration 1500 Lincoln Ave. Lowell ma 467 9782721175 1854
strWorkOrderNumber strCustomerID strBidNumber dtmStartDate dtmCompletionDate strSupervisor strHelper curMaterialCost curLaborCost memDescription Drawing
004 1035 98-107 4/15/03 4/20/03 12 18 ¤ 262.50 ¤ 252.00 Move washer and dryer
005 1036 98-108 5/10/03 5/15/03 14 19 ¤ 115.50 ¤ 315.00 Replace countertops
006 1037 98-111 5/12/03 5/25/03 17 ¤ 750.00 ¤ 800.00 Ceiling fans
007 1038 98-113 6/15/03 9/15/03 13 ¤ 2,500.00 ¤ 7,200.00 Finish basement
008 1033 98-116 6/15/03 7/1/03 12 ¤ 400.00 ¤ 750.00 Garden window
009 1039 98-117 6/25/03 6/26/03 10 17 ¤ 1,100.00 ¤ 450.00 SPA heater
010 1032 98-119 6/26/03 7/1/03 19 ¤ 175.00 ¤ 100.00 Replace toilet
011 1040 98-120 6/30/03 7/15/03 15 ¤ 300.00 ¤ 1,300.00 Repair driveway
012 1033 98-121 7/15/03 7/18/03 19 ¤ 280.00 ¤ 480.00 Erect tool shed
013 1032 98-122 7/10/03 7/15/03 10 17 ¤ 400.00 ¤ 1,100.00 Bay window
014 1037 98-124 7/12/03 7/20/03 12 18 ¤ 75.00 ¤ 300.00 Soaker system
015 1039 98-125 7/15/03 7/15/03 12 18 ¤ 420.00 ¤ 100.00 Install dishwasher
dtmStartDate dtmCompletionDate curMaterialCost curLaborCost memDescription Drawing strWorkOrderNumber strCustomerID strBidNumber strSupervisor strHelper
2/25/03 3/10/03 ¤ 500.00 ¤ 400.00 New wall 032 1032 98-101 10
3/15/03 3/18/03 ¤ 1,355.00 ¤ 740.00 Fix ceiling 999 1033 98-103 12
3/10/03 3/15/03 ¤ 600.00 ¤ 900.00 Repair roof 888 1034 98-105 14
4/25/03 4/30/03 ¤ 675.00 ¤ 850.00 Dry wall 1023 1037 98-200 10
6/5/03 6/25/03 ¤ 1,000.00 ¤ 1,200.00 Roofing 993 1043 98-400 14