Standard Jet DBnb` Ugr@?~1y0̝cßFNi7+֜(e$`"{6߱fC=3By['|*J|[ pf_Љ$g'DeFx -bT4.0 dvcO<)   x e R > +  {  g T A -}jVC0 lYüED1@+efq@+efqDW$AFo}U6ĭZseRC.c1]Bl7nPLs( **>wU]p @+efq@+efqDW$AFo}U6ĭZseRC.c1]Bl7nPLs( **>wU]p @+efqDW$AFo}U6ĭZseRC.c1]Bl7nPLs( **>wU]p ( T+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ) T+efqDW$AFo}U6ĭZseRC.c1]Bl7nPLs( **>wU]p T+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ) 7( 7+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 7) 6( 6+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 6) 5( 5+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 5) 4( 4+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 4) ( +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ) 3( 3+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 3) ( +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ) 2 ( 2 +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 2 ) 1 ( 1 +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 1 ) 0 ( 0 +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 0 ) / ( / +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p / ) . ( . +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p . ) - ( - +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p - ) , ( , +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p , ) + ( + +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p + ) * ( * +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p * ) ) ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ) ) ( ( ( +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) ' ( ' +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ' )  YdS dd Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName         nrollments].[studentID]8 g6 [students].[Balance Due]7 g6 [students].[Hometown]4 g6[students].[GPA]/ g6![students].[Num Credits Earned]> g6[students].[Major]1 g6[students].[Year]0 g6[students].[Last]0 g6[students].[Middle]2 g6[students].[First]1 g6[students].[Student ID]6 g672U0t"@2U0t"@junk Query44444444444 6ɚ/t"@0t"@join students enrolled sections/classesnnnnnnnnnnn 5ɚ/t"@ɚ/t"@enrollments Query1DDDDDDDDDDD 4ɚ/t"@ɚ/t"@enrollments QueryBBBBBBBBBBB \/t"@ʚ/t"@enrollments66666666666 3/t"@\/t"@CountOfEnrollByCourse QueryVVVVVVVVVVV d.t"@/t"@Catalog Courses>>>>>>>>>>> 2%.t"@d.t"@~sq_fstudentsWenrollHHHHHHHHHHH 1%.t"@%.t"@~sq_fstudents1<<<<<<<<<<< 0%.t"@%.t"@~sq_fstudents::::::::::: /%.t"@%.t"@~sq_fRooms44444444444 .-t"@%.t"@~sq_fEnter New Course:LLLLLLLLLLL --t"@-t"@~sq_fenrollments Subform2RRRRRRRRRRR ,-t"@-t"@~sq_fenrollments Subform1RRRRRRRRRRR +-t"@-t"@~sq_fenrollments SubformPPPPPPPPPPP *-t"@-t"@~sq_fCatalog CoursesHHHHHHHHHHH )-t"@-t"@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV (-t"@-t"@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT 'k-t"@k-t"@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx &k-t"@k-t"@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV %k-t"@k-t"@~sq_cstudents~sq_cFindStudTTOY2ScY Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectId @ @ @ @ @         ! ! ! ! " """""""######$$$$%%!%"%#%$%%% &&&(&)&''*','-'.'/'+(0(2(3(4(5(6(7(8(9(1):)<)=)>)?)@)A);*B*D*E*C+F+H+I+G,J,L,M,K-N-P-Q-O.R.T.U.S/V/X/Y/W0000111122 2 2 3 3333333333333 3 3 4444 4!4"45#5%5&5'5(5)5$6*6,6-6.6/6061626364656667686 96 :6 ;6 <6 =6>6?6@6A6B6C6D6E6F6G6H6I6 6 6 6 6 6 6 6 6+7 7 7 7 7 7 7 7 7  7  7  7  7  7  7  7  7 6@6A6B6C6D6E6F6G6H6 YSY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttributeFl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$F P$FMSysAccountsk;F0FnF0F Y;F~FJ@K@MSysAccessObjects DDDDDDDDDDB 2qCatalog CoursesstudentsKbPrerequisitesPrerequisitesO\ProfessorsProfessors(URoomsRoomso&Catalog Courses_1Catalog Courses j ;F0F  -Y SY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationship&'()*+,-./YIdParentIdName        Yv1b N  : k & W  C t/onIDDetachedLabelsectionID_Labeld5U7`a<b c0special permission Label$special permissionDetachedLabel0special_permission_Label`w Detailm7U`<a<bcestudentIDstudentIDm7U`ua<bcegksectionIDsectionIDm7]`a<b ce k$special permission$special permission$special_|SELECT DISTINCTROW Sections.sectionID, Sections.Dept, Sections.[Course#], Sections.Section, SecID="{FEAC9797-44BC-471E-B0CD-5A22585D108B}" DocClass=Form_main/&H00000000 DocClass=Form_studentTasks/&H00000000 DocClass=Form_FacultyTasks/&H00000000 DocClass=Form_DeansTasks/&H00000000 DocClass=Form_studentsWenroll/&H00000000 Name="university" HelpContextID="0" VersionCompatible32="393222000" CMG="7A78870F051asksForm_DeansTasksForm_DeansTasksForm_studentsWenrollForm_studentsWenrolltions.Sem, Sections.Year FROM Se0=Babe ghXiJjq%kNr@Ariald2hgh MS Sans Serif`@ Detaild5U`ab cdLabel0Administrativeh1U`abVc NewCourse New CourseCourses.newCourseh1U`l abciBackMain Back To Main BackToMain00-0000-C000-0000000Prof_LabelPickProfdרNJy2`FormFooteroM2Y3nt_Labelroctions WHERE (((Sections.Sem)="F") AND ((Sections.Year)=2002));.960;570;825;765;480;525d5`0 a<bc  $B HB @@@@@ @@@@  @@    @@ @ JO`YbmJk\kMJmJ^dUMdoikQkOQJbkmJk\kQbid^^`QbmkkoLSdi`Qbid^^`QbmkkoLSdi`8Qbid^^`QbmkkoLSdi`:QbmQibQsMdoikQ SJMo^mvmJk\k`JYbidd`kkQMmYdbkkmoOQbmkkmoOQbmk8kmoOQbmksQbid^^kmoOQbmmJk\kJ^^Qbid^^`Qbmk MdobmdSQbid^^LvOQfmJbOMdoikQ!iQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb:"iQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb<#idkmQiu$kMWQOo^Q%JomdQuQM&LJM\md`JYb'MdoikQk(SYbOkmO)JO`Yb*OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MQbid^^`QbmkkoLSdi`+kh+MMd`LdB++kh+MQbid^^`QbmkkoLSdi`8+kh+MkQMmYdbYO,+kh+MQbid^^`QbmkkoLSdi`:+kh+MkQMmYdbYO+kh+MkQMmYdbk+kh+MMd`Ld8B+kh+MkQMmYdbk+kh+MMd`Ld8F+kh+MkmoOQbmk+kh+MQbid^^`QbmkkoLSdi`8+kh+MkmoOQbmk+kh+MSYbOJkmoO+kh+MkmoOQbmk+kh+MSYbOkmoO+kh+MkmoOQbmk8+kh+MQbid^^`QbmkkoLSdi`:+kh+MkmoOQbmk8+kh+MSYbOkmoO+kh+MkmoOQbmksQbid^^+kh+MQbid^^`QbmkkoLSdi`+kh+OidkmQiu+kh+OkQMmYdbYO +kh+OkMWQOo^Q+kh+OkQMmYdbYO +kh+SMJmJ^dUMdoikQk +kh+SQbid^^`QbmkkoLSdi` +kh+SQbid^^`QbmkkoLSdi`8 +kh+SQbid^^`QbmkkoLSdi`:+kh+SQbmQibQsMdoikQ +kh+Sidd`k+kh+SkQMmYdbk+kh+SkmoOQbmk+kh+SkmoOQbmk8+kh+SkmoOQbmksQbid^^MJmJ^dUMdoikQkMdobmdSQbid^^LvMdoikQhoQivQbid^^`QbmkQbid^^`QbmkhoQivQbid^^`QbmkhoQiv8[dYbkmoOQbmkQbid^^QOkQMmYdbkM^JkkQk[dYbmQbid^^`QbmkhoQiv:[ob\MiQJmQkd`QkQMmYdbkJ[ob\MiQJmQkd`QkQMmYdbkmQkm[ob\Qbid^^`Qbmkbdm:66:hoQiv[ob\hoQiv`kvkJMMQkkdL[QMmk `kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkfiQiQhoYkYmQk!fidSQkkdik"idd`k#idkmQihoQiv$kMWQOo^QhoQiv`kQMmYdbQbid^^`QbmMdobmkhoQivkQMmYdbk`kQMmYdbkJbOMdoikQk[dYbhoQivQhoYqmd:bS`kmoOQbmk`kmoOQbmkJbOkQMmYdbkJbOMdoikQk[dYbQhoYqmd8bS`kmoOQbmkhoQiv`kmoOQbmkhoQivhoQiv`kmoOQbmkhoQiv8`kmoOQbmkhoQiv:`kmoOQbmkhoQiv<` JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOMJmJ^dUMdoikQkfiQiQhoYkYmQk` MJmJ^dUMdoikQkfiQiQhoYkYmQk8` MJmJ^dUMdoikQkkQMmYdbk` fidSQkkdikkQMmYdbk` idd`kkQMmYdbk`kQMmYdbkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`Blob VPropDataLNTypeInfo/13KSQ  @ @ @ @ @ @ @ @ @ @ @ @           !"#$%&' (!)"*#+$,%&'()*+,-. / 0 1 2 3456789:;<=>?@ABC$D`E`F`G`H`I`J`K` L` M` N` O` P`Q`R`S& Q!U"[#a`m`cPropData`bNTypeInfoO>3[ge3051305130513" DPB="F4F60989F902FA02FA02" GC="6E6C931377F7F0F8F0F80F" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_main=0, 0, 0, 0, C Form_studentTasks=0, 0, 0, 0, C Form_FacultyTasks=0, 0, 0, 0, C Form_DeansTasks=0, 0, 0, 0, C Form_studentsWenroll=0, 0, 0, 0, C e VB_Name = "Form_main" " Bas0{A9CE5C84Form_mainForm_mainForm_studentTasksForm_studentTasksForm_FacultyTasksForm_FacultyTScriptsVwl0jBlob kPropData 1irmBlob nPropData 2ptHeaderd2`<a<bQcdLabel19"Count Of En22 =MOQSnewCourseopen in add mode so cannot update existing recordsCatalog Courses000 02go to position for new record2Catalog Courses5 %*place cursor on dept field (control)DeptLine24` GroupHeader0m 0<`<b cJi DeptDw Roman`JDetailm`@ bHcCourse#CourBlob qCPropData 3^ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @zzzzzzzzz z z z zzzzzzzzzzzzz$z% z& z' z( z) z* z+ z, z- z. z/ z0 z1 z2 z3 z4z5z6z7z8z9z:z;z<z=z>z?z@zAzBzCzDzEzFzGzHzIzJzKzLzMzNzOzP}}}}}}}}}}}} }!}"}#}$}%}&}'}(})}*}+},}-}. }/ }0 }1!}2!}3!}4"}5"}6"}7#}8#}9#}:#};$}<$}=$}>%}?%}@%}A&}B&}C&}D&}E'}F'''((()))* * * + + ++,,,---...///00011 1!2"2#2$3%3&3'4(4)4*5+5,5-6.6/606172737485868798999::>:?:@;D;E;<<<===>>> ? ? ? @ @@AAABBBC0C1C2D3D4D5E9E:E;F?F@FAGBGCGDHEHHIIIJJJKK K L}L}L}M}M}M}N}N} N} O} O} O} P}P}P}Q}Q}Q}R}R}R}S S S  !"#$%&;<=ABC&&&&Q'Q(Q)U*U+U,[-[.[/a6a7a8m<m=m>zzzz zz zzzz!z"z#:DirData~dBlob m TypeInfo)PropDataIROEAVCXSYCCAEHJOQCUGWLGIYKB:ty"[Event Procedure]h1U`dabaciPickDean2Dean of Arts and ScienceabelTitl s?"(#E l $###### # #$ $ $$ %%%%%%%%&&&&&&&&&' '"'#'$'%'!(&((()(*(+('),).)/)-*0*2*3*4*5*6*1+7+9+:+;+<+8,=,?,@,>-A-C-D-E-F-B.G.I.J.K.L.M.N.O.P.H/Q/S/T/////R000011 1 1 2 222 33334444555566667 7"7#7!8$8&8'8%9(9*9+9):,:.:/:0:1:2:3:4:5:6:7:8:9: :: ;:-;<;>;?;@;A;B;=<C<E<F<G<H<I<D=J=L=M=N=O=P=Q=R=S=T=U="="="= "= "= "= "= "="=" =" =" =" =" ="="="="="="="="="="="="="="=K>">">">" >"!>"">"#>"$>"%> "&> "'>"?"(K @@MJmJ^dUMdoikQkfiQiQhoYkYmQkuMJmJ^dUMdoikQkfiQiQhoYkYmQkuMJmJ^dUMdoikQkfiQiQhoYkYmQk8uMJmJ^dUMdoikQkfiQiQhoYkYmQk8uMJmJ^dUMdoikQkkQMmYdbkuMJmJ^dUMdoikQkkQMmYdbkufidSQkkdikkQMmYdbkuidd`kkQMmYdbkukQMmYdbkQbid^^`QbmkukmoOQbmkQbid^^`Qbmku ʾCatalog Coursesjunk enrollments not 2002 Query studentsWenrollreport leading to unnormalized students design2Create data access page in Design viewAutoExec^3ά z0Catalog CoursesProfessors" @@ p Qbid^^`QbmkuQbid^^`Qbmku fiQiQhoYkYmQkufiQiQhoYkYmQkufiQiQhoYkYmQkufiQiQhoYkYmQkukQMmYdbkukQMmYdbkukQMmYdbkukQMmYdbkuts Subform~sq_cCombo6) @4MR2KeepLocal Tthhhhhhf `Q9vN@9vN@Sections)22222222220 2A#@A#@~sq_fstudentsWenroll)@4MR2KeepLocal TVJJJJJJH `P~.vN@~.vN@~sq_cstudents1~sq_cenrollments Subform2)' @4MR2KeepLocal T|ppppppn `O-HuN@]yYN@junk create some sections test)FM w@8o@vvj^^^^^^\ `NX7*@Oa7*@joint enrollments Query2)@+o@j^^RRRRRRRP @Md<$@d<$@report leading to unnormalized students design3)~ L9u$@I$@Sections and courses join Query - equiv to 2NF)@@F@~ `KI$@I$@report leading to unnormalized students design2)~ IB'\$@N$@students and sections and courses join equiv to 1NF))@E@ `0z@z@~sq_fstudents)@4MR2KeepLocal TH<<<<<<: `D@O3uN@Professors)@BBB66666664 @1k;@k;@~sq_fstudents1)@4MR2KeepLocal TJ>>>>>>< `.@@~sq_fEnter New Course:)4MR2KeepLocal TNNNNNNNL @,2c_7@id_7@~sq_fenrollments Subform1)4MR2KeepLocal TTTTTTTTR @)W[@W[@~sq_dSchedule~sq_dsectionID)4MR2KeepLocal TXXXXXXXV @&;@;@~sq_cstudents1~sq_cFindStud)4MR2KeepLocal TXXXXXXXV @$z@z@~sq_cstudents~sq_cFindAStud)4MR2KeepLocal TXXXXXXXV @#z@z@~sq_cstudents~sq_cenrollments Subform1)4MR2KeepLocal Tnnnnnnnl @ 2c_7@@enrollments Subform1)JJJJJJJJJJH H19R@19R@studentsenrollments)HHHHHHHHHHF FMx@Mx@RoomsSections)<<<<<<<<<<: a @@ MJmJ^dUMdoikQkuMJmJ^dUMdoikQkuMJmJ^dUMdoikQkuMJmJ^dUMdoikQkuMJmJ^dUMdoikQkuMJmJ^dUMdoikQkufidSQkkdikuidd`kukQMmYdbkukmoOQbmku ) V +efqDW$AFo}U6ĭZseRC.c1]Bl7nPLs( **>wU]p V ( V+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p V ) & ) % ( % +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p % ) $ ( $ +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p $ ) # ( # +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p # ) " ( " +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p " ) ! ( ! +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ! ) ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( H( H+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p H) F( F+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p F) B( B+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p B) A( A+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p A) @( @+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p @) ?( ?+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p -d Oc M`  y . * % m  >Wh W7M\A@$$)N@)N@~sq_cenrollments Subform1~sq_cSectionIDnnnnnnnnnnn `#N@ƒN@~sq_cenrollments Subform~sq_cCombo624MR2KeepLocal Thhhhhhhf @`!Q7@?@findstd20000000000.    @?@Courses20000000000. P~@?@BackToMain266666666664 nB@?@AutoExec222222222220 G[@?@Schedule222222222220 '@?@rosterX20000000000. d<$@d<$@report leading to unnormalized students design32~ I$@I$@report leading to unnormalized students design22~ Z2۽@@Count Of Enroll By Dept and Course2ffffffffffd @S@@All Enrollments2@@@@@@@@@@> ._@@studentTasks2::::::::::8 hUW@@studentsWenroll2@@@@@@@@@@> ;@@students1244444444442 q`_7@@students222222222220 9vN@9vN@Sections222222222220 g^<@@Rooms2,,,,,,,,,,* G@@main2**********( ƶ&@@FacultyTasks2::::::::::8 @@Enter New Course:2DDDDDDDDDDB z;@@enrollments Subform22JJJJJJJJJJH  2c_7@@enrollments Subform12JJJJJJJJJJH  fW@@enrollments Subform2HHHHHHHHHHF  E@@DeansTasks266666666664  @@@Catalog Courses2@@@@@@@@@@>  q@@AdminTasks266666666664  p_޿@p_޿@UserDefined288888888886  p_޿@p_޿@SummaryInfo2@|DDD88888886 @ ӕ@2N@AccessLayout24MR2KeepLocal T@zz:::::::8 @ ޿@ ޿@SysRel2..........,  ޿@ ޿@Scripts20000000000.  ޿@ ޿@Reports20000000000.  ޿@ ޿@Modules20000000000.  ޿@ ޿@Forms2,,,,,,,,,,* `ݿ@ݿ@MSysRelationships0DDDDDDDDDDB ݿ@ݿ@MSysQueries088888888886 ݿ@ݿ@MSysACEs022222222220 ݿ@ݿ@MSysObjects088888888886 `ݿ@ݿ@Relationships0<<<<<<<<<<: ݿ@ݿ@Databases044444444442 ݿ@ݿ@Tables0.........., Ux:O d F ( ]  y ?  | 8  e * p,\> S@pR4F( |?F( M P/Sections!!! / G/ / G.[Sections].[Year]0 g.[Sections].[Sem]/ g.[Sections].[Section]3 g.[Sections].[Course#]3 g.[Sections].[Dept]0 g.[Sections].[sectionID]5 g.Sections!!! . G. . G-([__Student ID] = studentID); '-enrollmentsstudentsWenrollEE' -  G-__Student ID))) O- - G,students!!! ,  G, , G+([__Student ID] = studentID); '+enrollmentsstudents199' +  G+__Student ID))) O+ + G*[students].[Last]0 g*[students].[First]1 g*[students].[Student ID]6 g*students!!! * G* * G)students!!! )  G) ) G(([__Student ID] = studentID); '(enrollmentsstudents77' (  G(__Student ID))) O( ( G'^@ ''Professors.Dept. g'Professors.Name. g'Professors%%% ' ' G&F@ g&[Rooms].[Data Projector]7 g&ooms].[Data Connection]8 g&[Rooms].[Front Computer]7 g&[Rooms].[size]- g&[Rooms].[room]- g&Rooms & & G%[Sections].[Section]3 g%[Sections].[Course#]3 g%[Sections].[Dept]0 g%[Sections].[sectionID]5 g% Sections!!! % G%  % G$Sections!!! $  G$ $ G#b@ '#Sections.Year, g#Sections.Sem+ g#Sections.Section/ g#Sections.[Course#]1 g#Sections.Dept, g#Sections.sectionID1 g#Sections!!! # G# # GLVAL(XN T 8 T & l ^THP XZ22[SectioSections.sectionID = enrollments.sectionID[Sections].[sectionID] =[enrollments].[sectionID][students].[Student ID] =[enrollments].[studentID][Catalog Courses].[Course#] =[Sections].[Course#][Catalog Courses].[Dept] =[Sections].[Dept][enrollments].[special permission][students].[Student ID] =[enrollments].[studentID][enrollments].[special permission][students Query].[Student ID] =[enrollments].[studentID][enrollments].[special permission][students Query].[Num Credits Earned]students.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept(((students.First)=[What is your first name?]) AND ((students.Last)=[What is your last name?]))students.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept(((enrollments.sectionID)=[Enter Course Index Number]))students.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID((([Catalog Courses].Dept)="BIO") AND ((Professors.Dept)="BIO"))((([Catalog Courses].Dept)="BUS") AND ((Professors.Dept)="MKTG"))[Sections].[sectionID] =[enrollments].[sectionID][students].[Student ID] =[enrollments].[studentID][Catalog Courses].[Course#] =[Sections].[Course#][Catalog Courses].[Dept] =[Sections].[Dept][enrollments].[special permission](((Sections.Sem)="S") AND ((Sections.Year)=1997))Sections.sectionID = enrollments.sectionID[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept(((Professors.Dept)=[Forms]![Sections]![Dept]))[Rooms].[Numb Student Workstations](((Sections.Sem)="F") AND ((Sections.Year)=2002))%%3/O~zN  MY ~K " Jm H%!HGtE|hBfA}CC N@CC0Y۟@6_@roster Query2@@@RFF:::::::8 @[@4@yYsN@Rooms2r@888,,,,,,,* @U@O3uN@Professors2@BBB66666664 @QN&F@Qlĵ@Prerequisites2C@HHH<<<<<<<: @&;-N@oN@MSysAccessObjects2DDDDDDDDDDB BL?@P7"@junk Query2@@NBB66666664 @`@-HuN@]yYN@junk create some sections test2@@vjj^^^^^^^\ @?˂XN@œ;N@@junk create some sections a2-@ |@{pddXXXXXXXV @>X7*@Oa7*@joint enrollments Query22@|@{j^^RRRRRRRP @=X+@p+@join students enrolled sections/classes2Z@||||pppppppn @`;SBZ@Z@enrollments Query2Z@|PPPDDDDDDDB @@' QN@enrollments2@|DDD88888886 @:aS@M@CountOfEnrollByCourse Query2@|@~pddXXXXXXXV @j@agnN@Catalog Courses2@|LLL@@@@@@@> @9A#@A#@~sq_fstudentsWenroll24MR2KeepLocal TJJJJJJJH @`7z@z@~sq_fstudents24MR2KeepLocal T|||<<<<<<<: @`5g^<@g^<@~sq_fRooms24MR2KeepLocal Tvvv66666664 @`3&";@&";@~sq_fenrollments Subform224MR2KeepLocal TTTTTTTTR @22c_7@id_7@~sq_fenrollments Subform124MR2KeepLocal TTTTTTTTR @`0?@?@~sq_fCatalog Courses24MR2KeepLocal TJJJJJJJH @/W[@W[@~sq_dSchedule~sq_dsectionID24MR2KeepLocal TXXXXXXXV @`-A#@A#@~sq_cstudentsWenroll~sq_cenrollments Subform24MR2KeepLocal Tzzzzzzzx @,;@;@~sq_cstudents1~sq_cFindStud24MR2KeepLocal TXXXXXXXV @`*z@z@~sq_cstudents~sq_cFindStud24MR2KeepLocal TVVVVVVVT @)z@z@~sq_cstudents~sq_cFindAStud24MR2KeepLocal TXXXXXXXV @`'tvN@tvN@~sq_cSections~sq_cCombo1824MR2KeepLocal TTTTTTTTR @`%T ;@T ;@~sq_cenrollments Subform2~sq_csectionID24MR2KeepLocal Tpppppppn @VAkM/ O 1  g + m O !  { ] ?  k M /  s *X_(~`B`-i;G Y =U[students].[Year]0 g=U[students].[Last]0 g=U[students].[Middle]2 g=U[students].[First]1 g=U[students].[Student ID]6 g=Uenrollments''' =Ustudents!!! =USections!!! =UCatalog Courses/// =U G=U =U G<U [grade]& g<U[special permission]3 g<U [sectionID]* g<U [studentID]* g<Uenrollments''' <U <U G;U [grade]& g;U[special permission]3 g;U [sectionID]* g;U [studentID]* g;Uenrollments''' ;U ;U G: co[Catalog Courses].[Course#]: g: co[Catalog Courses].Dept5 g: cob@ ':coSectionsenrollmentsT@C7! :coCatalog CoursesSections`@K?/ :coCatalog CoursesSectionsL@K?/ :co[Catalog Courses].[Course#]: g:co[Catalog Courses].Dept5 g:coCountOfstudentIDCount(enrollments.studentID)[11 o: coenrollments''' : coSections!!! : coCatalog Courses/// :co G:co G: co :co G9students!!! 9  G9 9 G8students!!! 8  G8 8 G7students!!! 7  G7 7 G6Sections!!! 6  G6 6 G5Rooms 5  G5 5 G4Catalog Courses/// 4  G4 4 G3enrollments''' 3  G3 3 G2enrollments''' 2  G2 2 G1enrollments''' 1  G1 1 G0Catalog Courses/// 0  G0 0 G/[Sections].[Section]3 g/[Sections].[Course#]3 g/[Sections].[Dept]0 g/[Sections].[sectionID]5 g2 YUGrad"NUAUUU Y  Y  Y < Y Y DeptCourse# TitleDescriptionCreditsvwYYQYQYaYYY.rD.rE.rFCourse#DeptPrimaryKey $ $$ %%%%%%%%&&&&&&&&&' '"'#'$'%'!(&((()(*(+('),).)/)-*0*2*3*4*5*6*1+7+9+:+;+<+9N@N@~sq_fstudentsWenrollHHHHHHHHHHH 8N@N@~sq_fstudents1<<<<<<<<<<< 7N@N@~sq_fstudents::::::::::: 6xN@N@~sq_fSections::::::::::: 5xN@xN@~sq_fRooms44444444444 4xN@xN@~sq_fEnter New Course:LLLLLLLLLLL 3U`N@U`N@~sq_fenrollments Subform2RRRRRRRRRRR 2U`N@U`N@~sq_fenrollments Subform1RRRRRRRRRRR 1U`N@U`N@~sq_fenrollments SubformPPPPPPPPPPP 02"N@2"N@~sq_fCatalog CoursesHHHHHHHHHHH /2"N@2"N@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV .2"N@2"N@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT -N@N@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx ,N@N@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn v1b @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @######### # #$ $ $$ %%%%%%%%&&&&&&&&&' '"'#'$'%'!(&((()(*(+('),).)/)-*0*2*3*4*5*6*1+7+9+:+;+<+8,=,?,@,>-A-C-D-E-F-B.G.I.J.K.L.M.N.O.P.H/Q/S/T/////R000011 1 1 2 222 33334444555566667 7"7#7!8$8&8'8%9(9*9) 4  G4 4 G3enrollments''' 3  G3 3 G2enrollments''' 2  G2 2 G1enrollments''' 1  6LVAL9`5zE Y * C ` = h + } >  w>JnCoA f.oGxr" x @h @X x@H e@8 @( p$ @ @ @ @ `DKo's{*$Ao\ΩP)YIطMަ0NPeople in groups / socPeople in groups / society, Frameworks courseMatrices, eigenvectors, with applications3D, partial differentiation and multiple integrationExtra Math for Computer Science MajorsSerious calculus for Math and Science majorslike it says, complexities of marketing internationallyOrganizational and interfunctional interaction, buyer behavior, global interdependenceAdvertising copy, ad agencies, measuring effectivenessSales presentations, lying, networkingDeveloping and Managing a competive workforceWars, Rumors or Wars, Miltary Industrial Complex, Weapons of Mass DestructionWomen's rights, industrial revolution, Women in WarPost Reconstruction, Modern Era, Superpower!Reading, analysis and discussion of prose fictionRead, Write, Think about primary texts (at least two genres)Planning and Executing Writing Assignments - especially about readings, or using library researchGrammar, Organization, Expository WritingBusiness firm and market analysisNational and International economicsTelephone network architecture, local loop, PBX and Centrex, ISDN, ATMPrinciples of process and resource management in OS and their applicationSystems developed to support group cooperation and workA practical approach to network administration using current technologiesPrinciples and Practice of Computer Security, including internet securityHelp desk, installation and supportHardware and Software componenets of a computing systemCreation of dynamic and interactive documents for the internetPlanning, designing and creating multimedia content. Integration into WWWProject oriented - development, testing, change managementProject oriented - requirements analysis, design, prototypingAnalysis of algorithms. Divide and Conquer, greedy, backtracking, dynamic programming, NP completeGeneral Principles and Concepts of process and resource management in OSKnowledge representation, search, heuristic systems and & Picture generation, 2D, 3D, transformationsDatabase systems in an N-tier worldTheory, finite automata, BNF, syntax, semantics, language paradigmsCommunication networks and cooperative processing. LANs WANSAppropriate industrial experienceAdvanced data structures and intro to analysis of algorithmsPrivacy, cryptography, hackers, ethicsApplications for PCs, especially using Visual BasicIntro to Database systems including relational theory and applicationsC++ introduction plus introductory algorithms - searching and sorting etcLearning Programming and Problem-solving using the computer language Java as a vehicle.Introduces basic packages such as Word, Excel - emphasis on ExcelIntroduces basic packages such as Word, ExcelThermodynamics and kinetics, chemical equilibrium, thermochemistryQuantum Mechanics applied to the solution of elementary systems. Lasers too!Chemistry in society - no math, hardly any labAll the way up through quantum mechanicsAn introduction to chem for real science majors & Time value of money, security valuation, cost of capital, financial statement analysisAccounting without software packagesAn introduction to biology for biology and chemistry majorsHow human bodies work, great for pre-medsA foundation biology course for non-majors, that places emphasis on human biologyA foundation biology course for non-majors, that places emphasis on ecology;r3K  : P  } . x 1 z B `g-z>MeRL`%HIS329The American Woman5@-." HIS324History of Philadelphia"From William Penn to John StreetU' HIS305US 1877 to Present.@,." HIS251Global History 1500 to PresentWars, Rumors of WarsP. HIS151Global History to 1500 Dinosaurs, Serfs, No computersR& ENG203Fiction3@+# ENG150Themes in Literature>@*0$ ENG108College Writing IIc@)." ENG107College Writing+@(+ ECN213Stats for EconomicsNo proofs, econ examplesI# ECN201Microeconomics#@'* ECN155Modern Economic IssuesMarkets. Plus special topicsP& ECN150Macroeconomics&@&* CSIT461Telecommunications and TelephoH@%;/ CSIT447Applied Operating SystemsK@$6* CSIT392Groupware9@#& CSIT382LANs and Network AdminK@"3' CSIT371SecurityK@!% CSIT365Client Support%@ + CSIT362NetworkingNetworking for IT majorsA CSIT136Intro to IT9@( CSD340Web Scripting@@) CSD210Creating MultimediaK@/# CSC481Project Implementation<@2& CSC480Project Design?@* CSC464Theory of Algorithmsd@0$ CSC457Operating SystemsJ@-! CSC456Intro to Artificial Intelligen=@:. CSC453Graphics-@$ CSC372Database Applications%@1% CSC366Language Theory and DesignE@6* CSC362Networks>@$ CSC360Internship#@& CSC354Data Structures>@+ CSC352Computers, Ethics, and Social(@9- CSC265PC Applications5@+ CSC264Database SystemsH@,  CSC162DataStructuresK@* CSC157Problem Solving and ProgramminY@ :. CSC152Intro to Computing, Math / SciC@ :. CSC151Intro to Computing/@ ." CHEM302Physical Chemistry IID@ 2& CHEM301Physical ChemistryN@ /# CHEM202Organic Chemistry IIYou still here?B% CHEM201Organic ChemistryWeed out course for pre-medsL" CHEM150Consumer Chemistry0@/# CHEM112General Chemistry II*@1% CHEM111Intro to Chemistry5@/# BUS200Fundamentals of Financial ManaX@:. BUS150Presentation Skills for Busine Giving Talks, using PowerPointZ. BUS101Intro to Financial Reporting&@8, BIO230Diversity, Evolution and EcoloThe environment and evolutionY. BIO210Cellular Biology and Genetics Basic Biochemistry, DNA, genesY- BIO180Intro to Biology=@,  BIO163Clinical MicrobiologyGerms and killing themI% BIO162Anatomy and Physiology IIMore fun for pre-medsL) BIO161Anatomy and Physiology+@2& BIO158Life Science: A Human approachS@:. BIO157Life Science: An environmentalM@:. tv A q L  j 5 ]  v ( `w Detailm7U`<a<bcestudentIDstudentIDm7U`ua<bcegksectionIDsectionIDm7]`a<b ce k$special permission$special permission$special_permissiono5U`bcd<nZ"";"";"";"";"";"";"";"";"";"";"";"";"10";"10" Combo6sectionIDTable/Query|SELECT DISTINCTROW Sections.sectionID, Sections.Dept, Sections.[Course#], Sections.Section, Sections.Sem, Sections.Year FROM Sections WHERE (((Sections.Sem)="F") AND ((Sections.Year)=2002));.960;570;825;765;480;525d5`0 a<bcSectID_Label SectID`FormFooterultyTasks" " Bas0{A9CE5CD4-9C1B-11D3-9E07-0050pacIFalse dCreatablTru Pre declaIͬ =^ZFormHeaderd studentID_LabelstudentID Labeld sectionID_LabelsectionID Labeld special_permission_Labelspecial permission LabelDetailmstudentIDmsectionIDmspecial_permissionspecial permissionoCombo6d SectID_Label FormFooter grade0=Babe g hijkx2c_7@ enrollmentsenrollments Subform1Ariald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5`h FormHeaderd5U7`<a<bcstudentID Label studentID DetachedLabelstudentID_LabeBlob PropData(*TypeInfoSOC150Principles of Sociology/@83' REL153Dynamics of ReligionPatterns courseA$ REL150The Christian TraditionPatterns courseD' PSY155Intro to PsychologyHow people work@# POL151American Government Money Talks<# PHL152Moral Choice"More interesting patterns courseJ PHL151The Human PersonPatterns course=  MTH240Linear Algebra,@7* MTH222Calculus III6@6( MTH221Calculus IIMore serious calc: MTH140Discrete Math(@5) MTH120Calculus.@4$ MTH118Multi-variable Calculus'' MTH117Calculus MTH113Algebra and Triglike it says:  MKTG305International Marketing9@34( MKTG304Business to Business MarketingX@2;/ MKTG302Advertising and Promotional Ma8@1;/ MKTG301Personal Selling(@0-! MGMT354EntrepreneurshipSmall business managementH! MGMT353Dispute Resolution"Conflict management, negotiationQ# MGMT303Managing Human Resources II/@/8, MGMT302Managing Human Resources"creating a competitive workforceW) HIS337The Black ExperienceSlavery, Civil Rights,H$ HIS333The American Imigrantlike it says?% HIS331America's Military PastO@.3'  @@@@@@@@@@@@@@@@@@@@@86886D286F3888 88: 88< 88D 88F 8:6868@6 8@6 8@6.8@648@68@68@88@868@88@88@:8@:8@<8@@/8@@8@D8@D8@F8B88B:8B:8B<8F6:66 :68:680:6::6<5:86:86$:8<1::8::::<6:>6:@87:B>:B@<68<68<6:<6:<6:<6<<6> <6@8<6@ <:>9<:H:<<8<<<<6%<@:<@<<@><@>>D,>@<>@B>@D >B8->B>!>F6">F8#r_Labelj2U`aiData ConnectionData ConnectionData_Connectiond5U`<abcData Connection LabelData ConnectionData_Connection_Labelj2U`aiData ProjectorData ProjectorData_Projectord5U`<abcData Projector LabelData ProjectorData_Projector_Labelj2U`aiOverheadOverheadd5U`<abcOverhead LabelOverheadOverhead_Labelm07U`abcekNumb Student WorkstationsNumb Student Workstations2number of computers in room for studets to work atNumb_Student_Workstationsd5U`<abcNumb Student Workstations LabelNumb Student WorkstationsNumb_Student_Workstations_Label` FormFooterFacultyTasks/&H00000000 DocCla0000000 DocClass=Form_studentsWenroll/&H0ͬZDetailFormHeaderFormFootermroomd room_Labelroom Labelmsized size_Labelsize LabeljFront_ComputerFront Computerd Front_Computer_LabelFront Computer Labelj Data_ConnectionData Connectiond Data_Connection_LabelData Connection Labelj Data_ProjectorData Projectord Data_Projector_LabelData Projector Labelj Overheadd Overhead_LabelOverhead LabelmNumb_Student_WorkstationsNumb Student Workstationsd Numb_Student_Workstations_LabelNumb Student Workstations LabelsFor0=Babche gh| ij,kFq`_7@studentsstudentsAriald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5` FormHeadero15Ucd"";"";"10";"4" FindAStud Table/Querystudentsfindstdd5]`8abcLabel25Student to Update:h1`axbci BackToMain Blob  PropData8:ATypeInfoBo8=)L)LBack To Main BackToMaino5U`b cpdn"";"";"";"";"";"";"10";"4"FindStud Table/QuerybSELECT DISTINCTROW [students].[Student ID], [students].[First], [students].[Last] FROM [students]; 1080;675;825findstdd5U`abdcPickStud_LabelStudent to Update`Detail m7U`axbce Student ID Student IDdStudent number - 4 digits - made text so leadin @@@      @     @     LYdLYdLYdLYdLYdLYdLYdLYdLokLok Lok MWQ` MWQ` MWQ` MWQ`MWQ`MWQ`MWQ`MkMMkMMkMMkMMkMMkMMkMMkMMkMMkMMkMMkMMkMMkMMkM MkM!MkM"MkM#MkO$MkO%MkYm&MkYm'MkYm(MkYm)MkYm*MkYm+MkYm,MkYm-QMb.QMb/QMb0QMb1QbU2QbU3QbU4QbU5WYk6WYk7WYk8WYk9WYk:WYkWYkWYk`U`m`U`m`U`m`U`m`\mU`\mU`\mU `\mU `mW `mW `mW `mW`mW`mW`mW`mWfW^fW^fd^fkviQ^iQ^kdMredits EarneddNum_Credits_Earned_LabelNum Credits Earned_LabelmGPAdGPA_LabelmHometowndHometown_LabelmBalance_DueBalance DuedBalance_Due_LabelBalance Due_LabelmsectionIDdsectionID_LabelmSections_DeptdSections_Dept_LabelmSections_Course_Sections_Course#dSections_Course__LabelSections_Course#_Labelm Sectiond!Section_Labelm"Semd#Sem_Labelm$Sections_Yeard%Sections_Year_Labelm&timed'time_Labelm(roomd)room_Labelm*professord+professor_Labelm,stop_pointstop pointd-stop_point_Labelstop point_Labelm.Titled/Title_Labelm0Descriptiond1Description_Labelm2Creditsd3Credits_Labeld4Label46m5Text47m6Text48f7Line49f8Line50f9Line508 :<=Babcwe g4d<$@fstudents and sections and courses join equiv to 1NF^report leading to unnormalized students design3 Arial8 hLexmark 3200 Series ColorFine` odXX  Lexmark 3200 Series ColorFineLPT1:LPT1:  @ @ @LYd8@DLYd8@FLYd8B8LYd8B:LYd8B<LYd8F6LYd:86LYd:<6Lok868Lok8@6 Lok:66 MWQ`888 MWQ`88: MWQ`8@6 MWQ`:68MWQ`:6:MWQ`<68MWQ`<6:MkM8@8MkM8@:MkM8@DMkM8B:MkM:B>MkM:B@MkM<@:MkM<@>MkM@<MkM>@BMkM>@D MkM>B>!MkM>F6"MkM>F8#MkO:86$MkO<>6%MkYm8>D,MkYm>B8-QMb8@6.QMb8@@/QMb:680QMb:8<1QbU86D2QbU86F3QbU8@64QbU:6<5WYk8@86WYk:@87WYk<6@8WYk<:>9WYk<:H:WYk<<8WYk<<<WYk<`\mU<68`\mU<6:`\mU<6> `\mU<6@ `mW88< `mW88D `mW88F `mW8:6`mW8>6`mW::8`mW:::`mW:>6fW^8@8fW^8@:fd^8@8fkv8@@iQ^8@6iQ^8@<kdM8@6HometownDetachedLabelϵUEzˉ}d7`P(a<bc,"Balance Due_LabelBalance DueDetachedLabel"Balance_Due_Label89AGRQd` 0a<bc,sectionID_LabelSection IndexDetachedLabel]0AiT!d`4a<bc,&Sections_Dept_LabelSections_DeptDetachedLabelLJI3Ld`8a<bc,,Sections_Course#_Label Sections_Course#DetachedLabel,Sections_Course__Labels]Ay Q>>>>>>>>>> 9N@N@~sq_fstudentsWenrollHHHHHHHHHHH 8N@N@~sq_fstudents1<<<<<<<<<<< 7N@N@~sq_fstudents::::::::::: 6xN@N@~sq_fSections::::::::::: 5xN@xN@~sq_fRooms44444444444 4xN@xN@~sq_fEnter New Course:LLLLLLLLLLL 3U`N@U`N@~sq_fenrollments Subform2RRRRRRRRRRR 2U`N@U`N@~sq_fenrollments Subform1RRRRRRRRRRR 1U`N@U`N@~sq_fenrollments SubformPPPPPPPPPPP 02"N@2"N@~sq_fCatalog CoursesHHHHHHHHHHH /2"N@2"N@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV .2"N@2"N@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT -N@N@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx ,N@N@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn v1 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @######### # #$ $ $$ %%%%%%%%&&&&&&&&&' '"'#'$'%'!(&((()(*(+('),).)/)-*0*2*3*4*5*6*1+7+9+:+;+<+8,=,?,@,>-A-C-D-E-F-B.G.I.J.K.L.M.N.O.P.H/Q/S/T/////R000011 1 1 2 222 33334444555566667 7"7#7!8$8&8'8%9(9*9+9):,:.:/:0:1:2:3:4:5:6:7:8:9: ::- 2 G1enrollments''' 1  G1 1 G0Catalog Courses/// @` rT6dF* | ` D ( r V :   p T 8  n R 6  l P 4  jL.jN2nR6rV:vZ>"z\> rV:vZ>"707080514707080506707080505707080461707080103616180496616180433616180431616180414616180301555580494555580474555580448555580436555580311555570238D 555570234B 555566415C 555562341A 555562272B 555511111A 515180496515180466515180449515180408515180405414180514414180506414180505414180492414180438313180463313180436313180410313180403313180202222280511222280453222280406222280405222280201212181201212180494212180424212180419212180301181880496181880469181880451181880406181880403181880202121280492121280471121280452121280408121280405121280201112380511112380491112380470112380447112380321112380301112370232B 112366422B 112366415B 112362341A 112362272D 111980494111980470111980452111980408111980403111980102111966419C 111966417B 111911112B 111782111111780519111780515111780472111780371111780361111769705A 111767488A 111762272C 111680516111680501111680465111680453111680408111680405111666419B 111666415A 111662341B 111580519111580465111580449111580435111580433111580414111580103111566419F 111566417A 111566416103455A111380465111380449111380443111380414111380103111366417A 111362341C 111362272A 111180503111180447111180435111180104111166419C 111166415134556B111162341F 109380474109380443109380322109380311109370234A 109366419D 109366416B 109362341A 101180520101180493101180414101180104\t717180475717180457717180412717180405717180202@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @8688F686>8688F6>8>8688F6>H<8688F6@:686H<B:<>886H<BB>8B86H<BB>8H86H<D6:<>86H<F6<8886H<F6<:: 86H<F6>>< 86H<F6>D> 8888B:<>8 8888BB>8@ 8888BB>8H8888F686>8888F6><@8888F6>>D8888F6@6<888<B::D:888<B:<>8888<BB>8D888<F686<888<F6>8>888<F6>><888<F6>>H888<F6>B@888@BB>8B888@BB>8D888@BB>8H888@F686<888@F6>8>888@F6><< 888@F6><@!888@F6>>H"888@F6>B@#888@F6@8H$888BB:<>8%888BBB>8@&888BBB>8H'888BF6>6@(888BF6>6F)888BF6>@<*888BF6>B@+888BF6@68,888BF6@8B-888DB::D:.888DBD>FF/888DBHD6@0888DF6D:3888DF6@8@4888DF6@8H5888DF:8886888H8888:7888HBB>8D8888HBB>8H9888HF686::888HF6>6<;888HF6>6F<888HF6>@:=888HF6>D6>888HF6>H>?88:<B::D:@88:<B:<>8A88:<BB>8@B88:<BB>::C88:<D6:<:D88:<F6<68E88:<F6<:8F88:<F6>>DG88:<F6>D6H88:<F6>H8I88:<F6@88J8:8:F6:68K8:8:F6>6@L8:8:F6>6FM8:8:F6>@:N8:8:F6>D8O8:8:F6>H:P8F8FF6:6:Q8F8FF6>6<R8F8FF6>6BS8F8FF6>@8T8F8FF6>BHU8F8FF6>HBV:8:8F6<68W:8:8F6>8HX:8:8F6>:>Y:8:8F6>H>Z:8:8F8:68[::::F6:68\::::F6>6@]::::F6>6B^::::F6>@<_::::F6@88`<8<8F6:6:a<8<8F6>6<b<8<8F6>86c<8<8F6>B<e>8>8F6>8>8F6>H:g>8>8F6@6@h>8>8F6@6Bi>8>8F6@8>j@8@8F6>6@k@8@8F6>6Fl@8@8F6>>Hm@8@8F6>BBn@8@8F6>HBo@@@@88888p@@@@B::D:q@@@@B:<>8r@@@@BB>8@s@@@@D6:<>t@@@@D6:>Fx@@@@F6>D>y@@@@F6>H>zB8B8F6<68{B8B8F6>8>|B8B8F6><8}B8B8F6><<~B8B8F6>HBD6D6F686<D6D6F6>B8D6D6F6@6@D6D6F6@6BD6D6F6@8>D8D8F6:6:D8D8F6>6@D8D8F6>8:D8D8F6>@DD8D8F6>D@88888p8888:7B::D:B::D:.B::D:@B::D:qB:<>8B:<>8 B:<>8B:<>8%B:<>8AB:<>8rBB>8@ BB>8@&BB>8@BBB>8@sBB>8BBB>8BBB>8DBB>8DBB>8D8BB>8HBB>8HBB>8HBB>8H'BB>8H9BB>::CBD>FF/BHD6@0D6:<:DD6:<>D6:<>tD6:F686>F6:68KF6:68\F6:6:QF6:6:aF6:6:F6<68EF6<68WF6<68{F6<88F6<88vF6<:8FF6<:: F66<;F6>6<RF6>6<bF6>6@(F6>6@LF6>6@]F6>6@kF6>6@F6>6BSF6>6B^F6>6F)F6>6F<F6>6FMF6>6FlF6>86cF6>8:F6>8>F6>8>F6>8>F6>8>|F6>8HXF6>:>YF6><8}F6><< F6><<~F6><@F6><@!F6>>< F6>><F6>>DF6>>DGF6>>FxF6>>HF6>>H"F6>>HmF6>@8TF6>@:=F6>@:NF6>@<*F6>@<_F6>@DF6>B8F6>B<eF6>B@F6>B@#F6>B@+F6>BBnF6>BHUF6>D6>F6>D6HF6>D8OF6>D:3F6>D> F6>D>yF6>D@F6>H8IF6>H:PF6>H:gF6>H<F6>H>?F6>H>ZF6>H>zF6>HBVF6>HBoF6>HBF6@68,F6@6<F6@6@hF6@6@F6@6BiF6@6BF6@88JF6@88`F6@8>jF6@8>F6@8@4F6@8B-F6@8H$F6@8H5F6@:6F8:68[F:88862@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @868886888688868886H<86H<86H<86H<86H<86H< 86H< 86H< 8888 8888 88888888888888888888888<888<888<888<888<888<888<888<888@888@888@888@888@888@ 888@!888@"888@#888@$888B%888B&888B'888B(888B)888B*888B+888B,888B-888D.888D/888D0888D1888D2888D3888D4888D5888D6888H7888H8888H9888H:888H;888H<888H=888H>888H?88:<@88:<A88:<B88:<C88:<D88:<E88:<F88:<G88:<H88:<I88:<J8:8:K8:8:L8:8:M8:8:N8:8:O8:8:P8F8FQ8F8FR8F8FS8F8FT8F8FU8F8FV:8:8W:8:8X:8:8Y:8:8Z:8:8[::::\::::]::::^::::_::::`<8<8a<8<8b<8<8c<8<8d<8<8e>8>8f>8>8g>8>8h>8>8i>8>8j@8@8k@8@8l@8@8m@8@8n@8@8o@@@@p@@@@q@@@@r@@@@s@@@@t@@@@u@@@@v@@@@w@@@@x@@@@y@@@@zB8B8{B8B8|B8B8}B8B8~B8B8D6D6D6D6D6D6D6D6D6D6D8D8D8D8D8D8D8D8D8D8?w;q,  B  I J  z / 8 z\> 4FX:Zp1[1}K @U[Catalog Courses].[Course#]: g@UCatalog Courses_Dept[Catalog Courses].Dept]99 o@UProfessors%%% @UCatalog Courses/// @U G@U G@U @U G?U@  '?UExpr5room "O 113"8# ?UExpr4sectionID80403@- ?UExpr3Year"2002"7# ?UExpr2Sem"F"2! ?UExpr1Section"01";) ?UprofessorProfessors.Name@# w?UCourse#[Catalog Courses].[Course#]H w?UCatalog Courses_DeptDept[Catalog Courses].DepteA9 ?UProfessors%%% ?UCatalog Courses/// ?U G?USections!!! O?U ?U G> Uenrollments_1.sectionID6 g> Uenrollments.sectionID4 g>Uenrollments_1.sectionID6 g>UCountOfstudentID Count(enrollments_1.studentID)]11 o>Uenrollments.sectionID4 g>UCountOfstudentID1Count(enrollments.studentID)]33 o>Uenrollmentsenrollments_1AA' >Uenrollments''' >U G>U G>U >U G=USectionsenrollmentsb@ C7! =Ustudentsenrollmentsd@ C7! =UCatalog CoursesSectionsb@ K?/ =UCatalog CoursesSectionsV@K?/ =U[Catalog Courses].[Credits]: g=U![Catalog Courses].[Description]> g=Uatalog Courses].[Title]8 g=U[Catalog Courses].[Course#]: g=U[Catalog Courses].[Dept]7 g=U[Sections].[stop point]6 g=U[Sections].[professor]5 g=U[Sections].[room]0 g=U[Sections].[time]0 g=U[Sections].[Year]0 g=U[Sections].[Sem]/ g=U[Sections].[Section]3 g=U[Sections].[Course#]3 g=U[Sections].[Dept]0 g=U[Sections].[sectionID]5 g=U[enrollments].[grade]4 g=U D@ g=U nrollments].[sectionID]8 g=U nrollments].[studentID]8 g=U [students].[Balance Due]7 g=U [students].[Hometown]4 g=U[students].[GPA]/ g=U![students].[Num Credits Earned]> g=U[students].[Major]1 g$ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @######### # #$ $ $$ %%%%%%%%&&&&&&&&&' '"'#'$'%'!(&((()(*(+('),).)/)-*0*2*3*4*5*6*1+7+9+:+;+<+8,=,?,@,>-A-C-D-E-F-B.G.I.J.K.L.M.N.O.P.H/Q/S/T/////R000011 1 1 2 222 33334444555566667 7"7#7!8$8&8'8%9(9*9+9):,:.:/:0:1:2:3:4:5:6:7:8:9: :: ;:-;<;>;?;@;A;B;=<C<E<F<G<H<I<D=J=L=M=N=O=P=Q=R=S=T=U="="="= "= "= "= "= "="=" =" =" =" =" ="="="="="="="="="="="="="="=K>">">">" >"!>"">"#>"$>"%> "&> "'>"?"(K#s @ @ @ @ @ @ @ @ @ @ @ @ @ @?"*?"+?",?"-?".?"/?"0?"1?"2?"3?"4?"5?"6?")@"7@"9@":@";@"<@"=@">@%@%@%@"8A%A%A%A%A%A% A% A% A% A% A%A%A%B%B%B%B%B%B%B%B%B %B %B %B %B %B %B %B % B  %!B%C%"C%$C%%C%&C%'C%(C%)C%*C%+C%,C%-C%.C%/C%0C%#D%1D%3D%4D%5D%6D%7D%8D%9D%:D%;D%D%?D%@D%AD%BD%CD%DD%2E%EElElElElElElElElElEl El El E l E l E lE lE lElElE lE lE lE%FFlFlFlFlFlFlFlFlFlFl Fl!Fl"Fl#Fl$Fl%F l&F l'F l(F l)F l*Fl+Fl,Fl-Fl.Fl/Fl0Fl1Fl2Fl3Fl4Fl5Fl6Fl7Fl8F l9F l:FlGl;Gl=Gl>Gl?GrGrGrGrGrGrG rG rGlLN@LN@joint enrollments Query2PPPPPPPPPPP =)N@LN@join students enrolled sections/classesnnnnnnnnnnn <)N@)N@enrollments Query1DDDDDDDDDDD ;N@)N@enrollments QueryBBBBBBBBBBB XN@N@enrollments66666666666 :XN@XN@CountOfEnrollByCourse QueryVVVVVVVVVVV N@N@Catalog Courses>>>>>>>>>>> 9N@N@~sq_fstudentsWenrollHHHHHHHHHHH 8N@N@~sq_fstudents1<<<<<<<<<<< 7N@N@~sq_fstudents::::::::::: 6xN@N@~sq_fSections::::::::::: 5xN@xN@~sq_fRooms44444444444 4xN@xN@~sq_fEnter New Course:LLLLLLLLLLL 3U`N@U`N@~sq_fenrollments Subform2RRRRRRRRRRR 2U`N@U`N@~sq_fenrollments Subform1RRRRRRRRRRR 1U`N@U`N@~sq_fenrollments SubformPPPPPPPPPPP 02"N@2"N@~sq_fCatalog CoursesHHHHHHHHHHH /2"N@2"N@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV .2"N@2"N@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT -N@N@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx ,N@N@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn v1 @ @ @ @ @ @ @?"*?"+?",?"-?".?"/?"0?"1?"2?"3?"4?"5?"6?")@"7@"9@":@";@"<@"=@">@%@%@%@"8A%A%A%A%A%A% A% A% A% A% A%A%A%B%B%B%B%B%B%B%B%B %B %B %B %B %B %B %B % B% AUSections.Year, gAUenrollments.grade0 gAU"enrollments.[special permission]? gAUenrollments.sectionID4 gAUenrollments.studentID4 gAUenrollments''' AUSections!!! AU GAU GAU AUK&[@@@@ ,6PwSysAccessObjects)LLLLLLLLLLJ x99K&[ࡱ>   1# !"2E%&'()*+,-./0_345678O:;<=>?@ABCDZGHIJKLMNPQRSTUVWXY[\]^`btachdefgikjlpmnoqsruzvwxy{|}~Root EntryZL VBA`LLVBAProject`LLVBA `LLdir__SRP_0 __SRP_1J&__SRP_2 O   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIKLMNPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrsuvwyz{|}~0* pHd university4@j = r > J< ADAO>BDAO *\G{00025E01-u0C  0046}#5.0#0#C:\PROGRAM FILES\COMMON MICROSOFT SHA0RED\w350.DLL#Microsoft  3.51 Object Li`braryHUstdole>fstdoPle^f\c^043[W-^2^WINNT\System32\12.tlb#OLE Automation/ VBIDE>VBIPDECÀCE157C5.3P\\Bc-srv1\PUBLIC\OFF0ICE2@ V\PFiles\Common\MSShared\VB A6E6EX T.OLBTVisual Basic for A pplic2s Extensibtil !- @Form_mainGA]rm_ainDMSWIRNZJFKLWDFQSMBBEXLQEZLK28AMSWLRNZJFKL@D@QMSBSX@*QZKB"H@1µuXB,+T"B(B+B 0studentTasksG F2ue3tTask6LVLIFQMPRWOSMDPJKXUHGTXTVADI6LV*I1MPR4O3D@J9XU0GXV@D S& AF@acultyF@cudty ARBEUK vYDTYDVSTWNJHTDVISPEA@1U@CO7Y]TTVTNU8H` D I`P[6@-6A%6Deans5D~a`5sNMRXLUFFKUUQDXDZRLLSP_BENFYHHCM@KVU5OU 3QXU`Z`L 9S6_@QETFH`7Oo5+PEPsWenrollGUPs+!R:rl@8Q`6COXKXWAFEPDXXMFOJD@WFSVNA6R"5X"OWMF2PX8F@9JW` S6N ElR/q/K*mrU~~~~~~~j  %4BJ<3(8  K&[ 9a Y 1 a !9 Form_mainForm_studentTasksForm_FacultyTasksForm_DeansTasksForm_studentsWenrollReport_Report1 universityFG\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\Common\MSShared\VBA\VBA6\VBE6.DLLVBA  `J_N?@\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\MSOffice\Office\MSACC9.OLBAccess\WĹMhV+I  1p^F=C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO350.DLLDAO a0FC:\WINNT\System32\stdole2.tlbstdole yWFJ\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\Common\MSShared\VBA\VBA6\VBE6EXT.OLBVBIDE Y!=s \@u3 {uxkL\!]!ү7{NZ@C7?FirstMiddleLastYear31?FormSC7?DetailMajorNum_Credits_EarnedGPAHometown Balance_DuePC7?enrollments_SubformAC7?enrollments_Subform_LabelEC7? Command22 Command26 FormHeader FormFooter Student_IDCommand26_Click ickFac_ClickPickDean_ClickPickAdmin_Click ` studentsɤs h)aN? `GXGPfĤIx8< VBE6.DLLrwKz$T    S  studentTasks FacultyTasks DeansTasks AdminTasks]>џI;TIpOhGyF\ΩP)aB HʌBackSeeSched PickRegisterSeeSched_Click Back_ClickPickRegister_Click T Schedule mainʛJN \ΩP)Buo_Dg N SeeRosterGoodBackSeeRoster_Click rosterX wI=FіuўfAHLÊ]ΩP)e!5NSeeCourseCountsSeeCourseCounts_Click DCount Of Enroll By Dept and Courseb\O#>e7GW߮A CGQtǔ,ү7{NZ::kh@#!'@C7?FirstMiddleLastYearMajorGPANum_Credits_EarnedHometown Balance_DuePC7?enrollments_Subformenrollments_Subform_Label Command22 Command26 FormHeader FormFooter Student_IDCommand26_Click ArU~~~~~~s     (  8  H i X\X\rU 0@4 a1zzz@8 aI~~~@< aaK&[@@ ay@D@Hppp@L a @P a) @T aY @X ai @\ a @`  @d ) @ hi  @ li   @p rrr@t ttt@x a vvv0   lX''' , pp ,>,F p6  O,tx$,p KR Cx@'0%ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  O,tx$,p T48<8rU $` n $` $` $` n__SRP_3t__SRP_4 x__SRP_5__SRP_6rU    A i y  !Iq @4) Q rrr@8 ppp@ < avvvI@ @ attt @D@ H axxxK&[dWKACx/'D%'T%lxFd%t$ `t t<''' @ tt ,>@F0 t60  >|(x$@t0 KRCx@'0%ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  O,tx$,p KR Cx@'0%ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  O,tx$,p @<HHrU T$` $A` $` nrU 0   A i y  1Y @ 4 attt @ 8 axxx@<) Q rrr@@@ D avvvI@H pppdWKACx/'D%'T%lxFd%t$ `t t<''' @ tt ,>@F0 t60  >|(x$@t0 KRCx@'0%ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  O,tx$,p 4DPrU T$__SRP_7__SRP_8 __SRP_9g__SRP_a r` $A` nrU `  A i y Ai@4) Q rrr@8) i ttt@ < avvv @@@ D axxx@H pppdKACx/'D%'T%lxFd%t$ `t t<''' @ tt ,>@F0 t60  >|(x$@t0 <XK&[ࡱ> rU T$` nrU   A i y  1@4Yzzz@8Y~~~@<Y@@Y@D@H ppp@LY@PY @TY@XY9@\YY@`y@d) @ h a@ l a1  @pQrrr@tqttt@xYvvv Kx7((F%'8%(H%(X%(h%x$ `x 4x7((F%'8%(H%(X%(h%x$ `x 4x<'''$ xx ,>$F x6 u$ $$xlXrU $ ` n__SRP_bg_VBA_PROJECT$ARBEUKCOMYDTYDVSTWNJHTDVISPE: DMSWIRNZJFKLWDFQSMBBEXLQEZLK:9am  **\G{000204EF-0000-0000-C000-000000000046}#4.0#9#\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\Common\MSShared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications(*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\MSOffice\Office\MSACC9.OLB#Microsoft Access 9.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO350.DLL#Microsoft DAO 3.51 Object Library*\G{00020430-0000-0000-C000-0K&[00000000046}#2.0#0#C:\WINNT\System32\stdole2.tlb#OLE Automationh*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\Common\MSShared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3 >8DMSWIRNZJFKLWDFQSMBBEXLQEZLK123eb3e6f8Form_mainu8LVLIFQMPRWOSMDPJKXUHGTXTVADI133eb3e6f8?"Form_studentTasksA8ARBEUKCOMYDTYDVSTWNJHTDVISPE143eb3e6f8W"Form_FacultyTasks0 8MRXLUFFKUUQDXDZRLLSP_BENFYHH153eb3e6f8_Form_DeansTasks+H8RBECOXKXWAFEPDXXMFOJDWFSVNAE1=3eb3f070g(Form_studentsWenrollq`R0H`CXo@MP7"T\ O 1ZEQ2(nBȏEBGeO ^˳EQ~+JBAccessVBAWin16~Win32MacVBA6# university.DAO Form_mainN _EvaluateChooseStud_ClickErr_ChooseStud_Click. stDocNamezstLinkCriteriaYDoCmdƧOpenFormExit_ChooseStud_Click4MsgBoxRErro Description PickStud_Click Err_PickStud_ClickIExit_PickStud_Click PickFac_Click|Err_PickFac_Click,Exit_PickFac_ClickaKPickDean_ClickErr_PickDean_ClickOExit_PickDean_ClickPickAdmin_ClickCErr_PickAdmin_Click:aExit_PickAdmin_ClickForm_studentTasksaSeeSched_Click0Err_SeeSched_Click OpenReport acPreviewoExit_SeeSched_Click+ Back_Click/Err_Back_Click`Exit_Back_ClickPickRegister_ClickErr_PickRegister_ClickExit_PickRegister_ClickForm_FacultyTasksASeeRoster_ClickRErr_SeeRoster_ClickITExit_SeeRoster_ClickForm_DeansTasks=SeeCourseCounts_ClicksErr_SeeCourseCounts_ClickExit_SeeCourseCounts_ClickForm_studentsWenroll8Command26_Click;Err_Command26_Click2i DoMenuItem&e acFormBar acEditMenu acMenuVer70XExit_Command26_Clickstdole`VBIDEAFormDetail2Label0,Label1,PickStudPickFac@PickDean PickAdminCommand7ClickSeeSched0Back_ PickRegister SeeRosterOiGoodBackSeeCourseCounts? FormHeader  FormFooterT Student_IDStudent_ID_Label~Firstz First_Label9MiddleX Middle_LabelLastbh Last_LabelYear6n Year_LabelBMajor' Major_LabelfNum_Credits_EarnedNum_Credits_Earned_Label!yGPAƔ GPA_LabelI2Hometown{8Hometown_Label8 Balance_DueBalance_Due_Label3ienrollments_Subformenrollments_Subform_Label Command22 Command26Report_Report1"Report$PageHeaderSectionwPageFooterSectionLine0K&[Line1Image2`Image3aLine4Line5Line6Image7eImage8fLine9Line106Line117Image12GImage13GLine14:Line15;Line16<Image17GImage18GLine19?Line20[Line21\Image22=GImage23>GLine24_Line25`Line26aImage27BGImage28CGLine29dLine30Line31Image32bGImage33cGLine34Line35Line36Line37Line38Line39Line40Line41Line42Line43Line44Line45Image46GImage47GLine48Line49Line50Image51GImage52GLine53Line54Line55Image56GImage57GLine58ecl0  ecltitle0\ecl1  ecltitle1\ecl2  ecltitle2\ecl3  ecltitle3\ecl4!  ecltitle4\ecl5"  ecltitle5\ecl6#  ecltitle6\ecl7$  ecltitle7\ecl8%  ecltitle8\ecl9&  ecltitle9\ecl10p! ecltitle10" ReportHeaderŃ ReportFooterR.Label81DLabel82E Detail_FormatCCancel FormatCountItemData ControlsKItemzg?vxW_  Z0   lX''' , pp ,>,F p6  O,tx$,      !"#$%&'()*+,-./0123456789;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklnopstuvy{|}~m ʛJN \ΩP)Buo_Dg NxME SLS S<(<,<<<<< <$<0<4<8<<<N0{A9CE5CD4-9C1B-11D3-9E07-00509508298F} h XX`@`x J`@`xmain`t %X0 %V` %0@" t @d @T @D p@ @0 @ @ @  p @` @P @@ @0 p, @ @ @ @K&[ XX8T>$ "  (/8 PX `<hx "   @  < xpZ`]@rosterX'  F B@D \(| Z "!$A@ $\oxXLh]]main'   B@N(| L "!$A@ NoAttribute VB_Name = "Form_FacultyTasks" " Bas0{A9CE5CD4-9C1B-11D3-9E07-00509508 298F} |GlobalSpacIFalse dCreatablTru Pre declaId"Expose_TemplateDerivCustomizD$Option Comp@ D3T  X "  ( 0@@ X` h<p "  @  < "  (0 8@P hp x< "  @  <  "(0 8@ H@` x < xp`]@]Xstudents'   B@ | "!$A@ xopp(`]] studentTasks'   B@*|( "!$A@ *o.] ]8 FacultyTasks'   B@0|. "!$A@ 0ho`P4P]] DeansTasks'   B@6|4 "!$A@ 6o:]] AdminTasks'   B@<|x:p "!$A@ <XoPHZAttribute VB_Name = "Form_main" " Bas0{A9CE5C84-9C1B-11D3-9E07-00509508 298F} |GlobalSpacFalse dCreatablTru Pre declaId"Expose_TemplateDeriv%CustomizD$Option Comp@ D3T   %@" t @d @T @D p@ @0 @ @ @  p @` @P @@ @0 p, @ @ @ @  p @` @P @@ @0 p, @ @ @ @ 888Th>5 "  (/8 PX `<hx "   @  < "   (@8 PX `<hx xpB`]@Schedule'  F B@D H(| B "!$A@ $HoxXLh]]main'   B@N(| L "!$A@ NoR]] students'   K&[B@T|R "!$A@ Toxp&Attribute VB_Name = "Form_studentTasks" " Bas0{A9CE5C96-9C1B-11D3-9E07-00509508 298F} |GlobalSpacIFalse dCreatablTru Pre declaId"Expose_TemplateDerivCustomizD$Option Comp@ D3T   "  *(/X px < xpb`]@"Count Of Enroll By Dept and Course'  F B@Dd|bx "!$A@ d`oXPDZAttribute VB_Name = "Form_DeansTasks" Bas0{A9CE5D02-9C1B-11D3-9E07-00509508298F} |GlobalSpacI False dCr@eatablTru PredeclaId"Expose_Template DerivCustomizD$Option Comp@ DT  $*\Rffff*1=3eb3f070z4~8<@DpHLPTX\`dhlrpttvx"  770 PX `<hx jp n p r B@lCoun n p r B@lse't(| j "!$A@ toxpAttribute VB_Name = "Form_studentsWenroll" Bas0{7B37AFD2-914E-11D3-B7F7-00105A10971B} |GlobalSpacIFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$P Sub Command26_Click() On Error GoTo_  DoCmd.DoMenuItem ac!Bar,Edit , 8, Ver70 6 Exit%:6)2T MsgBox7.Descri ptionCRe?@CDEFGHIJKLMNOQRSTUVWXYZ[\]^_`abcdefghijklmnopqruvwxyz{|}~0=BabcP e gg^<@RoomsRoomsAriald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5` FormHeader`_ Detailm7U`axbceroomroom&unique identifier for room e.g. at134d5U`<axbc room Labelroom room_Labelm07U`abceksizesizecapacityd5U`<abc size LabelCapacity size_Labelj2U`aHiFront ComputerFront Computer6whether there is a computer up front for the professorFront_Computerd5U`<aHbcFront Computer LabelFront ComputerFront_Computer_Labelj2U`aiData ConnectionData ConnectionData_Connectiond5U`<abcData Connection LabelData ConnectionData_Connection_Labelj2U`aiData ProjectorData ProjectorData_Projectord5U`<abcData Projector LabelData ProjectorData_Projector_Labelj2U`aiOverheadOverheadd5U`<abcOverhead LabelOverheadOverhead_Labelm07U`abcekNumb Student WorkstationsNumb Student Workstations2number of computers in room for studets to work atNumb_Student_Workstationsd5U`<abcNumb Student Workstations LabelNumb Student WorkstationsNumb_Student_Workstations_Label` FormFooterFacultyTasks/&H00000000 DocCla0000000 DocClass=Form_studentsWenroll/&H0ͬZDetailFormHeaderFormFootermroomd room_Labelroom Labelmsized size_Labelsize LabeljFront_ComputerFront Computerd Front_Computer_LabelFront Computer Labelj Data_ConnectionData Connectiond Data_Connection_LabelData Connection Labelj Data_ProjectorData Projectord Data_Projector_LabelData Projector Labelj Overheadd Overhead_LabelOverhead LabelmNumb_Student_WorkstationsNumb Student Workstationsd Numb_Student_Workstations_LabelNumb Student Workstations LabelsFor0=Babche gh| ij,kFq`_7@studentsstudentsAriald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5` FormHeadero15Ucd"";"";"10";"4" FindAStud Table/Querystudentsfindstdd5]`8abcLabel25Student to Update:h1`axbci BackToMain Blob  PropData8:ATypeInfoBo8=)L)LBack To Main BackToMaino5U`b cpdn"";"";"";"";"";"";"10";"4"FindStud Table/QuerybSELECT DISTINCTROW [students].[Student ID], [students].[First], [students].[Last] FROM [students]; 1080;675;825findstdd5U`abdcPickStud_LabelStudent to Update`Detail m7U`axbce Student ID Student IDdStudent number - 4 digits - made text so leadinK&[g zeroes dont go away - not doing math on them anyway Student_IDd5U`<axbcStudent ID Label Student IDStudent_ID_Labelm7U`abcekFirstFirstStudent First Named5U`<abc First LabelFirst First_Labelm7U`aHbcekMiddleMiddleStudent Middle Initiald5U`<aHbc Middle LabelMiddle Middle_Labelm7U`abcekLastLastStudent Last Named5U`<abc Last LabelLast Last_Labelo05Ubcdefh nYearYear Value List"Fr";"So";"Jr";"Sr";"Grad"1440&Student Academic Year (Fr, So, Jr, Sr)d5U`<abc Year LabelYear Year_Labelm7U`axbcekMajorMajor Student Majord5U`axbc Major LabelMajor Major_Labelm07U`abcekNum Credits EarnedNum Credits Earned(Student Number of Credits Earned to DateNum_Credits_Earnedd5U`abcNum Credits Earned Label TotalCreditsNum_Credits_Earned_Labelm07U`aHbce kGPAGPAXStudent Current GPA (derived from student course grades - must be updated each semester)d5U`aHbc GPA LabelGPA GPA_Labelm7U`abcekHometownHometown:Student Hometown (in reality would have whole address too)d5U`abcHometown LabelHometownHometown_Labelm7U`abce k Balance Due Balance Due$#,##0.00;($#,##0.00),Amount Student Currently owes the university Balance_Dued5U`abcBalance Due Label Balance DueBalance_Due_Labelp3W`<a4bcd enrollments Subform1Form.enrollments Subform1 studentID Student IDenrollments_Subform1d5]`<aDbfcenrollments Subform1 Label enrollmentsenrollments_Subform1_Label` FormFootert Dept_Labelm7U`abcekͬZʖZDetailFormHeaderFormFootermStudent_IDStudent IDd Student_ID_LabelStudent ID LabelmFirstd First_LabelFirst LabelmMiddled Middle_LabelMiddle Labelm Lastd Last_LabelLast Labelo Yeard Year_LabelYear Labelm Majord Major_LabelMajo r LabelmNum_Credits_EarnedNum Credits Earnedd Num_Credits_Earned_LabelNum Credits Earned LabelmGPAd GPA_LabelGPA LabelmHometownd Hometown_LabelHometown LabelmBalance_DueBalance Dued Balance_Due_LabelBalance Due Labelpenrollments_Subform1enrollments Subform1d enrollments_Subform1_Labelenrollments Subform1 Labeld Label25h BackToMaind PickStud_LabeloFindAStudoFindStud`Blob PPropData<>sTypeInfot09;CA)L)L0=Babche ghXiJj"k;@students students1Ariald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5`HK&[ FormHeadero5Ucdd"";"";"10";"4"FindStud Table/Querystudentsfindstdd5UabcLabel23Student to Find:`Detail m7U`axbce Student ID Student IDdStudent number - 4 digits - made text so leading zeroes dont go away - not doing math on them anyway Student_IDd5U`<axbcStudent ID Label Student IDStudent_ID_Labelm7U`abcekFirstFirstStudent First Named5U`<abc First LabelFirst First_Labelm7U`aHbcekMiddleMiddleStudent Middle Initiald5U`<aHbc Middle LabelMiddle Middle_Labelm7U`abcekLastLastStudent Last Named5U`<abc Last LabelLast Last_Labelo05Ubcdefh nYearYear Value List"Fr";"So";"Jr";"Sr";"Grad"1440&Student Academic Year (Fr, So, Jr, Sr)d5U`<abc Year LabelYear Year_Labelm7U`axbcekMajorMajor Student Majord5U`axbc Major LabelMajor Major_Labelm07U`abcekNum Credits EarnedNum Credits Earned(Student Number of Credits Earned to DateNum_Credits_Earnedd5U`abcNum Credits Earned Label TotalCreditsNum_Credits_Earned_Labelm07U`aHbce kGPAGPAXStudent Current GPA (derived from student course grades - must be updated each semester)d5U`aHbc GPA LabelGPA GPA_Labelm7U`abcekHometownHometown:Student Hometown (in reality would have whole address too)d5U`abcHometown LabelHometownHometown_Labelm7U`abce k Balance Due Balance Due$#,##0.00;($#,##0.00),Amount Student Currently owes the university Balance_Dued5U`abcBalance Due Label Balance DueBalance_Due_Labelp3W`<a4bcd enrollments Subform2Form.enrollments Subform2 studentID Student IDenrollments_Subform2d5]`<aDbfcenrollments Subform2 Label enrollmentsenrollments_Subform2_Label` FormFooterx ͬZDetailFormHeaderFormFootermStudent_IDStudent IDd Student_ID_LabelStudent ID LabelmFirstd First_LabelFirst LabelmMiddled Middle_LabelMiddle Labelm Lastd Last_LabelLast Labelo Yeard Year_LabelYear Labelm Majord Major_LabelMajor LabelmNum_Credits_EarnedNum Credits Earnedd Num_Credits_Earned_LabelNum Credits Earned LabelmGPAd GPA_LabelGPA LabelmHometownd Hometown_LabelHometown LabelmBalance_DueBalance Dued Balance_Due_LabelBalance Due Labelpenrollments_Subform2enrollments Subform2d enrollments_Subform2_Labelenrollments Subform2 Labeld Label23oFindStudlo sectio0=Babc e ghgij$kE@Ariald2hgh MS Sans Serif`Detaild5U`Ha,bcXdeLabel0Deans Information Systemd5U`,ab4cYd Label1Choose Your Task:h1U`daDbEcSeeCourseCountsSee Course Counts[Event Procedure]h1U` abciBack Back to Main BackToMain(  @` @PBlob _PropDataK&[@BTypeInfow10E)L)Lͬ]ΩP)Detaild Label0d Label1h SeeCourseCountsh Backspecial0=Babc e ghgihj$kƶ&@Ariald2hgh MS Sans Serif`Detaild5U`abcYd eLabel0.Oh, overburdened master what can I do for you?h1U`ta8b c SeeRoster See Roster[Event Procedure]h1U`atbciBack Back to Main[Event Procedure]h1U`aDbQ ciGoodBackClose Menu and Back to Main BackBlob PropDataDFTypeInfos11?OI)L)LToMainIDd studentID_LabelstudentID LabelosectiD_LabelsectionID Labelmspecial_peͬ\ΩP)Detaild Label0h SeeRosterh Backh GoodBackLabelgrade L0=Babc0*e ghYijz+kn@ Ariald2hghMS Sans Serif`! Detaild5U`a,b%cde Label0(La Salle University d5U`abcYd LaBlob ,PropDataHJTypeInfo12M)L)Lbel1"Select Your Role:h1U`abcPickStudI am a Student"[Event Procedure]h1U`a b(ciPickFacFaculty"[Event Procedure]h1U`dabaciPickDean2Dean of Arts and Sciences"[Event Procedure]h1U`a$ btciPickAdminAdministrator"[Event Procedure]h1U`a\ bVciCommand7New CoursegetridofthistooLabelCredits CredFormFooter GoTo_' Dim stDocAsͬ\ΩP)Detaild Label0d Label1h PickStudh PickFach PickDeanh PickAdminh Command7FormFooterm0=Babche gUbW@studentsstudentsWenrollAriald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4Blob VPropDataLNTypeInfo/13KWQ)L)Ln2o2p5r35zij MS Sans Serif{5K&[`  FormHeaderh1U`Da,bc Command26 Delete Record[Event Procedure]`Detail m7U`axbce Student ID Student IDdStudent number - 4 digits - made text so leading zeroes dont go away - not doing math on them anyway Student_IDd5U`<axbcStudent ID Label Student IDStudent_ID_Labelm7U`abcekFirstFirstStudent First Named5U`<abc First LabelFirst First_Labelm7U`aHbcekMiddleMiddleStudent Middle Initiald5U`<aHbc Middle LabelMiddle Middle_Labelm7U`abcekLastLastStudent Last Named5U`<abc Last LabelLast Last_Labelm7U`abcekYearYear&Student Academic Year (Fr, So, Jr, Sr)d5U`<abc Year LabelYear Year_Labelm7U`axbcekMajorMajor Student Majord5U` axbc Major LabelMajor Major_Labelm07U`abcekNum Credits EarnedNum Credits Earned(Student Number of Credits Earned to DateNum_Credits_Earnedd5U` abcNum Credits Earned Label TotalCreditsNum_Credits_Earned_Labelm07U`aHb ce kGPAGPAXStudent Current GPA (derived from student course grades - must be updated each semester)d5U` aHbc GPA LabelGPA GPA_Labelm7U`abcekHometownHometown:Student Hometown (in reality would have whole address too)d5U` abcHometown LabelHometownHometown_Labelm7U`ab ce k Balance Due Balance Due$#,##0.00;($#,##0.00),Amount Student Currently owes the university Balance_Dued5U` abcBalance Due Label Balance DueBalance_Due_Labelp3W`<a4bcd enrollments SubformForm.enrollments Subform studentID Student IDenrollments_Subformd5]`<aDbfcenrollments Subform Label enrollmentsenrollments_Subform_Label`8 FormFooterh1U`a Command22 Command22_Workstations_Label` FormFooter00 DocCla0000000 Dͬү7{NZDetailFormHeaderFormFootermStudent_IDStudent IDd Student_ID_LabelStudent ID LabelmFirstd First_LabelFirst LabelmMiddled Middle_LabelMiddle Labelm Lastd Last_LabelLast Labelm Yeard Year_LabelYear Labelm Majord Major_LabelMajor LabelmNum_Credits_EarnedNum Credits Earnedd Num_Credits_Earned_LabelNum Credits Earned LabelmGPAd GPA_LabelGPA LabelmHometownd Hometown_LabelHometown LabelmBalance_DueBalance Dued Balance_Due_LabelBalance Due Labelpenrollments_Subformenrollments Subformd enrollments_Subform_Labelenrollments Subform Labelh Command22h Command26Serifi1gh0=Babe ghgihj"k._@Ariald2hgh MS Sans Serif`@ Detaild5U`abcdLabel0!Where would you like to Go Today?h1U`8aBlob }PropDataPRTypeInfov14U)L@LbcSeeSchedSee My Schedule[Event Procedure]h1U`xa(bciBack Back to Main[Event Procedure]h1U`8abci PickRegisterRegister For Classes[Event Procedure]rytudents].[Student ID], [students].[First],ͬ\ΩP)Detaild Label0h SeeSchedh Backh PickRegisterDetai08=Babc,e gh|i|j"k@Е9vN@SectionsSectionK&[s Ariald2Blob m PropDataTV TypeInfo )DirDataSX    #$%&'()*+,-./0123456789:;<=>?@ABEFGHIJKLMNOPQRTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~e12f5g237hghMS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zijMS Sans Serif{5`FormHeader;(u_Label51m?Text52m@Text53fALine54fBLine55fCLine56DBalance DueEstudentIDFenrollments.sectionIDGspecial permissionHstop pointICatalog Courses.DeptJCatalog Courses.Course#KDescriptionmLText59dMLabel60FormFootermd Student_ID_LabelStudent ID Labelͬ ]ΩP)PageHeaderDetailPageFooterReportHeaderReportFooterGroupHeader0GroupFooter1mDeptdDept_LabelDept Labelm Course_Course#d Cour1\db@L@LBlob PropDataacCTypeInfoD0:<=Babc 0e ghgihj6kc$Z2۽@CountOfEnrollByCourse Query"Count Of Enroll By Dept and CourseArial8 0JhLexmark 3200 Series ColorFine` odXX  Lexmark 3200 Series ColorFineLPT1:LPT1: K&[ H/winspoolLexmark 3200 Series ColorFineLPT1:d278d eTimes New Romane24fg37jghm5CArialn=Arialo3AArialp4DeptCourse#` ReportHeaderd2`<a<bQcdLabel19"Count Of Enroll By Dept and Coursef2a<b$Line22` PageHeaderd`<a<b c, Dept LabelDept DetachedLabel Dept_Labeld`@ a<bHc, Course# LabelCourse# DetachedLabel Course__Labeld7`a<bc,CountOfstudentID LabelCountOfstudentID DetachedLabelCountOfstudentID_Labelf2b$Line23f2ab$Line24` GroupHeader0m 0<`<b cJi DeptDeptTimes New Roman`JDetailm`@ bHcCourse#Course#Course_m`bckCountOfstudentIDCountOfstudentID`8 GroupFooter1 m ` a<b$Text6݁="Summary for " & "'Dept' = " & " " & [Dept] & " (" & Count(*) & " " & IIf(Count(*) = 1, "detail record", "detail records") & ")"d` a,bcd Label7Sumd`X a,bcd Label8Avgd`Dabcd Label9Mind`X abcd Label10Maxd`Da,bcd Label11Percentm `abckSum Of CountOfstudentID=Sum([CountOfstudentID])Sum_Of_CountOfstudentIDm `8"a,b ckAvg Of CountOfstudentID=Avg([CountOfstudentID])Avg_Of_CountOfstudentIDm `PabckMin Of CountOfstudentID=Min([CountOfstudentID])Min_Of_CountOfstudentIDm `t"abckMax Of CountOfstudentID=Max([CountOfstudentID])Max_Of_CountOfstudentIDm `Pa,bckPercent Of CountOfstudentID==Sum([CountOfstudentID])/([CountOfstudentID Grand Total Sum])PercentPercent_Of_CountOfstudentID` PageFooterm ;<`<abc,i jText20=Now() Long DateTimes New Romanm ;<`abc,i jkText21$="Page " & [Page] & " of " & [Pages]Times New Roman`h ReportFooterm 5<`bc,i CountOfstudentID Grand Total Sum=Sum([CountOfstudentID])Times New Roman CountOfstudentID_Grand_Total_Sumd`<bGcd Label13 Grand Total08;804;708d5]`xa$ bcpickRoom_LabelpickRoom2NI8`0d Oo5U`bc(d fhn*"";"";"";"";"10";"30"nL/I "K:Combo18professorTable/QuerySELECT Professors.se__LabelCourse# Labelm CountOfstudentIDd CountOfstudentID_LabelCountOfstudentID Labelm Text6dLabel7dLabel8dLabel9dLabel10dLabel11mCountOfstudentID_Grand_Total_SumCountOfstudentID Grand Total SumdLabel13mSum_Of_CountOfstudentIDSum Of CountOfstudentIDmAvg_Of_CountOfstudentIDAvg Of CountOfstudentIDmMin_Of_CountOfstudentIDMin Of CountOfstudentIDmMax_K&[Of_CountOfstudentIDMax Of CountOfstudentIDmPercent_Of_CountOfstudentIDPercent Of CountOfstudentIDdLabel19mText20mText21fLine22fLine23fLine24belTitle DetachedLabel 0:<=Babc$e ghgihj6kc$'@ roster QueryrosterXArial8$JhLexmark 3200 Series ColorFine` odXX 2f@L@LBlob ScPropDataegTypeInfo> Lexmark 3200 Series ColorFineLPT1:LPT1: H/winspoolLexmark 3200 Series ColorFineLPT1:d278d eTimes New Romane24fg37jghm5CArialn=Arialo3AArialp4YearLastFirst` ReportHeaderd2`<a<bScdLabel14 Roster for:f2a<b$Line17o`bcpd,epf,"";"";"";"";"";"";"";"";"";"";"";"";"10";"5" sectionID sectionID Table/QueryߞSELECT DISTINCTROW [Sections].[sectionID], [Sections].[Dept], [Sections].[Course#], [Sections].[Section], [SectionsK&[].[Sem], [Sections].[Year] FROM [Sections];975;615;870;810;525;555` PageHeaderd`<a<b c, Year LabelYear DetachedLabel Year_Labeld` a<bc, Last LabelLast DetachedLabel Last_Labeld`La<bc, First LabelFirst DetachedLabel First_Labeld`8a<bc,Student ID Label Student ID DetachedLabelStudent_ID_Labeld`pa<bc, Middle LabelMiddle DetachedLabel Middle_Labeld`|a<bXc, Major LabelMajor DetachedLabel Major_Labelf2b$Line18f2ab$Line19` GroupHeader0m 0<`<b cJi YearYear&Student Academic Year (Fr, So, Jr, Sr)Times New Roman`JDetailm` bcLastLastStudent Last Namem`LbckFirstFirstStudent First Namem`8bck Student ID Student IDdStudent number - 4 digits - made text so leading zeroes dont go away - not doing math on them anyway Student_IDm`pbckMiddleMiddleStudent Middle Initialm`|bXckMajorMajor Student Major` PageFooterm ;<`<abc,i jText15=Now() Long DateTimes New Romanm ;<`abc,i jkText16$="Page " & [Page] & " of " & [Pages]Times New Roman` ReportFooterGPAGPAXStudent Current Gnt course grades - must be updated each seͬ\ΩP)PageHeaderDetailPageFooterReportHeaderReportFooterGroupHeader0mYeardYear_LabelYear LabelmLastd Last_LabelLast Labelm Firstd First_LabelFirst Labelo sectionIDmStudent_IDStudent IDdStudent_ID_LabelStudent ID LabelmMiddledMiddle_LabelMiddle LabelmMajordMajor_LabelMajor LabeldLabel14mText15mText16fLine17fLine18fLine190:<=Babc$e gG[@schedule QueryScheduleArial8 hLexmark 3200 Series ColorFine` odXX 3`pj@L@LBlob PropDataikTypeInfo: Lexmark 3200 Series ColorFineLPT1:LPT1: K&[ H/winspoolLexmark 3200 Series ColorFineLPT1:d278d eTimes New Romane24fg37jghm5CArialn=Arialo3AArialp4DeptCourse#` ReportHeaderd2`<a<b6cdLabel14Schedule` PageHeaderd`<a<b:c, Dept LabelDept DetachedLabel Dept_Labeld`a<bHc, Course# LabelCourse# DetachedLabel Course__Labeld`6a<b c, Title LabelTitle DetachedLabel Title_Labeld`xa<b c,sectionID Label sectionID DetachedLabelsectionID_Labeld`a<bc, time Labeltime DetachedLabel time_Labeld`a<bc, room Labelroom DetachedLabel room_Labeld`,a<bc,professor Label professor DetachedLabelprofessor_Labelf2`<ahb#Line17`Detailm`<a<b:cDeptDeptm`a<bHckCourse#Course#Course_m`6a<b ckTitleTitleo`bcxd<e fn "";"";"";"";"";"";"";"";"10";"4" sectionID sectionID Table/QueryySELECT DISTINCTROW [Sections].[sectionID], [Sections].[Dept], [Sections].[Course#], [Sections].[Section] FROM [Sections]; 0;615;870;810"SELECT DISTINCTROW [Sections].[sectionID], [Sections].[Dept], [Sections].[Course#], [Sections].[Section] FROM [Sections];";"Sections";"";"sectionID";"Dept";"PrimaryKey"m`a<bcktimetimem`a<bckroomroomm`,a<bck professor professor` PageFooterm ;<`<abc,i jText15=Now() Long DateTimes New Romanm ;<`abc,i jkText16$="Page " & [Page] & " of " & [Pages]Times New Romanf2`<ab$Line18` ReportFooterReportFooterGroupHeader0ͬ\ΩP)PageHeaderDetailPageFooterReportHeaderReportFootermDeptdDept_LabelDept LabelmCourse_Course#dCourse__LabelCourse# Labelm Titled Title_LabelTitle Labelo sectionIDd sectionID_LabelsectionID Labelm timedtime_Labeltime Labelmroomdroom_Labelroom Labelmprofessordprofessor_Labelprofessor LabeldLabel14mText15mText16fLine17fLine18rialS Sans Ser0:<=Babc 0e ͬ:=puLԴhKPageHeaderSectionDetailPageFooterSectionReportHeaderReportFooterGroupHeader0mStudent_IDStudent IDdStudent_ID_LabelStudent ID_LabelmFirstd First_Labelm Middled Middle_Labelm Lastd Last_Labelostudents_Yeardstude4n@L6LBlob L&PropDatamoTypeInfo08 :<=Babcwe g4d<$@fstudents and sections and courses join equiv to 1NF^K&[report leading to unnormalized students design3 Arial8 hLexmark 3200 Series ColorFine` odXX  Lexmark 3200 Series ColorFineLPT1:LPT1: H/winspoolLexmark 3200 Series ColorFineLPT1:d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4Student IDsectionID`ReportHeaderb_Ҟ^JRZ0d25`<a<bwcdLabel46^report leading to unnormalized students design3-kF+" 4f23a<bw Line49dDcx-A)̂^G`"PageHeaderSection\LܛLnd5`<a<bHc, Student ID_LabelStudent IDDetachedLabel Student_ID_LabelH~,/@R?!d5`a<bc,First_Label FirstDetachedLabeldHN-Ngzd5`a<bXc,Middle_Label MiddleDetachedLabelՄvCMo*02Vd5` a<bc,Last_LabelLastDetachedLabels TYGNjNd5` a<bpc,&students_Year_Labelstudents_YearDetachedLabel\LUdd5`a<b c,Major_Label MajorDetachedLabel楏6+E︁-d57`a<bc,0Num Credits Earned_LabelTotalCreditsDetachedLabel0Num_Credits_Earned_LabeldmͯMⰢd57`a<bpc,GPA_LabelGPADetachedLabel5nm2^68KAB>d5`p&a<bc,Hometown_LabelHometownDetachedLabel2ǯL4݆hd57`,a<bpc,"Balance Due_LabelBalance DueDetachedLabel"K&[Balance_Due_Label SfEӔ&d5`45a<b8c,sectionID_LabelSection IndexDetachedLabelPi)ˑK 7Cd5`9a<b8c,&Sections_Dept_LabelSections_DeptDetachedLabelJcTM~AWd5`>a<bdc,,Sections_Course#_Label Sections_Course#DetachedLabel,Sections_Course__Label4G(%d5`Ca<b c,Section_LabelSectionDetachedLabeldӅhJLjd5`Ga<b c,Sem_LabelSemDetachedLabel${jHZLSKd57`LJa<b8c,&Sections_Year_LabelSections_YearDetachedLabel$3@y|gd5`Na<bHc,time_LabeltimeDetachedLabelٓg<DцCdod5`DRa<bHc,room_LabelroomDetachedLabel^u\JQ[k6d5`Ua<bc,professor_LabelprofessorDetachedLabel2eE( 9d57`Ya<bc, stop point_LabelMax EnrollmentDetachedLabel stop_point_LabelK\vLmd5`^a<bc,Title_Label TitleDetachedLabel)%~C5~rƖd5`0fa<b c,"Description_LabelDescriptionDetachedLabelC=d57`@ta<buc,Credits_LabelCreditsDetachedLabeleB .L2j1if23bw Line50`a&L]iZwf23abw Line51˨DK27M=`GroupHeader06*ZVM m 7<`<bHcJeti Student IDStudent IDStudent number - 4 digits - made text so leading zeroes dont go away - not doing math on them anywayTimes New RomanStudent_ID)K#`gm 7<`bcJe*i k First First$Student First NameTimes New Roman1UA$5OL.m 7<`bXcJei k Middle Middle,Student Middle InitialTimes New Roman/RC m 7<` bcJei kLastLast"Student Last NameTimes New Roman0%=oA_zo 05:bc epfJh l n1=vgMZstudents_Yearstudents_YearValue List4"Fr";"So";"Jr";"Sr";"Grad"1440LStudent Academic Year (Fr, So, Jr, Sr)Times New Romanm 7<`b cJei k Major MajorStudent MajorTimes New Roman'tҳOXU Hm 07<`bcJei k$Num Credits Earned$Num Credits EarnedPStudent Number of Credits Earned to DateTimes New Roman$Num_Credits_Earned*|<@Mm 07<`bpcJevi kGPAGPA߰Student Current GPA (derived from student course grades - must be updated each semester)Times New Roman;DUCȂ$k,m 7<`p&bcJe i kHometownHometowntStudent Hometown (in reality would have whole address too)Times New Roman E\;v0Bm 7<`,bpcJeUi k Balance DueBalance Due*$#,##0.00;($#,##0.00)XAmount Student Currently owes the universityTK&[imes New RomanBalance_Due@_U ~EΦ`J Detail”#J  m`45b8cesectionIDsectionIDT"xN)#Rm`9b8cefkSections_DeptSections_Dept s D炳m`>bdcek Sections_Course# Sections_Course# Sections_Course_򀎆SMcl&lMpm`Cb cekSectionSection `r%A#=3m`Gb ceIkSemSemF S Su semester~NJ$OW)-m0`LJb8ce:kSections_YearSections_YearFyear offered - use 4 digit notationPIzF Q]؂m`NbHceVktimetime _Ctom`DRbHcekroomroomC=|Gm`Ubcekprofessorprofessor*BHs5m0`YbceIk stop pointstop pointstop_pointzNI7m`^bcek Title TitleLʯC,JJP+m`0fb ce k DescriptionDescriptionuíKNSm0`@tbuce*k CreditsCreditsYsOKVKu}`"PageFooterSectionERJܸm 7;<`<abc,i j Text47 =Now()Long DateTimes New RomankqbFm 7;<`dabc,i jk Text48H="Page " & [Page] & " of " & [Pages]Times New RomanKP hC2`ReportFooterR7)GAXtudent ID LabelmMiddledMiddle_LabelMiddle LabelmMajordMajor_LabelMajor LabeldLabel14mText15mText16fLine17fLine18fLine190:<=Babc$e gG[@schedule QueryScheduleArial8 hLexmark 3200 Series ColorFine` odXXnts_Year_LabelmMajordMajor_LabelmNum_Credits_EarnedNum Credits EarneddNum_Credits_Earned_LabelNum Credits Earned_LabelmGPAdGPA_LabelmHometowndHometown_LabelmBalance_DueBalance DuedBalance_Due_LabelBalance Due_LabelmsectionIDdsectionID_LabelmSections_DeptdSections_Dept_LabelmSections_Course_Sections_Course#dSections_Course__LabelSections_Course#_Labelm Sectiond!Section_Labelm"Semd#Sem_Labelm$Sections_Yeard%Sections_Year_Labelm&timed'time_Labelm(roomd)room_Labelm*professord+professor_Labelm,stop_pointstop pointd-stop_point_Labelstop point_Labelm.Titled/Title_Labelm0Descriptiond1Description_Labelm2Creditsd3Credits_Labeld4Label46m5Text47m6Text48f7Line49f8Line50f9Line51  ͬ>`oClƙReportHeaderdLabel50fLine53PageHeaderSectiondStudent_ID_LabelStudent ID_LabeldFirst_LabeldMiddle_LabeldLast_Labeldstudents_Year_Labeld Major_Labeld Num_Credits_Earned_LabelNum Credits Earned_Labeld GPA_Labeld Hometown_Labeld Balanc5ltr6L6LBlob (PropDataqsK&[vTypeInfoo    08 :<=Babcixe g8b$@fstudents and sections and courses join equiv to 1NF^report leading to unnormalized students design2 Arial8ixJhLexmark 3200 Series ColorFine` odXX  Lexmark 3200 Series ColorFineLPT1:LPT1: L/winspoolLexmark 3200 Series ColorFineLPT1:d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4Student IDsectionID`ReportHeader<}>pKJd2`<a<bwcdLabel50^report leading to unnormalized students design2YRm]BN}\f2a<bix Line538Av`D`"PageHeaderSectionPH0cN7d`<a<b c, Student ID_LabelStudent IDDetachedLabel Student_ID_LabelU@;H#v!d`a<bHc,First_Label FirstDetachedLabeln,oKA9G/d`a<bc,Middle_Label MiddleDetachedLabel"A- vd K&[`` a<bHc,Last_LabelLastDetachedLabelr(%IW]m1Yd` a<bc,&students_Year_Labelstudents_YearDetachedLabel[f"%LUZd`a<bc,Major_Label MajorDetachedLabelGCd,? d7`pa<bc,0Num Credits Earned_LabelTotalCreditsDetachedLabel0Num_Credits_Earned_Label)y(O4#8d7`0a<bc,GPA_LabelGPADetachedLabelm`B6J`D>ޙd`"a<b(c,Hometown_LabelHometownDetachedLabelϵUEzˉ}d7`P(a<bc,"Balance Due_LabelBalance DueDetachedLabel"Balance_Due_Label89AGRQd` 0a<bc,sectionID_LabelSection IndexDetachedLabel]0AiT!d`4a<bc,&Sections_Dept_LabelSections_DeptDetachedLabelLJI3Ld`8a<bc,,Sections_Course#_Label Sections_Course#DetachedLabel,Sections_Course__Labels]Ay QB]''4m` 0bcsectionIDsectionID Cgrjpm`4bckSections_DeptSections_Dept|P>qKqwm`8bck Sections_Course# Sections_Course# Sections_Course_jn.^G^%m`8>8o@8@8o@@@@oB8B8oD6D6oD8D8o & @ @ @ @ ()*+,-./0 1 2 3 4 56789:;<=>?@ABCDEFG H!I"J#K$LYYIdParentIdName        { }YGrad"NRR Y  Y  Y  Y Prog ClassPreProgPreClasspoCRTtsRvRwYYY8Catalog CoursesPrerequisites:Catalog CoursesPrerequisites1PrimaryKeyv1@ QnK(yT1@ @ @ @ @ @ @ @ @           !"#$%&' (!)"*#+$,%&'()*+,-. / 0 1 2 3456789:;<=>?@AB& MTH222MTH221 MTH221MTH120 MGMT303MGMT302 ENG108ENG107 CSC481CSC480 CSC464CSC354 CSC354CSC162 CSC265CSC264 CSC264CSC157 CSC162CSC157 CHEM302CHEM301 CHEM202CHEM201 CHEM112CHEM111 BIO162BIO161  Q@@@@LYd8B:LYd8B8SMWQ`88:MWQ`888SMWQ`:6:MWQ`:68SMWQ`<6:MWQ`<68SMkM8B:MkM8@DSMkM:B>MkM8@DSMkM:B@MkM:B>SMkM<@>MkM8B:SMkM>B>MkM<@>SMkM>F8MkM>F6S QbU86FQbU86DS `U`m<6<`U`m<6:S `mW::8`mW8:6S `mW:::`mW::8S YYIdParentIdName        s Y@Grad"NVV@@@@@ Y  Y  Y  Y  Y   Y  NameDeptPosition office phone email VX YVYiotoscVZSYaYYY.rDDeptNamePrimaryKeyv1,U@BT d ( p / w ?  J O  Vi+k.zAH S^#r2  @YoungCSCAdj AsstO 2342314jyoung-% ?WileyCSCAssocO 1331234wiley)" ?VenkatesanCSAsstbs3206122venkates/%?TurkCSAsstO 2301098jturk& ?TavanaMGMTAssocC 3144519tavana,$ ?SzabatMKTGAssocC 2318923szabat,$ ?SudeENGAdj AsstO 1088765sude*$ ?StullSOCAssocO 2359567jstull*" ?StevensCSInstructorbs3246439elsteven2(" ?SovenENGProfO 1252987soven(! ?Smith AMMISAsstC 2314592amsmith-$ ?SheehyHISAssocO 2122910broed*# ?ShalhoubCHEMAssocH 2135637shalhoub0&  ?RobisonECNAssocO 2289345robison-$ ?RhodaMGMTAssocC 2132314rhoda*# ?ReichardtCSCAdj AsstO 2342314reichard3)# ?RedmondCSCAssocO 3301096redmond-$ ?RatkusRELAssocW 1242345ratkus+# ?PaulinECNAsstO 1093245paulin*" ?PalisCSAssocbs3236077palis(! ?NguyenSOCAssocO 3126678nguyen+# ?MshombaECNProfO 2198538mshomba,# ?MoreauPHLProfW 1249238moreau*" ?MillardENGProfO 1231234millard,# ?MichalekMTHAssocO 3399192michalek/% ?MeadCSInstructorbs1256102mead+% ?McConnellMTHAdj AsstO 1316565mcconnel3)# ?McCartyMTHAssocO 1389128mccarty-$ ?Mc ManusCSCProfA 3171000mcmanus-$ ?Mc CoeyCSCAsstO 1361919mccoey+# ?MaCSVis Assocbs3196439evama)" ?LongoCSCProfH 1291010longo(! ?LeisterCSDAsstO 1368745leister,# ?LeibigerHISAsstO 3323214leibiger.$ ?LeaubyMGMTAssocC 2223452leauby,$ ?KolasaCSInstructorbs1206052kolasa/'! ?KnappenbergerMTHAsstO 1351095knappenb3)#?KirschCSCAssocO 2374321kirsch+# ?Kelly GRELAssocW 1232312gkelly,$ ?Jones NCHEMAssocH 3136728njones-% ?Jones DMKTGAsstC 2217612jones+$ ?JoglekarMGMTAssocC 2179767praf,&  ?GrantCSInstructorbs3246439kgrant.&  ?FalconePSYAssocH1088765falcone,# ?FairHISAssocO 2162911fair'! ?ElliottCSCAsstO 1261130elliott,# ?DiDioMTHAssocO 2348745didio)" ?DesnoyersHISAssocO 2142912desnoyer0&  ?DasguptaCSVis Asstbs3216439bhaskar0'! ?CollinsPSYAssocH 1047623collins-$ ?CamomileCSDAsstO 1342134camomill.$ ?ButlerENGProfO 1293245butler*" ?Burke JPSYProfH 1051245jburke+# ?BurkeCHEMProf Isc3256032burke+$ ?BruceMGMTProfC 2139099gbruce*" ?BroganPOLAsstO 1145637brogan*" ?BrazinaACCTProfC 2129191brazina-$ ?BlumCSCAsstO 3381111blum&  ?BillaCSVis Asstbs3216439billa+$ ?BeattyENGAsstO 1239192beatty*" ?BalloughBIOAssocH 2012122ballough/% ?BalchunisPOLAsstO 1129384balch,% ?ArmstrongPSYAssocH 1061212armstron0&  ?AndrilliMTHAssocO 1379101andrilli/% ? U @ @@@@@@@@    JMMmWLYdWMWQ`W MWQ`WMWQ`W3MkWMkWMkWMkWMkW!MkW&MkW,MkW7MkW<MkW=MkMWMkMWMkMWMkMW MkMW"MkMW#MkMW/MkMW0MkMW>MkMW?MkOW MkOWQMbW*QMbW-QMbW2QbUWQbUW QbUW(QbUW6QbUW9WYkWWYkWWYkWWYkW4`U`mW `U`mW`U`mW`U`mW1`U`mW;`YkW5`\mUW`\mUW:`mWW`mWW`mWW`mWW$`mWW%`mWW'fW^W)fd^Wfd^WfkvWfkvW fkvWfkvWiQ^WiQ^W.kdMW+kdMW8 U@   @@ @@@ @ @JbOiY^^YWJi`kmidbUWLJ^MWobYkWLJ^^doUWWLQJmmvWLY^^JWL^o`WLiJxYbJWLidUJbWLioMQW Loi\QW Loi\Q[W Lom^QiW MJ`d`Y^QW Md^^YbkWOJkUofmJWOQkbdvQikWOYOYdWQ^^YdmmWSJYiWSJ^MdbQWUiJbmW[dU^Q\JiW[dbQkOW[dbQkbW\Q^^vUW\YikMWW\bJffQbLQiUQiW\d^JkJW^QJoLvW^QYLYUQiW^QYkmQiW^dbUdW `JW!`MMdQvW"`M`JbokW#`MMJimvW$`MMdbbQ^^W%`QJOW&`YMWJ^Q\W'`Y^^JiOW(`diQJoW)`kWd`LJW*bUovQbW+fJ^YkW,fJo^YbW-iJm\okW.iQO`dbOW/iQYMWJiOmW0iWdOJW1idLYkdbW2kWJ^WdoLW3kWQQWvW4k`YmWJ`W5kdqQbW6kmQqQbkW7kmo^^W8koOQW9kxJLJmW:mJqJbJW;moi\W<qQb\JmQkJbW=sY^QvW>vdobUW? U@   @@ @@@ @ @JbOiY^^YWJi`kmidbUWLJ^MWobYkWLJ^^doUWWLQJmmvWLY^^JWL^o`WLiJxYbJWLidUJbWLioMQW Loi\QW Loi\Q[W Lom^QiW MJ`d`Y^QW Md^^YbkWOJkUofmJWOQkbdvQikWOYOYdWQ^^YdmmWSJYiWSJ^MdbQWUiJbmW[dU^Q\JiW[dbQkOW[dbQkbW\Q^^vUW\YikMWW\bJffQbLQiUQiW\d^JkJW^QJoLvW^QYLYUQiW^QYkmQiW^dbUdW `JW!`MMdQvW"`M`JbokW#`MMJimvW$`MMdbbQ^^W%`QJOW&`YMWJ^Q\W'`Y^^JiOW(`diQJoW)`kWd`LJW*bUovQbW+fJ^YkW,fJo^YbW-iJm\okW.iQO`dbOW/iQYMWJiOmW0iWdOJW1idLYkdbW2kWJ^WdoLW3kWQQWvW4k`YmWJ`W5kdqQbW6kmQqQbkW7kmo^^W8koOQW9kxJLJmW:mJqJbJW;moi\W<qQb\JmQkJbW=sY^QvW>vdobUW?V Y<Grad"N\\<<<< Y Y Y Y Y Y Y roomsizeFront ComputerData ConnectionData ProjectorOverhead2Numb Student Workstationsosc\^Semrmr\_orYaYY.rCPrimaryKeyroomv1@  [<pX@(hP8  x ` H 0  p X @ (  h P 8  x `   @@    @@ JO`YbmJk\kMJmJ^dUMdoikQkOQJbkmJk\kQbid^^`QbmkkoLSdi`Qbid^^`QbmkkoLSdi`8Qbid^^`QbmkkoLSdi`:QbmQibQsMdoikQ SJMo^mvmJk\k`JYbidd`kkQMmYdbkkmoOQbmkkmoOQbmk8kmoOQbmksQbid^^kmoOQbmmJk\kJ^^Qbid^^`Qbmk MdobmdSQbid^^LvOQfmJbOMdoikQ!iQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb:"iQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb<#idkmQiu$kMWQOo^Q%JomdQuQM&LJM\md`JYb'MdoikQk(SYbOkmO)JO`Yb*OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MQbid^^`QbmkkoLSdi`+kh+MMd`LdB++kh+MQbid^^`QbmkkoLSdi`8+kh+MkQMmYdbYO,+kh+MQbid^^`QbmkkoLSdi`:+kh+MkQMmYdbYO+kh+MkQMmYdbk+kh+MMd`Ld8B+kh+MkQMmYdbk+kh+MMd`Ld8F+kh+MkmoOQbmk+kh+MQbid^^`QbmkkoLSdi`8+kh+MkmoOQbmk+kh+MSYbOJkmoO+kh+MkmoOQbmk+kh+MSYbOkmoO+kh+MkmoOQbmk8+kh+MQbid^^`QbmkkoLSdi`:+kh+MkmoOQbmk8+kh+MSYbOkmoO+kh+MkmoOQbmksQbid^^+kh+MQbid^^`QbmkkoLSdi`+kh+OidkmQiu+kh+OkQMmYdbYO +kh+OkMWQOo^Q+kh+OkQMmYdbYO +kh+SMJmJ^dUMdoikQk +kh+SQbid^^`QbmkkoLSdi` +kh+SQbid^^`QbmkkoLSdi`8 +kh+SQbid^^`QbmkkoLSdi`:+kh+SQbmQibQsMdoikQ +kh+Sidd`k+kh+SkQMmYdbk+kh+SkmoOQbmk+kh+SkmoOQbmk8+kh+SkmoOQbmksQbid^^MJmJ^dUMdoikQkMdobmdSQbid^^LvMdoikQhoQivQbid^^`QbmkQbid^^`QbmkhoQivQbid^^`QbmkhoQiv8[dYbkmoOQbmkQbid^^QOkQMmYdbkM^JkkQk[dYbmQbid^^`QbmkhoQiv:[ob\MiQJmQkd`QkQMmYdbkJ[ob\MiQJmQkd`QkQMmYdbkmQkm[ob\Qbid^^`Qbmkbdm:66:hoQ#O 329 CO 327 CO 325 CO 323 CO 321 CO 319 CO 317 C#O 315 CO 313 CO 311 C#O 309 CO 307 CO 305 CO 303 CO 301 CO 229 CO 227 CO 225 CO 223 CO 221 CO 219 CO 217 CO 215 C#O 213 CO 211 KO 209 K#O 207 C#O 205 C#O 203 CO 201 O 200 O 129 O 127 O 123 CO 121 CO 119 KO 117 CO 115 KO 113 KO 111 CO 109 KO 107 CdO 100 H 103 CH 102 CH 101 (fa229 C#fa221 C#fa219 CC 206 C 205 2C 204 C 203 C 202 C 201 2bs134 cbs117 2bs115 o(at205 C(at123 P [Jm8:<]Jm:6@]Lk88@]Lk88D]Lk8<>]M:68]M:6:]M:6<]M:6>]M:6@] M:6B] SJ:8H] SJ::8] SJ::H] W868]W86:]W86<]d866]d86D]d86H]d888]d88<]d88@]d88D]d88H]d8:8]d8:<]d8:D]d8:H]d:66]d:68]d:6<]d:6@] d:6D]!d:6H]"d:88]#d:8<]$d:8@]%d:8D]&d:8H]'d::8](d::<])d::@]*d::D]+d::H],d<68]-d<6<].d<6@]/d<6D]0d<6H]1d<88]2d<8<]3d<8@]4d<8D]5d<8H]6d<:8]7d<:<]8d<:@]9d<:D]:d<:H];P [Jm8:<]Jm:6@]Lk88@]Lk88D]Lk8<>]M:68]M:6:]M:6<]M:6>]M:6@] M:6B] SJ:8H] SJ::8] SJ::H] W868]W86:]W86<]d866]d86D]d86H]d888]d88<]d88@]d88D]d88H]d8:8]d8:<]d8:D]d8:H]d:66]d:68]d:6<]d:6@] d:6D]!d:6H]"d:88]#d:8<]$d:8@]%d:8D]&d:8H]'d::8](d::<])d::@]*d::D]+d::H],d<68]-d<6<].d<6@]/d<6D]0d<6H]1d<88]2d<8<]3d<8@]4d<8D]5d<8H]6d<:8]7d<:<]8d<:@]9d<:D]:d<:H]; 2}"e aM  < V 5 sLJI~O pl @AEXN@0fN@AEXN@0fN@junk enrollments not 2002 Query2@@xll```````^ @<_O[@_O[@enrollments Query12Z@|RRRFFFFFFFD @8k;@k;@~sq_fstudents124MR2KeepLocal T~~~>>>>>>>< @6wtvN@wtvN@~sq_fSections24MR2KeepLocal T|||<<<<<<<: @4@@~sq_fEnter New Course:24MR2KeepLocal TNNNNNNNL @1 A@ A@~sq_fenrollments Subform24MR2KeepLocal TRRRRRRRP @.@@~sq_drosterX~sq_dsectionID24MR2KeepLocal TVVVVVVVT @+~.vN@~.vN@~sq_cstudents1~sq_cenrollments Subform224MR2KeepLocal Tpppppppn @(z@z@~sq_cstudents~sq_cenrollments Subform124MR2KeepLocal Tnnnnnnnl @&tvN@8tvN@~sq_cSections~sq_cCombo1624MR2KeepLocal TTTTTTTTR @$gg @gg @~sq_cenrollments Subform1~sq_cSectionID24MR2KeepLocal Tpppppppn @" 8@rݛN@Admin2 @~8,,,,,,,,,* ݿ@T@MSysDb2@|:::......., @^@^@DataAccessPages2@@@@@@@@@@> R19R@19R@studentsenrollments2HHHHHHHHHHF Q' QN@' QN@Sectionsenrollments2HHHHHHHHHHF PMx@Mx@RoomsSections2<<<<<<<<<<: OX@X@ProfessorsSections2FFFFFFFFFFD N6ڽ@6ڽ@Catalog CoursesSections2PPPPPPPPPPN MQlĵ@Qlĵ@Catalog CoursesPrerequisites12\\\\\\\\\\Z Lb@b@Catalog CoursesPrerequisites2ZZZZZZZZZZX K4q[@4q[@students Query32Z@ LLL@@@@@@@> @JFqo[@ǻro[@students Query22Z@ LLL@@@@@@@> @I MK[@ MK[@students Query12Z@ LLL@@@@@@@> @HC[@{9C[@students Query Query2Z@VVVJJJJJJJH @FB'\$@N$@students and sections and courses join equiv to 1NF2@@ @m`@zNtN@students2 @>>>22222220 @E9u$@I$@Sections and courses join Query - equiv to 2NF2@@@~ @aI '@N@Sections2@>>>22222220 @D@.PA@schedule Query2@@VJJ>>>>>>>< @ jYGrad"N  bb@; Y  Y  Y  Y  Y oY  Y t Y  Y tY  Y  sectionIDDeptCourse#SectionSemYeartimeroomprofessorstop pointjunkYbgCraKbhomyybi}]  bj}]  bk}]  bxbyYYYYYYUYY[YY.rI.Catalog CoursesSectionsDeptPrimaryKey$ProfessorsSectionsroomRoomsSectionssectionIDtimeC*pln@ 'C*plstudentsenrollmentsZ@C7! C*plstudents.Major- gC*plstudents.Year, gC*plstudents.Last, gC*plstudents.Middle. gC*plstudents.First- gC*plstudents.[Student ID]4 gC*plenrollments.sectionID4 gC*plenrollments''' C*plstudents!!! C*pl GC*pl GC*pl C*plstudents.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept(((enrollments.sectionID)=[Enter Course Index Number]))students.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID((([Catalog Courses].Dept)="BIO") AND ((Professors.Dept)="BIO"))((([Catalog Courses].Dept)="BUS") AND ((Professors.Dept)="MKTG"))[Sections].[sectionID] =[enrollments].[sectionID][students].[Student ID] =[enrollments].[studentID][Catalog Courses].[Course#] =[Sections].[Course#][Catalog Courses].[Dept] =[Sections].[Dept][enrollments].[special permission](((Sections.Sem)="S") AND ((Sections.Year)=1997))Sections.sectionID = enrollments.sectionID[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept(((Professors.Dept)=[Forms]![Sections]![Dept]))[Rooms].[Numb Student Workstations](((DCN@оN@schedule Query<<<<<<<<<<< s v1b ' ] $ r T 6  I y ;  P  gI+ L ]$pR4`,`oo @ @ @ @ D*plstudentsenrollmentsZ@C7! D*plSectionsenrollmentsT@C7! D*plCatalog CoursesSections`@K?/ D*plCatalog CoursesSectionsL@K?/ D*plSections.professor1 gD*plSections.room, gD*plSections.time, gD*plenrollments.sectionID4 gD*pl[Catalog Courses].Title6 gD*pl[Catalog Courses].[Course#]: gD*pl[Catalog Courses].Dept5 gD*plenrollments''' D*plstudents!!! D*plSections!!! D*plCatalog Courses/// D*pl GD*pl GD*pl D*pl GC*pln@ 'C*plstudentsenrollmentsZ@C7! C*plstudents.Major- gC*plstudents.Year, gC*plstudents.Last, gC*plstudents.Middle. gC*plstudents.First- gC*plstudents.[Student ID]4 gC*plenrollments.sectionID4 gC*plenrollments''' C*plstudents!!! C*pl GC*pl GC*pl C*pl GB U Sections.professor1 gB USections.room, gB USections.time, gB USections.Year, gB USections.Sem+ gB USections.Section/ gB USections.[Course#]1 gB USections.Dept, gB USections.sectionID1 gBUMax Of stop pointMax(Sections.[stop point])[33 oBUMin Of stop pointMin(Sections.[stop point])[33 oBUAvg Of stop pointAvg(Sections.[stop point])[33 oBUSections.Dept, gBUSections!!! BU GBU GBU BU GAU(((Sections.Year)<2002))7 'AUSectionsenrollmentsT@C7! AUSections.Year, gAUenrollments.grade0@x a2[ n 3 J T  i   1 AV p$3@P\ n}@ _80418MGMT35401FTR9C 206Joglekar:0)$"  ]80417MGMT30202FMWF10C 203Joglekar<2+$"  \80416MGMT35302FMWF11C 202Bruce92+$"  [80415MGMT35301FMWF9C 203Bruce81*$"  Y80414MGMT30201FMWF2C 202Bruce81*$"  W80413CHEM30102FMWF12O 123Shalhoub<2+$"  U80412CHEM20102FMWF11O 325Shalhoub<2+$"  S80411CHEM15002FTR2O 113Shalhoub:0)$"  R80410CHEM11102FMWF10O 217Shalhoub<2+$"  P80409CHEM30101FMWF11O 113Jones N;2+$"  N80408CHEM20101FMWF9O 325Jones N:1*$"  L80407CHEM15001FTR9O 113Jones N90)$"  K80406CHEM11101FMWF10O 113Jones N;2+$"  B80405BIO21001FMWF12O 123Ballough;1*#!  ?80404BIO16101FMWF11O 113Ballough;1*#!  >80403BIO18001FMWF9O 325Ballough:0)#!  +80402BIO15701FMWF10O 217Ballough;1*#!  !80371CSC48001FMW3:30O 201Kirsch:2+#!   80361CSC37201FMW2O 200Wiley6/(#!  80351CSC36201FMWF11O 109Kirsch91*#!  80341CSC35401FMWF11O 113Turk71*#!  80331CSC35201FT6O 200Turk4.'#!  80323CSC26403FR6O 201Reichardt9.'#!  80322CSC26402FMWF10O 215Redmond:1*#!  80321CSC26401FMWF9O 109Blum60)#!  80311CSC16201FMWF12R2O 217Turk93,#!  80301CSC15701FMWF11R11O 219Elliott=4-#!  80202CSC15201FMWF12H 101DiDio81*#!  80201CSC15201FMWF11H 101DiDio81*#!  80105CSC15105FMWF12O 200Young81*#!  80104CSC15104FMWF11O 200Young81*#!  80103CSC15103FMWF10O 200Young81*#!  80102CSC15102FMWF9O 127Wiley70)#!  80101CSC15101FMWF8O 200Wiley70)#!  70238CSIT46140Smw420bs115Redmond;2+$"  #70234CSIT13640Stt740at123Kolasa:2+$"  #70232CSIT13601Stt1230at205Venkatesan?3,$"  # 69705CSIT36501Smw120fa229Redmond;2+$"   67488CSIT44740Smw610fa221Ma62+$"  # 66422CSC26540Smw610fa229Kolasa91*#!  # 66419CSC15240Stt610at123Billa81*#!  # 66418CSC15141Smw730bs117Grant81*#!  #66417CSC15140Smw610at123Mead71*#!  #66416CSC15102Stt200bs134Stevens:1*#!  #66415CSC15101Smw120bs134Stevens:1*#!  c62341CHEM11101Smw900at123Burke92+$"  62272CSC15101Fmw610bs117Grant81*#!  11121CSC16201FMWF 1230O 107Turk:4-#!  11112CSC15702FMWF 1130O 107Redmond=4-#!  11111CSC15701FMWF 930O 111Redmond<3,#!  a2] o! 3 B S  d  x + ?Ocx)<Qk *~ 80468MTH22101FMWF12O 107Knappenberger@1*#!  80467MTH12002FMWF11O 107Knappenberger@1*#!  80466MTH12001FMWF10O 107Knappenberger@1*#!  80465MTH11701FMWF9O 107Knappenberger?0)#!  80464ENG10708FTR9O 113Sude5/(#!  80463ENG10707FTR2O 113Sude5/(#!  80462ENG10706FMWF9O 113Sude60)#!  80461ENG20303FMWF12O 217Soven81*#!  80460ENG20302FTR2O 113Soven6/(#!  80459ENG10705FMWF9O 217Soven70)#!  80458ENG10704FMWF10O 113Soven81*#!  80457ENG15005FMWF12O 113Millard:1*#!  80456ENG15004FMWF11O 123Millard:1*#!  80455ENG10802FMWF9O 217Millard90)#!  80454ENG10703FTR9O 217Millard8/(#!  80453ENG15003FMWF10O 113Butler91*#!  80452ENG15002FMWF9O 325Butler80)#!  80451ENG10702FMWF2O 325Butler80)#!  80450ENG20301FMWF11O 113Beatty91*#!  80449ENG15001FMWF12O 123Beatty91*#!  80448ENG10801FMWF9O 217Beatty80)#!  80447ENG10701FMWF10O 217Beatty91*#!  80446ECN20102FMWF9O 113Robison90)#!  80445ECN20101FTR3:30O 113Robison;2+#!  ~80444ECN15502FMWF11O 325Robison:1*#!  }80443ECN15501FMWF10O 217Robison:1*#!  |80442ECN21304FMWF9O 113Paulin80)#!  {80441ECN21303FMWF2O 113Paulin80)#!  z80440ECN21302FTR2O 113Paulin7/(#!  y80439ECN15004FMWF11O 113Paulin91*#!  x80438ECN21301FMWF9O 217Mshomba90)#!  w80437ECN15003FTR2O 325Mshomba8/(#!  v80436ECN15002FMWF10O 325Mshomba:1*#!  u80435ECN15001FMWF11O 113Mshomba:1*#!  t80434MKTG30401FMWF9C 203Szabat91*$"  s80433MKTG30104FMWF10C 202Szabat:2+$"  q80432MKTG30103FTR9C 206Szabat80)$"  p80431MKTG30501FMWF10C 203Jones D;2+$"  o80430MKTG30102FMWF9C 202Jones D:1*$"  m80429MKTG30101FMWF12C 206Jones D;2+$"  l80428MGMT30209FMWF10C 203Tavana:2+$"  k80427MGMT30208FMWF11C 202Tavana:2+$"  i80426MGMT30207FMWF9C 202Tavana91*$"  h80425MGMT35403FMWF10C 203Rhoda92+$"  g80424MGMT35303FMWF2C 203Rhoda81*$"  e80423MGMT30206FMWF12C 203Rhoda92+$"  d80422MGMT30205FMWF9C 202Leauby91*$"  c80421MGMT30204FMWF11C 206Leauby:2+$"  a80420MGMT30203FMWF10C 203Leauby:2+$"  `80419MGMT35402FTR3:30C 202Joglekar=3,$" a2_o! 4 @ M `  s $ 4G^r&@M\ hz 80518BUS10102FMWF11O 113Brazina:1*#!  80517BUS10101FMWF9C 203Brazina90)#!  80516POL15102FMWF11O 113Brogan91*#!  80515POL15101FMWF12O 325Balchunis<1*#!  80514HIS32402FMWF10O 113Leibiger;1*#!  80513HIS25104FMWF11O 113Leibiger;1*#!  80512HIS15106FMWF9O 113Leibiger:0)#!  80511HIS15105FTR9O 113Leibiger9/(#!  80510HIS32401FMWF12O 217Desnoyers<1*#!  80509HIS25103FMWF10O 113Desnoyers<1*#!  80508HIS25102FMWF9O 113Desnoyers;0)#!  80507HIS25101FTR2O 113Desnoyers:/(#!  80506HIS33301FMWF11O 123Fair71*#!  80505HIS32901FMWF10O 217Fair71*#!  80504HIS15104FMWF9O 325Fair60)#!  80503HIS15103FMWF2O 113Fair60)#!  80502HIS30502FMWF10O 113Sheehy91*#!  80501HIS30501FMWF11O 113Sheehy91*#!  80500HIS15102FMWF9O 325Sheehy80)#!  80499HIS15101FTR9O 113Sheehy7/(#!  80498SOC15002FMWF10O 113Stull81*#!  80497SOC15001FMWF9O 217Nguyen80)#!  80496REL15302FMWF12O 113Ratkus91*#!  80495REL15002FMWF10O 113Ratkus91*#!  80494REL15301FMWF9O 113Kelly G90)#!  80493REL15001FMWF11O 113Kelly G:1*#!  80492PSY15502FMWF10O 325Falcone:1*#!  80491PSY15503FMWF12O 113Collins:1*#!  80490PSY15501FMWF9O 217Burke J90)#!  80489PSY15501FMWF10O 113Armstrong<1*#!  80488PHL15201FMWF9O 113Moreau80)#!  80487PHL15101FTR2O 217Moreau7/(#!  80486MTH22201FMWF10O 113McCarty:1*#!  80485MTH14003FMWF9O 113McCarty90)#!  80484MTH11307FTR9O 113McCarty8/(#!  80483MTH24002FMWF12O 111Michalek;1*#!  80482MTH14002FMWF11O 111Michalek;1*#!  80481MTH12006FMWF10O 217Michalek;1*#!  80480MTH11306FMWF9O 113Michalek:0)#!  80479MTH11305FMWF11O 123McConnell<1*#!  80478MTH11304FMWF10O 111McConnell<1*#!  80477MTH11303FMWF9O 111McConnell;0)#!  80476MTH11302FTR9O 111McConnell:/(#!  80475MTH22102FTR9O 113DiDio6/(#!  80474MTH14001FMWF11O 123DiDio81*#!  80473MTH12005FMWF9O 217DiDio70)#!  80472MTH24001FTR3:30O 109Andrilli<2+#!  80471MTH12004FMWF11O 109Andrilli;1*#!  80470MTH12003FMWF10O 109Andrilli;1*#!  80469MTH11301FMWF9O 109Andrilli:0)#!  abu# 1 J *82111CSD34001FM6O 129Camomile8.'#!  )82102CSD21002FMW3:30O 129Leister;2+#!  (82101CSD21001FMWF9O 129Leister90)#!  '81212CSIT37102FM6H 102Longo6/($"  &81211CSIT37101FT2H 102Longo6/($"  %81201CSIT36201FMWF12O 107Kirsch:2+$"  $81103CSIT13603FMW2O 127Reichardt;0)$"  #81102CSIT13602FTR2O 127Reichardt;0)$"  "81101CSIT13601FTR11O 127Reichardt<1*$"  80523BUS20003FMWF10C 203Brazina:1*#!  80522BUS20002FMWF11O 113Szabat91*#!  80521BUS15002FMWF9C 203Szabat80)#!  80520BUS15001FMWF12O 113Szabat91*#!  80519BUS20001FMWF9C 203Jones D90)#! a@@@ @        @ @@@@@@@@@@@@ @ @ @         LYdc!LYdc"LYdc#LYdc$Loke0Loke1LokfLokfLokfLokfLokfMWQ`cMWQ`c%MWQ`c&MWQ`c'MWQ`c(MWQ`c)MWQ`c*MWQ`c+MWQ`c,MkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMc MkMc MkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMc MkOf MkOf MkOf MkYmc MkYmc MkYmc MkYmcMkYmcMkYmfMkYmfMkYmfMkYmfMkYmf MkYmf QMbdQMbdQMbdQMbdQMbdQMbdQMbdQMbdQMbdQMbdQMbdQMbdQbUdQbUdQbUdQbUdQbUd QbUd!QbUd"QbUd#QbUd$QbUd%QbUd&QbUd'QbUd(QbUd)QbUd*QbUd+QbUd,QbUd-WYkeWYkeWYke WYke!WYke"WYke#WYke$WYke%WYke&WYke'WYke(WYke)WYke*WYke+WYke,WYke-`U`mc-`U`mc.`U`mc/`U`mc0`U`mc1`U`md`U`md`U`md`U`md`U`md`U`md`U`md`U`md`U`md`U`md `\mUd `\mUd `\mUd `\mUd `\mUd`\mUd`mWd.`mWd/`mWd0`mWd1`mWe`mWe`mWe`mWe`mWe`mWe`mWe`mWe`mWe`mWe `mWe `mWe `mWe `mWe `mWe`mWe`mWe`mWefW^efW^efd^e.fd^e/fkvefkvefkvefkveiQ^eiQ^eiQ^eiQ^ekdMekdMepa88888c8888:c888:8cB::D:cB:<>8cBB>8@cBB>8BcBB>8DcBB>8FcBB>8Hc BB>::c BD>FFc BHD6@c D6:<:c D6:<>cD6:cF686@cF6:68cF6:6:cF6<68cF6<88cF6<:8cF6<::cF6<:<cF6<<8cF6<>8cF6<@8cF66:c!F6>6<c"F6>6>c#F6>6@c$F6>6Bc%F6>6Dc&F6>6Fc'F6>6Hc(F6>86c)F6>88c*F6>8:c+F6>8<c,F6>8>c-F6>8@c.F6>8Bc/F6>8Dc0F6>8Fc1F6>8HdF6>:6dF6>:8dF6>::dF6>:<dF6>:>dF6>:@dF6>:BdF6>:DdF6>:Fd F6>:Hd F6><6d F6><8d F6><:d F6><<dF6><>dF6><@dF6>>6dF6>>8dF6>>:dF6>><dF6>>>dF6>>@dF6>>BdF6>>DdF6>>FdF6>>HdF6>@6dF6>@8d F6>@:d!F6>@<d"F6>@>d#F6>@@d$F6>@Bd%F6>@Dd&F6>@Fd'F6>@Hd(F6>B6d)F6>B8d*F6>B:d+F6>B<d,F6>B>d-F6>B@d.F6>BBd/F6>BDd0F6>BFd1F6>BHeF6>D6eF6>D8eF6>D:eF6>D<eF6>D>eF6>D@eF6>DBeF6>DDeF6>DFe F6>DHe F6>F6e F6>F8e F6>F:e F6>F<eF6>F>eF6>F@eF6>FBeF6>FDeF6>FFeF6>FHeF6>H6eF6>H8eF6>H:eF6>H<eF6>H>eF6>H@eF6>HBeF6>HDeF6>HFeF6>HHeF6@66eF6@68e F6@6:e!F6@6<e"F6@6>e#F6@6@e$F6@6Be%F6@6De&F6@6Fe'F6@6He(F6@86e)F6@88e*F6@8:e+F6@8<e,F6@8>e-F6@8@e.F6@8Be/F6@8De0F6@8Fe1F6@8HfF6@:6fF6@:8fF6@::fF6@:<fF8868fF886:fF886<fF8:68fF8:88f F8:8:f F:868f F:86:f F:888f paJm8:<cJm8:<cJm8:<c Jm8:<cJm:6@c Lk88@cLk88DcLk88DcLk8<>cLk8<>cM:6:c-M:6:c/M:6:dM:6:dM:6:dM:6:dM:6:d M:6:dM:6<c.M:6<c0M:6<dM:6<dM:6<dM:6<dM:6<d M:6<d M:6<dM:6<e0M:6<fM:6<fM:6<fM:6Bc1M:6BdM:6Bd M:6Bd SJ::8c SJ::Hc SJ::Hc W868cW868cW86:f W86:f d86Dcd86Dcd86Dd.d86Dd/d86Dd0d86Dd1d86Dfd86Hcd86Hcd86Hed86Hed86Hed86Hed888cd888ed888ed888e d888e d888ed88<cd88<c#d88<c%d88<c&d88<c(d88<c*d88<dd88<dd88<dd88<dd88<dd88<dd88<dd88<dd88<d"d88<d&d88<d'd88<d)d88<d+d88<d,d88<d-d88<ed88<e d88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<e d88<e!d88<e"d88<e&d88<e'd88<e(d88<e*d88<e+d88<e,d88<e-d88<e/d88<e1d88<fd88<fd8:<c$d8:<c,d8:<dd8:<d%d8:<ed8:<e d8:<e%d8:Dcd8:Dfd8:Dfd8:Dfd8:Hf d8:Hf d8:Hf d:66cd:66cd:66cd:66cd:66cd:66cd:68cd:68c d:8@cd:8Dcd:8Dc!d:8Dc)d:8Ddd:8Ddd:8Ddd:8Ddd:8Dd#d:8Dd$d:8Dd(d:8Dd*d:8Ded:8De d:8Ded:8Ded:8Ded:8De$d:8De)d:8Hcd<:@c"d<:@c'd<:@c+d<:@dd<:@dd<:@dd<:@d d<:@d!d<:@ed<:@ed<:@e#d<:@e.pa88888c8888:c888:8cB::D:cB:<>8cBB>8@cBB>8BcBB>8DcBB>8FcBB>8Hc BB>::c BD>FFc BHD6@c D6:<:c D6:<>cD6:cF686@cF6:68cF6:6:cF6<68cF6<88cF6<:8cF6<::cF6<:<cF6<<8cF6<>8cF6<@8cF66:c!F6>6<c"F6>6>c#F6>6@c$F6>6Bc%F6>6Dc&F6>6Fc'F6>6Hc(F6>86c)F6>88c*F6>8:c+F6>8<c,F6>8>c-F6>8@c.F6>8Bc/F6>8Dc0F6>8Fc1F6>8HdF6>:6dF6>:8dF6>::dF6>:<dF6>:>dF6>:@dF6>:BdF6>:DdF6>:Fd F6>:Hd F6><6d F6><8d F6><:d F6><<dF6><>dF6><@dF6>>6dF6>>8dF6>>:dF6>><dF6>>>dF6>>@dF6>>BdF6>>DdF6>>FdF6>>HdF6>@6dF6>@8d F6>@:d!F6>@<d"F6>@>d#F6>@@d$F6>@Bd%F6>@Dd&F6>@Fd'F6>@Hd(F6>B6d)F6>B8d*F6>B:d+F6>B<d,F6>B>d-F6>B@d.F6>BBd/F6>BDd0F6>BFd1F6>BHeF6>D6eF6>D8eF6>D:eF6>D<eF6>D>eF6>D@eF6>DBeF6>DDeF6>DFe F6>DHe F6>F6e F6>F8e F6>F:e F6>F<eF6>F>eF6>F@eF6>FBeF6>FDeF6>FFeF6>FHeF6>H6eF6>H8eF6>H:eF6>H<eF6>H>eF6>H@eF6>HBeF6>HDeF6>HFeF6>HHeF6@66eF6@68e F6@6:e!F6@6<e"F6@6>e#F6@6@e$F6@6Be%F6@6De&F6@6Fe'F6@6He(F6@86e)F6@88e*F6@8:e+F6@8<e,F6@8>e-F6@8@e.F6@8Be/F6@8De0F6@8Fe1F6@8HfF6@:6fF6@:8fF6@::fF6@:<fF8868fF886:fF886<fF8:68fF8:88f F8:8:f F:868f F:86:f F:888f a@@ @ @ @ @ @ @@@   @@`Bf `Bf `s8:6c`s8:6c `s:c`s:f`s< <6c `s< <6f `s>:6c`sB86c`sB86c`sB86c `sB86c `sD<6c`sH66c`sS88<6c`sS8:<6c`sSH<6c`sS86c`sS86c`sS86c!`sS86c%`sS86c)`sS86c0`sS86d`sS86d`sS86d `sS86d `sS86d`sS86d`sS86d`sS86d`sS86d"`sS86d'`sS86d/`sS86e`sS86e `sS86e `sS86e`sS86e`sS86e`sS86e`sS86e`sS86e!`sS86e$`sS86e(`sS86e-`sS86f`sS88c`sS88c`sS88c`sS88c`sS88c#`sS88c(`sS88c+`sS88c/`sS88d`sS88d`sS88d`sS88d`sS88d`sS88d`sS88d%`sS88d0`sS88e`sS88e`sS88e `sS88e `sS88e`sS88e `sS88e%`sS88e,`sS88e/`sS88e1`sS88f`sS88i88c`sS8:c`sS8:c`sS8:c$`sS8:c,`sS8:d`sS8:d `sS8:d`sS8:d&`sS8:d*`sS8:d1`sS8:e`sS8:e`sS8:e`sS8:e)`sS8:e.`sS8:f`sS8:f`sS8:i:c`sS:c-`sS:d`sS:d`sS:d `sS:e"`sSFc`sSHc`sSHc`sSHc"`sSHc'`sSHc.`sSHd`sSHd`sSHd `sSHd`sSHd`sSHd`sSHd`sSHd`sSHd!`sSHd$`sSHd(`sSHd+`sSHd.`sSHe`sSHe`sSHe`sSHe `sSHe`sSHe`sSHe`sSHe`sSHe`sSHe`sSHe#`sSHe'`sSHe+`sSHe0`sSHf`sSHf`sSHf iBcm:f mBcmi88fmi:c*mi:dmi:dmi:d)mi:d,mi:emi:e&mi:fmi< <6dmi< <6dmi< <6emiHc&miHc1miHd miHd#miHd-miHemiHemiHemiHemiHe*mm8:<6c mm:66cmmB86c mmD>6c2@Zk/ L  A L  ~ ` B $ X  i[Ky&v5d dwY+@ @ @G*pl [First]& gG*pl[Student ID]+ gG*plstudents!!! G*pl G*pl GF *plSections.sectionID1 'F *plstudents.[Student ID]4 'F*plstudentsenrollmentsZ@C7! F*plSectionsenrollmentsT@C7! F*plCatalog CoursesSections`@K?/ F*plCatalog CoursesSectionsL@K?/ F*platalog Courses].Credits8 gF*pl[Catalog Courses].Description< gF*pl[Catalog Courses].Title6 gF*plSections.[stop point]4 gF*plSections.professor1 gF*plSections.room, gF*plSections.time, gF*plSections_YearSections.YearF++ oF*plSections.Sem+ gF*plSections.Section/ gF*pl Sections_Course#Sections.[Course#]Q11 oF*pl Sections_DeptSections.DeptF++ oF*pl Sections.sectionID1 gF*pl students.[Balance Due]5 gF*pl students.Hometown0 gF*plstudents.GPA+ gF*plstudents.[Num Credits Earned]< gF*plstudents.Major- gF*plstudents_Yearstudents.YearF++ oF*plstudents.Last, gF*plstudents.Middle. gF*plstudents.First- gF*plstudents.[Student ID]4 gF*plenrollments''' F*plstudents!!! F*plSections!!! F*plCatalog Courses/// F*pl GF*pl GF*pl F*pl GE *plSections.Year, 'E *plSections.[Course#]1 'E *plSections.Dept, 'E*plCatalog CoursesSections`@K?/ E*plCatalog CoursesSectionsL@K?/ E*pl atalog Courses].Credits8 gE*pl [Catalog Courses].Description< gE*pl [Catalog Courses].Title6 gE*pl Sections.[stop point]4 gE*pl Sections.professor1 gE*plSections.room, gE*plSections.time, gE*plSections.Year, gE*plSections.Sem+ gE*plSections.Section/ gE*plSections_Course#Sections.[Course#]Q11 oE*plSections_DeptSections.DeptF++ oE*plSections.sectionID1 gE*plSections!!! E*plCatalog Courses/// E*pl GE*pl G YGrad"N  nn Y  Y  Y  Y  Y e Y sY Y  Y (Y  Student ID First MiddleLastYear Major$Num Credits EarnedGPAHometownBalance DuePmynMeccoeonNtsDnOynp}nq}YYYYYY.rFLast MajorPrimaryKeyStudent IDYear%A%A%A% A% A% A% A% A%A%A%B%B%B%B%B%B%B%B%B %B %B %B %B %B %B %B % B  %!B%C%"C%$C%%C%&C%'C%(C%)C%*C%+C%,C%-C%.C%/C%0C%#D%1D%3D%4D%5D%6D%7D%8D%9D%:D%;D%<D%=D%>D%?D%@D%AD%BD%CD%DD%2E%EElElElElElElElElElEl El El E l E l E lE lE lElElE lE lE%FE*plCatalog CoursesSectionsL@K?/ E*pl atalog Courses].Credits8 gE*pl [Catalog Courses].Description< gE*pl [Catalog Courses].Title6 gE*pl Sections.[stop point]4 gE*pl Sections.professor1 gE*plSections.room, gE*plSections.time, gE*plSections.Year, gE*plSections.Sem+ gE*plSections.Section/ gE*plSections_Course#Sections.[Course#]Q11 oE*plSections_DeptSections.DeptF++ oE*plSections.sectionID1 gE*plSections!!! E*plCatalog Courses/// E*pl GE*pl Gv1b @ @ @ @ @ @ @ @ @ @ @ @ @ @?"*?"+?",?"-?".?"/?"0?"1?"2?"3?"4?"5?"6?")@"7@"9@":@";@"<@"=@">@%@%@%@"8A%A%A%A%A%A% A% A% A% A% A%A%A%B%B%B%B%B%B%B%B%B %B %B %B %B %B %B %B % B  %!B%C%"C%$C%%C%&C%'C%(C%)C%*C%+C%,C%-C%.C%/C%0C%#D%1D%3D%4D%5D%6D%7D%8D%9D%:D%;D%<D%=D%>D%?D%@D%AD%BD%CD%DD%2E%EElElElElElElElElElEl El El E l E l E lE lE lElE%Ff stop pointMin(Sections.[stop point])[33 oBUAvg Of stop pointAvg(Sections.[stop point])[33 oBUSections.Dept, gBUSections!!! BU GBU GBU BU GAU(((Sections.Year)<2002))7 'AUSectionsenrollmentsT@C7! AUSections.Year, gAUenrollments.grade0 gAU"enrollments.[special permission]? gAUenrollments.sectionID4@ b m` k t $ + 0 7  @@@@  @@    @@ JO`YbmJk\kMJmJ^dUMdoikQkOQJbkmJk\kQbid^^`QbmkkoLSdi`Qbid^^`QbmkkoLSdi`8Qbid^^`QbmkkoLSdi`:QbmQibQsMdoikQ SJMo^mvmJk\k`JYbidd`kkQMmYdbkkmoOQbmkkmoOQbmk8kmoOQbmksQbid^^kmoOQbmmJk\kJ^^Qbid^^`Qbmk MdobmdSQbid^^LvOQfmJbOMdoikQ!iQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb:"iQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb<#idkmQiu$kMWQOo^Q%JomdQuQM&LJM\md`JYb'MdoikQk(SYbOkmO)JO`Yb*OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MQbid^^`QbmkkoLSdi`+kh+MMd`LdB++kh+MQbid^^`QbmkkoLSdi`8+kh+MkQMmYdbYO,+kh+MQbid^^`QbmkkoLSdi`:+kh+MkQMmYdbYO+kh+MkQMmYdbk+kh+MMd`Ld8B+kh+MkQMmYdbk+kh+MMd`Ld8F+kh+MkmoOQbmk+kh+MQbid^^`QbmkkoLSdi`8+kh+MkmoOQbmk+kh+MSYbOJkmoO+kh+MkmoOQbmk+kh+MSYbOkmoO+kh+MkmoOQbmk8+kh+MQbid^^`QbmkkoLSdi`:+kh+MkmoOQbmk8+kh+MSYbOkmoO+kh+MkmoOQbmksQbid^^+kh+MQbid^^`QbmkkoLSdi`+kh+OidkmQiu+kh+OkQMmYdbYO +kh+OkMWQOo^Q+kh+OkQMmYdbYO +kh+SMJmJ^dUMdoikQk +kh+SQbid^^`QbmkkoLSdi` +kh+SQbid^^`QbmkkoLSdi`8 +kh+SQbid^^`QbmkkoLSdi`:+kh+SQbmQibQsMdoikQ +kh+Sidd`k+kh+SkQMmYdbk+kh+SkmoOQbmk+kh+SkmoOQbmk8+kh+SkmoOQbmksQbid^^MJmJ^dUMdoikQkMdobmdSQbid^^LvMdoikQhoQivQbid^^`QbmkQbid^^`QbmkhoQivQbid^^`QbmkhoQiv8 #ffF@@B7171PaulPPierceSoCHEMBoston:2,(  cbx@7070TimDDuncanSrHISSan Antonio=0+' ni@6161MichaelSJordanSrMKTGWilmingtonA5/+#! @5555PennyAHardawayFrCSCCherry HillA4/+! )\?@5151BaronUDavisSoBIOWestwood;1,(! F @O4141GlennBRobinsonJrHISPhiladelphiaB4/+! ffv@3131ShaneDBattierFrCHEMVorhees=4.*! ffF@2222LarryRHughesSoBIOPhiladelphia@2-)! [R>@@B2121KeithVVan HornSrMGMTCherry HillB5/+! 33?1818KevinGGarnettFrBIOChicago<3.*! C+@1212KobeJBryantSoBIOLower Merion?1,(  b@1123ShawnWBradleyFrCSCPalmyra<3.*! 0ˡM@ 1119MarcusSCambySoCHEMPennsauken?3-)"  kww@1117GrantPHillSrCSCPennsauken<0+'! Qb8@1116AllenXIversonJrBIOMaple Shade@3.*! ^t@1115ShaqOO'NealJrMKTGVorhees;2,(  66@1113KennyTAndersonSoMGMTCamden=5/+! @@1111CharlesDBarkleyFrHISPennsaukenA50,#! -`@@x}1093ChrisTWebberSoCSCHaddonfield?2-)! (ffF@1011AsonJKiddSoMGMTOakland90*& D m@ @ @8688o86H<o8888o888<o888@o888Bo888Do888Ho88:<o8:8:o 8F8Fo :8:8o ::::o <8<8o >8>8o@8@8o@@@@oB8B8oD6D6oD8D8ol m @ @SioSioSio Sio Sio[io[io[iokdokdokdokdokdo kdo kdokdokiokio kiokio7Dh5U7 D x 5 > j @ g I  f'o$cnZ,}:EF  @ @ J*pl [Sections].[Year]0 gJ*pl [Sections].[Sem]/ gJ*pl [Sections].[Section]3 gJ*pl [Sections].[Course#]3 gJ*pl [Sections].[Dept]0 gJ*pl[Sections].[sectionID]5 gJ*pl[enrollments].[grade]4 gJ*plD@! gJ*plnrollments].[sectionID]8 gJ*plnrollments].[studentID]8 gJ*pl[students].[Student ID]6 gJ*pl[students].[Last]0 gJ*pl[students].[First]1 gJ*plenrollments''' J*plstudents!!! J*plSections!!! J*plCatalog Courses/// J*pl GJ*pl J*pl GI*plstudentsenrollmentsd@ C7! I*pl[enrollments].[grade]4 gI*pl D@ gI*pl nrollments].[sectionID]8 gI*pl nrollments].[studentID]8 gI*pl [students].[Balance Due]7 gI*pl [students].[Hometown]4 gI*pl[students].[GPA]/ gI*pl![students].[Num Credits Earned]> gI*pl[students].[Major]1 gI*pl[students].[Year]0 gI*pl[students].[Last]0 gI*pl[students].[Middle]2 gI*pl[students].[First]1 gI*pl[students].[Student ID]6 gI*plenrollments''' I*plstudents!!! I*pl GI*pl I*pl GH*plstudents Queryenrollmentsp@OC- H*pl[enrollments].[grade]4 gH*pl D@ gH*pl nrollments].[sectionID]8 gH*pl nrollments].[studentID]8 gH*pl [students Query].[Balance Due]= gH*pl [students Query].[Hometown]: gH*pl[students Query].[GPA]5 gH*plJ@ gH*pl[students Query].[Major]7 gH*pl[students Query].[Year]6 gH*pl[students Query].[Last]6 gH*pltudents Query].[Middle]8 gH*pl[students Query].[First]7 gH*pl[students Query].[Student ID]< gH*plenrollments''' H*plstudents Query--- H*pl GH*pl H*pl GG*pl [Balance Due], gG*pl [Hometown]) gG*pl[GPA]$ gG*pl[Num Credits Earned]3 gG*pl [Major]& gG*pl[Year]% gG*pl[Last]% gG*pl [Middle]' g$ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @E lE lE lElElE lE lE lE%FFlFlFlFlFlFlFlFlFlFl Fl!Fl"Fl#Fl$Fl%F l&F l'F l(F l)F l*Fl+Fl,Fl-Fl.Fl/Fl0Fl1Fl2Fl3Fl4Fl5Fl6Fl7Fl8F l9F l:FlGl;Gl=Gl>Gl?GrGrGrGrGrGrG rG rGlJ r?J r@J rAJ rBJ rCJtJtJtJtJtJtJtJtJtJt Jt Jt Jt Jr1Kt KtKtKtKtKtKtKtStSt0St1St2St3St4St6St8St:StSt@StBS tDS tFStGS t5S t7S t9S t;S t=S t?S tAS tCS  tES tHSt gH*pl[students Query].[First]7 gH*pl[students Query].[Student ID]< gH*plenrollments''' H*plstudents Query--- H*pl GH*pl H*pl GG*pl [Balance Due], gG*pl [Hometown]) gG*pl[GPA]$ gG*pl[Num Credits Earned]3 gG*pl [Major]& gG*pl[Year]% gG*pl[Last]% gG*pl [Middle]' gBIDv1 G O 1  z F  ʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʈ j <  b $ t6Jf-|, @ @ @ @ @ @E lE lE lElElE lE lE lE%FFlFlFlFlFlFlFlFlFlFl Fl!Fl"Fl#Fl$Fl%F l&F l'F l(F l)F l*Fl+Fl,Fl-Fl.Fl/Fl0Fl1Fl2Fl3Fl4FS GS [Sections].[SecS S DCount(enrollments.studentID)= /SSectionsenrollmentsT@'C7! S Sections.Section/ gS Sections.Section/ gS Sections.room, gS Sections.room, gSSections.time, gS Sections.time, gSSections.Year, gS Sections.Year, gSSections.Sem+ gS Sections.Sem+ gSSections.professor1 gS Sections.professor1 gSSections.[Course#]1 gS Sections.[Course#]1 gSSections.Dept, gS Sections.Dept, gSSections.sectionID1 gS Sections.sectionID1 gSCountOfstudentIDCount(enrollments.studentID)[11 oSenrollments''' SSections!!! S GS GS S GK*pl[Year]% gK*pl[Last]% gK*pl [Middle]' gK*pl [First]& gK*pl[Student ID]+ gK*plstudents!!! K*pl K*pl GJ*plSectionsenrollmentsb@%C7! J*plstudentsenrollmentsd@$C7! J*plCatalog CoursesSectionsb@#K?/ J*plCatalog CoursesSectionsV@"K?/ J*pl[Catalog Courses].[Credits]: gJ*pl![Catalog Courses].[Description]> gJ*platalog Courses].[Title]8 gJ*pl[Catalog Courses].[Course#]: gJ*pl[Catalog Courses].[Dept]7 gJ*pl[Sections].[stop point]6 gJ*pl[Sections].[professor]5 gJ*pl[Sections].[room]0 gJ*pl[Sections].[time]0 g0  cl N n R studentsenrollmentsenrollmentsstudentIDstudentsStudent IDl\J4SectionsenrollmentsenrollmentssectionIDSectionssectionID~l\J4RoomsSectionsSectionsroomRoomsroomRJ@8(ProfessorsSectionsSectionsprofessorProfessorsNamephTB2Catalog CoursesSectionsSectionsCourse#Catalog CoursesCourse#xZL<Catalog CoursesSectionsSectionsDeptCatalog CoursesDeptzrTL<Catalog CoursesPrerequisites1PrerequisitesPreClassCatalog CoursesCourse#rbHCatalog CoursesPrerequisites1PrerequisitesPreProgCatalog CoursesDeptpbHCatalog CoursesPrerequisitesPrerequisitesClassCatalog CoursesCourse#j`FCatalog CoursesPrerequisitesPrerequisitesProgCatalog CoursesDepth`F< QLYd8B:SMWQ`88:SMWQ`:6:SMWQ`<6:SMkM8B:SMkM:B>SMkM:B@SMkM<@>SMkM>B>SMkM>F8S QbU86FS `U`m<6<S `mW::8S `mW:::S j@  MSysObjects### CStr(Database)5 3  #< QLYd8B8SMWQ`888SMWQ`:68SMWQ`<68SMkM8@DSMkM8@DSMkM8B:SMkM:B>SMkM<@>SMkM>F6S QbU86DS `U`m<6:S `mW8:6S `mW::8S enrollments not 2002 Query^^^^^^^^^^^ @oQN@oQN@junk create some sections test\\\\\\\\\\\ ?oQN@oQN@@junk create some sections aVVVVVVVVVVV >LN@LN@joint enrollments Query2PPPPPPPPPPP =)N@LN@join students enrolled sections/classesnnnnnnnnnnn <)N@)N@enrollments Query1DDDDDDDDDDD ;N@)N@enrollments QueryBBBBBBBBBBB XN@N@enrollments66666666666 :XN@XN@CountOfEnrollByCourse QueryVVVVVVVVVVV N@N@Catalog Courses>>>>>>>>>>> 9N@N@~sq_fstudentsWenrollHHHHHHHHHHH 8N@N@~sq_fstudents1<<<<<<<<<<< 7N@N@~sq_fstudents::::::::::: 6xN@N@~sq_fSections::::::::::: 5xN@xN@~sq_fRooms44444444444 4xN@xN@~sq_fEnter New Course:LLLLLLLLLLL 3U`N@U`N@~sq_fenrollments Subform2RRRRRRRRRRR 2U`N@U`N@~sq_fenrollments Subform1RRRRRRRRRRR 1U`N@U`N@~sq_fenrollments SubformPPPPPPPPPPP 02"N@2"N@~sq_fCatalog CoursesHHHHHHHHHHH /2"N@2"N@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV .2"N@2"N@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT -N@N@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx ,N@N@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn a @ @ @ @ @LYd8@Dc!LYd8B8c#LYd8F6c"LYd:86c$Lok868e0Lok868e1Lok8@6fLok8@6fLok:66fLok:66fLok:66fMWQ`888cMWQ`888c%MWQ`888c)MWQ`8@6c&MWQ`8@6c*MWQ`:68c'MWQ`:68c+MWQ`<68c(MWQ`<68c,MkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@:c MkM8@:cMkM8@:cMkM8@DcMkM8@DcMkM8@DcMkM8B:cMkM8B:cMkM:B>cMkM:B>cMkM:B>cMkM:B@c MkM<@:cMkM<@>cMkMF6c MkO:86f MkO:86f MkO<>6f MkYm8>Dc MkYm>B8cQMb8@6dQMb8@6dQMb8@6dQMb8@6dQMb8@@dQMb8@@dQMb:68dQMb:68dQMb:8<dQMb:8<dQMb:8<dQMb:8<dQbU86DdQbU86Dd QbU86Dd#QbU86Dd'QbU86Dd(QbU86Dd+QbU86Dd,QbU86Dd-QbU86FdQbU86Fd$QbU8@6dQbU8@6d!QbU8@6d"QbU8@6d%QbU8@6d&QbU:6<dQbU:6<d)QbU:6<d*WYk8@8eWYk8@8eWYk8@8e"WYk8@8e#WYk8@8e*WYk8@8e+WYk:@8e&WYk:@8e'WYk:@8e(WYk:@8e,WYk<6@e WYk<6@e!WYk<:>e)WYk<:>e-WYk<:He$WYk<<<e%`U`m<6:c-`U`m<6:c0`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d `U`m<@<c.`U`m<@<c/`U`m<@<d`U`m<@>c1`U`m<@>d`U`m<@>d`\mU<68d `\mU<68d `\mU<68d `\mU<68d`\mU<6>d`\mU<6@d `mW88<e`mW88<e`mW88<e`mW88<e `mW88<e `mW88<e `mW88<e`mW88Dd.`mW8:6d/`mW8:6d0`mW8:6e`mW8:6e`mW8:6e`mW8:6e `mW8>6e`mW8>6e `mW8>6e`mW::8d1`mW::8e`mW:::e`mW:>6e`mW:>6efW^8@8efW^8@:efd^8@8e.fd^8@8e/fkv8@@efkv8@@efkv8@@efkv8@@eiQ^8@6eiQ^8@6eiQ^8@<eiQ^8@<ekdM8@6ekdM8@6e~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn ca@   @@ @@@   @ @  @@    @@@@@@@@@@ @@@  @@    JbOiY^^YeJbOiY^^YeJbOiY^^YeJbOiY^^YeJi`kmidbUeLJ^MWobYke.LJ^^doUWc!LJ^^doUWc"LJ^^doUWc#LJ^^doUWc$LQJmmvdLQJmmvdLQJmmvdLQJmmvdLY^^Jc L^o`cLiJxYbJe0LiJxYbJe1LiJxYbJfLidUJbe/LioMQc-LioMQc.LioMQc/Loi\QcLoi\Q[eLom^Qid Lom^Qid!Lom^Qid"MJ`d`Y^Qf Md^^YbkeOQkbdvQike&OQkbdvQike'OQkbdvQike(OQkbdvQike)OYOYdcOYOYdcOYOYdeOYOYdeOYOYdeQ^^YdmmcSJYie"SJYie#SJYie$SJYie%SJ^MdbQeUiJbmcUiJbmc[dU^Q\Jic0[dU^Q\Jic1[dU^Q\Jid[dbQkOd [dbQkOd [dbQkOd [dbQkOf[dbQkbc%[dbQkbc&[dbQkbc'[dbQkbc(\Q^^vUe\Q^^vUe\YikMWc\YikMWc \YikMWf\bJffQbLQiUQid.\bJffQbLQiUQid/\bJffQbLQiUQid0\bJffQbLQiUQid1\d^JkJc \d^JkJc^QJoLvd^QJoLvd^QJoLvd^QYLYUQie*^QYLYUQie+^QYLYUQie,^QYLYUQie-^QYkmQif ^QYkmQif ^dbUdf ^dbUdf `Jc `MMJimve`MMJimve`MMJimve`MMdbbQ^^e`MMdbbQ^^e`MMdbbQ^^e `MMdbbQ^^e `QJOc`YMWJ^Q\e `YMWJ^Q\e `YMWJ^Q\e `YMWJ^Q\e`Y^^JiOd#`Y^^JiOd$`Y^^JiOd%`Y^^JiOd&`diQJoe`diQJoe`kWd`LJd`kWd`LJd`kWd`LJd`kWd`LJdbUovQbefJo^YbdfJo^YbdfJo^YbdfJo^YbdiJm\okeiJm\okeiQO`dbOciQO`dbOciQO`dbOc iQO`dbOciQO`dbOciQYMWJiOmciQYMWJiOmfiQYMWJiOmfiQYMWJiOmfiWdOJdiWdOJdiWdOJdidLYkdbdidLYkdbdidLYkdbdidLYkdbdkWJ^WdoLc)kWJ^WdoLc*kWJ^WdoLc+kWJ^WdoLc,kWQQWvekWQQWvekWQQWve kWQQWve!kdqQbd'kdqQbd(kdqQbd)kdqQbd*kmQqQbkckmQqQbkckmo^^ekoOQd+koOQd,koOQd-kxJLJmd kxJLJmdkxJLJmdkxJLJmfkxJLJmfkxJLJmfmJqJbJdmJqJbJdmJqJbJd moi\cmoi\cmoi\cmoi\cqQb\JmQkJbc sY^QvcsY^QvcsY^QvcvdobUcvdobUcvdobUcHHHHHHH /2"N@2"N@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV .2"N@2"N@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT -N@N@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx ,N@N@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn QQvcP=*z @ -  } j C 0  m Z G 3 p]I6#r_LK8%uaN;'Y  Y Y  Y2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2  2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 7 7 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 7 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 7 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 7 7 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 7 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 7 2 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp 2 LVALh  @ @ @ @άB0Catalog CoursesProfessorsά"&qenrollments qenrollments_1ʾCatalog CoursesάB0Catalog CoursesProfessorsά"&qenrollments qenrollments_1LVAL f @2B @ -  } j C 0  m Z G  @ @ @ @ @ @ @ @ @ @ @MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationReplicableUseTransactionC <      MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR24ODBCTimeoutMaxRecords" < MR24ODBCTimeoutMaxRecords" < MR24ODBCTimeoutMaxRecords" < MR2BValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToList m*$special permission       mS grade       m[studentID       m=sectionID       o Table/QueryD <SELECT DISTINCTROW [Sections].[sectionID], [Sections].[Dept], [Sections].[Course#], [Sections].[Section], [Sections].[Sem], [Sections].[Year] FROM [Sections];   6 .975;615;870;810;525;555  4350twip MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOn1 <   MR2ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlaces WCourse#       mS Title       mUDescription      Credits *     3   >0 And <62 *"Credits must be 1-5" mQDept       mMR20 Title AuthorCompany` university Mike Redmond La SalleMR2AccessVersion Build6Track Name AutoCorrect Info0Perform Name AutoCorrectCpgConversionN 08.50    [GvcO<)   x e R > +  {  g T A -}jVC0 lYXE1  ' 2 & 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp & 2 &ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp & 2 % 2 % ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp % 2 $ 2 $ ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp $ 2 # 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp # 2 #ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp # 2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp "2 !2 !ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp !2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 R2 Rϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp R2 Q2 Qϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp Q2 P2 Pϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp P2 O2 Oϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp O2 N2 Nϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp N2 M2 Mϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp M2 L2 Lϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp L2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp LVALl@@@( G&qCatalog Courses qSections2qenrollmentsά yD ] rCatalog CoursesCatalog Courses8Yenrollmentsenrollments$`SectionsSections!}studentsstudents  m\PrerequisitesPrerequisites.ProfessorsProfessors{VRoomsRoomsnCatalog Courses_1Catalog CoursesulSections_1SectionsTxSections_2Sectionsz,Sections_3Sections FvubO ; (    w d P = *   yfS?,|hUTA.}jWC0 ;ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp ;2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 :2 :ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp :2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 9 2 9 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 9 2 8 2 8 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 8 2 7 2 7 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 7 2 6 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp 6 2 6ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 6 2 5 2 5 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 5 2 4 2 4 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 4 2 3 2 3 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 3 2 2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 1 2 1 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 1 2 0 2 0 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 0 2 / 2 / ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp / 2 . 2 . ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp . 2 - 2 - ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp - 2 , 2 , ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp , 2 + 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp + 2 +ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp + 2 * 2 * ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp * 2 ) 2 ) ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp ) 2 ( 2 ( ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp ( 2 ' 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp ' 2 'ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp pFcP=) y f R ? ,   {  z  yfR?,{hUA.~jWD0  Y Y  Y  Y  YH2 G2 Gϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp G2 F2 Fϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp F2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp m2 E2 Eϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp E2 a2 aϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp a2 D2 Dϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp D2 C2 Cϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp C2 [2 [ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp [2 U2 Uϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp U2 Q2 Qϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp Q2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 @3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp 2 Tϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 T3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp Tϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 &3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp &2 &ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp &2 B2 Bϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp B2 A2 Aϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp A2 @2 @ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp @2 ?2 ?ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp ?2 >2 >ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp >2 =2 =ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp =2 <2 <ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp <2 ;2 LVALh , @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ ά&qCatalog Courses qSections( G&dCatalog Courses dSections2dstudentsdenrollments( G&dstudents denrollments( G&qSectionsά5#u0SectionsPenrollmentsά z0Catalog CoursesProfessorsLVAL  Q  em_Jm H%!HGtE| =6rC N@CN@roster Query88888888888 [IN@="0000" And <="9999"* ""must be numeric" m email   \ Tassumes local - only has userid not domain    mMR2rValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControl QProg       mS Class       mPreProg   0 (Dept of Prerequisite    mPreClass   4 ,Class# of Prerequisite    mMR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOn1 <   MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    LVAL r v  [  @  iG˅KXNMR2ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlacesOrientation$UnicodeCompressionh  J BSections.Dept, Sections.[Course#]sectionID   " Section Index   2 *>"00000" And <"99999"P H"Section ID must be 5 digit numeric" m `Course#       m Section <   "01"   & >"00" And <"99"N F"Section must be two digit numeric" m Ztime t      m Zroom       m dprofessor       m stop point    $ Max Enrollment  25    >10 And <100L D"Invalid Stop Point - enter 11-99" mZDept       m  Sem   & F S Su semester    m "F" #Year (  N Fyear offered - use 4 digit notation  2002  & >1954 And <2350N F"I dont think this year is correct" m5junk   MR2ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlaces room   T Lunique identifier for room e.g. at134    msize    capacity  Capacity  20    >5N F"We dont have any rooms that small" m"Front Computer   t lwhether there is a computer up front for the professor Yes/No  No   j~$Data Connection    Yes/No  No   j|"Data Projector    Yes/No  No   jdOverhead    Yes/No   j82Numb Student Workstations   l dnumber of computers in room for studets to work at   0   m LVAL MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: < MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationColumnWidthColumnHidden: <    E*$Sections.sectionID H  ; Sections_Dept   A& Sections_Course#   A& Sections.Section   9Sections.Sem   ; Sections.Year I  ; Sections.time V  ; Sections.room   E*$Sections.professor   K0*Sections.[stop point]   O4.[Catalog Courses].Title   S82[Catalog Courses].Credits *  LVALv1b N  : k & W  C t/MR2^ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlacesRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToList -Student ID t   Student number - 4 digits - made text so leading zeroes dont go away - not doing math on them anyway    m First *  , $Student First Name    m Middle   4 ,Student Middle Initial    m{Last   * "Student Last Name    mYear v  T LStudent Academic Year (Fr, So, Jr, Sr)   H @="Fr" Or ="So" Or ="Jr" Or ="Sr"8 0"Must be Fr So Jr or Sr" o Value List< 4"Fr";"So";"Jr";"Sr";"Grad"    1440  1440twip Hometown    | tStudent Hometown (in reality would have whole address too)    mBalance Due   ` XAmount Student Currently owes the university2 *$#,##0.00;($#,##0.00)   0  ;*$Num Credits Earned    X PStudent Number of Credits Earned to Date   TotalCredits  0   >=0> 6"Invalid Number of Credits" m GPA *   Student Current GPA (derived from student course grades - must be updated each semester)   0   >=0 And <=4V N"Invalid GPA - must be between 0 and 4" mu Major   " Student Major    m LVAL0 0 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @zzzzzzzzz z z z zzzʾCatalog Coursesjunk enrollments not 2002 Query studentsWenrollreport leading to unnormalized students design2Create data access page in Design viewAutoExec^3ά&qCatalog Courses qSections2qstudentsqenrollments LVAL" MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationColumnWidthColumnHidden: <    K0*students.[Student ID] t  ="students.First *  ?$students.Middle   ; students.Last   ; students_Year    ="students.Major   [@:students.[Num Credits Earned]   9students.GPA v  C("students.Hometown    M2,students.[Balance Due] U  E*$Sections.sectionID   ; Sections_Dept f  A& Sections_Course#   A& Sections.Section   9Sections.Sem I  ; Sections_Year :  ; Sections.time V  ; Sections.room   E*$Sections.professor   K0*Sections.[stop point] I  O4.[Catalog Courses].Title   S82[Catalog Courses].Credits *  S8pN@8pN@sectioS8pN@qN@section enrollment counts Query2@ @xll```````^ @GC[@S[@students Query2Z@JJJ>>>>>>>< @ vcO<)   k & W  C t/ AEXN@0fN@junk enrollments not 2002 Query2@@xll```````^ @<_O[@_O[@enrollments Query12Z@|RRRFFFFFFFD @8k;@k;@~sq_fstudents124MR2KeepLocal T~~~>>>>>>>< @6wtvN@wtvN@~sq_fSections24MR2KeepLocal T|||<<<<<<<: @4@@~sq_fEnter New Course:24MR2KeepLocal TNNNNNNNL @1 A@ A@~sq_fenrollments Subform24MR2KeepLocal TRRRRRRRP @.@@~sq_drosterX~sq_dsectionID24MR2KeepLocal TVVVVVVVT @+~.vN@~.vN@~sq_cstudents1~sq_cenrollments Subform224MR2KeepLocal Tpppppppn @(z@z@~sq_cstudents~sq_cenrollments Subform124MR2KeepLocal Tnnnnnnnl @&tvN@8tvN@~sq_cSections~sq_cCombo1624MR2KeepLocal TTTTTTTTR @$gg @gg @~sq_cenrollments Subform1~sq_cSectionID24MR2KeepLocal   $BHBS2 Sϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp S2 K2 Kϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp K2 J2 Jϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp J2 I2 Iϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp I2 H2 Hϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp LVALFDvh&Xh&( Y;?X$XX8X H <,X2XrXXXXX"XBXbXxX,X X`XXXXXX0XPXxX(XHXHXHXHXHXHXHXHXHX(X2XrXXXXX"XBXbX                    )enrollments.studentIDenrollments#Sections.sectionIDSectionsSections.DeptSections.Course##Sections.professorSections.SemSections.YearSections.timeSections.roomSections.Section'Count Of enrollments`X  XX xXXXpN@HX`X 0XHX X !~ 2X !~ rX !~ X !~ X !~ X !~ X !~ "X !~ BX !~ bX !~ xX !~ Sections` X    XH XXN@enrollmentsXXXX' QN@=section enrollment counts Query`XHX X X X X  X@ X H Xx X X X X X X X  X@ X H Xp X x X X xX X1[enrollments].[studentID] X+[Sections].[sectionID] X![Sections].[Dept] X'[Sections].[Course#]H X+[Sections].[professor] X[Sections].[Sem] X![Sections].[Year] X![Sections].[time] X![Sections].[room]H X'[Sections].[Section]x XxX2X !~ rX !~ X !~ bX !~ X !~ X !~ "X !~ BX !~ X !~Sections 2XX rXX XX bXX XX XX "XX BXX XX X XH Xx X X X XH X XX !~enrollments XX X XD%X%X $X8XhXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXv X XXv XPX8 X0HXhX@ X0X  !X00X $XXx   ` X !X X X  X X 8X X XX X PX pX$ $XXXhX#X!XX8X XSectionsȚX8X ȚX8X ȚX8X ȚX8X ȚX8X xX8XȚX8X ȚX8X ȚX8X XXX8XXpXXXXXXXXPX XX0Xenrollments%SectionsenrollmentsȚX LVAL* PX ȚXPX X@XXXX PXXXXX%Sectionsenrollments  XX  X XXXX%Sectionsenrollments @  @ @ @ @ @ @ @ @ @    xX0X xX0X xX0X xX0X xX0X xX0X xX0XxX0X xX0X xX0X  xX0X xX0X  !X( XX!X#X!X#X!X#X"X#X8"X$Xp"X$X"X $X"X0$X#X@$XP#XP$Xt$X*$Xp$X#X`$X|hX$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$X$XX}hXD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XD%XX  !X  X!X !X !X "X 8"Xp"X "X "X #X#XLVALh Dv1 G O 1  z F  ʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʈ j <  b $ t6Jf-|, <,X2XrXXXXX"XBXbXxX,X X`XXXXXX0XPXxX(XHXHXHXHXHXHXHXHXHX(X2XrXXXXX"XBXbX                    )enrollments.studentIDenrollments#Sections.sect][Sections].[sectionID] =[enrollments].[sectionID][students].[Student ID] =[enrollments].[studentID][Catalog Courses].[Course#] =[Sections].[Course#][Catalog Courses].[Dept] =[Sections].[Dept][enrollments].[special permission][students].[Student ID] =[enrollments].[studentID][enrollments].[special permission][studʾCatalog Coursessection enrollment counts Query studentsWenrollreport leading to unnormalized students design2Create data access page in Design viewAutoExec b^3ά5#0SectionsPenrollments