Standard Jet DBnb` Ugr@?~1y0̝cǟFN7]D^(`T{6u߱wCϯ34ay[|*|OJl>`&_Љ$g'DeFx -{\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ƺ|<{51E1ŢJ@;@mdlIsLoaded,,,,,,,,2r@%it@frmSplashk@666*******( @&@G7̲@8̲@~sq_cfrmReceipts~sq_cBanker IDr,*@DVWWWK?G7̲@8̲@~sq_cfrmReceipts~sq_cBanker IDr,*@DVWWWK??????= `2r@%it@frmSplashk@666*******( @2r@%it@frmSplashk@666**2r@%it@frmSplashk@666*******( @&@bMy\@2r@%it@frmSplashk@666*******( @&2r@%it@frmSplashk@666**2r@%it@frmSplashk@666*******( @2r@%it@frmSplashk@666*******( @&@ @MEMBER-YOUTH 999-------+ @|R@ @frmReport@VCS           2                 x  IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra  Id ParentIdName        vfmfbwjrp1vt,bofoz^1vt,bguosurhvfmfbwjrp1vt,bsurhprzԏ1vt,bguov`bbsufh`dd1vt,bofoz1vt,bguo}rxwi1vt,bguohxfvwgffw1vt,bguo}rxwi1vt,bguorpfd`}w1vt,bguo}rxwi1vt,bguoufsm`bfb`udw1vt,bguo}rxwi`dd1vt,hKS!@FKS!@Studentsh@555)))))))' @VFS!@VFS!@SysRel''''''''''% VFS!@VFS!@Modules((((((((((& VFS!@VFS!@Scripts((((((((((& VFS!@VFS!@Reports((((((((((& VFS!@VFS!@Forms&&&&&&&&&&$ VFS!@VFS!@MSysModules,,,,,,,,,,* VFS!@VFS!@MSysModules2----------+  |FS!@|FS!@UserDefined,,,,,,,,,,*  |FS!@|FS!@SummaryInfoc@888,,,,,,,* @YڕFS!@YڕFS!@MSysRelationships22222222220 YڕFS!@YڕFS!@MSysQueries,,,,,,,,,,* YڕFS!@YڕFS!@MSysACEs))))))))))' YڕFS!@YڕFS!@MSyVCKS     2  ObjectIdSIDACM FInheritable? ObjectIdVVW"VVX"V[V"WVV"guoufpw`mv`ddIegruo,guoufpw`mvofpxNgruo,guoufsm`bfb`ud[gruo,guoufsruwv gruo,guov`bbsofpx#gruo,guov`bbsufhAgruo,guov`bbsufh`dd9gruo,guovsm`viqgruo,guo}rxwiwgruo,guo}rxwi`ddPbgruo,guo}rxwiofpxgruo,v{jwbiar`udodma`vb`mfpd`utodmbrxpwfuWodmjvmr`dfdsov}vdaufsruw,uswsurhufbfjswfbfjswBov}vdaFov}vdaov}vdaov}vdaov}vdaov}vdaov}vdaov}vdaJdFfov}vdaJdov}vdaJd[]ov}vda[]ov}vda[]ov}vda[]ov}vda[]ov}vda[]ov}vda[VC?7S  7           ObjectId AttributeOrderName1Name2 ExpressionFlag ObjectIdAttribute  ÐÐÐÐ>>>>>>>>>>>>>>>>>>>>  ÷···················k=### ?MSysDbC9 ### MSysDb )W### ?MSysDb )W### ?Form_frmMain=x'A5) Report_rptProgReceipt3:;!>J>2&"mdlCountern]''' ?Form_frmOpenRecAddc+! ,.G;/#Form_frmOpenRecMenuRS,\wlH<0$ Form_frmProgSelectionD-LOJ>2&"Form_frmOpenRec0& D8, Form_frmRentalsAddpszG;/#Form_frmYouthAddP;@  E9-!Form_frmPreK wU@ VCS            szRelationshipgrbitccolumnicolumnszObjectszColumnszReferencedObjectszReferencedColumn   szObjectszReferencedObjectszRelationshipB#Microsoft Access 8.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#4.0#0#C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO350.DLL#Microsoft DAO 3.51 Object Library*\G{8E27C92E-1264-101C-8A2F-040224009C02}#7.0#0#C:\Program Files\Microsoft Office\Office\MSCAL.OCX#Microsoft Calendar Control 9.0$ 3; " #;$ Form_Switchboard 5c3b85145e*D&Form_frmOpenRecMenu 83b853307*D/ S((Form_frmMemberSelect 1d3b85330e*Dv(!*Report_rptProgReceipt 243b85334d*D  H( *Form_frmProgSelection d3b85330d*D )Form_frmOpenRec c3b853307*D hK $Form_frmMem100FredSmoot99 East North Street! 050HermanMunster1313 Mockingbird! 002MaryContrary10 N. Maple001JoeGringo122 Main Street  {qg]SI?5 | Ho{@aWVW(hWVV(iXVV(kXW(!"#$%&'()*+     dd1vt,bbroar\^z 1vt,bguosurhvfmfbwjrp1vt,bofoz^1vt,bguosurhvfmfbwjrp1vt,bsurhprzԏ1vt,bguov`bbsufh`dd1vt,bofoz1vt,bguo}rxwi1vt,bguohxfvwgffw1vt,bguo}rxwi1vt,bguorpfd`}w1vt,bguo}rxwi1vt,bguoufsm`bfb`udw1vt,bguo}rxwi`dd1vt,hKS!@FKS!@Studentsh@555)))))))' @VFS!@VFS!@SysRel''''''''''% VFS!@VFS!@Modules((((((((((& VFS!@VFS!@Scripts((((((((((& VFS!@VFS!@Reports((((((((((& VFS!@VFS!@Forms&&&&&&&&&&$ VFS!@VFS!@MSysModules,,,,,,,,,,* VFS!@VFS!@MSysModules2----------+  |FS!@|FS!@UserDefined,,,,,,,,,,*  |FS!@|FS!@SummaryInfoc@888,,,,,,,* @YڕFS!@YڕFS!@MSysRelationships22222222220 YڕFS!@YڕFS!@MSysQueries,,,,,,,,,,* YڕFS!@YڕFS!@MSysACEs))))))))))' YڕFS!@YڕFS!@MSysObjects,,,,,,,,,,* YڕFS!@YڕFS!@MSysDbE@333'''''''% @YڕFS!@YڕFS!@RelationshiHo{@VVWaWVW(VVXhWVV(V[VkXW(___iXVV(Amt_Label: Banker_IDLabel29nMember__݄Label35 Prog1_CostoLabel38 Program1__lLabel39Child40Label41 Program2__qLabel42 Prog2_Cost%Label43Total_Amt_PaidLabel46 Program3__DwLabel47 FormFooterT Balance_DueLabel51 Total_AmtLabel52 Prog3_CostۻLabel55Command56_Click Print_Receipt|Program_DetailsLabel57Program1___GotFocusGotFocusKProgram2___GotFocus stProgInfolCurrenteClickst(_ stProgramListּstPr5 ProgramList5acFormReadOnlyl_B_var_ProgramListu stProgDetailsY(Program2___LostFocus LostFocusMSProgram2___ChangeaChangeProgram2___ExitGOacForm_B_var_stProgDetails6_B_var_# program2 3h Program2 #hValueKtblPtblRegReceiptsjCprogram2p__B_var_tblRegReceiptsz tblProgramsKstLinkCriteriaYstLink;nScreenIcreenfp ActiveControlyProgram3___ChangeProgram3___ExitOProgram1___Enter(Program1___ExitNEnterProgram1___Change˴Combo59&Find_Member___LabelCombo59_AfterUpdateXVRecordsetClone8BookmarkC AfterUpdateControlsKItemzCombo8Find_Member_LabelCombo8_AfterUpdateOH _B_var_Combo8DMemberMember jMember #{ MEMBER-YOUTHmCombo61&Pr5@@ @@ `dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvftxjkrjpvwxdfpwv{jwihu`dfvhu`dfvmfgwkrjp`mmwifhu`dfv`pd`p}vwxdfpwvwi`wo`wbimfgwrxwfukrjpwifhu`dfgru`vwxdfpw{iri`vdurssfdrxwov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvujhiwkrjp`mmvwxdfpwv`pd`p}hu`dfvwi`wo`wbiujhiwrxwfukrjpwifvwxdfpw{iri`vprhu`dfvvwxdfpwv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd iH i i 8 i@ iP i` ip i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i i  ip i i p i i p i i p i i | i  i i i ix i  i|@ i i i i( i i| i  iX i i  i{h iX i i  i  i ( i X i8X i` ih ip ip i i i( iX i i iGrades  i  i  isNum PrimaryKo{ProgaProg_AfterUpdate  frmProgSelectLabel97oText99tLabel100&Text101~Label102(Cost2:lCost3;lForm_frmProgSelect19Form_frmProgSelect2:Form_frmProgSelect3;Details1_ClicksErr_Details1_ClickExit_Details1_Click:Details2_ClickErr_Details2_ClickExit_Details2_ClickrDetails3_ClickErr_Details3_Click K Program3 #mExit_Details3_Clickw Form_Close[isOpennfrmProgSelect1{frmProgSelect2|frmProgSelect3}Details1Details2Details3Label110K _B_var_IsOpen8Details1_LostFocusɵDetails1_DblClickwoCmd?DblClick _B_var_oCmdl( Details1_Exit( Details2_Exit Details3_ExitU_B_var_CommandXa_B_var_ArgumentNumber-Member___BeforeUpdateMember___ChangepPrint_Receipt_GotFocus^Member___AfterUpdate _B_var_LastFirstReceipt___BeforeUpdate GoToRecordM6 acDataFormacLastLabel112M Prog_1_CostProg_1_Cost_Change+jProg_1_Cost_BeforeUpdateԩFindLastzacNormalText113Label114OText115Label116QText119Label120p Form_MainN Form_frmMain;btnOpenContacts_Click!Err_btnOpenContacts_Click(Exit_btnOpenContacts_ClickbtnAddNewContact_Click Err_btnAddNewContact_ClickacNewRecYExit_btnAddNewContact_ClickbtnCloseApp_ClickErr_btnCloseApp_ClickQuit9Exit_btnCloseApp_ClickT Form_frmMembershipiWbtnmembership_ClickQErr_btnmembership_ClickExit_btnmembership_ClickΩbtnreturntomain_ClickOErr_btnreturntomain_ClickqExit_btnreturntomain_ClickLabel8,Image12GLabel14DLabel15E btnmembershipn%GrayBox btnQuitAppbtnQuitAp @ @ @          % ) ) ) ) ) ) ) ) ) )  ) )! )1 )2 ), )- ). )/ )0 )" )3 )? )@ )A )B )C )D )E )F )G )H )4)I)K)L)M)N)O)P)Q)J@@@GradesStudentsGrades.sNum = Students.sNUMA  {qg]SI?x@ G::xGra@ $e @ @ @ @ @ @ @ @ @********* ************ *!*"*#*$ *% *& *' *+ *, *- *. - - - - - - - -- - - --- -----*(*)**------ %-%-%-****** * * * ***roLengthDisplayControl eycNumStudents  i  isNUM PrimaryKey i0 ip i d  i @ i i iX i d PrimaryKey i iv  i i i iv  i i i iH iHs iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH iH i8 i  iX i  i  i  i0 i< iStudentssNUMp i0 i @ i0 i i i@ ip iGradessNump i< i @ i< i i i i i i@ i@ iH i@ iH iX i i i iX i i i i i i @ @ @ @ @ @ @                                        " # $ % & ' ( ) * ! + - . / 0 1 2 3 4 5 $ ,yl0ylpyl yl pyl yl pyl yl pyl yl |yl ylylylylyl0yl|@yl yl yl yl8 yl yl|yl ylhylyl0yl{hylh yl yl  yl  yl 8 yl h yl8hylpylxylylyl yl yl8 ylh yl yl ylGrades yl yl) ) ))!@  ~S!@ ~S!@LEFT OUTER JOIN - the GRADE for a student who has dropped outx@#jjj^^^^^^^\ @  H^S!@oS!@Admin@*2&&&&&&&&&$  cS!@d 0 AND [SwitchboardID]= SwitchboardID  ORDER BY [ItemNumber];qm.1m. ,There are no items for this switchboard page OptionLabel1Caption Program3__ ItemNumbercyPPcyPP LastFirst Mem MEMBER-YOUTH Mem# Member # tblRegReceipts frmRegReceiptscyPPcyPPLastFirst_AfterUpdate [ID Youth Membership] =  LastFirstcyPPcyPP8yPcyPP Receipt__  d GradeGradesGradeGrades.Grade9-("";  d sLastStudentssLastStudents.sLast=/*"";  d sFirstStudentssFirstStudents.sFirst@1+##;  d sNUMStudentssNUMStudents.sNUM:-)!!;VCEN __A__          ObjectId AttributeOrderName1Name2 ExpressionFlag ObjectIdAttribute  ÐÐÐÐ>>>>>>>>>>>>>>>>>>>>  ÷···················k=### ?MSysDbC9 ### MSysDb )W### ?MSysDb )W### ?Form_frmMain=x'A5) Report_rptProgReceipt3:;!>J>2&"mdlCountern]''' ?Form_frmOpenRecAddc+! ,.G;/#Form_frmOpenRecMenuRS,\wlH<0$ Form_frmProgSelectionD-LOJ>2&"Form_frmOpenRec0& D8, Form_frmRentalsAddpszG;/#Form_frmYouthAddP;@  E9-!Form_frmPreK wU@ {@@   `dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvftxjkrjpvwxdfpwv{jwihu`dfvhu`dfvmfgwkrjp`mmwifhu`dfv`pd`p}vwxdfpwvwi`wo`wbiov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdl Students, and any grades that MATCh@@@*maaUUUUUUUS @`S!@8N`S!@EQUI JOIN - Students with GRADES@@@*YMMAAAAAAA? @#o VS!@$XS!@Grades @333'''''''% @hKS!@;gPS!@Studentsh@555)))))))' @VFS!@VFS!@SysRel''''''''''% VFS!@VFS!@Modules((((((((((& VFS!@VFS!@Scripts((((((((((& VFS!@VFS!@Reports((((((((((& VFS!@VFS!@Forms&&&&&&&&&&$ VFS!@VFS!@MSysModules,,,,,,,,,,* VFS!@VFS!@MSysModules2----------+  |FS!@|FS!@UserDefined,,,,,,,,,,*  |FS!@|FS!@SummaryInfoc@888,,,,,,,* @YڕFS!@YڕFS!@MSysRelationships22222222220 YڕFS!@YڕFS!@MSysQueries,,,,,,,,,,* YڕFS!@YڕFS!@MSysACEs))))))))))' YڕFS!@YڕFS!@MSysOVCeN            FlagsFormModuleNameReplicationVersionTypeTypeInfoVersion#Index1>>>>>  ÷···················k=### ?MSysDbC9 ### MSysDb )W### ?MSysDb )W### ?Form_frmMain=x'A5) Report_rptProgReceipt3:;!>J>2&"mdlCountern]''' ?Form_frmOpenRecAddc+! ,.G;/#Form_frmOpenRecMenuRS,\wlH<0$ Form_frmProgSelectionD-LOJ>2&"Form_frmOpenRec0& D8, Form_frmRentalsAddpszG;/#Form_frmYouthAddP;@  E9-!Form_frmPreK wU@ {qg@@   `dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvftxjkrjpvwxdfpwv{jwihu`dfvhu`dfvmfgwkrjp`mmwifhu`dfv`pd`p}vwxdfpwvwi`wo`wbimfgwrxwfukrjpwifhu`dfgru`vwxdfpw{iri`vdurssfdrxwov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd - the GRADE for a student who has dropped out\\\\\\\\\\\  YS!@S!@LEFT JOIN - ALL the grades, and any students that matchVVVVVVVVVVV YS!@YS!@Grades%%%%%%%%%%%  YS!@YS!@EQUI JOIN - Students with GRADES???????????  YS!@YS!@Admin$$$$$$$$$$$  YS!@YS!@UserDefined***********  YS!@YS!@SummaryInfo*********** LVAL i_VBA_PROJECTa^  *\G{000204EF-0000-0000-C000-000000000046}#3.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\vba332.dll#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#8.0#0#D:\Program Files\Microsoft Office\Office\MSACC8.OLB#Microsoft Access 8.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#4.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\dao350.dll#Microsoft DAO 3.51 Object Library  ;_x$AccessVBAWin16~Win32MacDAOJOINSb30 dir0* pHd JOINS @8= Vh  @; J< DAO>DAO( *\G{00025E01-0C  0046}#4.0#0#C:\Program Files\C ommon Microsoft Shared\w\dao350.0dll# 3.51 Object Libra,ryH"_LVAL @ @ @                       btnSaveRecord_ClickbtnAddItems_DblClickBUILDNUMBR_AfterUpdatebtnCurrentInspection_Clickbtnrefresh_ClickbtnInspectHist_ClickbtnBudgetDet_ClickbtnBuilderInsp_ClickJ:YikcbtnOpenPayout_ClickbtnDisbReq_Click  qRLikc qRLikc qRLikcForm_frmCalendar qRLikc#qRLikc"qRLikcmdlBasCalendarCqRLikcFqRLikcEqRLikcGqRLikcIqRLikcHqRLikcForm_frmOneDayA:YikcD:YikcC:YikcE:YikcG:YikcF:YikcH:YikcI:YikcK:YikcM:YikcL:YikcN:YikcP:YikcO:Yikcn:Yikcm:YikcText615 frmGuestFeeText601Text603Text605Text607Text609Text611Text613 8 )cykcykcykcJTykcykcLabel62Label61 ykcykcykcykcykcykc frmPreSchlAddykcykcykcykcykcykcykcykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc2b`ykc3b`ykc3b`ykc frmPreKAdd3b`ykc3b`ykcPJTykc3b`ykcCombo643b`ykc3b`ykc3b`ykcAge 3b`ykc!3b`ykc 3b`ykc3b`ykc#3b`ykc"3b`ykc 3b`ykc%3b`ykc$3b`ykc!zkc$zkc#zkc%zkc'zkc&zkc(zkc*zkc)zkc+zkc-zkc,zkc0zkc/zkc p3zkc5zkc4zkc7zkc9zkc8zkc;zkc=zkc<zkcForm_frmYouthAddForm_frmRentalsAddForm_frmOpenRecA/pszObject = sMSysDb#@ov}vda"        x  IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra  Id ParentIdName        vfmfbwjrp1vt,bofoz^1vt,bguosurhvfmfbwjrp1vt,bsurhprzԏ1vt,bguov`bbsufh`dd1vt,bofoz1vt,bguo}rxwi1vt,bguohxfvwgffw1vt,bguo}rxwi1vt,bguorpfd`}w1vt,bguo}rxwi1vt,bguoufsm`bfb`udw1vt,bguo}rxwi`dd1vt,hKS!@FKS!@Studentsh@555)))))))' @VFS!@VFS!@SysRel''''''''''% VFS!@VFS!@Modules((((((((((& VFS!@VFS!@Scripts((((((((((& VFS!@VFS!@Reports((((((((((& VFS!@VFS!@Forms&&&&&&&&&&$ VFS!@VFS!@MSysModules,,,,,,,,,,* VFS!@VFS!@MSysModules2----------+  |FS!@|FS!@UserDefined,,,,,,,,,,*  |FS!@|FS!@SummaryInfoc@888,,,,,,,* @YڕFS!@YڕFS!@MSysRelationships22222222220 YڕFS!@YڕFS!@MSysQueries,,,,,,,,,,* YڕFS!@YڕFS!@MSysACEs))))))))))' YڕFS!@YڕFS!@MSyS           2                 x  IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra  Id ParentIdName        vfmfbwjrp1vt,bofoz^1vt,bguosurhvfmfbwjrp1vt,bsurhprzԏ1vt,bguov`bbsufh`dd1vt,bofoz1vt,bguo}rxwi1vt,bguohxfvwgffw1vt,bguo}rxwi1vt,bguorpfd`}w1vt,bguo}rxwi1vt,bguoufsm`bfb`udw1vt,bguo}rxwi`dd1vt,hKS!@FKS!@Studentsh@555)))))))' @VFS!@VFS!@SysRel''''''''''% VFS!@VFS!@Modules((((((((((& VFS!@VFS!@Scripts((((((((((& VFS!@VFS!@Reports((((((((((& VFS!@VFS!@Forms&&&&&&&&&&$ VFS!@VFS!@MSysModules,,,,,,,,,,* VFS!@VFS!@MSysModules2----------+  |FS!@|FS!@UserDefined,,,,,,,,,,*  |FS!@|FS!@SummaryInfoc@888,,,,,,,* @YڕFS!@YڕFS!@MSysRelationships22222222220 YڕFS!@YڕFS!@MSysQueries,,,,,,,,,,* YڕFS!@YڕFS!@MSysACEs))))))))))' YڕFS!@YڕFS!@MSy (((Grades.Grade) Is Null))2 'VC&N&&  d  d  d  dsNUMsFirstsLastsAddress&( &) PrimaryKeysNUMordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvftxjkrjpvwxdfpwv{jwihu`dfvhu`dfvmfgwkrjp`mmwifhu`dfv`pd`p}vwxdfpwvwi`wo`wbimfgwrxwfukrjpwifhu`dfgru`vwxdfpw{iri`vdurssfdrxwov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvujhiwkrjp`mmvwxdfpwv`pd`p}hu`dfvwi`wo`wbi`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd $  $   ( 0 h  $D ` @ !aL ep ``x`t8  $ h  $p x  %e $P p ` 8  $ h  $  $x p `   $   S!@YFlagMSysQueriesF@@{q @ @ @         N0{0FC0219B-8B28-11D5-B26B- S!@S!@RIGHT JOIN - all Students, and any grades that MATChSSSSSSSSSSS S!@S!@MSysModules2+++++++++++ S!@S!@MSysModules***********  S!@S!@LEFT OUTER JOIN - the GRADE for a student who has dropped out\\\\\\\\\\\  YS!@S!@LEFT JOIN - ALL the grades, and any students that matchVVVVVVVVVVV YS!@YS!@Grades%%%%%%%%%%%  YS!@YS!@EQUI JOIN - Students with GRADES???????????  YS!@YS!@Admin$$$$$$$$$$$  YS!@YS!@UserDefined***********  YS!@YS!@SummaryInfo***********  YS!@YS!@AccessLayout+++++++++++ YS!@YS!@SysRel%%%%%%%%%%% YS!@YS!@Scripts&&&&&&&&&&& YS!@YS!@Reports&&&&&&&&&&& YS!@YS!@Modules&&&&&&&&&Y%k@@ @`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvftxjkrjpvwxdfpwv{jwihu`dfvhu`dfvmfgwkrjp`mmwifhu`dfv`pd`p}vwxdfpwvwi`wo`wbimfgwrxwfukrjpwifhu`dfgru`vwxdfpw{iri`vdurssfdrxwov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvujhiwkrjp`mmvwxdfpwv`pd`p}hu`dfvwi`wo`wbiujhiwrxwfukrjpwifvwxdfpw{iri`vprhu`dfv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd@ 100FredSmoot99 East North Street! 050HermanMunster1313 Mockingbird! 002MaryContrary10 N. Maple001JoeGringo122 Main Street %VVW'VVX'V[V'WVV'       x  IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra  Id ParentIdName        vfmfbwjrp1vt,bofoz^1vt,bguosurhvfmfbwjrp1vt,bsurhprzԏ1vt,bguov`bbsufh`dd1vt,bofoz1vt,bguo}rxwi1vt,bguohxfvwgffw1vt,bguo}rxwi1vt,bguorpfd`}w1vt,bguo}rxwi1vt,bguoufsm`bfb`udw1vt,bguo}rxwi`dd1vt,hKS!@FKS!@Studentsh@555)))))))' @VFS!@VFS!@SysRel''''''''''% VFS!@VFS!@Modules((((((((((& VFS!@VFS!@Scripts((((((((((& VFS!@VFS!@Reports((((((((((& VFS!@VFS!@Forms&&&&&&&&&&$ VFS!@VFS!@MSysModules,,,,,,,,,,* VFS!@VFS!@MSysModules2----------+  |FS!@|FS!@UserDefined,,,,,,,,,,*  |FS!@|FS!@SummaryInfoc@888,,,,,,,* @YڕFS!@YڕFS!@MSysRelationships22222222220 YڕFS!@YڕFS!@MSysQueries,,,,,,,,,,* YڕFS!@YڕFS!@MSysACEs))))))))))' YڕFS!@YڕFS!@MSy%VVW'VVX'V[V'WVV'ebkcgbkcibkchbkckbkcjbkcpbkcobkc ,[ProgNo] = Forms![frmProgSelection]![ProgNo]4!(kc7!(kc6!(kc8!(kc:!(kc9!(kc!(kc;!(kcA!(kc@!(kcPK$ btnfrmOpenRecbtnfrmOpenRec_ClickbtnOpenRecAdd_ClickG@t4Co3r$0 9[ProgNo] = Forms![frmOpenRec]![frmProgSelection]![ProgNo]Form_frmOpenRecMenuForm_frmOpenRecAdd"JS R 'HZQ T|P+:Mu g,HQ37 GOdi.AIi/  dsNUMsFirstsLastsAddress     ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   BLVALXX @ @ @::xGradesRsStudents`4:Grades"qStudents::xGradesRsStudents`4:Grades"qStudents NZI &>Grades"qStudentsD.0GradesRsStudents4 ILVAL . }e      M ėkcM ėkcM ėkcM ėkcM ėkcM ėkcM ėkcM ėkcM ėkcM ėkcM ėkcM ėkcM ėkcM ėKKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl k sNum    Link to Students Table    mb cNum     Course Number    m[ Grade     Grade    mKKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDTitleAuthorCompanyA JOINS Jim Hare, AOS-320 CTR FAAKKD AccessVersionBuild%  07.53 KKD KeepLocal T2~ozk\XI:6't %S!@S!@Students'''''''''''  S!@S!@RIGHT OUTER join - the STUDENT who has no GRADESOOOOOOOOOOO  S!@S!@RIGHT JOIN - all Students, and any grades that MATChSSSSSSSSSSS S!@S!@MSysModules2+++++++++++ S!@S!@MSysModules***********  % %ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o %    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o      ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   Tۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Tۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o LVALozk\XI:6's`QB>/ ss     ۇ O8V#%S!@S!@Students'''''''''''  S!@S!@RIGHT OUTER join - the STUDENT who has no GRADESOOOOOOOOOOO  S!@S!@RIGHT JOIN -`4:Grades"qStudents NZI &>Grades ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o      ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ʾGradesEQUI JOIN - Students with GRADESt( y$>GradesRsStudentsLVAL @ @ @ @ @ @ @ @ @********* ************ *!*"*#*$ *% *& *' *+ *, *- *. - - - - - - - -- - - --- -----*(*)**------ %-%-****** * * * ***ks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl k sNum  KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl c sNUM    Student Number    ma sFirst     First Name    m_ sLast     Last Name    m`sAddress    Address    m