ࡱ> 7 _bjbjUU *7|7|_l       4    & ,4(2^ ^ ^ ^ ^ ^ ^ ^ h(j(j(j(j(j(j($* ;,( ^ ^ ^ ^ ^ (J  ^ ^ (J J J ^ v ^ ^ h(J ^ h(J J t'  \(^ R n4  v,(\( (0(D(,J ,\(J 44    ATG 383 Excel / Access Project Spring 2002 This is based on OFFICE 2000. For the exercise, assume that the Dean has asked you to analyze the visits our colleges web site. At the end of this handout is a check list showing what must be turned in. The assignment is due on Wednesday, April 10 at the start of class. This is not a group project. Do your own work. From my web site, you can down load the files needed to complete this exercise. December99.xls has data we will use for a practice exercise in class. March00.xls has the actual data for completing the exercises you will turn in. The questions from the dean are: Which pages in the website receive the most hits? For the /fcba/ page, are certain days during the month busier than others? Is there any pattern? Can you explain the pattern? To answer these, you will create a pivot table using Excel Open the Excel file and put you cursor anywhere in the data. The columns mean: Date = MM/DD/YY BU_Page = Name of page data is gathered about Visitor = IP address of the computer used to visit the page Visitors using Bradley computers have an IP address of either *.bradley.edu or 136.176.*. * is a wild card. Number = number of times during the day there was a visit from that IP address Select Data | Pivot Table and Pivot Chart Report from the menu Step 1. Accept the following defaults on the first screen. Hit Next Data = Microsoft Excel list Kind of report = Pivot Table Step 2. Accept the default for the range. Step 3. Click on Layout. To answer the Deans first question, arrange the data as follows:  To set the layout, click OK. Before clicking on Finish, make sure the new worksheet option is checked. The new worksheet is created. You can use the drop down box next to date to analyze the data for any given day. The table shows how many people visited each page in a given day or for all days. By putting your cursor in the first total number, and then selecting Data | Sort | Descending from the menu, you can see the number of hits from greatest to least. If you have not yet done so, save your work. Set the date to all. Sort the totals in descending order. Print the pivot table. Prepare your answer to the first question. To answer the Deans second question, return back to the worksheet that has the original data (December99 or March00). Click anywhere in the data. Once again, select Data | Pivot Table and Pivot Chart Report from the menu. Follow the same steps from above. When asked if you want to base the new pivot table on the original pivot table, click Yes. Use the default pivot table. Click the Layout button and rearrange the buttons as follows:  Click OK and then Finish. You can use the drop down box to see how many visitors came to a listed page on all days or a given day. Set the BU_Page to /fcba/ To view the daily visits as a graph, put he cursor in the total for the first day. Click on the Chart Wizard icon on the menu. A graph of the number of visits by day should appear. Be sure you are only looking at the /fcba/ data. Print the second pivot table and the graph. Save your work if you have not already done so. Prepare your answer to the deans second question. The dean was so pleased with your work, that he asked two more questions. What web pages are most frequently visited by people using computers at cat.com? Based on this information, what might you interpret about their interest in Bradley? To answer the above question, you will need to import your spreadsheet into Access and write a query. Start Microsoft Access. Select File | New | Database Point to the appropriate directory. Give the database a name. Click on create. Select File | Get External Data | Import On the bottom of the screen, change the Files of type to Microsoft Excel. Select the Excel file you used in the previous exercise. Click import. When the import Wizard appears, select the worksheet that contains your original data, December99 or March00. Click on Next. Make sure the First Row Contains Column Headings box is checked. Select Next. Store the data in a new table. Select Next. A field information screen comes up. Accept the defaults. Select Next. Click on the No Primary Key option. Select Next. Accept the default name for the table. Select Finish. After selecting Tables from the menu on the left, double click on the name of the table you created. Note how it looks like the spreadsheet. Close the table after inspecting it. Click on Queries in the menu on the left. Click on the create queries in design view option. A Show Table box appears. Double click on the entry found under the Tables tab. Then close the box. Double click on the Bu_Page, Visitor, and Number field names in the table. The fields should drop down into grid below. From the menu select View | Totals. Under Bu_Page, the Totals line should say Group By. If not, use the drop down box to modify this. Visitor should also have Group by on the totals line. For Number, change the Total to Sum For Number, change the Sort to Descending. Under Visitor, on the Criteria line, type in *.cat.com. Once you move off the cell, Access makes a few modifications to your entry. The query should resemble what is shown on the following page. To execute the query, click on the red !. To change back to design view, click on the small symbol that looks like a green triangle (upper left corner).  Print the results of your query. Prepare your answers to the Deans 3rd and 4th questions. When asked to save your query, give it the name CatVisits. Notice that the query is saved. You can rerun it at any time Checklist for what you must turn in: Written answers to the four questions asked by the dean. Printed copies of the two pivot tables described above. Printed copy of the graph created above. Printed copy of the results of the Microsoft Access query. This is not a group project. Everyone should do his or her own work. Please see me if you have any questions. OCrsz*. / g deFymbdjlxRS_ 56CJH* j KCJU j{%CJU 56CJ jCJU5CJCJ5&OPrs XYz*+f0+ o  & F & F^ & F & F & F & F_ - . 0 1 2 3 P \ - $bcdfgF & Fh^h & FFyz{mn Y Smn0 & F & Fh^h & F01hi>?~xyh^h & FS_ & F h^h/ =!"#$%{%DdFdH  c $A?b${+l$Dnn${+lPNG  IHDRZW.)bsRGB$\IDATx^흍ܸF{^ v$3q&Dbg( H֙3\(ϟ?? e |%Hϟu!BV~  p߿'yykh֋5-!#Xq:z<=9O> aCe:iͅIm_IkX5KE8@X"jۛ2fQ-l<(gETu49PP- i9aX;xK,@xPpq+[CYIԗ˞SzjOr>*IQlD_O`\ +򧨖[^iǭj-/D.vͻk ݬ)miȑ4ՠa-c ,ObqqA Rj^aM)GlM1V W+w U|(e'nh-#icQ=qexeɖ}Mm@`JEרA z{}O?gð5fہ="EsC9j_Uv?~k ,̋ m!|UskZry֘qΙ@X{ػ=z!c8@%?8OZz!@2@9 ,}`  Wg^@nr7 @*HU %AR~y F)wC@"_Ey!nO77aðtmpe M<. O|{g>U<()Jr ;*@{WdG6H583A^7 '(~7!ԟ oc/_Ҭ@8^/7)\S-AaRʛ=owpJS)O,>/[R..*I5nN{ܘHyKEhE>9j%k[J"xoVdXɋws1IDy#hSᮧQf-DjmE~|/3J[2^h(` '[; vweء.Ọ ɸ/肾vm|ck3ږv*٢gL,='2{W]lϾPg UrX D<%杢55ܱM;ѹfGI-+M۬gWOVBRD ?5_x!qycZMKjCwbz+N'i4ZQ-oj$;c ^GY;%u$2>5]r:KAMfW2)ϡUޣqog^tdZwwՠ׻cG~u؝_fu`BΘF&*3j,Ts*\6 Ѥ8 ROzKgGgB~a;X8%褶}oNm3]Ocx/&G.[΅4[?*y mš#oy԰ *ڳz\.Xq*1мx5wn/7%љ_8ԓg*G֖faN:M4|F]FI'Sr4D&GLs) o|9"{E}aVM`F)vo>qdb>̩D=v6D&ךbO4Zlev( DIej|rEȎ5PI<2lKru @DݯmAjRkÛwEv ljuJr)F:~Kzhޕ{:f,-0,3fzܦO(൵#?5 mc|Oɝdص)\.ȂCꞕJyirhF"[-E>6(ݙ:ii X2L!^|N)kCzZZ$7?ZmM&٣3^J|m歕AΏRu(;ռ+\w1n:і1.mYٽY xj kkaj~}͛aF˞ ,薕 ,.S7#hQk\^!uQcoE+j, nM?bDz," *-h,h1ܹVn OroX)U}*V5vgDݲgkzqͼO1eD5m*mlV0u rZyN^ X./EE\ޏ)ׄ8ro\36hʡhaһjVB@r:鞯 bݡ5|T6l^Xr,n%6gAK}VPs(uqPz{ye=?e25}~51[Y9VU ųVVَ~ڠ_6fl*0|U |V]#iU]Gh0D]g F9J`mG}ZVvFz尲>t XnF ȴ ?"8 ܛR~ H#Œ /A ?"8 ܛR. ["h p-B ,nb=@ ,7.%_!x@=(2 K gr@r@RH܃"c@R~)~& A).%_!x@=(2 K gr@r@RHcp=` @p "+/Iy9 @ d})?>= @`(~Eh(n& Џ=ed@ @3  ~~l H L@[F 0R>4@G)ǖ! "4@ed@ @3  ~~l H L@[F 0R>4@Gfed@Sx{{1V]D4DL_BOV~!{YyPy~Xrm+[IV~W pAe@nE @t\ C7Fn3 H3W#^Cg X5OSuDIOZHw@RuD)gB8KwK@ ؼ;;f57YKVƍ^ J)R~(4N@%r^O,ף_ϚgԳ% p[<嶡1@J& ,,@v}DxojrwL]-9cUwNz>{UV{\+G3R@P|'U0v,%Jjg?=|(Or!$He;H9= @`|h Џ ,'cQ`aB~iLW4K_t$4H)A?CG/ @gGmAd6}ICa$ٰ(4X?uw>u^&f}R}}|}m^Ov^9l]`DxŠx]Go=%+K&n_s jHQFM}Yyyˁ_'r83?,B)wT?&ϭ xba6sߥĂ쌻 p?&czF[Vm#Oy̒YQ1H[~.4YD ݌'OTӎ'sd;%2]RyI'N`vR6O hKC3dd7.E `{6?cnsHŶE؋g8?@[?;!y״V򌔏?vg\Hw}VYi % )WJZ%)?⚼fY-FJ17+yq;R~Fʳ&+ 㨔S+o<҇1axN.Me"x0͉KolK:Vf}iFqv,_DZyVI^w^xYEƴ+l+NX2uŖMmhbnBe och%2=} =jGHyˊHo3i>lmu%OgV3-[;XtTZzuVS+$^~Q+"9rj#i+ 趣X\JV.%76YY}Ą~\.:HV~]Cʟ"nJJ'fw)Y7nX*=Qi>~vKX5LԬg ,mlW5}ƻtPc.Zz.]{ե[V8;:|3~j5Hye3+ךc*f+w_FGgUSoSބ@eV}Ii"iP}tS&+ߍlx5Bvx=ħZWXʵ{^Ӽ{?Yƹ@eV~NOV> Բ{䂇5F?R(4@V.;DZ7GEu ,{/\nIoOFt9Fw7#F{O^5z, x=%gbB,:CFeI3n#_C`=ψhK Q}My!&ƭ;_5Om}mdf'ܗ'AR~t K˞<Ǎ˞h2?~s§FHc<ÇKp"Vo k~n0a  v\lgGO@@' f@h'vvV~-[N|ŰR+_1j @ C (B ,Fnb\`ixH<ٜˀ@0 I^Go=%+_fE~xVy#i3 )ps0` 33 @ O`uT@ C@~M0X)?J#O &! ?lIt,M˟h.>R>ɚ @`U+Ax"6gHyܖ@qզ*gԾH F O@tL·_EyO_m~]ewAY2]X3XifRbi!$XXd˾ 09jyZ]1Y>mh cE)gA@XR|qR <| 5@`yH!@H9kCr ˇ  @@ʗ!@@Y'/B  ,O)_>8@)g @XR|qR <| 5@`yH!@H9kCr ˇ  @@ʗ!@@Y'/B  ,O)_>8@)g @XR|qR <| 5@`yH!@H9kCr ˇ  @@ʗ!@@Y'/B  ,O)_8/dFa  7ϟ?Qzz||9, @Y'/B  ,O)_>8@)g @XR|qR <| 5@`yH!@H9kCr ˇ  @@ʗ!@@Y'/B  ,O)_>8@)g @XR|qR <| 5@`yH!@H9kCr ˇ  @@ʗ!@@Y'/B  ,O)_>8@)g @XR|qR JDa0Zǚbu) ¯ÖfV2R~xai7W5\^zŦg,ʸ<u|nI͈ +NA"?+x ܒR~˰ ,H⍷- +NA"?+x ܒ}vKp ȓ xAc<IENDB`%DdF--<  C Ab$Ȟg lx $%nn$Ȟg lx PNG  IHDRZW.)bsRGB$|IDATx^흍ܸF{6;LI{"daaH H֙3\(ϟ?? e |%Hϟu!z-BHk:ޭ13ngw{腔; @qZ>酔71  ?eF rA8 +B !Xn @W@ʯ"ϼ n(U3/ 7HJ p* @R \E)PoV@T nC=/ e@^Mm__qq }d[^Ptv62ds!Ϳ?#ra 6oQ{eAG]럿Ơ}4 !HyP)|rt&Okti 謁FE͈q=r1nۤ;wM)\uu3GruʷMejDs w Л@ߋwu2H@LO`џ?+gS(O[HTWz{R.ɔhbVWڮu',{j.W 1@B`K"ga/ªYV)嗗VtW^lA cFrދa<;ѱ 6JC9rrI5Et/&媼zm} 4Mb%Xe5W )(-'4GDzmKIZ +yn?5(qY 4GTye} ,:ڪ|[ߋfr,_|p0Fn-;Y3KʰC]Gq _}4Ń+L]ѶԏPie?+wgg9ٻ u0Q.@̳ļS4]LSґOّ9iGvQ[N=5HB{}x_!Mͽn]IѴ;#Ho ^m|<һ\=|OǬeƬ\I;vDg&9`AtX4Sr'v-i_%x&g 4ĐgRqڬ+g&@$)n: Jw!&ujZ)7{-5/s3SHF}o5SڐV.[K d>:nFaZy. 80 ^牲Sw.0AjNeˤd[VvlV}63^tA`lD2|mM:L[Nw}޼Fo.٩nYi:u3[5R QGi56[~n>ktjaHv қ}Pd YPYmQEfoEe%εrK~j>;~OtHESaX8;h 2=[mՋk-xj)#RE0mSiCecTe;w.L |ry,*~L&{ϷDDUyIw[նқ# y|ɗx{N+vjj;bO،y]b!S˱˞B^kGI-xMmSc{ *./dj֑Hjcs3,jg +g}/'׭sTMYb-OGEԛp @wnf)wsl7Mc‹~%)A VgSGfle[)т40 -g)0ttC$^HܵvHbܫH2+Z׌F2xAt4R~-f@w|>0|U |V]#iU]Gh0D]g Fi%0V_h.{/^9,6݂['."t!"G'!{@_A)Dq7;@G'!{X!_!Z{׽W$A\ys@ ܄P @@/< K39 HEƀ p)RL@RA1 \J)?C {Pd @@/< K39 HEƀ p)RL@@y1S0 8x}}MG畗< vz_'  % dg? @`|h ЏRޏ-#CD)i #c@f@ 22 AA@?Hy? @`|h ЏRޏ-#CD)i #c@f@~z߬ @`*oooS#|||Zwx_3~ڄ !{YyPy~Xrm+[IV~W pAe@nE @t\%u})?QA$6k^#\x %`ܑ9@ٰF_20&1NY`=ужv sh {QlRk~v\QwY8Or뽞*|}q9l] @"O\U}# `]S.YgS~kv$+UNYͻ>:5ó %nOj^Gh.9xv?5[&_XEE*ч}פ'dgh"pErk [jIQ$^^u,Ih8wy3)?m}刎c*gY ` A&U~ۖlyHY6nʩϢ??Ht>:d,0;+c,ixkCnw-6#-{lٳ@E/hrfD<# `U W #Ze#,]W^V[Is4VSEV"Zfƺ-FL;+!5hJ)?#|-BK`aLa }^s9qpʤ[TVaL8(d ,5YyfK7poe}آq%I|pVul8unK.vpԓY؛JOzJp:X6#Yi}R${dz@WȊHo392 } e vC #L)xptn6`#rZ-GBӇEˡrH_!1i\ӆZy P+-"jʢ<\N-;@Ō}Cl m*Rޛ0$PG_R$Ioڵvi4]ySd廑 A˞^$GC|4)Vr|EDlKuxm |E,d^+q Tfγ.5YpiI-)mKh/r Oe:P+_v#ѣC=ts}%drKzx x21*D%m +K+Ҹ, x=%gV{VRN`.Q_CKt@%I&G}ZŊCF+ jyj]%0*R˓ \@):SB%eO_F{eq4_Y1%=&f畽.Hς3} ㏔Ogrg < 5O62 L,C@~dW뭧dˬPU#7wW>2t?=A|dt @Hy @`$|$mB`uT) ?!&coe47#h@`:Ht! @`֘4O_jD#哬̀V% Y߈'O=h{{gm Wm rf@틔`d@4Ow|H>u[y~>6[EQ|%m,ޕMK})JDA\W+H[<}Y.fnqЖ۾Y9`Yu5<%ȷNx{SKJ:nyDLRV[ vc%yΚ!@eP7X'f咛ןnV`I/c*zb-XZ;|;IG<*y,eg![*%4z->\ʏb)w[8@)g @XR|qR <| 5@`yH!@H9kCr ˇ  @@ʗ!@@Y'/B  ,O)_>8@)g @XR|qR <| 5@`yH!@H9kCr ˇ  @@ʗ!@@Y'/B  ,O)_>8@)g @XR|qR <| 5@`yH!@H9kCr ˇ  @@d/A9Q@`?~x< @X@Po߾9, @Y'/B  ,O)_>8@)g @XR|qR <| 5@`yH!@H9kCr ˇ  @@ʗ!@@Y'/B  ,O)_>8@)g @XR|qR <| 5@`yH!@H9kCr ˇ  @@ʗ!@@Y'/B  ,O)_>8@)g @XR|qR qW[_YoLV^ϊ@x6+U:Q]uj2@wB4:F|Ŧҗ) F`t䨃x?5m yEҹ0RTھ %dzv뗸`?u`Xō%&7wX8{<^J0r~t qKWfG/.m @ hܟ2Pڃ @o2OOOKk`oO1f{HI @ V=$ʧ`V_XqG==7K 2oKV)Qa؄ @@ g&Gyv$!%qG<| Ò=+}U!f qGUM ЪGۉ?WQ|61W&C:XAlbw @m |%Xqw fˁncŸxe(mQ2߼t2 @@:m NOC`bj=W} @ߋ)I uRd(_WOv^7__bm @1s1{3V}:-{Pd v_Fl qǼ%@hP`g$` ݘc4w|Vqc q-YƖhmK @ %iz?l0?c @(<ܞKzrM8pKX @j[7X?g>:Lܣs @jWsV1 @&,jA @ 1B @ ׯ_woG:wRctuv#@"PaV2vo4Yd|^m etK:r=XkT.!@.84Njc|4_بHvzU,9n=Ţ^K#i{<>'lEQ`A0hgI{ۖw<])jwZ{AeG%ZQ0 \QM}Q<78'@& ={~t겨{GkA0ƘbV҈cC` q,:ۺ/b<;q=ƖdQ7wdpzu]oKgYʧ;*uGj, @I`+> G~y y-Vvs_iy͟Fݬj̵W39뿷ǥGŠ=4vM @O?~%|GxA^R56C#m6JT @@a_W>lM[[uݟ׿{ NVhZ3!LYE7"ҍٜ ` @ 5oooq- @ Yk  @(  @xz}}H @@ P"s(ehY5- @-ߖVU|]٨ij76vͻo.V*U;Jݽ[$"(r+Zm/Nl @@%? @_\iO%@R$.XRVKkHz"з@%7*ٜ` 4ո4|lu'|y|0Ng`;1M-lcEgnYG;Dd/2~Ze4S٨$Nž%z?qE7x^xkSh;lk]g۸a/_~!eӝ5w܅]x4 .>*!@EsQ[ wGH|c#~~~G(h*# Ҷ)JJ+MPdwy0Izġ&Ձ-5nwhƖz"0 ?㷻S!-lZ Szx?mql`yfYUJ @ ~䃶Gyl'}P}Yע8 P>|%<^+Ӈ `6n%6qkBi.fqdG|=oiiF 3r-o Ʂчy6Y@opvÒڧ8L&oq_jgTlCIz Pg8@QgWM<E$=Fb%c8 jcҜ$U*ɳ:+3IXFgRFYvcAG4FON/@9gRf0ۺ B,ly#OZWpu/uhW pQ ٤m'gxv*>;Sl%Oj{jFHhgBHK1~Z{)فGFLl$'?ap Rp1$9!ș;8}xLy6g %; oDy'b92@N eKO!e~}-ȔXX  P$,HU'E{k8\%(9 I[h;֓ƵqQ. UU~9'Jf?O8)/P9@51ʯY')ML8 #kDxj0 8i ^ޘw i%d28~O5pu?>ŀ?3{,K >'~XO4Mli |y·%L )js*)DXv= !tH)L8qH~?gI#/f;3qeYxL_zz5tY#if >q_oe 9_cK7G8S{{[Pۗv@@u3SYc0/ qF?"mp~:sݨ4ư˹ZvQEʎ\*s<&̬J;CqEx ?Ԩt;sߗnffcJI0[}ۻ,&`(Bd V!=O @){ gP lO1WVdqZN^80?Tsa\^ZjHʟT$8t K6ܷ^]V~ RTlu!SK1:??'L6H >ew6$,X7= h>׍oA'-wIg ?3/K' s(8?C yJ 2%VGD9@lN:_بA%ӫl<%90gc?ǒjwg\|afJF:0Ŷt ׊S` ;s?u_7o>'@9G`Yz`w8ٓ?zGk*O &}xX5%[f8rAQxOz9@F؅k&Ѿ3&n]|Icdu3in$?=0( & `Fk0uoq Ҽ5[v}>"ˑ= Mx=.?m  PQ(sb;Uǫ.^{N㸋왭lx1nvXx|7xҴF<_ɪ<%ǧ?!V׹ ωۉ1}Z/NKlv68OT挟locz3Κͧ]\x VK_y?t[b-* ,$]=@\fV͏jggg7y4F TA& Ľr|D+ +撛)~y*][֭v͹YDŎK_yAsXa?HPoLgb'Yl`q'BC>%WiLl1llyf5[8 Gc-#(32..*UޜT*-'%.<-6ۊ`ixg?>fVnX]oJJUݫ:0`݅wlc˱6v/" ЄsXM  @_? @\kf߾2 ZɺjO @b]K ZLfuhTTy#,$T  @8efNމ'@ P$%`f״J"@ pZ?w:mCN @@TJ9 @H:DM @ P* (R @@:Q @ HJ#@ ЁN @R) @t 5 @@TJ9 @H:DM @ P* (R @@:Q @ HJ#@ ЁN @R) @t 5 @@TJ9 @H:DM @ P* (R @@:Q @ HJ#@ ЁN @R) @t 5 @@TJ9 @H:DM @ P* (R @@:Q @ HJ#@ ЁN @R) @t 5 @@TJ9 @H:DM @ P* (R @@:Q @ HJ#@ ЁN @R) @t 5 @@TJ9 @H:DM @ P* (R @@:Q @ HJ#@ ЁN @R) @t 5 @@TJ9 @H:DM @ P* (R @@:Q @ HJ#@ ЁN @R) @t 5 @@TJ9 @H:DM @ P* (R @@:Q @ HJ#@ ЁN @R) @t 5 @@TJ9 @H:DM @ P* (R @@:Q @ HJ#@ ЁN @R) @t 5 @@TJ9 @H:DM @ P* (R @@:Q @ HJ#@ ЁN @R) @t 5 @@TJ9 @H:DM @ P* (R @@:Q @ HJ#@ ЁN @R) @t 5 @@TJ9 @H:DM @ P* (R @@:Q @ <[( @ >%UQ ]%  @L͉9G$;F?~P* @? JqJ%@ Т%@z%<&L @߿ f.~h>f @@f6M|6&@o|zzXT~Uo^Vfʩ$@`un"@s YV-+zN""NYئ]W:1Y<g(m ý=bmc{9 8zO䰏[/<_1L44XJ&ջG0~H8T@Ps/XQc|i]*m  (B'Eҽ'&@? ­`jUA0pNd ıf; @p &|`SE6&@.v  POl ȃ  = P( (*6H"vT p1?JK.KP `m/;C p60/s)Ioѳ-9@۷o  p nw pgq $@% @K! @$UO @% @K! @|&^Z{ý5ܗ&dׯwxOw:}k H ٗ[uǪ`],'a)I*N& &q; !wgXp 9`!l=lLJz!@^$ y؝_| ?l:mLܬ f X b2 @8ۀO @`` @. 8{>&>=*ETj  P[ ܉8}C H%;4)0܆d E@{R Jo-t^M @\sׂhU:$}~~}+Vӧ/ږO)^zXQw}|" ~t&:g46՟6WM/#fU139Hn J`ٷUf$_+ߏG+(g?%!ж  @ HT%"Kv4.° @vܦ-97ű|`- @$} io%' ~5]L,xU @^__Í+z;-bk 8̽'vhR`? M6BPt+ kcÞ:o @=sd{-= H|/ 趛5&4-"@වC!\gxm;5 hODD @GCLۦj0X$Y3v Ф&EPt~(wG@fA p  @:f긪} 8hY@rN)`&h\50p F@F6 @`B Ã$- @fNm&p eZC  @(3GIk$klC&8<hY@rN)`&h\50p F@Fr<}ai򚷶hR @"(~ H=n.)Yss>pL(fѭ @L @R60d <1{4 ,SC$r(?08HO9>~{$@L: @AfV HVو0 @e @˽#68Sv \F@pP8J QC 5 @ 3Z;mŷ?2\&@@KfZ  0t{L ׀۞00^?GY Π#@`W U7*g|8=O_kp `3'@`R@a4 8% ;@JL /IA À$-'T:0i[z0kj>$}AH3 0p~5H}'{ h!l)$ՉALwa*ۚh[C@kfZ H=1z\:XƓ Kv+aX+``8B@p} @\5$2 @@fZ!{ymyyy~~oa3H~}e]k7 1vN5 ፨|ϟ.J P.Ǯr%[K¤cS^LoooJ HZC:Qs2j +*;`%X(ǮXȦ8 @3 XۦfCS(0P* Xw ׯ_whIUYvZF@TJ9BC3TA 4܄kvW3p @yH3I;@ @@]|o_ZH !@ G@Z @ѿ#F$t0 @! 8B> @4" h#A @ AWx{{ }\E{ hA=l!Ne&@KϟBb_ sn E`U:=~c#|BB/_$@#W,zT@R)XQ9۷EÙ')z5 @`?K6YӸUIޥ?>>̳/LM\S޾y=,Zo-} @|۷k.` +\zAؽ!@{!d7$G;~N  @GŎG|T?8= @} >$u?#@&>*vvHjKo1p pě  @`py/{$@{(A=${(ձ'n>1S@s @w>>  5tn- 8Z|?e hJ=l*>Cgo _Q'1,/] |\.$UEq*X6,b쀞'5*/(Gv+ 7OvN pyxEU]ઔ @@./ ׯ_7ec@t 'PW  @`Ij$@3 @ImLg\絘f? @0 3oooj1\R %] -6;xDU @%@j Hv=; 2wr8 PO5lL @Q_h @@  @ Uu @hT@h @@ ݤE_~bc(<\\ +\"{ g+@+lR*s"%I@f6K3#-ڤc@Z[[C5 vdkBI3%\ 1UE~ S'Rxo @mg @+ x @8TE;x E5^1+n.>!\H=73T"YUWEzVۢ)\(’-p|_+/㏁*YH!p~K߇-(567[om(- 8>K3LEA7)d\:/'0VGhͅ-#V8!07%n*b߆/i@/ ps PU@P٦430)鴮wXj5-E- @duX w(o7姍L&o0 N➵Ɲ\iblatg*y4+et4F%@`a嫆ps@97HԈklYL4dH3 Gims  @!W`.WǙx`XI-i F:cώ}{{ }t,iB@pnZk6g'*o%=EPvŏf^ւtq|+|O'OԺjR; 6|p"&I@6e&b+Ik! 㮧_)!(v|N G&ъ~iLW_jǷo.Ţ& hG⇒Nl h΢B@y3OJR{e*x*c`'`鈸@(S>Kxw>-Q  @k @ݻq+]֐6,,bVYkS* 8D;Bx@8J=:@jķ5wYJ$];{pϮ5 л4=&cuJ`VP-/ 8|=ʊlQ8`+`+oӴ@tJ͒{aDn,1i#j  @x {1}WZ4~%o^J~I>dOGϸym\\lɽ6i-<TLy}|UiTus|q7/&򙁛5W-!AI``Wt h6!@K HNyfqlލ\㛇 IuoKV `U;-0/ɓ7?06n#4^O'\JLĐ`[ hϷo[Q #HS7p(wƯ ׉i4K_VF%npdLG`#̓gVƙ no#؊7{\vQ*\$``'@a'n įe@tJ?bI%IʜG >j!@q=XouUC5{Fm į8_gOא7d[L&`` 8N@p= @3?0x>St n tݾdo~o@F/0Ki' x=y+|o7Y! bG%Zn J3 t(1Y(]Ӌ1A_6UT4K#8g^ v\~`Kno(`vM" ". h]ҝzlWS"/_g%[3lJCk '%wݿZG' @Og[xœBX48s^ \1?0Z3{~g;_G^ث*ܼ}{ؾuv\3艝$'ksމ{:f*j ]@;i ~VMUOAl>[{^ @V- Hv'Ua߼g^7kc`VZ3U@pMsW2'& R'[Ijt٭EK i5t|+A11VmZ3Mu` C %87UW߾T.Xll%v5N_i #F:,J}Wk:= Hzm'y #f^JMUk =@ɯ8 َ#*Y.+,DNj?=ORni@+ X @uzԛWiW^N;quG=^`\LH:k5aKU㯮ű_kgWM`kR_$vRĩ5Z-pt/F]i? p :yUgO[*B \wb+ %ZW ^)n ne`էxvI O@{6 x[lz1omke:٭)0 x P. (:dޮ<޻sii7{zVl  pT p @[=7+?YX,qWm\5-/ ۦ[깪vG >j!@{'q tA :vOL7K)ZP&A%:+Lo6WvXTfN]%pi 9z%` 4i\9,.e'1P'??+x:+7Iy~ī # 8O_ݏt⚁Q>KCnCVޛ/)ki#AUG@5 @5U,vQUfkm3إZ `1@Y$T+v@Sb^JLs H悟YZ>EzC=If.~h> HZ|Xc0gjՠb-*\ 81?|@.$j Ws^ nk9 HcE`g|+tgW界 ~*O%+OfS@fS-"Ыמ.8T vFsC%9wFp:k @`_3ig}Fm$8vl:$:N,td8 Q[VΪ]:y @ghJ ]-jSCgX:pv H߇Z@ ,h d! pQ E;^  @`_3zzzymb&H @G):t}[pFCl' DUR/T4+`ٮ C ``DU p&w&EPU Y{N' n00LW @χH86r z{m#@p3!+$+lFr3" 8KO0tL=IJB9ضM\6r6{ )>bQ@ ]%co lv;i0[;v k$C)8vN U` Y)n/ 8j4 t@E$x&@}6 H٪.$`BN. 8y 0F?y  @`V ,4" h#A0p=+ HJTU1; HvU\S 5] Q@p^34'`.w$  ŸOOO;RX% Xf# 0Ƿo @O8_^^{}=onF߿w(!@@U8/De'o;m媝rcW co %lv;i0[;6t֭C38vn @S @ H.ٚJ+Əcvm/)@ ugeJ PS@PSW pU|oգ@ 4* hcEg~ ' OZ0o'A@& p8 @B @$ @\5 (xTAxz}}}?g*0xyyy~~Q-4'*_|i!b[CP6 j+YOOOK[t`sy ıBߒG[R|̚3FWk i{`߅&Sl{hҷ0_ Ќh/ <}c/)q'X޻ p[MGFK~Y)V/-Γ5/3!@@'5JyƷ--lc X  @qD,j?ڏ&%H  иn7]EUBtWp5>.G7w|⧈6 І~8C~a @q{o_& G+g5> @@o%VzV-n HEKn1[9x-q=S( k_z p=}7?94&$MvKAgMn6;_@½>8{؂ Fh\`7; @= @{}r?\X+ {yons,n ~۷°!|I?8 ;MB> ?}#@`@JU`K?e8@O ". x`v  @U\絛$;@ X%` *6 P$Ǯ..R @@>Q+ @ H"@ Ї~  @E"& @!  @@I! @}HG @ P$ (bR @@>Q+ @ H"@ Ї{G{n˷oީ @@>_#@0v}~~li{ @[N9.! N @ 5v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @PU' @F$v @xz}}}gقzH@ @? @Jooo!TU- @D7?~B-}*(R н@SESj  @`@L.~g-- @ u @8[Õ',/ﶧE{[(V н ?|/{e7۪  @\D`{œ F*V8;ʷ 7\W2=7dz%n2$X @."0,=av6ii~>ǯۻ  @N-p;9xk%6,M+l={LWLgJ2)O @gaIz|Wx`eN~}ݢug-+ڒ$$bU @{{ _F ?~sNi?uSq{?KSIhA`j Ә< |)銫Kj,: 0XT2 @*f]εà 1QZ3ƾI Г|q bX`" d4X/is @E3пp=X*L3!ܼx`Pg0||ira.-\/tx?>??ᕏ 7 ld;ֽ!}o`7.*m%nHNw頪*'@-S ~m{|MbT3)X @ 2 @K $51}#ҽHv  @gJ1,rT @$,&`v @]`x # @Q`۷ohp.U @KJn\}- @ <u @ ДKTL!@ @ծf @pЦC0 @ L;Hݹ  @5wb֬^N)09e 0Yw6sViLo;VcU(EuT6YըH^ S`K9<UX?%?;" vW!GL]>Z @0vOS5M @ EUh|8"@ pjf \Ǎ  @N*2IuM @3 Ͽ6x|X*-"AgC @} 4&r! @ 2ݻxjX< @X9@G C,) @`p>3-J5Ŭ`P  @ ' ή  @W}Om @ ?~xySa      f f f  f                                                      _ F0__!  ELao{   a333333333Simon Petravik&C:\WINDOWS\Desktop\Excel-AccessF00.docSimon PetravickXQ:\home\simonp\WPDATA\BRADLEY\2001Spring\atg383\access-excel project\Excel-AccessS01.docSimon PetravickYC:\My Documents\Simon\atg 383\Spring2002\Access-Excecl Assignment\ExcelAccessSpring02.docSimon PetravickYC:\My Documents\Simon\atg 383\Spring2002\Access-Excecl Assignment\ExcelAccessSpring02.docSimon Petravick<C:\windows\TEMP\AutoRecovery save of ExcelAccessSpring02.asdSimon PetravickYC:\My Documents\Simon\atg 383\Spring2002\Access-Excecl Assignment\ExcelAccessSpring02.docSimon Petravick<C:\windows\TEMP\AutoRecovery save of ExcelAccessSpring02.asdSimon PetravickA:\ExcelAccessSpring02.docSimon Petravick=C:\WINDOWS\Desktop\2002 Spring\ATG383\ExcelAccessSpring02.docSimon Petravick=C:\WINDOWS\Desktop\2002 Spring\ATG383\ExcelAccessSpring02.doc I\>LPO5wSr SBL@mV=F9g*B1S7@h8i?l>¼@l];l3 ylJh88^8`.h^`.h L ^ `L.h  ^ `.hxx^x`.hHLH^H`L.h^`.h^`.hL^`L.h^`.h^`.hpLp^p`L.h@ @ ^@ `.h^`.hL^`L.h^`.h^`.hPLP^P`L.h^`.h^`.hpLp^p`L.h@ @ ^@ `.h^`.hL^`L.h^`.h^`.hPLP^P`L.h ^`OJQJo(h ^`OJQJo(oh pp^p`OJQJo(h @ @ ^@ `OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h ^`OJQJo(oh PP^P`OJQJo(h^`.h^`.h pp^p`OJQJo(h @ @ ^@ `OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h ^`OJQJo(oh PP^P`OJQJo(h^`.h ^`OJQJo(h ^`OJQJo(h ^`OJQJo(h^`.hL^`L.h^`.h^`.hPLP^P`L.88^8`o(.^`. L ^ `L.  ^ `.xx^x`.HLH^H`L.^`.^`.L^`L.h ^`OJQJo(h ^`OJQJo(oh pp^p`OJQJo(h @ @ ^@ `OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h ^`OJQJo(oh PP^P`OJQJo(h ^`OJQJo(h pp^p`OJQJo(oh @ @ ^@ `OJQJo(h ^`OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h PP^P`OJQJo(oh   ^ `OJQJo( l];l9gS7@h3 y SI\>?lmV5wS a@Ld_0@UnknownG:Times New Roman5Symbol3& :Arial?1 Courier New;Wingdings"qhzc{cKaE )$202.ATG 383  Excel / Access Project  Spring 2002Simon PetravikSimon Petravick Oh+'0( @L h t  /ATG 383 Excel / Access Project Spring 20020TG Simon Petravik imoimo Normal.dotvSimon Petravick3moMicrosoft Word 9.0c@F#@@dO@8A@daE ՜.+,0( hp  Bradley University)  /ATG 383 Excel / Access Project Spring 2002 Title  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnpqrstuvwxyz{|}~Root Entry F`ϴnData z1Tableo,WordDocument*SummaryInformation(DocumentSummaryInformation8CompObjjObjectPool`ϴn`ϴn  FMicrosoft Word Document MSWordDocWord.Document.89q