Standard Jet DBnb` Ugr@?~1y0̝cßFNi7+֜(e$`"{6߱fC=3By['|*J|[ pf_Љ$g'DeFx -bT4.0dvcO<)   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 ' ) 4Hp Y$S oo 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_cFindStudTTOYoSnY 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  $$@@  @@@@ @@@@@JO`Yb*OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MkmoOQbmksQbid^^+kh+MQbid^^`QbmkkoLSdi`MJmJ^dUMdoikQkQbid^^`Qbmk`kvkJMMQkkdL[QMmk `kvkJMQk`kvkY`QuMd^o`bk`kvkY`QukfQMk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkfiQiQhoYkYmQk!fidSQkkdik"idd`k#kQMmYdbk`kmoOQbmk`JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOMJmJ^dUMdoikQkfiQiQhoYkYmQk` MJmJ^dUMdoikQkfiQiQhoYkYmQk8` MJmJ^dUMdoikQkkQMmYdbk` fidSQkkdikkQMmYdbk` idd`kkQMmYdbk`kQMmYdbkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`mk`kmoOQbmkQbid^^`Qbmk`mkQbid^^`Qbmk``Qbmk`kmoOQbmkQbid^^`Qbmk`kQMmYdbkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kQMmYdbkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`QMmYdbkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`Qbmk`kmoOQbmkQbid^^`Qbmk`OQbmkQbid^^`Qbmk`d^^`Qbmk`kmoOQbmkQbid^^`Qbmk`oOQbmkQbid^^`Qbmk`id^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`moOQbmkQbid^^`Qbmk``kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`QbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`QMmYdbkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`^`Qbmk`kmoOQbmkQbid^^`Qbmk`bmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`MmYdbkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`^`Qbmk`kmoOQbmkQbid^^`Qbmk``Qbmk`kmoOQbmkQbid^^`Qbmk`bmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`Qbmk`kmoOQbmkQbid^^`Qbmk`Qbmk`kmoOQbmkQbid^^`Qbmk`Qbid^^`Qbmk`moOQbmkQbid^^`Qbmk`bid^^`Qbmk`moOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk``kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`mk`kmoOQbmkQbid^^`Qbmk`QMmYdbkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`mk`kmoOQbmkQbid^^`Qbmk`QMmYdbkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`k`kmoOQbmkQbid^^`Qbmk`dbkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`OQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk``kmoOQbmkQbid^^`Qbmk`OQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk```kmoOQbmkQbid^^`Qbmk`kQbid^^`Qbmk`bid^^`Qbmk`mk`kmoOQbmkQbid^^`Qbmk`Qbid^^`Qbmk`oOQbmkQbid^^`Qbmk``^^`Qbmk`bid^^`Qbmk`^^`Qbmk`Qbmk`kmoOQbmkQbid^^`Qbmk```d^^`Qbmk`KSQ  @ @ @ @     "*-L` M` N` O` P`Q`R`& Q!U"[#a`m`NTypeInfoO>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 39  @ @ @ @ @ @ @ @ @ @ @ @ @ @zzzzzzzzz z z z zzzzzzzzzzzzz$z%"}5"}6"}7---L}L}L}M}M}M}N}N} N} O} O} O} P}P}P}Q}Q}Q}R}R}R} !"#$%&;<=ABC&&&&Q'Q(Q)U*U+U,[-[.[/a6a7a8m<m=m>zzzz zz zzzz!z"z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#z#)PropDataIROEAVCXSYCCAEHJOQCUGWLGIYKB:ty"[Event Procedure]h1U`dabaciPickDean2Dean of Arts and ScienceabelTitl #?"(#E l $Jr7s#### # #$ $ $$ %%%%%%%%&&&&&&&&&' '"'#'$'%'!(&((()(*(+('),).)/)-*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 _ Z VM s & 8 ʂʂʂʂʂʂʂʂʂʂʂʂʂʂʂʂʂʂʂʂʂʂʂʂ- --$$)N@)N@~sq_cenroll`#N@ƒN@~sq_cenrollments Subform`#N@ƒN@~sq_cenrollments Subform~sq_c`#N@ƒN@~sq_cenrollments Subform`#N@ƒN@~sq_cenrollments Subform~sq_cCombo624MR2KeepLocal Thhhhhhhf `" 8@FEѳ@Admin2 @8,,,,,,,,,* !`" 8@FEѳ@Admin2 @8,,,,,,,,,* !Q7" 8@FEѳ@Admin2 @8,,,,,,,,,* !Q7" 8@FEѳ@Admin2 @8,,,,,,,,,* !" 8@FEѳ@Admin2 @8,,,,,,,,,* " 8@FEѳ@Admin2 @8,,,,,,," 8@FEѳ@Admin2 @8,,,,,,,," 8@FEѳ@Admin2 @8,,,,,,,,,* " 8@FEѳ@Admin2 @8,,,,,,,,,* " 8@FEѳ@Admin2 @8,,,,,,,,,* " 8@FEѳ@Admin2 @8,,,,,,,,,* !" 8@FEѳ@Admin2 @8,,,,,,,,,* " 8@FEѳ@Admin2 @8,,,,,,,,,* !" 8@FEѳ@Admin2 @8,,,,,,,,,* !Q7@?@findstd" 8@FEѳ@Admin2 @8,,,,,,,,,* !Q7@?@findstd20000000000. " 8@FEѳ@Admin2 @8,,,,,,,,,* !Q7@?@findstd20000000000. " 8@FEѳ@Admin2 @8,,,,,,,,,*" 8@FEѳ@Admi" 8@FEѳ@Admin2 @8,,,,,,,,,* !" 8@FEѳ@Admin2 @8,,,,,,,,,*  " 8@FEѳ@Admin2 @8,,,,,,,,,* "" 8@T˯@Admin2`@8,,,,,,,,,*  p_޿@p_޿@UserDefined288888888886  p_޿@p_޿@SummaryInfo2@|DDD88888886 @ ӕ@R/@AccessLayout24MR2KeepLocal T"@zz:::::::8 @ ޿@ ޿@SysRel2..........,  ޿@ ޿@Scripts20000000000.  ޿@ ޿@Reports20000000000.  ޿@ ޿@Modules20000000000.  ޿@ ޿@Forms2,,,,,,,,,,* `ݿ@ݿ@MSysRelationships0DDDDDDDDDDB ݿ@ݿ@MSysQueries088888888886 ݿ@ݿ@MSysACEs022222222220 ݿ@ݿ@MSysObjects088888888886 ݿ@T@MSysDb2"@:::......., @ݿ@ݿ@Relationships0<<<<<<<<<<: ݿ@ݿ@Databases044444444442 ݿ@ݿ@Tables0.........., UpM P/Section/Section/Sections!!! /Sections!!! //Sections!!! //Sections!!! //Sections!!! //Sections!!! //Sections!!! //Sections!!! /Section/Section/Section/Sections!!! /Section/Section/Section/Sections!!! /Sections!!! //Sections!!! //Sections!!! //Sections!!! //Section/Section/Sections!!! //Sections!!! //Sections!!! //Sections!!! /Section/Section/Sections!!!/Sections!!! //Sections!!! //Sections!!! //Sections!!! //Sections!!! //Sections!!! /Section/Section/Section/Sections!!! /Sections!!! //Sections!!! //Sections!!! //Section/Section/Section/Sections!!! /Section/Section/Sections!!! //Section/Sections!!! //Sections!!! / /Section/Section/Section/Sections!!! /Section/Section/Sections!!! //Section/Sections!!! //Sections!!! / /Section/Section/Section/Sections!!! /Sections!!! //Sections!!! //Sections!!! //Sections!!! //Sections!!! //Sections!!! //Section/Section/Section/Sections!!! / -([__Student ID] = studentID); '-enrollmentsstudentsWenrollEE' -  G-__Student ID))) O- - G LVALʾexxxPrerequisitesCreate query in Design viewCreate form in Design viewCreate report in Design viewCreate data access page in Design view e^3 %)))))))))))))_________ : CCC0Y۟@6_@CC0Y۟C0Y۟@xNk@~TMPCLP2652812@ |@@`TTH<<<<C0Y۟@xNk@~TMPCLP2652812@ |@@`TTCC0Y۟@xNk@~TMPCLP2652812@ |@@`TTH<<<<<<: `[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@[@4@zO@Rooms2@888,,,,,,,* @U[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@BBB66666[[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@BBB66666664 [@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@BBB66666664 @QN&F@Qlĵ[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@BBB66666664 [[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@BBB66666664 [[[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@BBB66666664 @[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@BBB66666664 @[[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@B[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@BBB66666664 @[[[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@BBB66666[[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@BBB66666664 @[@4@zO@Rooms2@888,,,,,,,* @U@O3uN@Professors2@BBB66666664 @QN&F@Qlĵ@Prerequisites2C@HHH<<<<<<<: @&;-N@oN@MSysAccessObjects2DDDDDDDDDDB @@enrollments2@ DDD88888886 @j@agnN@Catalog Courses2@|LLL@@@@@@@> @-A#@A#@~sq_cstudentsWenroll~sq_cenrollments Subform24MR2KeepLocal Tzzzzzzzx @ FVY =U=U=U=U[students].[Year]0 =U[students].[Yea=U[students].[Year]0=U[students].[Year]0 g=U[students].[=U[students].[Year]0 g==U[students].[Year]0 g==U[students].[Year]0 g=U=U[students].[Year]0 g=U=U[students].[Year]0 g=U=U[students].=U[students].[Year]0 g==U[students].[Year]0 g==U=U=U[students].[Year]0=U[students].[Year]0=U[students].[Year]0=U[students].[Year]0 g==U[students].[Year]0=U=U=U[students].[Year]0=U[students].[Year]0=U[students].[Year]0=U[students].[Year]0 g==U[students].[Year]0=U=U=U=U[students].[Year]0 =U[students].[Yea=U[students].[Yea=U[students].[Year]0=U[students].[Year]0 g==U[students].[Year]0 g=U[students].[Year]0 g=U[students].[Year]0 g=U[students].[Year]0 g=U 9student9student9students!!! 9 9student9student9student9students!!! 99student9student9student9students!!! 99student9student9student9students!!! 99student9student9student9students!!! 9 9student9student9student9students!!!9student9student9student9students!!! 9student9student9student9students!!! 9student9student9student9students!!! 9student9student9student9students!!! 9 /[Sections].[Section]3 g/[Sections].[Section]3 /[Sections].[Section]3 g/[Sections].[Section]3 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 t? @U@U@U@U[Catalog Courses].[Course#]:@U[Catalog Courses].[@U[Catalog Courses].[Course#]: g@UCatalog C@U[Catalog Courses].[Course#]: g@U ?U@ ?U@  '??U@ ?U@  '?UE?U@  '??U@  '?UExpr5room "O 113"8# ??U@  '?UExpr5room ?U@  '?UExpr5room?U@  '?UExpr5ro?U@  '?UEx?U@  '?UExpr5?U@  '?UExpr5room?U@  '?UExpr5?U@  '?U > U> U> U> Uenrollments_1.section> Uenrollments_1.sectionID6 g> > Uenrollments_1.sectionID6 g> Uenrollme> Uenrollments_1.sectionID6 > Uenrollments_1.sectionID6 g> Uenrollme> Uenrollments_1.sectionID6 g> Uenrollments_1.sectionID6 > Uenrollments_1.sectionID6 g>U =USectionsenrollmentsb@ =USectionsenrollmentsb@ C7!=USectionsenrollmentsb@ =USectionsenrollmentsb@ =USectionsenrollmentsb@ C=USectionsenrollmentsb@ C=USectionsenrollmentsb@ C=USectionsenrol=USectionsenrollmentsb@ =USectionsenrollmentsb@ =USectionsenrollmentsb@ =USectionsenrollmentsb@ =USectionsenrollmentsb@ =USectionsenrollmentsb@ =USectionsenrollmentsb@ =USectionsenrollmentsb@ =USectionsenrollmentsb@ =USectionsenrollmentsb@ =USectionsenrollmentsb@ =USectionsenrollmentsb@ C=USectionsenrollmentsb@ C7=USectionsenrollmentsb@ C=USectionsenrollmentsb@ C7!=USectionsenrollmentsb@ C7=USectionsenrollmentsb@ C7! ==USectionsenrollmentsb@ C7! ==USectionsenrollmentsb@ C7! =USectionsenrollmentsb@ C7!   @-A-C-D-E-F-B/R/R/R/R/R/R/R/R/R/R/R/R/R/R/R/R/R/R9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)9)=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K=K>">">">">">">">">">">">"?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(?"(K #?")?")?")?")?")?")?")?")?")?")?")?")?")?")@"8@"8@"8@"8@"8@"8@"8@"8@"8@"8@"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%#C%#D%2D%2D%2D%2D%2D%2D%2D%2D%2D%2D%2D%2D%2D%2D%2D%2D%2D%2D%2D%2E l E l E l E l E l E l E l E l E l E l E l E l E l 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&[@@@@ Mp ] SysAccessObjects)LLLLLLLLLLJ x99K&[ࡱ> p ^/:Root EntryZ۝* VBA`L9yVBAProject `L9yVBA`L9yK+,  D G2%L  0>9&<4 .!J;'5678O#=z-EAB"hF@?YM(XPQRSTUVW1H[`acdefgijlmnoq)ruvwxy{I|}~Blob PropDataTypeInfo09)L)L1@L@LBlob PropDataTypeInfo3@L@LBlob PropDataTypeInfo:7d"p˔*p˔Blob TypeInfo=PropDataRoot EntryZj* VBA`L9yVBAProject `L9yVBAK&[`L9y+,s  D G2%L  0ZG&<4 .!;'5678O#=zABJ"hF@_M(XPQRSTUVWCH[`bacdefgijl1mnoqruk)vwxy{I|}~Blob }PropDataTypeInfov14)L@LBlob  PropDataTypeInfok3LLBlob ?PropDataTypeInfoe2LLBlob PropDataTypeInfoe4L)LBlob  PropDataTypeInfoK&[o8)L)L0@L@LBlob PropDataTypeInfo+9@hRЩRBlob FTypeInfoKPropDataBlob APropDataTypeInfoe6)L)L Office\OFFICE11\MSACC.OLB#MicroWn4rl@8QGTFPSECFHBBSDEHZPEPGNKDDXUTK#6FID="{FEAC9797-44BC-471E-B0CD-5A22585D108B}" Name="university" soft Access 11.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO350.DLL#Microsoft DABlob PropDataTypeInfoe5)L)LBlob _PropDataTypeInfow10)L)L8'̔p͔Blob TypeInfo&PropData@`ystudentTasks "studentsWenroll  main FacultyTasks DeansTasksK&[ students1studentsRooms&Enter New Course:,enrollments Subform2,enrollments Subform1*enrollments Subform"Catalog CoursesAdminTasksSecCB0 2CB0 2CB0 1CB014CB0d enrollnrollments Subform2 studentID Student IDͬN?]ΩP)PageHeaderDetailPageFooterReportHeaderReportFooterGroupHeader0GroupFooter1GroupHeader2GroupFooter3 GroupHeader4 GroupFooter5m Sections_YearSections.Yeard Sections_Year_LabelSections.Year Labelm SemdSem_LabelSem LBlob VPropDataTypeInfo/13)L)LPROJECTwmAcessVBAData Forms YL@L0LL6pPjPjBlob =TypeInfopPropDataBlob ,PropDataTypeInfo12)L)LBlob PropDataTypeInfoe1LLBlob K&[m PropDataTypeInfo)DirData"Blob aPropDataTypeInfox7)L)L56L6LBlob (PropDataTypeInfooHelpContextID="0" VersionCompatible32="393222000" CMG="CCCE3123F10FF50FF50FF50FF5" DPB="B4B6495BD942DA42DA42" GC="9C9E6173A15AA25AA2A5" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_main=kT  PROJECTBlob PropDataTypeInfos11)L)LK&[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 orm_studentsWenroll=0, 0, 0, 0, C , 0, C Frm_studentTasksForm_studentTasks 0, 0, C(>7;1Zpd5dH<>D.AccessVBAWin16~Win32MacVBA6# university.DAOstdole`VBIDEA Form_mainN _EvaluateChooseStud_ClickErr_ChooseStud_Csks tTasks Tasks studentTasks oll studentTasks enroll studentTasks enroll studentTasks nroll studentTasks tudentTasks l studentTasks SectionscekNum Credits EarnedNum Credits Earne 13CB0 12CB0 8CB0 7CB00 7CB0 6CB00 6CB00 6CB0 5CB0 4CB0 3dentTasksForm_FacultyTasksForm_FacultyTasksForm_studentsWenrollForm_studentsWenrollh XX`@`x J`@`xmain`t %X0 %V` % 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 2@L@LBlob cPropDataTypeInfo>4@L6LBlob L&PropDataTypeInfoBlob PropData 16L6LBlobK&[ Extensibtil !-@Form_studentTasksG"am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft \] $PropDataCmdbars@L@LModulesv@L@LReports@L0#RDirDataCopyPROJECT#PROJECTBPROJECTkO 3.51 Object Library*\G{00020430-0000-0000-C000-000000000046}#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#MicrosCourse__LabelCourse#_Labelm Sectiond Section_Labelm Semd Sem_Labelm Yeard Year_Labelmtimed time_Labelmstop_pointstop pointd stop_point_Labelstop point_LabelroomprofessoroCombo16d pickRoom_LabeloCombo18d PickProf_LabelMiddleMiddleStustudentTasks l studentTasks udentTasks dentTasks dentTa0@" 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  8lick. 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_FacultyTasksASeeRosterK&[_ClickRErr_SeeRoster_ClickITExit_SeeRoster_ClickForm_DeansTasks=SeeCourseCounts_ClicksErr_SeeCourseCounts_ClickExit_SeeCourseCounts_ClickForm_studentsWenroll8Command26_Click;Err_Command26_Click2i DoMenuItem&e acFormBar acEditMenu acMenuVer70XExit_CommaDirDataPropDataScripts[6L:06L6L36L6LBlob .PropData DirData$0>7;1ZpsEd5dx(eM&(x-ۊ{/h I=;E<>D.AccessVBAWin16~Win32MacVBA6# university.DAOstdole`VBIDEA 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_S[xME Blob yPropData 16L6LBlob PropData K&[PropData4Databases6L6L06L6L%*place cursor on dept field (control)Dept_Year_Labelstudents_YearDetacel[f"%LUZd`a<bc,Major_22 /:place current position on student id attributeStudent ID )+-/147find in db the right student=[FindStud]1020-1-1  )put cursor back on my combo boxFindStudDetached22close current form -10open the main menumain0-10fg37jghrialn= Arialo3A Arialp422 =MOQSnewCourseopen in add mode so cannot update existing recordsCatalog Courses000 02go to position for new record2Catalog Courses5 ScheduleZreport leading to unnormalized rooms design>Relationships for UNIV2000new  8CB0 7CB0 4CB0 5CB0 0CB0 1CB0 2CB0 3CB0 6CB0 9CB0`PropData 26L6LBlob CPropData _VBA_PROJECT dir$DirDataCopy\AcessVBAData tions 0CB0 1CB0 2CB0 3CB0 4CB0 5CB0 6CB0 7CB0 8CB0 9CB0 10CB0 11CB0 12CB0 13CB0 14CB0>$F ick OpenReport acPreviewoExit_SeeSched_Click+ Back_Click/Err_Back_Click`Exit_Back_ClickPickRegister_ClickErr_PickRegister_ClickExit_PickRegister_ClickForm_FacultyTasksASeeRoster_Clic K&[kRErr_SeeRoster_ClickITExit_SeeRoster_ClickForm_DeansTasks=SeeCourseCounts_ClicksErr_SeeCourseCounts_ClickExit_SeeCourseCounts_ClickForm_studentsWenroll8Command26_Click;Err_Command26_Click2i DoMenuItem&e acFormBar acEditMenu acMenuVer70XExit_Command26_ClicklC k   6Form_stu   "  *(/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 acEditMenu acMenuVer70XExit_Command26_Click`Ck  $(S<S<S<<N0{A9CE5C84-9C1B-11D3-9E07-00509508298F}h p`MI`AR PROJECTwm3PROJECTPropDataCopy0PropDataCopyDirDataPropDataScripts[6L:0x6L6Leading to unnormalized students design3 unnormalized students  3CB0 2CB0 4CB0 4CB0 4CB0 4CB0 7CB0 8CB0 8CB0 9CB0 22fill the whole screenopen main menumain0-10  5Catalog_Courses_DeptCatalog Courses_Deptm6Catalog_Courses_Course_Catalog Courses_Course#m7Titlem8Descriptionm9Credits:PageFooterSectionm;Text51m<Text52=ReportFooterSchedulero K&[sterXbreport leading to unnormalized students design3breport leading to unnormalized students design3ort lͬjDUEZDetaild Label0h NewCourseh BackMainMSShared\VBA\0=Babc e gG@Catalog CoursesCatalog CoursesAriald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5` FormHeader`8Detailm7U`axbceDeptDeptd5U`<axbc Dept LabelDept336L6LBlob .PropData DirDataw1$ Dept_Labelm7U`abcekCourse#Course#Course_d5U`<abc Course# LabelCourse# Course__Labelm7U`aHb ce kTitleTitled5U`<aHbc Title LabelTitle Title_Labelm 27U`abcHe k Description Descriptiond5U`<abcDescription Label DescriptionDescription_Labelm07U`apbXceXkCreditsCreditsd5U`<apbc Credits LabelCredits Credits_Label` FormFooter@ @0 ͬ GZDetailFormHeaderFormFootermDeptd Dept_LabelDept LabelmCourse_Course#d Course__LabelCourse# LabelmTitled Title_LabelTitle Labelm Descriptiond Description_LabelDescription Labelm Creditsd Credits_LabelCredits LabelP @@=Babce ghj`!k fW@enrollments&enrollments Subform ArialPropData3PropData4Databases6L6L06L6Ld2e12f5g237hghMS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zijMS Sans Serif{5`hFormHeaderd5U7`<a<bcstudentID LabelstudentIDDetachedLabelstudentID_Labeld5U7`ua<bcsectionID LabelsectionIDDetachedLabelsectionID_Labeld5U7`a<b c0special permission Label$special permissionDetachedLabel0special_permission_Label K&[`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_LabelLJI3Ld`8a<bc,,Section~TMPCLP272581~TMPCLP286171~TMPCLP294301~TMPCLP302421 0CB1 1CB1 2CB1 3CB1ection_LijnDetachedLabel=ۛQNMSysDbSem_LabelSemDetachedesign3junk schedjunk rostlSections_YearDetacld5U7`ua<bcsectionID Label sectionID DetachedLabelsectionID_Labeld5U7`a<b cspecial permission Labelspecial permission DetachedLabelspecial_permission_Labeld5U7`a<bc grade Labelgrade DetachedLabel grade_Label`wDetailm7]`<a<bce studentID studentIDm7]`a<b ce kspecial permissionspecial permissionspecial_permissionm7U`a<bcekgradegradeo5WcHd<n"Section Index";"";"10";"5" SectionID sectionID Table/QuerySections` FormFooter`x`X0ͬ _ʖZDetailFormHeaderFormFootermstudentIDd studentID_LabelstudentID Labeld sectionID_LabelsectionID Labelmspecial_permissionspecial permissiond special_permission_Labelspecial permission Labelm graded grade_Labelgrade Labelo sectionID @P PROJECTwm3PROJECTPropDataCopyM0PropDataCopy0=Babce gz;@ enrollmentsenrollments SubformK&[2Ariald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5`h FormHeaderd5U7`<a<bcstudentID Label studentID DetachedLabelstudentID_Labeld5U7`ua<b csectionID Label sectionID DetachedLabelsectionID_Labeld5U7` a<b cspecial permission Labelspecial permission DetachedLabelspecial_permission_Labeld5U7`a<bc grade Labelgrade DetachedLabel grade_Label`wDetailm7U`<a<bce studentID studentIDo5U`bcud<e fh n "";"";"";"";"";"";"";"";"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"m7U` a<b ce kspecial permissionspecial permissionspecial_permissionm7U`a<bcekgradegrade` FormFooterSLS <,<<<ͬ ZDetailFormHeaderFormFootermstudentIDd studentID_LabelstudentID LabelosectionIDd sectionID_LabelsectionID Labelmspecial_permissionspecial permissiond special_permission_Labelspecial permission Labelm graded grade_Labelgrade Label %^0=Babce g @Catalog CoursesEnter New Course:Ariald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5` FormHeader` Detailm , !"#$%&'()*+4-./01256789:;<=>?@ABCDEFGHI7U`axbceDeptDeptd5U`<axbc Dept LabelDept Dept_Labelm7U`abcekCourse#Course#Course_d5U`<abc Course# LabelCourse# Course__Labelm7U`aHb ce kTitleTitled5U`<aHbc Title LabelTitle Title_Labelm 27U`abcHe k Description Descriptiond5U`<abcDescription Label DescriptionDescription_Labelm07U`apbXceXkCreditsCreditsd5U`<apbc Credits LabelCredits Credits_Label` FormFooter GoTo_' Dim stDocAs Syng 8nt Of Enroll Byd.OpenReportG, ac[viewExit': Aͬ =^ZDetailFormHeaderFormFootermDeptd Dept_LabelDept LabelmCourse_Course#d Course__LabelCourse# LabelmTitled Title_LabelTitle Labelm Descriptiond Description_LabelDescription Labelm Creditsd Credits_LabelCredits Label(_VBA_PROJECT dir$DirDataCopy J\AcessVBADataK&[  , !"#$%&'()*+4-./01256789:;<=>?@ABCDEFGHIK0=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 nd26_ClickH   eCounts_ClicksErAutoExecBackToMainCoursesfindstdo unnormalized stunts design3breport leading t 0CB1 1CB1 2CB1 3CB1design2"All EnrollmentsHCount Of Enroll By Dept and CourserosterXBack 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_LabelMajolLJI3Ld`8a<bc,,Section~TMPCLP272581~TMPCLP286171~TMPCLP294301~TMPCLP302421 0CB1 1CB1 2CB1 3CB1ection_LijnDetachedLabel=ۛQNMSysDbSem_LabelSemDetachedesign3junk schedjunk rostlSections_YearDetacr 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`30=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 CourPropDataCmdbars@L@LModulesv@L@LReportsh@L0#R0:<=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 Root EntryZ_@VBA`L_VBAProject`L_VBA`L_ 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 BalancFHDK&[v2345678OPQRSTUVW^`btachdefgikjlpmnoqsruzvwxy{|}~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`?A E J$3NSPQRTWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~cdefghijklnopstuvy{|}~tudentsWenrollForm_studentsWenrollZVB_Name = "Form_main" " Bas0{A9CE5C84-9C1B-10=Babe ghXiJjq%kNr@Ariald2hgh MS Sans Serif`@ Detaild5U`ab cdLabel0Administrativeh1U`abVc NewCourse New CourseCourses.newCourseh1U`l abciBackMain Back To Main BackToMainCmd.0Open}, AstI$ExiztN*:; rUResu@RC EndCXPickXA)GPWτBlob yPropData 1w{6L6LBlob | 22close current form -10open the main menumain0-10fg37jghrialn= Arialo3A Arialp422 =MOQSnewCourseopen in add mode so cannot update existing recordsCatalog Courses000 02go to position for new record2Catalog Courses5 PropData# 2~6L6LBlob $CPropData#K&[* %*place cursor on dept field (control)Dept_Year_Labelstudents_YearDetacel[f"%LUZd`a<bc,Major_22 /:place current position on student id attributeStudent ID )+-/147find in db the right student=[FindStud]1020-1-1  )put cursor back on my combo boxFindStudDetached3}6L6LBlob +.PropData0 DirData1\kT  PROJECTbPropData30PropData4Databases6L6L06L6LBlob DirData5CustomGroups6L6LDataAccessPages 6L6L9@hRЩRBlob VFTypeInfo]KPropData\, 8, Ver70 6 Exit%:6)2T MsgBox7.Descri ptionCRe{ }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];  ХJJJJJJJZ 1 g @AAEXN@0fN@junk enrollments not 2[[B@B@[B@B@Relation[B[[[B@B@Relationships for UNIV2000new2\\\\\[[B@B@Relationships for UNIV2000new2\\\\\[B@B@Relationships for UNIV2000new2\\\\\[B@B@Relationships for UNIV2000new2\\\\\[B@B@Relationships for UNIV2000new2\\\\\[B@B@Relationships for UNIV2000new2\\\\\[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z 8[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z 8[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z 8[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z 8k;@k;@~sq_fstuden[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z 8k;@k;@~sq_fstudents124MR2[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z 8k;@k;@~sq_fstud[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z 8k;@k;@~sq_fstudent[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z 8k;@k;@[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z 8k;@k;@~sq_fstudents124MR2[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z 8k;@k;@~sq_fstudents124MR2[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z 8k;@k;@~[B@B@Relationships for UNIV2000new2\\\\\\\\\\Z .@@~sq_drosterX~sq_dsectionID24MR2KeepLocal TVVVVVVVT @ݿ@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 m`@zNtN@students2 @>>>22222220 @aI '@a³@Sections2@>>>22222220 @ 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>6c r@@ @ @G*pl G*pl [First]&G*pl [First]& gGG*pl [First]& gG*pl F *plF *plF *plF *plSections.sectionID1 F *plSections.sectioF *plSections.sectioF *plSections.sectionID1F *plSections.sectionID1 'FF *plSections.sectionID1 F *plSections.sectionID1 F *plSections.sectionID1F *plSections.sectionID1 'F *plF *plSections.sectionID1 F *plSections.sectionID1 'F *F *plSections.sectionID1F *plSections.sectionID1 F *plSections.sectionID1 'FF *plSections.sectionID1 'F *plSections.sectionID1 'F *plF *plSections.sectionID1 'F *plsF *plSections.sectionID1 F *plSections.sectionID1F *plSections.sectionID1 'F *plF *plSections.sectionID1F *plSections.sectionID1F *plSections.sectionID1 'F *plSections.sectionID1 'FF *plSections.sectionID1 'FF *plSections.sectionID1 'F *F *plSections.sectionID1 'F F *plSections.sectionID1 'F *plF *plSections.sectionID1 'F *plF *plSections.sectionID1 'F *plF *plSections.sectionID1 'F *plF *plSections.sectionID1 'FF *plSections.sectionID1 'F*pl E *plE *plE *plSections.Year, 'EE *plSections.Year,E *plSections.Year, 'EE *plSections.Year, 'E *plE *plSections.Year, 'E *plSectioE *plSections.Year, 'EE *plSections.Year, E *plSections.Year, 'E *plSections.Year, 'E *plSections.Year, 'E *plSections.Year, 'EE *plSections.Year, 'E E *plSections.Year, 'E *E *plSections.Year, 'E *plE *plSections.Year, 'E *pE *plSections.Year, 'E *plE *plSections.Year, 'E *plE *plSections.Year, 'E *plSections.Year, 'EE *plSections.Year, ' 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 kiokio jD @ @ J*pl J*pl J*pl [Sections].[Year]0 J*pl [Sections].[YeaJ*pl [Sections].[YeaJ*pl [Sections].[Year]0J*pl [Sections].[Year]0 gJ*pl [Sections].[Year]0 gJ*pl [Sections].[Year]0 gJJ*pl [Sections].[Year]0 gJJ*pl [Sections].[Year]0 gJJ*pl [Sections].J*pl [Sections].[Year]0 gJJ*pl [Sections].[Year]0 gJJ*pl [Sections].[Year]0 gJ*pl [Sections].[Year]0 gJJ*pl [Sections].[Year]0 gJJ*pl [Sections].[Year]0 J*pl [Sections].[Year]0 gJ*pl I*plstudentI*plstudentI*plstudentsenrollmI*plstudentsenrollmentI*plstudentsenrollmentsd@ I*plstudentsenrollmentsd@ I*plstudentsenrollmentsd@ I*plstudentsenrollmentsd@ I*plstudentsenrollmentsd@ I*plstudentsenrollmentsd@ I*plstudentsenrollmentsd@ C7!I*plstudentsenrollmentsd@ I*plstudentsenrollmentsd@ I*plstudentsenrollmentsd@ CI*plstudentsenrollmentsd@ CI*plstudentsenrollmentsd@ CI*plstudentsenrolI*plstudentsenrollmentsd@ I*plstudentsenrollmentsd@ C7! I*pl H*plstudentH*plstudentH*plstudents QueryenrollmH*plstudents QueryenroH*plstudents Queryenrollmentsp@H*plstudents QueryenrollmentspH*plstudents QueryenrollmentspH*plstudents QueryenrollmentsH*plstudents QueryenrollmentsH*plstudents QueryenrollmentspH*plstudents QuerH*plstudents QueryenrollmentsH*plstudents Queryenrollmentsp@H*plstudents Queryenrollmentsp@H*plstudents QueryenrollmentspH*plstudents QueryenrollmentspH*plstudents QuerH*plstudents QueryenrollmentH*plstudents Queryenrollmentsp@OC- H*pl G*pl [Balance Due],G*pl [Balance Due],G*pl [Balance Due],G*pl [Balance Due],G*pl [Balance Due], gGG*pl [Balance Due],G*pl [Balance Due], G*pl [Balance Due], g $E%FE%FE%FE%FE%FE%FE%FE%FE%FFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlFlGlJ 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 tHStTtITTTTTTTTT T T T T  T T T T TTtJUU#U$U%U&U'U(U)U*U+U,U-U.U /U 0U 1U2U4U 3UW5W7W8W9W6 g >Z @ @ @T0students!!! T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)C7!T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)CT0studentsenrollmentsd@)CT0studentsenrolT0studentsenrollmentsd@)T0studentsenrollmentsd@)C7! TFil TFil TilTFil Til TFil TilTFil TilTFil TilTFil TilTFil TFil Til GTFil Til GTFil Til GSTFil Til GS TFil Til GS TFil Til GS TFil Til GS TFil Til GS TFil Til GS TFil Til GS DTFil Til GS DTFil Til GS DTFil Til GS DTFil TFil S DS DS DS DCount(enrollmS DCount(enrollments.sS DCount(enrollments.studentID)= /SSectionS DCount(enrollments.studentID)=S DCount(enrollments.studenS DCount(enrollments.studentID)=S DCount(enrollments.studentID)=S DCount(enrollments.studeS DCount(enrollments.studenS DCount(enrollments.studenS DCount(enrollments.studenS DCount(enrollments.studentIDS DCount(enrollments.studentID)= /SS DCount(enrollments.studentID)=S DCount(enrollments.studenS DCount(enrollments.studentID)=S DCount(enrollments.studentID)=S DCount(enrollments.studeS DCount(enrollments.studenS DCount(enrollments.studenS DCount(enrollments.studenS DCount(enrollments.studentIDS DCount(enrollments.studentID)= /S 0  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 QvcP=*z @ -  } j C 0  m Z G ɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪɪY  Y Y  Y2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 2 2 ϒ8ka,UN t943UU#qh/z2 2 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  LVAL @ @ @ @άB0Catalog CoursesProfessorsά"&qenrollments qenrollments_1ʾCatalog CoursesάB0Catalog CoursesProfessorsά"&qenrollments qenrollments_1 LVALl } j C 0  m Z G  @ @ @ @ @ @ @ @ @ @ @MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationReplicableUseTransactionC <      MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR24ODBCTimeoutMaxRecords" < MR24ODBCTimeoutMaxRecords" < MR24ODBCTimeoutMaxRecords" < MR2BValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCMR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: < MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOn1 <   MR2ODBCTimeoutMaxRecordsRecordLocksRecoMR2ODBCTimeoutMaxRecordsRecordLocksRecoMR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOn1 <   MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationReplicableUseTransactionC <      MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR24ODBCTimeoutMaxRecords" < 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 Salle| GvcP<) y  e R ? ˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵˵ˢ +  ' 2 ' 2 & 3|VHa,UN;46z43UU#qE: l)0l]GI' 2 ' 2 & 3|VHa,UN;46z43UU#qE: l)0l]GI' 2 ' 2 & 3|VHa,UN;46z43UU#qE: l)0l]GI' 2 ' 2 ' 2 & 3|VHa,UN;46z43UU#qE: l)0l]GI' 2 ' 2 & 3|VH& 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp & 3|VH& 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp "2 "ϒ8ka,UN t943UU#qh/za)0l]GI"2 "2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GI"2 "2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GI"2 "2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GI"2 "2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GI"2 "2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GI"2 "2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GI"2 "2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GI"2 "2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GI"2 "2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GI"2 "2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GI"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  LVAL@@@( G&qCatalog Courses qSections2qenrollmentsά yD ] rCatalog CoursesCatalog Courses8Yenrollmentsenrollments$`SectionsSections!}studentsstudents  m\PrerequisitesPrerequisites.ProfessorsProfessors{VRoomsRoomsnCatalog Courses_1Catalog CoursesulSections_1SectionsTxSections_2Sectionsz,Sections_3Sections( G&qCatalog Courses qSections2qenrollments FvccccccccccccccccccccccccccccccccccccccPγ<))) ;ϒ8k;ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp ;ϒ8k;ϒ8k;ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GI2 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 Fvcb a N M : '  v c P ɳ < ) ))) ȌȌȌȌȌȌ Y Y  Y  Y  YH2 H2 H2 G2 Gϒ8ka,UN t943UU#qh/zH2 H2 G2 G2 Gϒ8ka,UN t943UU#qh/za)0l]GIG2 F2 F2 Fϒ8ka,UN t943UU#qh/za)0l]GIF2 m2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIm2 m2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIm2 m2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIm2 m2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIm2 m2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIm2 m2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIm2 m2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIm2 m2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIm2 m2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIm2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp m2 a2 aϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp a2 [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  LVAL @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ ά&qCatalog Courses qSections( G&dCatalog Courses dSections2dstudentsdenrollments( G&dstudents denrollments( G&qSectionsά5#u0SectionsPenrollmentsά z0Catalog CoursesProfessorsLVAL н m 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    mLVALhDQ'''pe ?''' ''P 'h ' <`''''"'B'b'H'''''0'P'x'''''''`''''"'B'b'              )enrollments.sectionIDenrollments%students.Student IDstudentsstudents.Firststudents.Middlestudents.Laststudents.Yearstudents.Major'' @''p'6_@'' '' `'$ '$ '$ '$ "'$ B'$ b'$students '  ' 'X'p'zNtN@enrollmentsx 'P '` '0'p'@roster Query'' H'8' @'p' 'x' '' '' 0'' P''H')students.[Student ID]@''''0'P''$ '$ '$ "'$ B'$ b'$students ' ' '( ' '0 ' "'8 ' B'@ ' b'H '@''''0'P'`'$enrollments `'H 'H'h ' ''5[Enter Course Index Number]h ' '8'' p'8'X'x''' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' ''('''h'H'0' H'X' H'X' H'X' H'X' H'X' H'X' 'z '`''''$'' ''z 'h'('''H''8$''H''p'P''''''''  ' ' ' P' ' ' 'D '''''''@''''P''''X'0'students p' ' ' ' 'YearStudent IDPrimaryKey MajorLastenrollments P' x'  '  ' '%studentsenrollmentsstudentID%SectionsenrollmentssectionIDPrimaryKey X''@'  0' ' 0'X''  Student ID''v "'!''v P&' &'8&''8'8'q8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8''' '(''&' ' '$' 'enr LVALMR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationColumnWMR2fODBCTimeoutMaxRecordsColumnWidthColumnHidden" < S82[enrollments].[stuMR2fODMR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOn1 <   MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    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 LVAL @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @zzzzzzzzz z z z zzzʾstudents simulate bad enrollment designstudentsWenrollreport leading to unnormalized students design2Create data access page in Design viewAutoExec^3ά&qCatalog Courses qSections2qstudentsqenrollments? LVALO ollmentsH'' H'' ''"''@"'"'x"'"'' '`#'#'#'#'%Sectionsenrollments( $'#' h '65[Enter Course Index Number]$'#'#'"'<$' "'d$'8$'@$'($' '''%'8$'%studentsenrollmentsstudentsStudent IDH' ' ' 'P&'p$'&'&'&'x"''8''8'(''&'`''''(''''`''''X'0'" ЧJJJJJJJ\ndE@%F@potent\\ndE@ !k@~TMP\ndE@ !k@~TMPCLP2466912@ @THH<<<<<<<: @Z^\ndE@ !k@~T\ndE@ !k@~\ndE@ !k@~TM\ndE@ !k@~TMPCLP2466912@ @THH<<<<<<<\ndE@ !k@~TMPCLP2466912@ @THH<<<<<<<: @\ndE@ !k@~TMPCLP2466912@ @THH<<<<<<<: @Z\ndE@ !k@~TMPCLP2466912@ @THH<<<<<<<: @\ndE@ !k@~TMPCLP2466912@ @THH<<<<<<<: @Z\ndE@ !k@~TMPCLP2466912@ @THH<<<<<<<: @Z^@^@junk roster288888888886 Y u~@-~@~sq_djunk sched~sq_dsectionID2s @4MR2KeepLocal Th\\\\\\Z `X|@|@junk sched266666666664 ȑ0V@0V@MSysIMEXColumns2@@@@@@@@@@> ,V@i-V@MSysIMEXSpecȑ0V@0V@MSysIMEXColumns2@@@@@@@@@@> ,V@i-V@MSysIMEXSpecs2<<<<<<<<<<: f 2vcbO EXN@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_cstu\2 \2 \ϒ8ka,UN t943UU#qh/za)0l]GI\2 \2 \2 \ϒ8ka,UN t943UU#qh/za)0l]GI\2 \2 \2 \ϒ8ka,UN t943UU#qh/za)0l]GI\2 \2 \ϒ8ka,UN t943UU#qh/za)0l]GI\2 \2 \2 \ϒ8ka,UN t943UU#qh/za)0l]GI\2 \2 \2 \ϒ8ka,UN t943UU#qh/za)0l]GI\2 \2 \2 \ϒ8ka,UN t943UU#qh/za)0l]GI\2 \2 \2 \ϒ8ka,UN t943UU#qh/za)0l]GI\2 \2 \2 \ϒ8ka,UN t943UU#qh/za)0l]GI\2 [2 [2 [ϒ8ka,UN t943UU#qh/za)0l]GI[2 [2 [2 [ϒ8ka,UN t943UU#qh/za)0l]GI[2 [2 [ϒ8ka,UN t943UU#qh/za)0l]GI[2 [2 [ϒ8ka,UN t943UU#qh/za)0l]GI[2 [2 [2 [ϒ8ka,UN t943UU#qh/za)0l]GI[2  3|VH 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp  3|VH 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp  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  l\Profess\Profess\Profess\Professors%%% \Professors%%% \Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \ \Professors%%% \\Professors%%% \ G\Profess\Profess\Profess\Professors%%% \Professors%%% \Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \ \Professors%%% \\Professors%%% \ G\Profess\Profess\Profess\Professors%%\Professors%%% \Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%%\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \\Professors%%% \ G\\Professors%%%\Professors%%% \\Profess\Profess\Profess\Profess\Professors%%% \Fil Y GY GYSections!!! Y[Sections].[Year]0 gYY[Sections].[Year]0 gY[Sections].[Year]0 gYY[Sections].[Year]0 gYY[Sections].[Year]0 Y[Sections].[Year]0 gY  YN  Y Y Y Y  Y  L Y  DY Y  Y DY Y  Y   Y DDateDelim"DateFourDigitYear DateLeadingZerosDateOrderDecimalPointFieldSeparatorFileType SpecIDSpecNameSpecTypeStartRowTextDelimTimeDelimDDDDYPrimaryKey LVAL з  B s 6 ˪˪˪˪˪˪˪˪˪˪˪˪˪ˌ n F  j ' H 9students.[Student ID] = enrollments.studentIDSections.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 isURoomsSectionsRooms.room = Sections.roomS+ U Sections.Year, gU Sections.Sem+ gU Sections.sectionID1 gUSections.time, gUB@, gURooms.Overhead- gURooms.[Data Projector]5 gURooms.[Data Connection]6 gURooms.[Front Computer]5 gU Rooms.size) gU Rooms.room) gUSections!!! URooms U GU GU U GT<@studentsenrollmentsZ@*C7! T<@ enrollments.grade0 gT<@ "enrollments.[special permission]? gT<@ enrollments.sectionID4 gT<@ students.[Balance Due]5 gT<@ students.Hometown0 gT<@students.GPA+ gT<@students.[Num UɴʌS@NtьS@Rooms and sections - [Sections].[sectionstudents.[Student ID] = enrollments.students.[Student ID] = enrollments.studenstude(((students.Major)=[Professors]![Dept]))Se(((students.Major)=[Professors]![Dept]))(((Sectio(((students.Major)=[Professors]![Dept])) LVAL1 G O 1  z F  ʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʈ j <  b $ t6Jf-|, <,X2XrXXXXX"XBXbXxX,X X`XXXXXX0XPXxX(XHXHXHά&qstudents qenrollmentsʾstudentsά0RoomsPSectionsά0RoomsPSectionsά0RoomsPSectionsLVAL@<FDm))t} :?)8 <, $TRz,Hx@h,((((, $TRz               Rooms.room RoomsRooms.size'Rooms.Front Computer)Rooms.Data Connection'Rooms.Data ProjectorRooms.Overhead=Rooms.Numb Student WorkstationsSections.timeSections#Sections.sectionIDSections.SemSections.Year`  X xNtьS@HX(@MSy ~ti   ~s,$ ~0#~T ~`f ~m ~je ~L"~ ~R ~wsz ~Na  ~"~ RoomsP  @ yYsN@SectionsP   8hN@ARooms and sections - equiv to 1NFX@        P  X  `     @  h   +Rooms.[Front Computer] -Rooms.[Data Connection] +Rooms.[Data Projector] ARooms.[Numb Student Workstations]` @h  ~~   ~ $ ~ T ~  ~ ~~ ~ Rooms     $  T          `  R ~4 z ~  ~  ~Sections R z  @h h! 8h)x Ț x x x x x x Țh Țh Țh xh z 0P(@ (~Xx X(8Hz ( p~@X8p x X   8 pT0 xx X8phRooms h  xroomPrimaryKeySections H  X p      # LVAL3  timesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catalog CoursesSections 0x  h @ h  roomv  ##v &%'c0h!h!qh!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!' (' "x%&SectionsȚ8 x8Ț8 x8 #X#$#$# $,D$P$$T$`$$d$ X#Sections.Year $~^$$%$  #Sections.Sem%"F"L%@$h$0$$X%8H% RoomsroomȚP  xP &h%P&& P ('8'@'P'"room  #d' &'`'h'&room &P&# @ Țh! xh!xh!('P((((P((((hK&[hNh V 8 0 r  V *7ptd"p˔*p˔Blob 5TypeInfoH=PropDataGGTFPSECFHBBSDEHZPEPGNKDDXUTK:'_VBA_PROJECT Fdir ͬ 1ܟh(`G!% PageHeaderSectionDetailPageFooterSectionReportHeaderReportFooterGroupHeader0mroomdroom_Labelmsized size_Labelj Front_ComputerFront Computerd Front_Computer_LabelFront Computer_Labelj Data_ConnectionData Connectiond Data_Connection_LabelData Connection_LabeljData_ProjectorData ProjectordData_Projector_LabelData Projector_Labelj08 :<=Babc2e g͇fS@BRooms and sections - equiv to 1NFVreport leading to unnormalized rooms design Arial8 hEPSON Stylus Photo 785EPX`f odhhRL*** xhhDLLName32=E_DU12SE.DLL d &K&[2EPSON Stylus Photo 785EPX   E-winspoolEPSON Stylus Photo 785EPXUSB001d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4roomtime`ReportHeader@-8sO7FO/d25`<a<bLcdLabel18Vreport leading to unnormalized rooms design 1G^L =tf23a<b2 Line21'ۙCIz`"PageHeaderSectionAaga:b d5a<bc room_LabelroomDetachedLabeldOEc'=hd57`a<b\c size_LabelCapacityDetachedLabellvDXEZݶd5`(a<bc (Front Computer_LabelFront ComputerDetachedLabel(Front_Computer_Label6CLX:`[0d5`@a<b`c *Data Connection_LabelData ConnectionDetachedLabel*Data_Connection_Labelbm"_I >7rd5`a<bc (Data Projector_LabelData ProjectorDetachedLabel(Data_Projector_Label>#LKA d5`(a<bc Overhead_LabelOverheadDetachedLabely"P]G/0$d57`a<b\ c >Numb Student Workstations_Label2Numb Student WorkstationsDetachedLabel>Numb_Student_Workstations_Label ҴM$9Md5`(a<bc time_LabeltimeDetachedLabelB?K a8jd5`+a<b4c sectionID_LabelSection IndexDetachedLabelJlm͍Cf23b2 Line22@$QCL6(7ޟMf23ab2 Line23Dag"`GroupHeader0RFNt J ` Detail>zSME m5broomroomLunique identifier for room e.g. at134uII m05`b\ksizesizecapacityzuDj`(iFront ComputerFront Computerl'K&[Nwhether there is a computer up front for the professorFront_Computer/,Lk@99j`@iData ConnectionData ConnectionData_Connection4~D{j`iData ProjectorData ProjectorData_ProjectorCZlt|wM>O?j`(iOverheadOverhead<}@schedule Queryjunk sched Arial8 h\\ADM-SRV1\O126-HP4100?dXXLetter.HP LaserJet 4100 PCL 62xeP.Ca=~~ZD /PI <4! 6/;7܍Y993p tևm;qHv3#e2uD[-P+h9"0v>' 6OiDgC U^t;:K{}@a2F[ mR>tVR[z/:O?[RNyB~W:臌֪ g5g] \Ta 59 ܢ^IY Q`:JpF(K&[First_Labelm Student_IDStudent IDd Student_ID_LabelStudent ID_LabelmMiddledMiddle_LabeloYeardYear_Labelm54ACAB" [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 x Form_mainForm_mainForm_studentTasksForm_studentTasksForm_FacultyTasksForm_FacultyTasksForm_DeansTasksForm_DeansTasksForm_s08:<=Babc2e g^@roster Queryjunk roster Arial82h\\ADM-SRV1\O126-HP4100?dXXLetter.HP LaserJet 4100 PCL 62xeP.Ca=~~ZD /PI <4! 6/;7܍Y993p tևm;qHv3#e2uD[-P+h9"0vg gr1\db@L@LBlob PropDataacCTypeInfoDHAVTPFCOJAWTPDFCEFNJMIMEMKLJ:HOBMAVLIDOFSODAHMCNIEIODPONC:k AOGTLGLWSKDIHEUKBTZD_JAHOZOB: HQPWRRHJBCGVTXDNCFZVSNLGICNTL:,  !"#$%&'()*+-./0123456789:;<=>?@ABCDEFGIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijlmnopqrstuvwxyz{|}~>' 6OiDgC U^t;:K{}@a2F[ mR>tVR[z/:O?[RNyB~W:臌֪ g5g] \Ta 59 ܢ^IY Q`:JpF% LVALNY Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectIdMR2ODBCTimeoutMaxRecordsColumnWidthColumnHiddenRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <     C("[students].[Last]  K0*[students].[Hometown]  Q60[students].[Balance Due] U S82[enrollments].[sectionID]  eJD[enrollments].[special permission] G K0*[enrollments].[grade]  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 *  MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationColumnWidthColumnHidden: <    K0*students.[Student ID] t  ="students.First *  ?$students.Middle   ; students.Last   ; students_Year    ="students.Major   [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 *  LVALICFD)GF3 *G ;?(6F3GF3F36F3XT <\F3F3F3F3(F3jF3F3F3F3 F3:F3hF3F3F3 F3F3ZF3zF3F3F3F3HF3F3\F3F3F3F3(F3XF3xF3F3F3F3(F3hF3F3F3F3F3HF3hF3F3F3F3(F3`F3\F3F3F3F3F3F3F3F3F3F3PF3PF3PF3PF3PF3PF3PF3PF3PF3PF3F3F3F3\F3F3F3F3HF3jF3F3F3F3 F3:F3F3F3F3 F38F3ZF3zF3F3F3F3HF3F3               (                       <    %students.Student IDstudentsstudents.Firststudents.Middlestudents.Laststudents_YearYearstudents.Major5students.Num Credits Earnedstudents.GPA!students.Hometown'students.Balance Due#Sections.sectionIDSectionsSections_DeptDeptSections_Course# Course#Sections.SectionSections.SemSections_YearYearSections.timeSections.room#Sections.professor%Sections.stop point)Catalog Courses.TitleCatalog Courses5Catalog Courses.Description-Catalog Courses.Credits0F3 F3` F3F3F3N$@L F30 F34|4 F3 F34|4 F3 F34|4 F3 F34|4F3|4|F3|4|F3|4|F3|4|(F3|4|jF3|4|F3|4|F3|4|F3|4| F3|4| :F3|4| hF3|4| F3|4| F3|4|  F3|4|F3|4|ZF3|4|zF3|4|F3|4|F3|4|F3|4|HF3|4|F3|4|Catalog Courses`F3F3@F3+F3F3agnN@SectionsF3  F3F3*F3F3N@students@F3   F3(F3P(F3F3zNtN@enrollmentsF3F3F32F3F3' QN@estudents and sections and courses join equiv to 1NF0 F3 F3 F3 F3 F3F3 F3F3 F3 F3 F3(F3 (F30F3 XF38F3 @F3F3 F3F3 F3F3  F3F3 (F3F3 hF3F3 F3F3 F3F3 F3F3 F3F3 HF3F3 hF3F3 F3F3  F3HF3 PF3F3 F3F3 F3F3)students.[Student ID]F3F3F3F3(F3XF39students.[Num Credits Earned]@F3F3F3+students.[Balance Due]F3(F3hF3F3F3F3F3HF3hF3F3)Sections.[stop point]F3-[Catalog Courses].TitlePF39[Catalog Courses].DescriptionF31[Catalog Courses].CreditsF3MF3|HF3|F3|Catalog Courses tF3hF3 F3pF3 F3xF3PF3F3F3:F3| F3|  F3|ZF3|zF3|F3|F3|Sections :F3HF3 zF3PF3 F3XF3 F3`F3 F3hF3LVAL *F3pF3 ZF3xF3 zF3F3 F3F3 F3F3(F3hF3F3F3F3F3HF3hF3F3F3 F3|~F3|8F3|F3|jF3|F3|F3|F3| F3| students F3HF3 F3PF3 F3XF3 F3`F3 :F3hF3 jF3pF3 F3xF3 F3F3 F3F3 F3F3F3F3F3F3(F3XF3@F3F3F3F3enrollments F3;F3-F3 F38F3F3F3XF3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3(F3GF3.F3!ȚF3P(F3 ȚF3P(F3 ȚF3P(F3 ȚF3P(F3 ȚF3P(F3 ȚF3P(F3 xF3P(F3 xF3P(F3 ȚF3P(F3 xF3P(F3  ȚF3*F3 ȚF3*F3 ȚF3*F3 ȚF3*F3 ȚF3*F3 xF3*F3 ȚF3*F3 ȚF3*F3 ȚF3*F3 xF3*F3  ȚF3+F3 F3+F3 $xF3+F3 F3z 1F35F3FF32F34F34F3| F3H#F3#F3h)F3#F3x)F3#F3)F3($F3)F3`$F3)F3$F3)F3$F3)F3%F3)F3@%F3)F3F3z h0F34F3XFF30F3p4F34F305F3(| F3x%F3)F3%F3 +F3%F30+F3 &F3@+F3X&F3P+F3&F3`+F3&F3p+F3'F3+F38'F3+F3p'F3+F3F3z /F36F3 FF3/F3`5F305F3|0 F3'F3+F3 'F3,F3(F3,F3 H#F3 #F3 #F3 #F3 ($F3 `$F3$F3$F3 (%F3@%F3  x%F3 %F3 %F3  &F3 X&F3&F3 &F3 'F3 8'F3p'F3 <'F3 'F3(F3l/F3/F3/F3 /F3(/F30/F38/F3@/F3H/F3P/F3X/F3`/F3h/F3p/F3x/F3/F3/F3/F3/F3/F3/F3/F3/F3h4F34F35F36F3H#F3#F3#F3#F3($F3`$F3$F3$F3%F3@%F3x%F3%F3%F3 &F3X&F3&F3&F3'F38'F3p'F3'F3'F3(F3-+F3*F3P(F32F3Catalog Courses 00F3 H0F3 X0F3PrimaryKeyDept Course#Sections  1F3  01F3 H1F3 h1F3 x1F3  1F3 1F3  1F3timesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catalog CoursesSectionsstudents x2F3 2F3 2F3 2F3 2F3YearStudent IDPrimaryKey MajorLastF3z 3F3FF34F3| F3enrollments *F3 4F3 P(F34F3h4F3  2F3 04F3 2F34F3X/F3  PrimaryKey4F3  2F3 4F3 2F35F3/F3  Student ID LVALN  +F3@5F3`/F3  h/F3  *F3p5F35F3  6F3  +F3 5F3+F3 5F3PrimaryKey06F3F3v X=F3@=F3F3v (>F3=F3@F3F3v p@F3@@F3BF3F3v BF3BF3DF340XTF3;F3;Fq3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3PEF3 F3EF3DF3 hF3=F3`>F3>F3>F3>F3F3 7F3?F3?F3?F3?F3%studentsenrollments  X=F3?F3 ?F3?F3?F3?F3>F3%studentsenrollmentsSectionssectionIDȚF38F3 ȚF38F3 ȚF38F3 xF38F3p@F3@F3@F3PAF3@F3`AF3AF3pAF3F3 8F3BF3 (BF30BF3@BF3sectionID  `>F3TBF3 AF3|BF3PBF3XBF3AF3sectionIDCatalog CoursesPrimaryKeyȚF39F3 ȚF39F3 xF39F3BF3BF3 CF3CF3XCF3CF3F3 9F3@DF3 XDF3pDF3DF3"PrimaryKey @F3  @F3DF3 CF3DF3DF3DF3CF3PrimaryKey X=F3  p@F3XCF3AF3=F3>F3 @  @ ȚF3;F3 ȚF3;F3 xF3;F3xF3;F3xF3;F3xF3;F3EF3DF3EF3GF3 FF3GF3XFF3 GF3FF30GF3FF3@GF3 FF3PGF3XFF3`GF3FF3pGF3FF3GF3+F3*F3P(F32F3LVALLFDH+F7.H+ ";?`!F7H+F7F7!F7@7 <42F7`F7F7F7F7"F7BF7bF7F7F7F70F7hF74 F7`F7F7F7F7F70F7PF7pF7F7F7F7HF74HF7HF7HF7HF7HF7HF7HF7HF7HF7HF7F7F7F742F7F7F7F7F7"F7BF7bF7F7F7F70F7hF7                    <    #Sections.sectionIDSectionsSections_DeptDeptSections_Course# Course#Sections.SectionSections.SemSections.YearSections.timeSections.room#Sections.professor%Sections.stop point)Catalog Courses.TitleCatalog Courses5Catalog Courses.Description-Catalog Courses.Creditsx F7  p F7HF7 F7xF7I$@,8F7XF7|(F7@F7|2F7||Z`F7||F7||F7||F7||"F7|X=F3BF7|-bF7|enF7|udF7|] F7|(>F3 0F7|1 hF7|ll Catalog Courses F7` F7 F7PF7xF7agnN@SectionshF7  F7PF7F7xF7N@]Sections and courses join Query - equiv to 2NFXF7@F7 F7 F7 `F7( F7 F70 F7 F78 F7 F7@ F7 F7H F7 0F7P F7 PF7X F7 pF7` F7  h F7 F7 F7 F7 F7 F7 F7X F7 F7`F7F7F7F7F70F7PF7pF7)Sections.[stop point]h F7-[Catalog Courses].Title F79[Catalog Courses].Description F71[Catalog Courses].Credits F7MF7|X# 0F7|Se thF7|.Y aCatalog Courses F7F7 F7F7 D F7F7 F7 F7 F72F7|F7||F7||"F7||BF7||bF7||F7|F7|Se Sections 2F7F7 rF7F7 F7F7 F7F7 F7F7 "F7F7 BF7F7 bF7F7 F7F7 F7F7 F7`F7F7F7F7F70F7PF7pF7h F7 F7$F7F7 xF78F7pF7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7X+F7pF7ȚF7F7 ȚF7F7 ȚF7F7 ȚF7F7 ȚF7F7 xF7F7 ȚF7F7 ȚF7F7 ȚF7F7 xF7F7  ȚF7PF7 F7PF7 $xF7PF7 F7z F7*F7F7h F7|@F7F7F7F70F7F7hF7F7F7F7F7F7F7F7HF7F7F7 F7F70F7F7z @F7H!F7x*F7`F7 F7h F7|XF7LVALN  /a6pWI@%I@prw_tblLogrXs@BBB66666664 @C@ D@prw_tblHistoryrX@JJJ>>>>>>>< @|?@A@Paste ErrorsrX::::::::::8 F9@{k9@og_TblValuesAndLabelsrX@XXXLLLLLLLJ @4@>5@og_TblTemprX@PBBB66666664 @2@2@NORM_tblMULockrX@JJJ>>>>>>>< @J*@+@mx_TblImexColsrX)@JJJ>>>>>>>< @'@1[(@mlbl_tblUserSizesrXq@PPPDDDDDDDB @e@%!@mlbl_tblRepPropertiesrXd@XXXLLLLLLLJ @@S@mlbl_tblMailingLabelPreferencesrX@Plll```````^ @Qx@S@mlbl_tblLabelSizesrX@PRRRFFFFFFFD @ L @D @mlbl_qryUserLblListrX*@P|@(`TTHHHHHHHF @ @@mlbl_qryLblListrX@|@(XLL@@@@@@@> @M1@җ@LBWiz_tblValLstrX@BLLL@@@@@@@> @C+)@ @im_TblInputMaskrXs@BLLLF7@F7 (F7hF7`F7xF7  F7 F7 0F7 hF7 F7F7 F7 HF7 F7F7 <F7 (F7`F7\<F7F7F7F7F7F7F7F7F7F7 F7(F70F7!F7@!F7F7F70F7hF7F7F7F7HF7F7F7F7(F7`F7%PF7F7Catalog Courses F7 F7 F7PrimaryKeyDept Course#Sections F7  F7 F7 F7 F7   F7 ( F7  8 F7timesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catalog CoursesSections PF7x F7F7  F7  F7 F7!F7  @!F7  PF7  F7PF7 !F7PrimaryKeyh!F7F7v %F7%F7F7v ('F7&F7)F74]0@7F7$F7$Fq7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7)F7 F7)F70)F7 p%F7F7!F7(F7SectionsȚF7!F7 ȚF7!F7 xF7!F7xF7!F7%F7F7&F7&F7@&F7&F7x&F7&F7Catalog CoursesPrimaryKeyȚF7#F7 ȚF7#F7 xF7#F7('F7&F7`'F7'F7'F7'F7F7 #F7(F7 (F7(F7(F7"PrimaryKey %F7  &F7(F7 (F7(F7(F7(F7'F7PrimaryKey %F7 &F7@&F7'F7x&F7 @ @ @ȚF7$F7 ȚF7$F7 xF7$F7xF7$F7xF7$F7)F7)F7*F7*F7@*F7*F7x*F7+F7*F7+F7x*F7(+F7*F78+F7PF7F7 LVALNU0?DwdhʾexxxProfessorsSections and courses join Query - equiv to 2NFstudentsWenrollreport leading to unnormalized students design3ά%Q&qSections qenrollmentsʾexxxProfessorsSections and courses join Query - equiv to 2NFstudentsWenrollreport leading to unnormalized students design3ά%Q&qSections qenrollmentsv1 Qbid^^`QbmkQufdimkfQMYSYMJmYdbzzzzz 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 TTTUUUVVV !"#$%&;<=ABC&&&&Q'Q(Q)U*U+U,[-[.[/a6a7a8m<m=m>zzzz zz zzzz!z"z# qY N66Y Y  Y ~Y Y Y Y Y AttributesDataTypeFieldNameIndexTypeSkipColumn SpecID Start WidthYY Index1PrimaryKeyϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 V2 Vϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp V2 U2 Uϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp U2 T2 Tϒ8ka,UN t943UU#qh/za)0l]GI,V@i-V@MSysIMEXSpecs2<<<<<<<<<<: V͇fS@͇fS@report leading to unnormalized rooms design2xxxxxxxxxxv UɴʌS@NtьS@Rooms and sections - equiv to 1NF2@<@@||pddddddb `T΋wP@TH{P@simulate bad enrollment design2@@vjj^^^^^^^\ @S8pN@qN@section enrollment counts Query2@ @xll```````^ @GC[@S[@students Query2Z@JJJ>>>>>>>< @v1 kmoOQbmYO2Ydb4kmoOQbmYO2kmoOQbmYO2kmoOQbmYO2idd`'kYxQ(idd`'kYxQ(idd`'kYxQ(vQJivQJizzz$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 TTTUUUVVV !"#$%&;<=ABC&&&&Q'Q(Q)U*U+U,[-[.[/a6a7a8m<m=m>zzzz zz zzzz!z"z# 2 4 4<5---;AAAf ϭFn̄N  Enrollments Export Specification/:.,'YUSQOMKKKG  Prerequisites Export Specification/:.,']YWUSQOOOK  Rooms Export Specification/:.,'MIGECA???;  Professors Export Specification/:.,'WSQOMKIIIE  Rooms Export Specification/:.,'MIGECA???;  Sections Export Specification/:.,'SOMKIGEEEA  Students Export Specification/:.,'SOMKIGEEEA  CatalogCourses Export Specification/:.,'_[YWUSQQQM 6                  DataTypemx_TblImexColsDataTypemx_TblImexCols.DataTypeVF**  SkipColumnmx_TblImexColsSkipColumnmx_TblImexCols.SkipColumn^J..  IndexTypemx_TblImexColsIndexTypemx_TblImexCols.IndexTypeZH,,  Widthmx_TblImexColsWidthmx_TblImexCols.Widthr  CreditsCatalog CoursesCreditsCreditsbTFA junk ;A junk  Numb Student Workstation Numb Student Workstatio Numb Student Workstatio <grade  2special permission 2special permission511  studentID#  LVAL. NppppacCmdUndosGacCmdInsertLookupFieldrGacCmdCompileLoadedModules!qGacCmdTransparentBorderpGacCmdTransparentBackground"oGacCmdPropertiesnGacCmdTileHorizontallymGacCmdDocumenterlGacCmdAnalyzeTablekGacCmdAnalyzePerformancejGacCmdDatasheetViewiGacCmdFor8JacDataAccessPageBrowseGacCmdMicrosoftScriptEditor"GacCmdSaveAsDataAccessPage!GacCmdDemoteGacCmdGroupByTableGacCmdPromoteGacCmdDataAccessPageDesignView%GacCmdEditTriggersGacCmdConnectionGacCmdDiagramDeleteRelationship&GacCmdDiagramNewTableGacCmdDiagramLayoutDiagram!GacCmdDiagramLayoutSelection#GacCmdDiagramAutosizeSelectedTables*GacCmdDiagramRecalculatePageBreaks)GacCmdDiagramViewPageBreaks"GacCmdDiagramModifyUserDefinedView)GacCmdDiagramShowRelationshipLabels*GacCmdDiagramAddRelatedTables$GacCmdDiagramNewLabelGacCmdZoomSelectionGacCmdViewTableUserViewGacCmdViewTableKeysGacCmdViewTableColumnProperties&GGacCmdRemoveGacCmdHidePaneGacCmdViewTableNameOnlyGacCmdViewTableColumnNames!GacCmdQueryAddToOutputGacCmdQueryGroupByGacCmdViewVerifySQLGacCmdViewShowPaneGridGacCmdViewShowPaneDiagram GacCmdViewShowPaneSQLGacCmdViewViewsGacCmdViewStoredProcedures!GacCmdViewDiagramsGacCmdViewFieldListGacCmdNewObjectDiMR2ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlacesu ` XRooms.size DESC, Rooms.[Front Computer] DESCroom   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   mLVAL} HFD8GF8j p~?#G8GG$GGG <hGGGGRGGGHGGGG@GxGGxGxGxG(G`G`G`GhGGGGRGGG     <         'Catalog Courses.DeptCatalog Courses-Catalog Courses.Course#)Catalog Courses.Title)enrollments.sectionIDenrollmentsSections.timeSectionsSections.room#Sections.professor G G GGG.PA@@G`G 0GHG G0GGG hG0 G0 G0 G0 RG0 G0 G0!Catalog Courses GX G GGGagnN@Sections G   G GhGGN@studentsG  hGhGGzNtN@enrollmentsGGG@GG' QN@schedule Query`GHG0GG G G G G G0 G G8 G @G@ G xGH G GP G+[Catalog Courses].Dept G5[Catalog Courses].[Course#] G-[Catalog Courses].Title GG@GxGG hG0?G0G0Catalog Courses G G G G $ G G G G G?RG0olmG0 G0D Sections RGPG GXG G`G@GxGGstudentsG0enrollments GGGGGG`GGG3[What is your first name?]G1[What is your last name?]GPG Gp(GG G8GXGxGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG(G9G(G GG GG GG G@G GhG GhG GhG Gz Gp#G7GG@#G"Gp4`GpGGGGG GGz  G88G G!G8GG0GGz PGx"G8GhG"G!G"G5HGPGXGGGGG pG G <G  G PG G GD(pGxGGGGGGp"G"G8#GpGGGGPGGG GhG@GCatalog Courses G 0G @GPrimaryKeyDept Course#Sections  G   G 0 G P G ` G   G  G  GtimesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catal #YZYZYZYZYZYZYZYZYZYZ\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\dParentId = 251658241 and Type = 6 and Connect Is NullLVAL<V P L ` : og CoursesSectionsenrollments `!G !G  !G  !G !G%studentsenrollmentsstudentID%SectionsenrollmentssectionIDPrimaryKey hG"GG  @G("Gp"G  hG 8"GPrimaryKey G"G"G  8#G  hG "GhG #G hGP#GpG  xG  PrimaryKey#GGv *G*GGv /GX/G1GGv 1G1G4GGv X4G 4GH6Gs 0Gp(Gp(Gqp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(G6G G 7G`6G )GG*G05GGX*G3GG-Gp0GstudentsG$G G$G G$G *GG*G`+G(+Gp+G+G+G+G+G *Gstudents.First+G G43[What is your first name?]<,G+G+G+G+GH,GG $G,G,G-G-GLast  x-G$-G G21[What is your last name?]|-G -G(-GX,G-G h,G-G-G-G-G G$G-G8,Genrollments%studentsenrollmentsG(%G G(%G G(%G/G-G/G@0G0GP0GG (%G0G1G 1G01G%studentsenrollments  *GD1G p0Gl1G@1GH1G`0G%studentsenrollmentsSectionssectionIDG@&G G@&G G@&G G@&G1Gx1G2G2GP2G2G2G2GG @&G3G 3G3G3GsectionID  /G3G 3G3G3G3G2GsectionIDCatalog CoursesPrimaryKeyGX'G GX'G GX'GX4G3G4G5G4G5GG X'G5G 5G5G5G"PrimaryKey 2G  P2G6G 05G,6G6G6G 5GPrimaryKey4G2G0G4G2G0G@@@Gp(GGp(GGp(GGp(GGp(GGp(G 7G86GX7Gp8G7G8G7G8G8G8G88G8G7G8G8G8G88G8G GhG@GK&[z2P  I(winspool\\ADM-SRV1\O126-HP4100IP_172.25.41.156d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4*Dept & ", " & Course#timesectionID`ReportHeaderwB8 hd25`<a<bScdLabel14junk sched?n0X;K+f23a<b2 Line17F1)J9!ʽ`"PageHeaderSection٪=C|N@] d5`<a<bc,Dept_LabelDeptDetachedLabel ؍J=r$d5`Ta<bsc,Course#_LabelCourse#DetachedLabelCourse__Label]4lI_但ҥd5` a<b c,Title_Label TitleDetachedLabelWxB EZF)d5`a<bc,time_LabeltimeDetachedLabel#'\CMx! d5`a<bc,room_LabelroomDetachedLabel(@jKyNd5`H!a<bc,professor_LabelprofessorDetachedLabel"5EHePd5`&a<b c,sectionID_LabelsectionIDDetachedLabel %o0cFFfyf23b2 Line18Y-M=K?f23ab2 Line19 ^4o# I]0rT`GroupHeader0|~Oaώm7<`<bchei jDeptDeptTimes New Roman(FG]rMh= om7<`Tbschei jkCourse#Course#Times New RomanCourse_jNnJm7<` b che i jk Title TitleTimes New RomanQ)0p3Exn`aGroupHeader1rE n(@Qsm 7<`bcJeti timetimeTimes New RomanI7|N/E::m 7<`bcJei kroomroomTimes New RomanvuLQA9::m 7<`H!bcJei kprofessorprofessorTimes New Roman )2^@HNZ _`J Detail,|Ju^o`bc&e fZ"";"";"";"";"";"";"";"";"";"";"";"";"10";"10"c2n>oLݰ/X?sectionIDsectionIDTable/Query<SELECT DISTINCTROW [Sections].[sectionID], [Sections].[Dept], [Sections].[Course#], [Sections].[Section], [Sections].[Sem], [Sections].[Year] FROM [Sections];.975;61) LVAL  @ @ @ @ @ @ @ @ @ @ @ @Jr8Jr9Jr:Jr;JrJ r?J r@J rAJ rBJ rCJtJtJtJtJtJtJtJtJtJt Jt Jt Jt Jr1Kt KtKtKtKtKtKtKtStSt0St1St2St3SMR2BValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListQ < 4enrollments.sectionID MR2BValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListQ < 4enrollments.sectionID DESCm*$special permission       mMR2BValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListQ < 4enrollments.sectionID DESCm*$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 LVALGFD8(%\8( p<?H %8(%p% %  <42%r%%%%%%J%j%%%%P%4 %`%%%%%%8%X%%%%8%4H%H%H%H%H%H%H%H%H%H%%%%42%r%%%%%%J%j%%%%P%               (      d   %students.Student IDstudentsstudents.Firststudents.Middlestudents.Laststudents.Yearstudents.Major5students.Num Credits Earnedstudents.GPA!students.Hometown'students.Balance Due)enrollments.sectionIDenrollments;enrollments.special permission!enrollments.grade8 %  0 %0%%`%TH{P@ %8% % % 2%- r%- %- %- %- %- %- J%- j%- %- %- %- P%- students %   0 % %%`%zNtN@enrollments%@%p%%`%' QN@;simulate bad enrollment design8% % % % `% % % % %( % %0 % %8 % @ % % 8% % X% %  % % % % % % 8%( %)students.[Student ID] %`%%%%%9students.[Num Credits Earned]@ %8%X%+students.[Balance Due] %%?enrollments.[special permission] %8%2%- r%- %- %- %- %- %- J%- j%- %- students 2%% r%% %% %% %% %% % % J%(% j%0% %8% %`%%%%%@ %8%X% %%- %- P%- enrollments %X% %`% P%h%% %8% %#%% `%8%p%%%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%p%%%H(%%%% %% %% %% %% %% %% %% %% %%  %% %% %% %z %0 %'%% %%18%8%p%(%%8%%H%%X%P%h%%x%%%%%0%%%z %'%%%H3 %h%%%%%% 8% p% % % xLVAL@ MJmJ^dUMdoikQkkQMmYdbkMJmJ^dUMdoikQkkQMmYdbkfidSQkkdikkQMmYdbkidd`kkQMmYdbkkQMmYdbkQbid^^`Qbmk% P%%% (%0%  h% d% %\8H%P%X%`%h%p%x%%%%%%% %8%p%%%%P%%%%0%h%%%%%students 8% H% `% x% %YearStudent IDPrimaryKey MajorLastenrollments % @%  X%  % %%studentsenrollmentsstudentID%SectionsenrollmentssectionIDPrimaryKey %% %  % % % %H%  Student IDP %%v $%$%%v %%H%%0'%%#%#q%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%#%x'% p%'%X'% X$%% %&%students% % % %$%%$%(%%enrollments%studentsenrollments%!% %!%%%8%%%%%%% !%&%&%&%&%%studentsenrollments  $%&% &%'%&%&%&%%studentsenrollments$%%%%#%%#%'% '%'%(%'%(%'%((%%%K&[5;870;810;525;555`"PageFooterSectionzN&53m 7;<`<abc,i j Text15 =Now()Long DateTimes New RomanE7B5m 7;<`abc,i jk Text16H="Page " & [Page] & " of " & [Pages]Times New Romanb-iLJ4T#-`ReportFooterpHFOxtm*KLMNPQRSTUVWXY[\]^`btachdefgikjlpmnoqsruzvwxy{|}~5C0* 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_ainHAVTPFCOJAWTPDFCEFNJMIMEMKLJ28AVTPFCOJWDBE@N@ MTMTMKFLAH@1µ% B,+"B(B+B0studentTasksG VF2ue3t$ask6OBMAVLIDOFSODAHMCNIEIODPONC6OM7jLƒO2S8HTM;NEO5@P@N`aFacultyFacDudtyAOGTLGLWSKDIHEUKBTZD_JAHOXZOBGLDG 1WS 2DUH3U`B`Z_4A 4OZm@BA+6-6%6Deans5D~a`5sk5QPWRRHJBCGVTXDNCFZVSNLGICNTLCQ6pPjPjBlob &=TypeInfo8pPropData78'̔p͔Blob TypeInfoR&PropDataQ5lr6L6LBlob (PropDataqsTypeInfooDirDatau6PropDatagScripts[z6L6L0x6L6L3`j@L@LBlob * LVALάy0Professorsstudents LVALN˪˪˪˪˪ˌ n F  j ' H 9ǝǝǝǝǝǝǝǝǝǝǝǝǝǝǝa3Jd+ktVWYSections!!! Y[Sections].[Year]0 gY[Sections].[Sem]/ gY[Sections].[Section]3FD/ s ` }? P `"bPp888888"b           #Sections.sectionIDSectionsSections.DeptSections.Course#Sections.SectionSections.SemSections.Yearph( -~@@X"؀ab؀G؀"G؀5H؀GX؀GSectionsX  @N@9~sq_djunk sched~sq_dsectionIDX   @ Hx  +[Sections].[sectionID]![Sections].[Dept]'[Sections].[Course#]'[Sections].[Section]H[Sections].[Sem]![Sections].[Year] "؀ab؀7G؂؀G"؀GG؀؀G Sections "  b         H hX8Ph                                    z 8XPXX8p(8     8 p@ (8pSections     8 H  p   timesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catalog CoursesSectionsv hhqhhhhhhhhhhhhhhhhhhhhhhhhhhhhH X8PSectionsPrimaryKeyPHhX(X LVALʾexxxPrerequisitessCreate query in Design viewurses join equiv to 1NFCreate form in Design viewCreate report in Design viewd students design3Create data access page in Design viewindstdin^3 LVALʾexxxCatalog Coursespotential advisees studentsWenrollreport leading to unnormalized rooms designCreate data access page in Design viewAutoExec^3K&[N  yfS?PropDataikTypeInfo:PropDataCopyBlobCopyTypeInfoCopy     6!"%&'(),-./2F9:;<=>?@ABCDE[IJKLMNOPSTUVWXYZ^_`abcdefghijklmnopqr5Catalog_Courses_DeptCatalog Courses_Deptm6Catalog_Courses_Course_Catalog Courses_Course#m7Titlem8Descriptionm9Credits:PageFooterSectionm;Text51m<Text52=ReportFooterjunk rosterjunk schedbreport leading to unnormalized students design3breport leading to unnormalized students design2"All EnrollmentsHCount Of Enroll By Dept and CourserosterX 6CB0 3CB0 2CB0 1CB0 0CB0 5CB0 4CB0 7CB0 8CB0 22fill the whole screenopen main menumain0-10  lLJI3Ld`8a<bc,,SectionAutoExecBackToMainCoursesfindstd,Sections_Course__ 3CB0 2CB0 1CB0 0CB0ection_LijnDetachedLabel=ۛQNMSysDbSem_LabelSemDetacheScheduleZreport leading to lSections_YearDetacOverheaddOverhead_LabelmNumb_Student_WorkstationsNumb Student WorkstationsdNumb_Student_Workstations_LabelNumb Student Workstations_Labelmtimedtime_LabelmsectionIDdsectionID_LabeldLabel18mText19mText20fLine21fLine22fLine23SemYearunnormalized rooms design>Rela  MajordMajor_LabeldLabel14mText15mText16fLine17fLine18fLine19mText20sectionIDLine19 tionships for UNIV2000new PropaͬOĜ~kI̡ ěPageHeaderSectionDetailPageFooterSectionfLine0fLine1gImage2gImage3fLine4fLine5f Line6g Image7g Image8f Line9f Line10fLine11gImage12gImage13f+K&[N  Line14fLine15fLine16gImage17gImage18fLine19fLine20fLine21gImage22gImage23fLine24fLine25fLine26gImage27gImage28f Line29f!Line30f"Line31g#Image32g$Image33f%Line34f&Line35f'Line36g(a<bVc, Student ID_LabelStudent IDDetachedLabel Student_ID_LabelG4@-\1d`a<bc,Middle_Label MiddleDetachedLabel"}3NF=m`bcek Middle Middle,Student Middle Initial /E+4Enz io09bce fhvnzeMH$n:jYearYearValue List4"Fr";"So";"Jr";"Sr";"Grad"1440LStudent Academic Year (Fr, So, Jr, Sr)m`%bVcek Major MajorStudent MajoraA^T`"PageFooterSection LVO3m ;<`<abc,i j Text15 =Now()Long DateTimes New Roman{1`(C̈2lm ;<`abc,i jk Text16H="Page " & [Page] & " of " & [Pages]Times New RomanO`ΐaO]J`ReportFooter:2M[M `5CustomGroupsImage37g)Image38f*Line39f+Line40f,Line41g-Image42g.Image43f/Line44f0Line45f1Line46g2Image47g3Image48f4Line49n5ecl0d6ecltitle0n7ecl1d8ecltitle1n9ecl2d:ecltitle2n;ecl3d<ecltitle3n=ecl4d>ecltitle4n?ecl5d@ecltitle5nAecl6dBecltitle6nCecl7dDecltitle7nEecl8dFecltitle8nGecl9dHecltitle9nIecl10dJecltitle10KReportHeaderLReportFooterdMLabel72dNLabel73Q6pPjPjBlob &=TypeInfo08:<=Babc,,K&[ @ @(e gJ;@:Relationships for UNIV2000new Arial8,(hEPSON Stylus Photo 785EPX`f odhh0RL*** xhhDLLName32=E_DU12SE.DLL d 2EPSON Stylus Photo 785EPX  ***E-winspoolEPSON Stylus Photo 785EPXUSB001d2 Tahomag37n Tahoma`ReportHeader9H8vdbh ceLabel72:Relationships for UNIV2000newޫmMʊdabH cLabel738Wednesday, December 10, 2003h\hC$(=`"PageHeaderSectionNٽK<{$` DetailXΆAyŽ=f23` ab Line0ʧg`0 a[bc< Image3x( P@@@@@@@-K&[ @ @ @ @ @ @ @@@@@@@@Ɂ_C@f` abc$ Line4mYT\[Is f23` ab Line59'@af23`afb Line6QsGg`abHc` Image7h(@@@@@@@@@@@@@@@.K&[HF@F,;g`0 a'bc< Image8x( P@@@@@@@@@@@@@@b6=B[XW=Vf` arbc$ Line9ozF-f23``aVb Line10XaNnD9Ha;f23`ab Line114߰EIfg`a"bHc`Image12h(@@@@@@@@@@@@@@@/K&[)>OeFY/Yg`xabc<Image13x( P@@@@@@@@@@@@@@aOcP,f`abc Line14:?bHإUf23``a"b Line15MXmG_ f23`a~b Line16y^3j BI3 C?8g`abHc`Image17h(@@@@@@@@0K&[@@@@@@@.I1Hb5 v4g`xabc<Image18x( P@@@@@@@@@@@@@@u ߛ 2HnYf`abc Line19ՈxEFLS^f23`ab Line20%M4E 1f23`ab Line21X] Ceνg`a bHc`Image22h(@@@@@@@@1K&[@@@@@@@`{k"B@ C%g`asbc<Image23x( P@@@@@@@@@@@@@@2K&[6XJc]f` ab( c< Line24v33H3}if23`ab Line25*,wUU@E+f23`afb Line26wI_FLd@tAg`abHc`Image27h(@@@@@@@@@@@@@@@qt G3dg`a?bc<Image28x( P@@@@@@@@@@@@@@3K&[d _ Z 7 T  _ } }{*R Yg=*e3Ac{Of` arb( c< Line29ԃ)Mhf23`pajb Line30(7zO{ff23`azb Line31XFn"E=ONg`abHc`Image32h(@@@@@@@@@@@@@@@$F)M Mp+# $g`abc<Image33x( P@@@@@@@4K&[{hUB/A S @ ,  |  B /   l Y @@@@@@@ݢSENr57f`$avbc Line34`oJoEy3xf23`pab Line35 woD'vf23`@a b Line36pyEQ~u:ig`da bHc`Image37h(@@@@@@@@@@@@@@@(Ra$L%,>g`a;bc<Image38x( P@@@@@@@5K&[,Z ) _ @ ~ ! [.n?{*t!s@@@@@@@¡Fpgf`$a bc  Line39H]~EOyB ާBf23`afb Line40CjKu@f23`a b Line41\[tFYSd}g`az bHc`Image42h(@@@@@@@@@@@@@@@6K&[NnnY_PKsf23`a. b Line46츌0DYBg`a bHc`Image47h(@@@@@@@@@@@@@@@7K&[v1b FNkG%_g` a7bc<Image48x( P@@@@@@@@@@@@@@>·GlQ f`a: bcl Line49wKCVf;n03ab@cd ecl0Value Listf"Dept";"Course#";"Title";"Description";"Credits";""ݿKKWwEd235 `ahbcecltitle0Catalog Courses󨔶M8Ɏn03aP b@c<dXlecl1Value Listn"studentID";"sectionID";"special permission";"grade";""YBG)eGd235 `P ah b<cecltitle1enrollments{{X̅@fEhn03a`b cdp lecl2Value List"sectionID";"Dept";"Course#";"Section";"Sem";"Year";"time";"room";"professor";"stop point";"junk";""u PIذ;0d235 ``a 8K&[vcO<)   x e R > +  {  g T A -bcecltitle2Sections ,?L ުp#n03ahb cd lecl3Value List"Student ID";"First";"Middle";"Last";"Year";"Major";"Num Credits Earned";"GPA";"Hometown";"Balance Due";""IpJՃ d235 `ha bcecltitle3students=K`gkn03a bdcd(lecl4Value ListL"Prog";"Class";"PreProg";"PreClass";""$}|JpAd235 ` abcecltitle4PrerequisitesYmYGLs6oln03ab cdlecl5Value Listh"Name";"Dept";"Position";"office";"phone";"email";""ѯ/&E7Ld235 `aHbcecltitle5Professorsf4hKKjn03ab8 cdlecl6Value List"room";"size";"Front Computer";"Data Connection";"Data Projector";"Overhead";"Numb Student Workstations";""j.>tH5#d235 `a` bcecltitle6 Rooms4CXK[~rên03adbXcdlecl7Value Listf"Dept";"Course#";"Title";"Description";"Credits";""6#]H=4!R=d235 `dabcecltitle7"Catalog Courses_1ntoL3̇Mn03ab@cdlecl8Value List"sectionID";"Dept";"Course#";"Section";"Sem";"Year";"time";"room";"professor";"stop point";"junk";""8˵JT#Iu=7d235 `ahbcecltitle8Sections_1'J+On03a#bcdl ecl9Value List"sectionID";"Dept";"Course#";"Section";"Sem";"Year";"time";"room";"professor";"stop point";"junk";""ePRMDZ({=d235 `#abcecltitle9Sections_2<0jLCn03ahb@cdl ecl10Value List"sectionID";"Dept";"Course#";"Section";"Sem";"Year";"time";"room";"professor";"stop point";"junk";""&`%I*ԮH#d235 `hahbcecltitle10Sections_3>nͣ(F䌑`1`"PageFooterSectionNJ `G1`hReportFooter J {EB^({OWR HB0GRXa2F@VNG@(CN LP io5+PEPsWenrollGFUPsWn4rl@8QGTFPSECFHBBSDEHZPEPGNKDDXUTK#6FS4jCPH`SB HUPP:N9DPXU K0Sҍ6q/ qxME 9K&["am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB#Microsoft Access 11.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-000000000046}#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 >8HAVTPFCOJAWTPDFCEFNJMIMEMKLJ024459f5a4Form_main% 8HOBMAVLIDOFSODAHMCNIEIODPONC034459f5a4C"Form_studentTasksa8AOGTLGLWSKDIHEUKBTZD_JAHOZOB044459f5a4["Form_FacultyTasks08QPWRRHJBCGVTXDNCFZVSNLGICNTL054459f5a4cForm_DeansTasks+H 8GTFPSECFHBBSDEHZPEPGNKDDXUTK064459f5a4k(Form_studentsWenrollq`x0H`,I>7;1ZpsEd5d]_BeM&(b@M-ۊ{/h I=;E<>D.AccessVBAWin16~Win32MacVBA6# university.DAOstdole`VBIDEA 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_B:LVALKKKKKKKKKKKKKK)    MR2AccessVersion Build6Track Name AutoCorrect Info0Perform Name AutoCorrectCpgConversionProjVerZ 08.50 .   MR2AccessVersion Build6Track Name AutoCorrect Info0Perform Name AutoCorrectCpgConversionProjVerZ 08.50 6    #MR2AccessVersion Build6Track Name AutoCorrect Info0Perform Name AutoCorrectCpgConversionProjVerZ 08.50 6    #MR2ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlacesOrientation$UnicodeCompressionJ  , $Sections.room DESCsectionID   " 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   jLVALР~ ME s  J ' ʈssȦ*]PXAA\ FEѳ@FEѳ@AdmʾexxxPrerequisitesCreate query in Design viewCreate form in Design viewCreate report in Design viewCreate data access page in Design view]^3άzpJ LVALά}0ProfessorsPSectionsstudents(enrollmentsʾexxxProfessorsroster Query studentsWenrollreport leading to unnormalized students design3Create data access page in Design viewAutoExec b^3 LVALʾexxxstudentss potential advisees studentsWenrollreport leading to unnormalized students design3Create data access page in Design viewAutoExec^3K&[ack_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_ClickcCk[  Z(S<S<S<<N0{7B37AFD2-914E-11D3-B7F7-00105A10971B}x lh@%@@" 0 PX `hx np r t v B@pCoun r t v B@pse'x(| n &!(A@$xoxpAttribute 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]] Admin=K&[Tasks'   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   \enrollments''' \enrollments'''\enrollments'''\enrollments''' \Sectionsenrollmentsb@\Sectionsenrollmentsb@\Sectionsenrollmentsb@\Sectionsenrollmentsb@\Sectionsenrollmentsb@\Sectionsenrollmentsb@C7!\Sectionsenrollmentsb@\Sectionsenrollmentsb@\Sectionsenrollmentsb@C\Sectionsenrollmentsb@\Sectionsenrollmentsb@\Sectionsenrollmentsb@\Sectionsenrollmentsb@\Sectionsenrollmentsb@C7! \Sectionsenrollmentsb@C7! \Sectionsenrollmentsb@C7!  \studentsenrollm\studentsenrollm\studentsenrollment\studentsenrollmentsZ@ \studentsenrollmentsZ\studentsenrollmentsZ@\studentsenrollmentsZ\studentsenrollmentsZ\studentsenrollmentsZ\studentsenrollmentsZ@ C7!\studentsenrollmentsZ\studentsenrollmentsZ@ \studentsenrollmentsZ@ \studentsenrollmentsZ@\studentsenrollmentsZ@\studentsenrollmentsZ@ \studentsenrollmentsZ@ \studentsenrollmentsZ@ C7! \studentsenrollmentsZ@ C7! \studentsenrollmentsZ@ C7!  \P@  '\\P@  '\ \P@  '\ \P@  '\ \P@  '\ \P@  '\ \P@  '\ \P@  '\ \P@  '\ \P@  '\ \P@  '\ \P@  '\ \P@  '\ \P@  '\ \P@  '\ \P@  '\ students.Major- \ students.Major- '