Standard Jet DBnb` Ugr@?~1y0̝cßFNk7=Ԝ(s&`4{6߱dC?3Ty[%|*j|_׎}2f_Љ$g'DeFx -bT4.0-dv@ Y"S "" Y   Y Y  Y Y  Y  Y  Y  r Y s Y E Y a Y d Y 2Y  Y   Y  jY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeniYYIdParentIdName        OYhS!Y Y Y  Y 2ACMFInheritableObjectIdSID YObjectId YSY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -YSY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/ @@@2  @@ @@@  @JO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^QkiQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^mJL^QkMokmd`QiQ`f^dvQQYbqQbmdivYmQ`MJmQUdiv`kvkJMMQkkdL[QMmk`kvkJMQk`kvkbJqfJbQUidofMJmQUdiYQk`kvkbJqfJbQUidofk`kvkbJqfJbQUidofmddL[QMmk `kvkbJqfJbQdL[QMmYOk!`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkdiOQidiOQiYmQ`JMMQkk^Jvdom`kvkOLko``JivYbSd okQiOQSYbQO + 6SMJ@BJQ@F66JS@M>BLLMH:M868@Q68FQBD+ +;K[+ JF8J8QBJO>H@@HF<8@SL:O:>OLO@DJL@B:MH@<<6O+ +;K[  @ @ @ @          #(-5ADH O!x  @ @ @ @ @ @ @ @ @ @ @ @ @ !"#$%&'()*+,-./0123FGH I J K L M N O < < < < < < < <  456789#:#;#<(=(>(?-@-A-B5C5D5EA<A< A< A<D< D< D< D<H<H<H<H<O<O<O<O<     @@+ 6SMJ@BJQ@F66JS@M>BLLMH:M868@Q68FQBD+ +;K[;+ JF8J8QBJO>H@@HF<8@SL:O:>OLO@DJL@B:MH@<<6O+ +;K[; YbqQbmdiv;diOQi;diOQi;diOQiYmQ`;diOQiYmQ`; @@ Mokmd`Qi;Q`f^dvQQ;YbqQbmdiv;YmQ`MJmQUdiv;diOQi;"d _ Z 7 T  _  L 7! +4O6#=@6#=@ MSysNavPaneObjectIDs4MR2KeepLocal  TJJJJJJJH @HJ~"=@J~"=@ MSysNavPaneGroupToObjects4MR2KeepLocal  TTTTTTTTR @D"=@J~"=@ MSysNavPaneGroups4MR2KeepLocal  TDDDDDDDB @A"=@>Z"=@ MSysNavPaneGroupCategories4MR2KeepLocal  TVVVVVVVT @  @@AccessLayout4MR2KeepLocal T"@@zz:::::::8 @  O1 @t!mQ@Admin@S8,,,,,,,,,*  + @+ @{0FCA56AE-53D0-4800-AF5C-386C6C70CDD9}nnnnnnnnnnl  u @u @{D1A2D907-775A-424D-BD57-AB562C95330D}nnnnnnnnnnl  u @u @{A81A1E37-31B7-46A3-9938-0725962E02D5}nnnnnnnnnnl  u @u @{CB5B5069-004D-4955-9831-5FB2D380F2BE}nnnnnnnnnnl {| @{| @{731E66DC-5AD3-446B-BC92-C1015E018E67}nnnnnnnnnnl 5 @+ @OrderItem@4@@@44444442 @-O @, @Order"@4888,,,,,,,* @(k @, @ItemCategory@FFF:::::::8 @# @+ @Inventoryձ@@@@44444442 @X4 @ u @EmployeeL@>>>22222220 @; @ @CustomerZ@>>>22222220 @ @ @DataAccessPages@@@@@@@@@@> gH @gH @SysRel.........., gH @gH @Modules0000000000. gH @gH @Scripts0000000000. gH @gH @Reports0000000000. gH @gH @Forms,,,,,,,,,,*   @ @UserDefinedA@DDD88888886 @  @ @SummaryInfoՊ@DDD88888886 @ӝ @ӝ @MSysAccessObjectsDDDDDDDDDDB MW @MW @MSysRelationshipsDDDDDDDDDDB MW @MW @MSysQueries88888888886 MW @MW @MSysACEs22222222220 MW @MW @MSysObjects88888888886 MW @mQ@MSysDb@04:::......., @MW @MW @Relationships<<<<<<<<<<: MW @MW @Databases44444444442 MW @MW @Tables.........., fP{hUB/A S @ ,  |  B /   l Y 2 o\I"r_K8%taN:'     ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp      ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  5 5ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp 5 - -ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp - ( (ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ( # #ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp #  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp     ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp TON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp TON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp             Y NY Y DataIDYAOIndexOJmJLJkQkiQ^JmYdbkWYfkmJL^Qk`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkOL ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp            v1 @ @ @       ?   K[d k f 8`#TwDDDDS@D SHSp tStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStStS0PSMSysAccountsIx HK[ @ࡱ> Root Entry+ PropData Forms ββReportsββ Root EntryK PropData Forms ββReportsββ  ModulesTTScriptsTTVBATKCmdbarsTTCustomGroups TTDirDataVBAProjectȧKAcessVBAData DataAccessPages TTDatabases T0 TBlobK[v1 @   !"#$%&'()*+,-jiMSysDbID="{09C02B26-E8A0-42EB-A39D-A0FA8C98529E}" Name="SQLProb2" HelpContextID="0" VersionCompatible32="393222000" CMG="D4D62D1BD5EBD9EBD9EBD9EBD9" DPB="A8AA51A252A252A2" GC="7C7E85A38D768E768E89" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 00 VBAΧKPROJECTwmPROJECT!_VBA_PROJECT|0* pHdSQLProb2,@ Z= n ; %J< rst dole>stdole h%^*\G{0002`0430-C 0046}#2.0#0#C:\Windows\system32\e2.tlb#OLE Automation`hADO DB> ADOBD.DE1D10-8DAA006D2EA4D1Dgram Files\CommonSM\ado\ms21NMicrosoft ActiveX Data Objects 2.1 Libra,ryH"pK a  *\G{000204EF-0ModulesTTScriptsTTVBAT+CmdbarsTTCustomGroups TTDirDataVBAProjectȧ+AcessVBAData dir ImExSpecs++  !"#$%&'()*+,-LVAL v55  ܀mDw60DDMR2OrderByOnColumnWidthColumnOrderColumnMR2OrderByOnColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlDecimalPlacesDefaultValue YCategory      m_Description      mc StoreLocation      mU Season      meManagerID      0  mMR2OrderByOnColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlDecimalPlacesDefaultValue Format U ItemID      m_Description      mo"QuantityOnHand      0  mYCategory      mListPrice u  2 *$#,##0.00;($#,##0.00)   0  mCost 9  2 *$#,##0.00;($#,##0.00)   0  mMR2OrderByOnColumnWidthColumnOrderColumnHiddenDecimalPlacesDefaultValueRequiredDisplayControlAllowZeroLengthInputMask Y EID      0  mQName      mWAddress      m[Specialty u     meManagerID      0  mw Phone   $ 999\-999\-9999   mQCity      mS State :     mY Zip X     0  mMR2OrderByOnColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlDecimalPlacesDefaultValue QName      mWAddress C     mQCity      mS State      mY Zip      0  mYCategory      mY CID      0  mMR2( ReplicateProject MR20 Title AuthorCompanyV SQLProb2" Administrator CSUNK[N000-0000-C000-000000000046}#4.1#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office14\MSACC.OLB#Microsoft Access 14.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\system32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\System\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library  ;pKx  %AccessVBAWin16~Win32Win64xMacVBA6#VBA7#SQLProb26@stdole`ADODBs< jiMSysDbID="{09C02B26-E8A0-42EB-A39D-A0FA8C98529E}" Name="SQLProb2" HelpContextID="0" VersionCompatible32="393222000" CMG="DAD8230BF90FF90FF90FF90F" DPB="B4B64D75FD4EFE4EFE4E" GC="8E8C775F8BE364E464E49B" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 VBAΧ+PROJECTwmPROJECT%_VBA_PROJECT|0* pHdSQLProb2,@ Z= n ; %J< rst dole>stdole h%^*\G{0002`0430-C 0046}#2.0#0#C:\WINDOWS\system32\e2.tlb#OLE Automation`hADO DB> ADOBD.DE1D10-8DAA006D2EA4D1Dgram Files\CommonSM\ado\ms21NMicrosoft ActiveX Data Objects 2.1 Libra,ryH"pK am  *\G{000204EF-0dir ImExSpecs <YNY  Y d Y d Y d Y dY  Y dCIDNameAddressCity StateZipCategoryY-YY.rCCIDPrimaryKeyv1 t'~8 d)Charlie Peacock23 Paris LnFt. WorthTXFLO<73( ]Ray Boltz333 ZiptreeBostonMAWALK4.*" pJim Brickman787 SurewayBostonMAWALK71-% B0Marvin Matthews234 Sandy Ln # 128SpringfieldILWALKF@</ fStephen C. Chapman12 Oakwood Suite 234BostonMAGOVE@<4 L0Leon Redbone2934 Simon Dr.SpringfieldILFLO>95( ]Warren Hill324 East 7thBostonMAGOV61-% ^Celine Dion143 Canada WayBostonMAFLO83/'   @ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ; @; @Customer22222222220  @ @DataAccessPages@@@@@@@@@@> gH @gH @SysRel.........., gH @gH @Modules0000000000. gH @gH @Scripts0000000000. gH @gH @Reports0000000000. gH @gH @Forms,,,,,,,,,,*   @ @UserDefinedA@DDD88888886 @  @ @SummaryInfoՊ@DDD88888886 @ӝ @ӝ @MSysAccessObjectsDDDDDDDDDDB MW @MW @MSysRelationshipsDDDDDDDDDDB MW @MW @MSysQueries88888888886 MW @MW @MSysACEs22222222220 MW @MW @MSysObjects88888888886 MW @MW @MSysDb\@:::......., @MW @MW @Relationships<<<<<<<<<<: MW @MW @Databases44444444442 MW @MW @Tables..........,   @CustomerC:\00-Crses\MIS430\03\Homework\Part2\SQLProb2.mdb /Customer.*- 3Customer C:\00-Crses\MIS430\03\Homework\Part2\Order.mdbiii   # Y (pZN    Y  Y 2d Y dd Y ed Y dY  Y d Y dY EIDNameAddressCity StateZip PhoneSpecialtyManagerID !"Y-YYY.rDEIDManagerIDPrimaryKeyv1  Mv 6 T  hDiana GonzalesPO Box 4930293, Boston, TX 73849BostonMA5555552233H[YMIA |Joe ChickenPO Box 239403, Boston, MA, 23203BostonMA5555552930GWUIE= qLouise KingPO Box 2340, Boston, MA, 20304BostonMA5555559394FUSGC; gSamantha TechnickPO Box 123, Boston, MA, 23423BostonMA5555551303EZXLH@! 80Kevin AlexanderPO Box 10340, Springfield, IL, 12433SpringfieldIL5555559993DdbVRE 90Carla JonesPO Box 11, Springfield, IL, 12323SpringfieldIL5555551231C][OK> C0Susan SmithPO Box 434, Boston, MA 12345SpringfieldIL5555552354BYWKG: John SamualPO Box 1243, Boston, MA 75234BostonMA5555551223ATRFB: 80Smitty ClarkPO Box 302, Springfield, IL, 23940SpringfieldIL5555552321L_]QM@ Katie HayesPO Box 390, Boston, MA, 23923BostonMA5555552310KTRFB: .0Joan SwitcherPO Box 30202SpringfieldIL5555552111JJH<8+ Kaethe OswaldPO Box 23239BostonMA5555552390IEC73+  @       ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]οX4 @X4 @Employee22222222220 ; @X4 @CustomerZ@>>>22222220 @ @ @DataAccessPages@@@@@@@@@@> gH @gH @SysRel.........., gH @gH @Modules0000000000. gH @gH @Scripts0000000000. gH @gH @Reports0000000000. gH @gH @Forms,,,,,,,,,,*   @ @UserDefinedA@DDD88888886 @  @ @SummaryInfoՊ@DDD88888886 @ӝ @ӝ @MSysAccessObjectsDDDDDDDDDDB MW @MW @MSysRelationshipsDDDDDDDDDDB MW @MW @MSysQueries88888888886 MW @MW @MSysACEs22222222220 MW @MW @MSysObjects88888888886 MW @MW @MSysDb\@:::......., @MW @MW @Relationships<<<<<<<<<<: MW @MW @Databases44444444442 MW @MW @Tables..........,    @   EmployeeC:\00-Crses\MIS430\03\Homework\Part2\SQLProb2.mdb /Employee.*- 3Employee C:\00-Crses\MIS430\03\Homework\Part2\Order.mdbiii   #  @       |Joe ChickenPO Box 239403, Boston, MA, 23203BostonMA5555552930GWUIE= qLouise KingPO Box 2340, Boston, MA, 20304BostonMA5555559394FUSGC; gSamantha TechnickPO Box 123, Boston, MA, 23423BostonMA5555551303EZXLH@! 80Kevin AlexanderPO Box 10340, Springfield, IL, 12433SpringfieldIL5555559993DdbVRE 90Carla JonesPO Box 11, Springfield, IL, 12323SpringfieldIL5555551231C][OK> C0Susan SmithPO Box 434, Boston, MA 12345SpringfieldIL5555552354BYWKG: John SamualPO Box 1243, Boston, MA 75234BostonMA5555551223ATRFB: 80Smitty ClarkPO Box 302, Springfield, IL, 23940SpringfieldIL5555552321L_]QM@ Katie HayesPO Box 390, Boston, MA, 23923BostonMA5555552310KTRFB: .0Joan SwitcherPO Box 30202SpringfieldIL5555552111JJH<8+ Kaethe OswaldPO Box 23239BostonMA5555552390IEC73+ Y N$$  Y d Y dY Y Y  Y td ItemIDDescriptionListPriceCostQuantityOnHandCategory<T<T$&T$'$=MY5Y(YY.rCL{D1A2D907-775A-424D-BD57-AB562C95330D} ItemIDPrimaryKeyv1 @ X # W!R ~ 0q@k@9765ArchwayFLO*%?@@ 8776WrenchTOOL*$?@ffffff@8766WrenchTOOL*$?@@3446HammerTOOL*$?@@3445HammerTOOL*$?(\@333333@ 1504RakeGAR'"?@@1502SpadeGAR(#?@@1302Cat ToyCAT*%???1300Cat FoodCAT+&?ffffff@ @1225Dog ToothbrushDOG1,?@@1224Dog BrushDOG,'???1223Dog FoodDOG+&? #@ @8::<%8::>%8::@%8<66%8<6:%8@6:%8@6>%<>>@%<>>B%FDBB% FDDB% HDB@% #ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp #  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp # @ @Inventory44444444442 X4 @ @EmployeeL@>>>22222220 @; @X4 @CustomerZ@>>>22222220 @ @ @DataAccessPages@@@@@@@@@@> gH @gH @SysRel.........., gH @gH @Modules0000000000. gH @gH @Scripts0000000000. gH @gH @Reports0000000000. gH @gH @Forms,,,,,,,,,,*   @ @UserDefinedA@DDD88888886 @  @ @SummaryInfoՊ@DDD88888886 @ӝ @ӝ @MSysAccessObjectsDDDDDDDDDDB MW @MW @MSysRelationshipsDDDDDDDDDDB MW @MW @MSysQueries88888888886 MW @MW @MSysACEs22222222220 MW @MW @MSysObjects88888888886 MW @MW @MSysDb\@:::......., @MW @MW @Relationships<<<<<<<<<<: MW @MW @Databases44444444442 MW @MW @Tables..........,  #@ @8::<%8::>%8::@%8<66%8<6:%8@6:%8@6>%<>>@%<>>B%FDBB% FDDB% HDB@%  InventoryC:\00-Crses\MIS430\03\Homework\Part2\SQLProb2.mdb / Inventory.*/ 3 Inventory  C:\00-Crses\MIS430\03\Homework\Part2\Order.mdbiii     # ,YN)) Y d Y d Y d Y dY CategoryDescriptionStoreLocation SeasonManagerID<T<T)+T<<T<T),T<Y#YY.rCManagerIDPrimaryKeyv1(k8 ItemCateTOOLTools351SUMMER  GARGarden Items351SUMMER& FLOFlorist Supplies234SPRING*" DOGDog Item342SPRING" CATCat Item123SPRING"  ( *****(ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ( # #ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp #  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te(k @k @ItemCategory::::::::::8 # @k @Inventoryձ@@@@44444442 @X4 @ @EmployeeL@>>>22222220 @; @X4 @CustomerZ@>>>22222220 @ @ @DataAccessPages@@@@@@@@@@> gH @gH @SysRel.........., gH @gH @Modules0000000000. gH @gH @Scripts0000000000. gH @gH @Reports0000000000. gH @gH @Forms,,,,,,,,,,*   @ @UserDefinedA@DDD88888886 @  @ @SummaryInfoՊ@DDD88888886 @ӝ @ӝ @MSysAccessObjectsDDDDDDDDDDB MW @MW @MSysRelationshipsDDDDDDDDDDB MW @MW @MSysQueries88888888886 MW @MW @MSysACEs22222222220 MW @MW @MSysObjects88888888886 MW @MW @MSysDb\@:::......., @MW @MW @Relationships<<<<<<<<<<: MW @MW @Databases44444444442 MW @MW @Tables..........,  (@MJm*OdU*S^d*UJi*mdd^*GARGarden Items351SUMMER& FLOFlorist Supplies234SPRING*" DOGDog Item342SPRING" CATCat Item123SPRING"  wYH3TN..Y Y Y  Y OrderIDOrderDateCIDEIDTT9TT9T.09TTTT9TT9T.19TTTT9TT9T.29TTTT9TT9T.39TTY5YYYYYY.rGL{731E66DC-5AD3-446B-BC92-C1015E018E67}L{CB5B5069-004D-4955-9831-5FB2D380F2BE}CIDEIDOrderIDPrimaryKeyHv1b0-v_H1yb2@:1@0@ 0@ 0@0@0@0@ 0@0`@ 0@ 0@ 0@@ 0@0@ 0 @0@ /@|@ ~ - @ @/// /// /// / ///// ///-ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp - ( (ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ( # #ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp #  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y q-O @O @Order,,,,,,,,,,* (k @O @ItemCategory@FFF:::::::8 @# @k @Inventoryձ@@@@44444442 @X4 @ @EmployeeL@>>>22222220 @; @X4 @CustomerZ@>>>22222220 @ @ @DataAccessPages@@@@@@@@@@> gH @gH @SysRel.........., gH @gH @Modules0000000000. gH @gH @Scripts0000000000. gH @gH @Reports0000000000. gH @gH @Forms,,,,,,,,,,*   @ @UserDefinedA@DDD88888886 @  @ @SummaryInfoՊ@DDD88888886 @ӝ @ӝ @MSysAccessObjectsDDDDDDDDDDB MW @MW @MSysRelationshipsDDDDDDDDDDB MW @MW @MSysQueries88888888886 MW @MW @MSysACEs22222222220 MW @MW @MSysObjects88888888886 MW @MW @MSysDb\@:::......., @MW @MW @Relationships<<<<<<<<<<: MW @MW @Databases44444444442 MW @MW @Tables.........., ~ - @ @ / / / /  / / / / / // / ///// / OrderC:\00-Crses\MIS430\03\Homework\Part2\SQLProb2.mdbyy /Order.*' 3Order C:\00-Crses\MIS430\03\Homework\Part2\Order.mdbiii   #~ - @ @//0/0/0/0/0/0/0/0/0/ 0/ 0/ 0/ 0/ 0/0/1:/2/:1@0@ 0@ 0@0@0@0@ 0@0`@ 0@ 0@ 0@@ 0@0@ 0 @0@ /@|@ ~ - @ @//0/0/0/0/0/0/0/0/0/ 0/ 0/ 0/ 0/ 0/0/1:/2/LVAL1  -MR2nAccessVersion BuildProjVerNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By>Show Navigation Pane Search Bar&Theme Resource Name~ 08.50 P w       MR2nAccessVersion BuildProjVerNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By>Show Navigation Pane Search Bar&Theme Resource Name~ 08.50 P w       MR2OrderByOnColumnWidthColumnOrderColumnHiddenDecimalPlacesDefaultValueRequiredDisplayControlAllowZeroLength Format aOrderID       0  mU ItemID      mcQuantity 9     0  mSalePrice   2 *$#,##0.00;($#,##0.00)   0  mMR2OrderByOnColumnWidthColumnOrderColumnHiddenDecimalPlacesDefaultValueRequiredDisplayControlCaptionRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToList aOrderID       0  mHOrderDate    Y CID      0  m] EID V     0  o EmployeeID Table/Queryp hSELECT DISTINCTROW [Employee].[EID] FROM [Employee];       1440  1440twip  YN66Y  Y dY Y OrderID ItemIDQuantitySalePrice68696:Y-Y#YYYL{0FCA56AE-53D0-4800-AF5C-386C6C70CDD9}L{A81A1E37-31B7-46A3-9938-0725962E02D5} ItemID OrderItemOrderIDPrimaryKeyv1^ 5eF'mN/ 2 @12242 ?1223:1p@97650@87760?13000ffffff@34450@12240@12230@87760@12240 @12240ffffff@12250@12240?13000@12230@87760?13000@15040@1224/ ?1223D 5@ @ @8::<78::<78::<7 8::<78::>78::>78::>7 8::>7 8::>7 8::>78::@78<6678<6678<6678@6>7<>>@7FDDB7FDDB7 FDDB7HDB@75ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp 5 - -ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp - ( (ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ( # #ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp #  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON5 @ @OrderItem44444444442 -O @ @Order"@4888,,,,,,,* @(k @O @ItemCategory@FFF:::::::8 @# @k @Inventoryձ@@@@44444442 @X4 @ @EmployeeL@>>>22222220 @; @X4 @CustomerZ@>>>22222220 @ @ @DataAccessPages@@@@@@@@@@> gH @gH @SysRel.........., gH @gH @Modules0000000000. gH @gH @Scripts0000000000. gH @gH @Reports0000000000. gH @gH @Forms,,,,,,,,,,*   @ @UserDefinedA@DDD88888886 @  @ @SummaryInfoՊ@DDD88888886 @ӝ @ӝ @MSysAccessObjectsDDDDDDDDDDB MW @MW @MSysRelationshipsDDDDDDDDDDB MW @MW @MSysQueries88888888886 MW @MW @MSysACEs22222222220 MW @MW @MSysObjects88888888886 MW @MW @MSysDb\@:::......., @MW @MW @Relationships<<<<<<<<<<: MW @MW @Databases44444444442 MW @MW @Tables.........., l 5 @ @/7070707070707070707 07 07 07 07 0707071:72727CoOrderItemC:\00-Crses\MIS430\03\Homework\Part2\SQLProb2.mdb /CoOrderItem.*/ 3CoOrderItem CoC:\00-Crses\MIS430\03\Homework\Part2\Order.mdbiii Co Co # 5/8::<708::>708@6>708<6670FDDB708::<708<66708::>708::@708::>7 08::>7 0FDDB7 08::<7 08::>7 0<>>@708<6670FDDB71:HDB@728::<728::>72 ?1223:1p@97650@87760?13000ffffff@34450@12240@12230@87760@12240 @12240ffffff@12250@12240?13000@12230@87760?13000@15040@1224/ ?1223 q= {hUB/A S @ ,  |  B /   l Y 2 o\I"r_K8%tON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  5 5ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp 5 - -ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp - ( (ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ( # #ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp #  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp     ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]{0FCA56AE-53D0-4800-AF5C-386C6C70CDD9}OrderItemOrderIDOrderOrderIDzlZ{D1A2D907-775A-424D-BD57-AB562C95330D}InventoryCategoryItemCategoryCategory|lZ{A81A1E37-31B7-46A3-9938-0725962E02D5}OrderItemItemIDInventoryItemIDxlZ{CB5B5069-004D-4955-9831-5FB2D380F2BE}OrderEIDEmployeeEIDzjdZ{731E66DC-5AD3-446B-BC92-C1015E018E67}OrderCIDCustomerCIDzjdZ vcO<)   x e w v c  @ @ @ @ @ @ !"#$%&'()*+,-./0123FGH I J K L M  456789#:#;#<(=(>(?-@-A-B5C5D5E   O[ZJ'*Y94]? V%tYElռo &j3i%Od& ֋J=>u?)MgQ102xmMqS 6.y qp O OON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp O H[ZJ'*Y94]? V%tYElռo &j3i%Od& ֋J=>u?)MgQ102xmMqS 6.y qp D[ZJ'*Y94]? V%tYElռo &j3i%Od& ֋J=>u?)MgQ102xmMqS 6.y qp A[ZJ'*Y94]? V%tYElռo &j3i%Od& ֋J=>u?)MgQ102xmMqS 6.y qp H HON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp H D DON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp D A AON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp A    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp      ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp      ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  #@@@MJm%MJm%OdU%OdU%OdU%S^d% UJi%UJi%mdd^%mdd^%mdd^% mdd^%  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  5 5ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp 5 - -ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp - ( (ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ( # #ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp #  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp    ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp     ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp   ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp TON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp TON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp       ON8Te*Y94]ο͛Uso &j3i%Od& k@g,_NMgQ102xmMqS 6.y qp  LVALcO< 7 T  _  L ʾOrderItemY^3ά(yE&bOrderOrder bOrderItemOrderItem2qCustomerCustomerqInventoryInventory>qEmployeeEmployee$qItemCategoryItemCategoryK[++000-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\Office12\MSACC.OLB#Microsoft Access 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\System\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library ;pKx $AccessVBAWin16~Win32MacVBA6#SQLProb26@stdole`ADODBs<   LVALʾItemCategoryCreate query in Design viewY^3>YNBB Y Y Y  Y Y Y 3Y 3 Filter FlagsIdNamePosition SelectedObjectIDType3,3,BC,3YIdv1ALLL RY NEE Y Y Y  Y Y ,Y 3Y 3 FlagsGroupCategoryIDIdName"Object Type GroupObjectIDPosition3,3,EF,33,3,EG,3YYGroupCategoryIDIdv1@  D @MMMMMMMM M D @MMMMMMMMM YNIIY Y Y Y @ Y ,Y 3Y 3 FlagsGroupIDIconIdNameObjectIDPosition,3,3IJ3,,3,3IK3,YYGroupIDIdv1@@ H @ @NNNNNNNN N N  N  N  N N  H @ @NNNNNNNNNN N N N N qAOCustomgR e e/D yL|O  }Custom Group 162.*&" } } } } } } }` HyLk> H w D  w A  w 5  w -  w ( w# w w w w w w w wRY"MW @NPPY  Y  Y IdNameTypedvO"h=T)  M (  i  F e 8 q 4 OMSysNavPaneObjectIDs2.HMSysNavPaneGroupToObjects<8DMSysNavPaneGroups,(AMSysNavPaneGroupCategories>:AccessLayout " Admin  {0FCA56AE-53D0-4800-AF5C-386C6C70CDD9}VR {D1A2D907-775A-424D-BD57-AB562C95330D}VR {A81A1E37-31B7-46A3-9938-0725962E02D5}VR {CB5B5069-004D-4955-9831-5FB2D380F2BE}VR{731E66DC-5AD3-446B-BC92-C1015E018E67}VR5OrderItem-Order(ItemCategory"#InventoryEmployeeCustomerDataAccessPages($SysRelModulesScriptsReportsFormsUserDefined SummaryInfo MSysAccessObjects,(MSysRelationships,(MSysQueries MSysACEsMSysObjects MSysDbRelationships$ DatabasesTablesA׏ mLVALά' :jOrderOrderAOrderItemOrderItem xCustomerCustomeriInventoryInventoryyEmployeeEmployee&%ItemCategoryItemCategory