Thomas_Exp19_Access_Ch07_HOEAssessment_Technical_Services.accdb

Thomas_Exp19_Access_Ch07_HOEAssessment_Technical_Services.accdb

CallTypeIDDescriptionHourlyRatemSysRowId
1Hardware Support20A3dPv9NQtKfk2JaO2r83lK70RHEHHNS8uszg2GEwLOo=-~fivasi/85vCxkEuapsoBjA==
2Software Support20A3dPv9NQtKfk2JaO2r83lK70RHEHHNS8uszg2GEwLOo=-~fivasi/85vCxkEuapsoBjA==
3Network Troubleshooting30A3dPv9NQtKfk2JaO2r83lK70RHEHHNS8uszg2GEwLOo=-~fivasi/85vCxkEuapsoBjA==
4Network Installation20A3dPv9NQtKfk2JaO2r83lK70RHEHHNS8uszg2GEwLOo=-~fivasi/85vCxkEuapsoBjA==
5Training30A3dPv9NQtKfk2JaO2r83lK70RHEHHNS8uszg2GEwLOo=-~fivasi/85vCxkEuapsoBjA==
6Security Camera Maintenance40A3dPv9NQtKfk2JaO2r83lK70RHEHHNS8uszg2GEwLOo=-~fivasi/85vCxkEuapsoBjA==
7Virus Removal20A3dPv9NQtKfk2JaO2r83lK70RHEHHNS8uszg2GEwLOo=-~fivasi/85vCxkEuapsoBjA==
8Disaster Recovery70A3dPv9NQtKfk2JaO2r83lK70RHEHHNS8uszg2GEwLOo=-~fivasi/85vCxkEuapsoBjA==
9VoIP Service30A3dPv9NQtKfk2JaO2r83lK70RHEHHNS8uszg2GEwLOo=-~fivasi/85vCxkEuapsoBjA==
10Other30A3dPv9NQtKfk2JaO2r83lK70RHEHHNS8uszg2GEwLOo=-~fivasi/85vCxkEuapsoBjA==
CallIDCustomerIDRepIDCallTypeIDHoursLoggedOpenedDateClosedDateCustomerSatisfaction
001YS01252121/1/191/10/191
002YS0383231/1/191/12/192
003YS0205431/1/191/10/194
004YS0092651/2/191/6/194
005YS0124911/2/191/6/195
006YS0043751/3/191/9/194
007YS0415371/4/191/6/191
008YS0075631/4/191/9/191
009YS0276991/4/191/12/193
010YS0402851/5/191/11/194
011YS0313551/6/191/13/192
012YS00765121/6/191/15/194
013YS0447241/10/191/15/195
014YS0297881/11/191/22/195
015YS02045101/11/191/13/193
016YS0277861/12/191/14/194
017YS00776121/13/191/24/193
018YS0407821/13/191/21/191
019YS0446991/14/191/20/194
020YS0183521/15/191/21/193
021YS0441211/18/191/28/194
022YS02359111/19/191/22/193
023YS0075511/19/191/29/191
024YS0076361/20/191/28/194
025YS0161711/21/191/23/194
026YS04811061/23/191/25/192
027YS02058101/23/191/27/193
028YS0045411/26/192/5/195
029YS0235931/26/192/6/192
030YS0487971/28/192/8/194
031YS0312612/1/192/3/195
032YS0457422/1/192/11/194
033YS0173312/1/192/4/191
034YS0526642/2/192/7/194
035YS0201482/2/192/8/194
036YS0315662/2/192/8/195
037YS05258122/3/192/6/195
038YS00131062/4/192/15/192
039YS035410102/6/192/16/193
040YS0274522/7/192/16/194
041YS0275862/8/192/19/193
042YS0013942/8/192/11/195
043YS0124442/9/192/11/193
044YS0313762/10/192/14/195
045YS04127122/12/192/17/195
046YS01235112/13/192/18/193
047YS0482142/15/192/19/194
048YS04126122/16/192/23/194
049YS0416322/16/192/26/195
050YS03527112/17/192/25/192
051YS0296752/17/192/25/195
052YS0011252/17/192/22/195
053YS0173412/18/192/26/192
054YS0405342/18/192/26/195
055YS0382522/19/192/21/191
056YS0287332/19/192/26/191
057YS01831122/20/192/23/193
058YS00421112/21/192/23/195
059YS0185322/21/193/2/193
060YS0445582/21/192/24/193
061YS0387822/21/192/27/193
062YS0525772/25/192/27/191
063YS04449112/25/192/28/191
064YS0412472/26/193/2/192
065YS0174212/26/193/6/192
066YS02736102/27/193/9/193
067YS00761123/2/193/4/195
068YS0446563/4/193/6/191
069YS04451013/7/193/16/192
070YS00446113/10/193/20/191
071YS01836123/11/193/21/192
072YS00926113/11/193/17/194
073YS0077823/11/193/16/194
074YS00436123/13/193/21/193
075YS00921023/13/193/23/192
076YS0164833/13/193/21/194
077YS0274843/14/193/16/194
078YS0204973/16/193/26/193
079YS0232753/16/193/27/193
080YS0123653/17/193/24/195
081YS03519103/17/193/24/195
082YS04471023/18/193/21/191
083YS0522813/20/193/24/194
084YS0013373/23/193/30/193
085YS0234373/24/193/27/194
086YS02322123/25/193/29/191
087YS0095933/27/194/6/192
088YS0014473/28/194/1/192
089YS0317413/28/193/31/194
090YS0351913/28/194/3/191
091YS0122314/2/194/7/194
092YS0273224/3/194/7/193
093YS0127224/4/194/11/192
094YS04017124/6/194/12/192
095YS0442734/6/194/15/191
096YS05274104/6/194/16/192
097YS0451424/6/194/17/194
098YS0073354/9/194/15/193
099YS0177624/9/194/13/194
100YS0125984/11/194/18/193
101YS03818104/12/194/16/195
102YS01818124/12/194/18/194
103YS0123694/12/194/15/195
104YS02077114/14/194/22/193
105YS0445154/14/194/21/191
106YS0353154/15/194/23/191
107YS03156104/20/194/26/195
108YS03871074/21/194/30/194
109YS0487644/21/194/23/195
110YS03558114/22/195/3/193
111YS05241034/23/195/2/191
112YS0456174/24/195/2/195
113YS0237334/24/195/2/195
114YS0203434/26/195/6/194
115YS00174124/26/195/6/191
116YS0163214/26/195/6/193
117YS0407394/27/195/7/193
118YS0185184/27/194/29/191
119YS00978104/27/194/28/194
120YS0381314/28/195/4/194
121YS0011914/28/195/3/195
122YS0457335/1/195/3/195
123YS0092365/3/195/13/194
124YS03859105/3/195/10/193
125YS0311455/6/195/15/194
126YS05214105/6/195/13/193
127YS0097485/8/195/11/191
128YS0414465/9/195/14/191
129YS03869125/9/195/13/194
130YS00924115/10/195/17/194
131YS0443945/10/195/13/194
132YS0093315/10/195/17/195
133YS0077275/12/195/20/191
134YS04475125/15/195/20/194
135YS02063125/15/195/31/192
136YS04139115/16/195/22/195
137YS02749125/18/195/22/191
138YS0127365/21/195/28/194
139YS0015525/22/195/27/195
140YS0205545/22/195/25/191
141YS01818105/23/195/29/191
142YS0044135/24/196/4/192
143YS0455655/24/196/3/192
144YS03813115/27/196/7/193
145YS0043785/28/196/2/194
146YS0207415/28/196/4/192
147YS0125936/2/196/9/193
148YS0074596/2/196/12/194
149YS01212116/2/196/12/193
150YS0124986/2/196/8/192
151YS0127666/5/196/10/195
152YS04471076/6/196/16/191
153YS02327116/6/196/9/194
154YS0013656/7/196/17/192
155YS00465106/9/196/12/193
156YS0184466/9/196/20/193
157YS0183536/10/196/13/195
158YS0315156/10/196/18/192
159YS0162996/11/196/18/195
160YS0046776/12/196/18/191
161YS0165816/12/196/18/192
162YS0281886/13/196/18/193
163YS02919116/14/196/24/192
164YS03553126/14/196/25/194
165YS0357666/15/196/17/191
166YS01644106/17/196/20/194
167YS0125116/17/196/24/191
168YS0355526/17/196/25/195
169YS0167526/17/196/21/193
170YS0286286/17/196/24/194
171YS0281476/19/196/26/193
172YS0297656/19/196/23/194
173YS0294546/19/196/30/195
174YS0286136/19/196/29/192
175YS01631066/20/196/22/192
176YS0121646/22/197/1/192
177YS0014476/22/196/25/195
178YS03561076/24/197/5/194
179YS0526976/24/196/26/194
180YS0443556/26/197/7/195
181YS0013586/26/197/5/194
182YS0091676/28/197/9/192
183YS020410126/28/197/2/191
184YS0281457/1/197/8/194
185YS0415187/1/197/11/195
186YS0077227/2/197/9/191
187YS04811097/2/197/11/192
188YS0453327/4/197/4/195
189YS0524137/6/197/15/195
190YS0527947/7/197/15/193
191YS02325107/10/197/13/192
192YS01862117/10/197/19/191
193YS03136117/13/197/15/193
194YS0097967/15/197/19/191
195YS0232537/15/197/24/195
196YS0523887/17/197/23/191
197YS0044617/17/197/23/195
198YS02321047/18/197/28/191
199YS00441127/21/197/31/195
200YS0447897/24/197/29/195
201YS0281127/24/197/26/193
202YS0482377/24/197/28/195
203YS0353987/26/198/3/194
204YS045710127/27/198/2/195
205YS0073767/28/198/8/193
206YS0454368/2/198/8/193
207YS0014558/2/198/11/195
208YS0041718/2/198/4/193
209YS0413828/2/198/7/193
210YS0173978/5/198/8/193
211YS02321028/6/198/9/195
212YS0163158/7/198/12/193
213YS0046488/8/198/10/192
214YS01771088/9/198/17/192
215YS0046148/9/198/12/193
216YS00411118/9/198/18/193
217YS0485978/12/198/19/192
218YS02743108/12/198/20/195
219YS0234428/15/198/17/193
220YS0165338/17/199/8/191
221YS0176978/17/198/25/192
222YS0522378/17/198/21/194
223YS0454228/17/198/24/194
224YS0014448/18/198/24/192
225YS0276998/18/198/28/194
226YS05221068/18/198/28/193
227YS0456448/21/198/28/195
228YS01251028/21/198/29/195
229YS03873118/22/198/29/192
230YS0416758/22/199/2/192
231YS0453918/24/198/30/194
232YS02834108/24/199/3/193
233YS0121748/26/199/5/195
234YS00133108/26/198/31/191
235YS04461098/26/198/31/194
236YS0314378/27/199/7/192
237YS0277948/28/199/6/194
238YS0092739/1/199/5/194
239YS0312729/2/199/5/194
240YS0353629/3/199/14/193
241YS04856129/3/199/14/195
242YS018610109/3/199/5/195
243YS0287419/4/199/9/192
244YS0354389/5/199/10/194
245YS01779119/6/199/8/192
246YS0383749/8/199/15/194
247YS02361119/10/199/10/195
248YS00443129/11/199/19/191
249YS0044289/12/199/18/194
250YS04062119/12/199/22/192
251YS0237249/13/199/22/191
252YS02854129/13/199/17/195
253YS02841019/14/199/17/195
254YS0186489/16/199/23/194
255YS01613109/17/199/23/195
256YS01836129/17/199/24/193
257YS0047939/19/199/24/192
258YS0043279/20/199/26/195
259YS0353179/21/1910/1/191
260YS01731119/21/199/28/195
261YS0285249/22/199/30/194
262YS0094599/23/199/25/194
263YS0452839/24/199/30/195
264YS0042399/24/1910/1/193
265YS0016699/26/1910/7/191
266YS0174869/26/1910/2/193
267YS0453639/26/199/30/194
268YS0352949/27/199/29/193
269YS016171210/1/1910/8/192
270YS01724610/2/1910/8/191
271YS02359710/6/1910/10/194
272YS0295101110/7/1910/17/195
273YS018341110/9/1910/12/193
274YS017210610/10/1910/12/194
275YS01242710/10/1910/19/192
276YS04041310/12/1910/22/195
277YS009221210/12/1910/19/192
278YS04137510/14/1910/23/193
279YS03539110/14/1910/25/194
280YS04016410/16/1910/27/192
281YS029581010/17/1910/24/195
282YS0276101110/17/1910/25/191
283YS04062110/17/1910/22/195
284YS028251110/17/1910/26/192
285YS05246910/17/1910/20/192
286YS01658510/18/1910/21/193
287YS020710810/18/1910/28/195
288YS00148410/19/1910/24/191
289YS02716510/20/1910/20/193
290YS004121010/20/1910/28/194
291YS004361210/21/1910/31/195
292YS05228710/21/1910/28/192
293YS044310210/21/1910/31/191
294YS009161010/22/1911/1/192
295YS03558310/22/1911/2/193
296YS00923410/23/1910/31/193
297YS01262510/23/1910/31/194
298YS007291010/23/1911/1/191
299YS048171010/26/1910/30/192
300YS044610210/26/1911/3/193
301YS023310810/27/1911/1/191
302YS05248410/27/1911/5/193
303YS001410110/27/1911/6/193
304YS040651110/28/1911/3/194
305YS01252111/1/1911/11/192
306YS04524911/2/1911/11/195
307YS00462211/2/1911/9/191
308YS04818511/7/1911/17/192
309YS00455811/7/1911/13/191
310YS031281111/8/1911/13/194
311YS02712811/8/1911/16/192
312YS00453211/8/1911/12/195
313YS03163711/8/1911/10/191
314YS00756611/9/1911/20/194
315YS04536211/10/1911/13/192
316YS04169211/10/1911/20/195
317YS00969311/11/1911/21/192
318YS00932911/12/1911/23/192
319YS02341211/13/1911/21/193
320YS017751011/15/1911/21/192
321YS04418211/15/1911/20/192
322YS01778811/18/1911/23/194
323YS0414101111/19/1911/28/192
324YS00142311/21/1911/23/194
325YS04561411/22/1911/27/192
326YS03533311/22/1911/27/194
327YS02772511/23/1912/4/195
328YS01872211/23/1911/28/193
329YS02855111/24/1911/30/191
330YS040110411/24/1911/28/195
331YS05264511/25/1912/3/195
332YS01762411/25/1912/1/192
333YS02046611/27/1911/30/193
334YS029591211/28/1911/30/193
335YS04821212/2/1912/5/193
336YS017511112/2/1912/9/194
337YS044511212/5/1912/9/194
338YS023141212/5/1912/11/192
339YS04142312/6/1912/11/194
340YS03159812/7/1912/16/194
341YS02851412/8/1912/9/195
342YS00424612/8/1912/10/194
343YS027331212/9/1912/18/194
344YS012221212/11/1912/17/193
345YS02969112/12/1912/15/192
346YS04836912/14/1912/21/194
347YS009331012/14/1912/18/195
348YS04875112/15/1912/22/192
349YS023791212/15/1912/22/195
350YS045731012/15/1912/17/194
351YS00452412/16/1912/19/193
352YS012510212/17/1912/28/193
353YS03129712/18/1912/21/192
354YS001671212/20/1912/25/191
355YS031561112/22/1912/26/192
356YS04852212/22/1912/31/194
357YS0047412/23/19
358YS04127612/24/1912/28/193
359YS0182312/24/19
360YS0204712/24/19
361YS0174312/24/19
362YS04436212/25/1912/28/194
363YS0017312/25/19
364YS0297312/25/19
365YS03129512/26/1912/31/194
366YS04029612/27/19
CustomerIDCompanyNameAddressCityStateZipPhone
YS001SVC Pharmacy2314 Stooren HighwayShepherdMT59079959-280-6894
YS004Monday's Restaurant1125 Constitution WayActonMT59002976-939-7549
YS007Penny's Arcade596 Gulkana StreetHuntleyMT59037236-730-1937
YS009The Home Store1601 Mission WayBillingsMT59106976-394-7333
YS012Grahame Tax Service306 Gayot LaneHuntleyMT59037711-671-5587
YS016Supermercado1920 Cheveley CircleBillingsMT59105711-729-4207
YS017Graber Dentistry1483 Mc Henry PlaceCusterMT59024969-860-9461
YS018Ringwood Trophy Factory1460 Hollow RoadBillingsMT59103959-346-7137
YS020Wild Bill's Office Superstore859 Kitlisa PlaceBillingsMT59116857-910-3588
YS023Haledon Movie Superplex562 Ryle CourtBroadviewMT59015300-256-6712
YS027Totowa Motor Vehicles1880 Giroux LaneBillingsMT59116857-695-3335
YS028Beato & Rauch Law Offices921 Hawkins RoadBillingsMT59117969-488-6244
YS029JobSource2074 Garmisch DriveBallantineMT59006969-707-3936
YS031Homer's CyberCafe413 Chaffee AvenueBillingsMT59105958-362-6984
YS035Fountains of Clifton2000 Brittany AvenueBillingsMT59102830-378-9170
YS038Dr. Jennifer Lynn307 Gwenn BoulevardBillingsMT59111224-547-9818
YS040Fabrics and More1012 Sparks StreetBillingsMT59106236-500-6216
YS041Betagraphics334 Mc Clellan PlaceBallantineMT59006857-582-8032
YS044Dr. Lorenzo Reyes2235 May HighwayActonMT59002822-488-6662
YS045Paterson Credit Union29 Delphin DriveLaurelMT59044424-715-2596
YS048Totowa Day Spa877 Stover HighwayCusterMT59024300-968-2770
YS052Zapatos1595 Star TerraceActonMT59002822-546-3381
IDmSysRowId
1r7RQNhUupiRhhQaZ6A8K6AgqSUwOapwZvta/rclCsIk=-~VQ54YtBUk/PeKHSfTd9GLw==
RepIDRepFirstRepLastmSysRowId
1RosalieLovevkJSbGs+BXc4xiTvLBIzuZf8GBhN7KelJ4cuLNhg8GA=-~s5RWnA0Agc5mbvUi9Qk5pQ==
2CoryMontgomeryvkJSbGs+BXc4xiTvLBIzuZf8GBhN7KelJ4cuLNhg8GA=-~s5RWnA0Agc5mbvUi9Qk5pQ==
3BrookeBallardvkJSbGs+BXc4xiTvLBIzuZf8GBhN7KelJ4cuLNhg8GA=-~s5RWnA0Agc5mbvUi9Qk5pQ==
4MiriamParsonsvkJSbGs+BXc4xiTvLBIzuZf8GBhN7KelJ4cuLNhg8GA=-~s5RWnA0Agc5mbvUi9Qk5pQ==
5ConradWilliamsonvkJSbGs+BXc4xiTvLBIzuZf8GBhN7KelJ4cuLNhg8GA=-~s5RWnA0Agc5mbvUi9Qk5pQ==
6SidneyWrightvkJSbGs+BXc4xiTvLBIzuZf8GBhN7KelJ4cuLNhg8GA=-~s5RWnA0Agc5mbvUi9Qk5pQ==
7IsraelAdamsvkJSbGs+BXc4xiTvLBIzuZf8GBhN7KelJ4cuLNhg8GA=-~s5RWnA0Agc5mbvUi9Qk5pQ==
IDSatisfactionmSysRowId
1Very Unsatisfied
2Unsatisfied
3Neutral
4Satisfied
5Very Satisfied
SELECT DISTINCTROW *FROM Customers;
SELECT DISTINCTROW *FROM Customers;
SELECT DISTINCTROW *FROM Calls;