Standard Jet DBnb` Ugr@?~1y0̝cßFNo7 М(G"`{6߱#`C;3`y[!|*J|k䴂f_Љ$g'DeFx -bT4.0dv Y,hS ,, Y  M Y eY  Y Y  Y  8Y  Y   Y t Y  Y  Y  Y 2Y  Y   Y  tY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypetYYIdParentIdName        OYS+Y Y Y  Y 2ACMFInheritableObjectIdSIDdHr YObjectId Y:S:Y  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/ @@  @>@>@%  @@   @@  JO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk`kvkJMMQkkdL[QMmk`kvkJMQk`kvkY`QuMd^o`bk`kvkY`QukfQMk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhkQ^Ldd\khkQ^Mokmd`QibJ`QkhkQ^fiJMmYMQ[dYbhkQ^iQmJY^fiYMQhkQ^kofQiqYkdikhumLfid[QMmmY`QmL^Ldd\fid[QMmmL^Ldd\kJ^QkmL^Mokmd`QimL^Q`fYOfid[QMmmL^WiOJmJmL^bQsfid[QMmk mL^fQikdbJ^!mL^fiJMmYMQQhoYf`Qbm"mL^fiJMmYMQ`JbJUQik#mL^fid[QMmmY`Q$mL^kofQiqYkdik%JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO+ :BL>88>>6F+ +;K[&+ :BL>88>@6F+ +;K['+ :BL>88>B6F+ +;K[(+ :BL>88>D6F+ +;K[)+ :BL>88>F6F+ +;K[*mL^fQikdbJ^mL^WiOJmJ[  @ @ @ @ @          &'()*[%,159 ?!C"I#O$U%s  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ \\\\\\\\\ \ \ \ \\\\\\\\\\\\\$\% \8 \9 \: _ _ _ _ _  _  _  _  _  _ _ _______\&\'\(\)\*\+\,\-\.\/\0\1\2\3\4\5\6\7\H\I\J\K\?\@\A\L_____\;\<\=\>\B\C\D\E\F\G___%_%_%_,_,_,_1_ 1_!1_"5_#5_$5_%9_&9_'9_(?_)?_*?_+C_,C_-C_.I_/I_0I_1O_2O_3O_4U_5U_6U_7\\\\ \\ \\\\!\"\#^  @ @ @ @ @ @ @                                       ! " # $ % & ' (  )+,-.*/1234567 8 90 @@+ :BL>88>>6F+ +;K[Z+ :BL>88>@6F+ +;K[Z+ :BL>88>B6F+ +;K[Z+ :BL>88>D6F+ +;K[Z+ :BL>88>F6F+ +;K[ZmL^fQikdbJ^mL^WiOJmJZ @@mL^Ldd\kJ^QkZmL^Ldd\kJ^QkZmL^Mokmd`QiZmL^Q`fYOfid[QMmZmL^Q`fYOfid[QMmZmL^WiOJmJZ  @mL^Ldd\fid[QMmZmL^Ldd\fid[QMmZmL^Mokmd`QiZmL^fQikdbJ^ZmL^fQikdbJ^ZmL^fQikdbJ^ZO+d _ Z g  ~K s  \ zGKGFFCjT>77@77@{26B41148-03B6-11CF-77@77@{26B41148-03B6-11CF-98C6-0020AFD5DA48}ȓnnnnnnnnnnl @7@@7@{26B41147-03B6-11CF-98C6-0020AFD5DA48}ȓnnnnnnnnnnl 7@7@{26B41146-03B6-11CF-98C6-0020AFD5DA48}ȓnnnnnnnnnnl @57@@57@{26B41145-03B6-11CF-98C6-0020AFD5DA48}ȓnnnnnnnnnnl 27@27@{26B41144-03B6-11CF-98C6-0020AFD5DA48}ȓnnnnnnnnnnl UGK@:`k>L@tblSupervisorsȓ*@eJJJ>>>>>>>< @[I9-K@/Ν-K@tblPracticeManagersȓ@eTTTHHHHHHHF @C5v-K@j-K@tblPracticeEquipmentȓ@dVVVJJJJJJJH @?7@?- K@tblPersonalȓ@dDDD88888886 @9 oJ@0 K@tblNewProjectsȓ@cJJJ>>>>>>>< @5.sI@sI@tblHRDataȓ>@c@@@44444442 @1Y7@ 7@tblEmpIDProjectȓ_@bLLL@@@@@@@> @[% |U7@dJ@tblBookSalesȓ@aFFF:::::::8 @37@GK@tblBookProjectȓ@aJJJ>>>>>>>< @yKs-K@/3-K@qxtbProjectTimeȓ@^@]XLL@@@@@@@> @oF,K@I^-K@qselSupervisorsȓ@^@@`XLL@@@@@@@> @[ OL@KpL@qselPracticeJoinȓ/@^@@]ZNNBBBBBBB@ @ IxUK@{-K@qselCustomerNamesȓQ@^@]\PPDDDDDDDB @ 2;K@hZN@qselBooksȓ@^@@]L@@44444442 @5@`j5@MSysIMEXSpecsȓ<<<<<<<<<<: 5@YYrI@MSysIMEXColumnsȓ@@@@@@@@@@> !R@!R@MSysAccessObjectsȓDDDDDDDDDDB   0@OJ@Adminȓ@]8,,,,,,,,,*  `G5@`G5@UserDefinedȓ88888888886  `G5@`G5@SummaryInfoȓ@^DDD88888886 @[l5@l5@SysRelȓ.........., `5@`5@Scriptsȓ0000000000. L5@L5@Reportsȓ0000000000. 5@5@Modulesȓ0000000000. L5@L5@Formsȓ,,,,,,,,,,*  R@ R@DataAccessPagesȓ@@@@@@@@@@> D5@D5@MSysRelationshipsɑDDDDDDDDDDB D5@D5@MSysQueriesɑ88888888886 D5@D5@MSysACEsɑ22222222220 D5@D5@MSysObjectsɑ88888888886 D5@ R@MSysDbȓ"@^:::......., @D5@D5@Relationshipsɑ<<<<<<<<<<: D5@D5@Databasesɑ44444444442 D5@D5@Tablesɑ..........,  YNY Y DataID rocerYAOIndexv1 K[X06 wSysAccessObjectsLLLLLLLLLLJ vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv 23v | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |SysAccessObjects | | | | | | | | | | | | | | | | | | | | | | | |xp  |{WS@pwP@Њ$~$~x$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~$~Ѝ`~0/x, x ~ ~(x rOrderBMSysAccountsonColumnWidthColumnOrderColumnHiddenRequiredAllopx    xx ROGRAM FILES\  -K[ࡱ>   Root Entry qEP VBA;PqEPVBAProject;PqEPVBAE>P@Pdir_VBA_PROJECT  PROJECT.8PROJECTwm3  !"#$%&'()*+,-/0120* pHd QueryDsn .mdb<@ = v B]9DA<VDAO>BDAO *\G{00025E01-0C  0046}#5.0#0#C:\PROGRAM FILES\COMMON MICROSOFT SHARED\w350.DLL#Microsoft 3.5 Object LibraryHTstdole>fstdole]h^]043[V -]2]WINDOWS\Syst em32\22.tlb#OLE AutomatiLon0VBIDE> VBIDjEDDE157D5.3Qrogram Files\Co0mmonIShared\VBA6E6EXT.OLBRVisual Basic for Applic1s Extensibility +"b^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\Office10\MSACC.OLB#Microsoft Access 10.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.5 ObjectK[ Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE AutomationZ*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3 B]9Ab^x %AccessVBAWin16~Win32MacVBA6# QueryDsn.mdb!DAOstdole`VBIDEAH   ID="{3571B576-9704-4588-99C0-BA58BC3156EA}" Name="QueryDsn.mdb" HelpContextID="0" VersionCompatible32="393222000" CMG="5250EE514F554F554F554F55" DPB="AFAD13342DCC8BCD8BCD8B" GC="0C0EB09750F551F5510A" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ijMSysDbAcessVBAData4 Forms  ;P;PCmdbars;P;PModules ;P;PReports;P;PScripts ;P;PPropData5Databases;PqEP0;P@PBlob DirData6CustomGroups;P;PDataAccessPages ;P;PK[  qYNY Y  Y Y Y Y Y Y AttributesDataTypeFieldNameIndexTypeSkipColumn SpecID Start Width$$$$$$YY Index1PrimaryKeyv1   YN   Y Y Y Y  Y $ Y Y Y $ Y $ԀY  Y   Y  $ Y  $DateDelim"DateFourDigitYear DateLeadingZerosDateOrderDecimalPointFieldSeparatorFileType SpecIDSpecNameSpecTypeStartRowTextDelimTimeDelim$$$ԉYPrimaryKeyv1 W:NI O  W e G ) X k M /  q*Z<N0U!i"  Format([dtmPeriodEnd],"mmmm")< g  tblProjectTime.strProjectID: g Total HoursSum(tblProjectTime.dblHours)Q'' o The ValueSum(tblProjectTime.dblHours)M## o Expr1~@' o tblProjectTime.strProjectID: g tblProjectTime---   G  G    G tblSupervisorstblSupervisors_1MM-  tblSupervisors---   G  G    G  @ '  CalcNewBookPrice[curBookPrice]*1.05R11 o  tblBookProject.curBookPrice: g  tblBookProject.strBookTitle: g  tblBookProject.strPartNumber; g  tblBookProject---    G   G     G  tblPracticeManagerstblPracticeEquipment@k_7   B@ g  !tblPracticeManagers.strDeptCode> g  tblPracticeManagers.strName: g  tblPracticeEquipment999   tblPracticeManagers777    G   G     G  tblCustomertblBookSalesl@K?'   tblBookProjecttblBookSalesl@QE-   tblCustomer.strCustomerName: g  tblBookProject.strBookTitle: g  tblCustomer'''   tblBookSales)))   tblBookProject---    G   G    G tblBookSales.lngQuantitySold; g tblBookSales.lngOrderID6 g tblBookProject.strBookTitle: g tblBookProject.[strPart#]8 g tblBookSales)))  tblBookProject---   G  G    G LVAL(b 0 Format([dtmPeriodEnd],"mmmm") In ("January","February","March")(((tblBookProject.strPartNumber) Like "31*" Or (tblBookProject.strPartNumber) Like "34*"))tblPracticeManagers.strDeptCode = tblPracticeEquipment.strDeptCodetblPracticeEquipment.strEquipmenttblCustomer.strCustomerID = tblBookSales.strCustomerIDtblBookProject.[strPart#] = tblBookSales.strPartNumber *YN   Y   Y dY Y Y Y  Y  strPart#strBookTitle$curDevelopmentCostcurBookPricedtmStartDatedtmShipDate*strProjectManagerCode$$ "$ԉ$$ #$Ԁ$$ $$ԀYYYPrimaryKeystrBookTitle*strProjectManagerCodev1GTI 5  Q R  P 2_SdlY @@36-272-TCUsing Electronic Mail Effectivelyen1-15XP-"p @@35-152-TCManaging Your Personal Financesen1-15VN-"d@@u@34-340-T3Residential LandscapingEN1-10NF-"֞;@K@34-338-T3Planning a GreenhouseEN1-10LD-"п^B@@U@34-326-T3Planning Perennial GardensEN1-10QI-"y`B@@S@34-313-T3The Complete Guide to Vegetable GardeningEN1-10`X-"y>@O@34-312-T3The Complete Guide to Flower GardeningEN1-10]U-"@*@30-353-T3Wallpapering Made EasyEN1-10ME-"`Nj@@30-352-TCIndoor Painting TechniquesEN1-10QI-"I@R@30-312-T3Renovating Your BathroomEN1-15OG-"L I@S@30-258-T3Wallpaper Made EasyEN1-10JB-"P1p@@30-231-T3Creating Toys with WoodEN1-10NF-"F@@T@30-179-TCBasic Home WiringEN1-10H@-"K  @ @ @ <68DHmM!<6:<8m<!<6:@Fm<!<6<8:m<!<6<@:mM!<6<@@:m<!<6>@>m<!<6>@Bm<!<6>@Dm<! <6>B6m<! <6>F8m<! <6>F:mM! <6@:BmM! <6@:DmM!<88:8m<!<88::m<!<88:m<!<8::@m<!<8:8mM!<><8:m<!<><8<:Bm<!<><<>6m<!<@8@:mM! ] 0  | O " n A  ` 3   R % qDc6 U(tGf9 X+wJi<VC@ 34-326-T320512$UB@30-457-T321965$TB@30-231-T321965$SB@31-124-T320784$RB@30-526-TC20784$QA@34-340-T320932$PA@ 31-241-TC20932$OA@34-340-T320926$NA@30-454-T320926$MA@ 30-352-TC20926$LA@30-452-T320151$K A@31-124-T320493$J A@ 31-123-T320493$I A@31-122-T320493$H A@31-121-T320493$G@@30-527-TC20657$F@@30-231-T320657$E@?@34-313-T321617$D@?@34-338-T321617$C>@ 30-457-T320932$B>@30-456-T320932$A>@30-454-T320932$@=@34-340-T321570$?=@34-338-T321570$>=@ 34-312-T321570$=;@30-457-T321965$<;@30-454-T321965$;;@30-452-T321965$:9@30-352-TC20926$99@30-231-T320926$89@31-241-TC21510$79@30-457-T321510$69@30-452-T320493$59@ 30-527-TC20493$49@ 30-526-TC20493$3@8@30-482-TC20657$2@8@34-313-T320657$1@7@31-241-TC20688$0@7@ 30-352-TC20688$/7@34-340-T321617$.7@ 34-338-T321617$-5@34-313-T320784$,5@30-454-T320784$+5@30-231-T320784$*4@31-121-T321587$)4@ 31-122-T321587$(4@31-123-T321587$'3@ 34-340-T320512$&3@30-526-TC20151$%3@30-352-TC20151$$@2@31-241-TC20181$#@2@31-238-TC20181$" 2@34-312-T320512$! 2@ 30-482-TC21587$ @1@ 31-241-TC20493$@1@ 31-241-TC20932$@1@31-241-TC21587$@1@ 31-241-TC20688$@1@ 31-241-TC20784$/@34-312-T321965$/@ 34-326-T321965$/@31-122-T321965$/@34-340-T321965$.@30-482-TC20493$.@30-481-T320493$ .@ 30-352-TC21587$ .@34-340-T321587$,@ 34-313-T320657$,@ 34-312-T320657$,@30-231-T320657$@,@ 34-338-T320688$@,@ 34-340-T320688$+@30-527-TC21570$ +@30-526-TC20784$ *@31-123-T321617$ *@31-122-T321617$ *@31-121-T321617$ *@30-482-TC20932$*@30-456-T320932$*@30-454-T320932$*@31-121-T321965$`(@34-338-T320512$`(@ 34-340-T320512$ '@34-338-T321617$ '@ 34-326-T321617$ '@34-312-T321617$` %yLk> dH@31-123-T320493$cH@31-241-TC20932$bH@31-122-T320932$aH@ 30-231-T320932$` G@31-241-TC20926$_ G@30-481-T320926$^ G@30-352-TC20926$]`E@30-527-TC20657$\`E@30-457-T320657$[`E@30-481-T321570$ZE@31-241-TC21510$YE@30-482-TC21510$XC@ 34-340-T320512$WC@34-338-T320512$ % @ @ @ @ @ @ @ @ @ @ @ @'''''''' ' '  '  '  ' ' ''''''''''''''''' '!' "'!#'"$'#%'$&'%''&('')'(*')+'*,'+-',.'-/'.0'/1'02'13'24'35'46'57'68'79'8:'9;':<';='<>'=?'>@'?A'@B'AC'BD'CE'DF'EG'FH'GI'HJ'IK'JL'KM'LN'MO'NP'OQ'PR'QS'RT'SU'TV'UW(X(Y(Z([(\(](^(_(`( a( b( c( d( p %:68@8'$:68@8'%:68@8'K:68F8'":68F8'#:6>H<':6>H<':6>H<':6>H<'3:6>H<'4:6>H<'5:6>H<'G:6>H<'H:6>H<'I:6>H<'J:6>H<( :6@8:':6@8:':6@8:'!:6@8:'&:6@8:'U:6@8:(:6@8:(:6B@D':6B@D':6B@D':6B@D'1:6B@D'2:6B@D'E:6B@D'F:6B@D(:6B@D(:6BFF':6BFF':6BFF':6BFF'/:6BFF'0:6DF>' :6DF>':6DF>'*:6DF>'+:6DF>',:6DF>'Q:6DF>'R:6H:B'8:6H:B'9:6H:B'L:6H:B'M:6H:B'N:6H:B(:6H:B(:6H:B( :6H<:':6H<:':6H<:':6H<:':6H<:'@:6H<:'A:6H<:'B:6H<:'O:6H<:'P:6H<:( :6H<:( :6H<:( :8@86'6:8@86'7:8@86(:8@86(:8@D6' :8@D6'=:8@D6'>:8@D6'?:8@D6(:8@FD':8@FD':8@FD':8@FD' :8@FD'':8@FD'(:8@FD'):8B8D':8B8D':8B8D':8B8D' :8B8D' :8B8D' :8B8D'-:8B8D'.:8B8D'C:8B8D'D:8HB@':8HB@':8HB@':8HB@':8HB@':8HB@'::8HB@';:8HB@'<:8HB@'S:8HB@'T\% @ @ @ @ @ @ @ @ @ @ @ @<6:<8m<'<6:<8m<'*<6:<8m<'8<6:<8m<'E<6:<8m<'S<6:<8m<( <6<@:mM'<6<@:mM'$<6<@:mM'/<6<@:mM'9<6<@:mM'L<6<@:mM(<6>@:m<'5<6>@:m<':<6>@:m<'K<6>@>m<'<6>@>m<'+<6>@>m<';<6>@>m<'@<6>@>m<'M<6>@Bm<'<6>@Bm<'A<6>@Dm<'6<6>@Dm<'<<6>@Dm<'B<6>@Dm<'T<6>@Dm<(<6>F8m<'<6>F8m<(<6>F8m<(<6>F:mM'<6>F:mM'<6>F:mM' <6>F:mM'2<6>F:mM(<6@:BmM' <6@:BmM'%<6@:BmM'3<6@:BmM'Q<6@:DmM' <6@:DmM'4<6@:DmM'F<6@:DmM(<88:8m<'<88:8m<' <88:8m<')<88:8m<'G<88::m<' <88::m<'<88::m<'(<88::m<'H<88::m<( <88:m<'J<88:>m<'R<8:8mM'<8:>8mM'<8:>8mM'<8:>8mM'<8:>8mM'<8:>8mM'#<8:>8mM'0<8:>8mM'7<8:>8mM'O<8:>8mM(<8:>8mM( <8:>8mM( <><8:m<'<><8:m<'<><8:m<'<><8:m<'!<><8:m<'=<><8<8<8<8<:Bm<'<><:Bm<'<><:Bm<'U<><<<<<<><<<>6m<'<><>6m<'<><>6m<'<><>6m<'<><>6m<'&<><>6m<'.<><>6m<'?<><>6m<'N<><>6m<'P<><>6m<( YN -- Y  Y d Y Z Y 2 Y $ Y ( Y  Y $ Y $ Y  strCustomerIDstrCustomerNamestrAddressstrCitystrRegionstrCountrystrPostalCodestrPhone strFaxstrSalesperson$$$-/$$$$-0$YYPrimaryKeystrZipCodev1@@,k i { u e X  21965Cover to Cover12 Harbor StBurlingtonVT04982-297730949777233094977861en1-20c[OC773'   21617S-Mart Garden Emporium5619 East AveHamiltonOntarioCanadaL2A 4J741637866384163782637en1-39tl`TKC:0!   21587Books and Beyond51 Windsor StCambridgeMA02139-212437536720943753674711en1-20e]QE995*   21570In Between the Covers2008 Delta AveCincinnatiOH45208-446874831144527483112349en1-39ldXL@@<0   21510Marlene's Magazines and Books81 114th AveBellevueWA98004-337397622746389762273312en1-50ph\PDD@6(   20932Allendale Books512 Columbia RdSomervilleNJ08876-298720738675562073861908en1-20g_SG;;7+   20926The Corner Bookstore36 N. Miller AveSyracuseNY13206-497631556278983155623876EN1-20kcWK??;1   20784Book World687 Mountain RdStoweVT08276-319630982866183098287569en1-20]UI=11-&   20688Books Abound51 Ulster StDenverCO80237-338659783582905978352699en1-50]UI=11-%   20657The Unabridged Bookstore99 West 77th StEdinaMN55435-027867521985626752193578en1-39kcWK??;4#   20512Gardening Galore79 Gessner PkHoustonTX77024-626120893568172089352879en1-39c[OC773*   20493Jamison Books396 Apache River AveFountain ValleyCA92708-498290949722899094972287en1-50og[OCC?.   20181Lakeview Bookstore289 Jacoban StHamiltonOntarioCanadaH8R 1C341639872094163982681en1-39qi]QH@7-   20151Engel's Books19 International DrRyebrookNY10273-976448722960874872291765en1-20g_SG;;7-  x ,:68@8.:68F8.:6>H<.:6@8:.:6B@D.:6BFF.:6DF>.:6H:B.:6H<:.:8@86. :8@D6. :8@FD. :8B8D. :8HB@.  ,@ @ 6:8. 6>HF::HDD. 6F:DB<8HB.6FFDB:HFD.86:D.8<:6B>HDB.>@:6F>>BF. @@><@6:DF.DD6:>B:B8.F6:HF:.HF66><[D. #YN22 Y  Y strEmployeeID strProjectNumber24ndYPrimaryKeyv11jL.z\>EN1-4031-241-TC EN1-4031-238-TC EN1-3836-272-TC EN1-3635-152-TC EN1-3531-238-TC EN1-3530-452-T3 EN1-3331-124-T3 EN1-3330-482-TC EN1-3330-452-T3 EN1-2631-124-T3 EN1-2630-457-T3 EN1-2630-452-T3 EN1-2231-241-TC EN1-2231-225-T3 EN1-2230-353-T3  1Qb8::<6<@8mM3Qb8:B<6>@:m<3Qb8:B<6>@Dm<3Qb8:B<88:>m<3Qb8<<<6>@:m<3Qb8<<<6>F:mM3Qb8<<<88:>m<3Qb8<@<6>@:m<3 Qb8<@<8:6<8:6<8:>8mM3 YN66 Y  Y Y Y  Y $ Y Y strEmpIdstrDeptdblHourscurPayRatestrHealthstrParkLotcurParkRate$$68$YPrimaryKeyv1? 5U y@  ` ' | C c *  D@  EN1-53MK1NW,(&"D@X EN1-50SS1SE,(&"9@" EN1-48SS1SW,(&"D@EN1-45CE1SE,(&"B@' EN1-43EE3NE,(&"D@PEN1-41MK4((&"_D@PpdEN1-40ES3SE,(&"D@G' EN1-39MS2NE,(&"9@[EN1-38ES3SW,(&"D@x]EN1-36SS1SE,(&"D@Gh EN1-35EE4NE,(&"D@x]h EN1-33CE2NE,(&"D@0|V EN1-30MK1NW,(&"A@Hh EN1-28CE1NE,(&"A@' EN1-27SS1NW,(&"D@`[' EN1-26SA1NE,(&"D@EN1-25CE3((&"_/@4 EN1-23EE3SW,(&"D@UEN1-22EE2SE,(&"D@I EN1-20EE1NW,(&"=@4EN1-19ES3((&"_9@LEN1-16MS3((&"_A@ EN1-15MK1NW,(&"D@G' EN1-12ES2NW,(&"C@x]EN1-10MK2SW,(&"E 5@ @ @ Qb8867Qb88:7Qb88@7Qb88B7Qb88H7Qb8:67Qb8::7Qb8:<7Qb8:@7Qb8:B7 Qb8:D7 Qb8:F7 Qb8<67 Qb8<<7 Qb8<@7Qb867Qb8>87Qb8><7Qb8>@7Qb8>F7Qb8@67Qb8@<7 4YN:: Y   Y dY Y Y Y  Y  strPartNumberstrBookTitle$curDevelopmentCostcurBookPricedtmStartDatedtmShipDate*strProjectManagerCode$$:<$$$:=$$$:>$YYYPrimaryKeystrBookTitle*strProjectManagerCodev1@  95\ 4 Q@ [@43-401-TCThe Mountain Bike Resource KitEN1-15UM-"Q@@Z@43-389-T3Maintaining Your Mountain BikeEN1-15UM-"X P@`Y@43-234-T3Mountain Biking in Southern CaliforniaEN1-15]U-"-O@X@41-157-TCThe Radio Controlled Airplane ReferenceEN1-10^V-"`N@W@41-145-T3Building and Flying Radio Controlled AirplanesEN1-10e]-"?N@V@41-132-T3Model Airplanes and MoreEN1-10OG-"&M@U@41-125-T3Getting Started with Radio Controlled AirplanesEN1-10f^-"q 9 @>88:@m<;>88<:m<;>88>@m<;>88@DmM;><:<>m<;><<>68mM; 9 LoY^OYbUJbOS^vYbUiJOYdMdbmid^^QOJYif^JbQk;UQmmYbUkmJimQOsYmWiJOYdMdbmid^^QOJYif^JbQk;`JYbmJYbYbUvdoi`dobmJYbLY\Q;`dOQ^JYif^JbQkJbO`diQ;`dobmJYbLY\YbUYbkdomWQibMJ^YSdibYJ;mWQ`dobmJYbLY\QiQkdoiMQ\Ym;mWQiJOYdMdbmid^^QOJYif^JbQiQSQiQbMQ; 9@ Qb886;Qb886;Qb886;Qb886;Qb88@;Qb88@;Qb88@; PYN  @@ Y  Y 2 Y  Y < Y $< Y  Y  Y $$Y strEmpIDstrLastNamestrFirstNamestrAddressstrCitystrStatestrZipCodestrPhonedtmHireDate$$@B$ԉYPrimaryKeyv1?7 N b |  " B `-B @EN1-53HigginsPaul67 Fargo RdIoniaNY14475-8469(716) 898-2012UE95.!  @EN1-50EisenbergCarolyn453 Lakeshore DrPultneyvilleNY14538-4987(315) 876-2124fVJF8&  @EN1-48WilliamsGayle45 French LaneHallNY14463-3745(315) 813-4833YI=93#  R@EN1-45DiPaoloEvelyn466 Fairhaven StLeicesterNY14481-4987(716) 821-2978`PD@5#  @EN1-43OsowskiRobert34 Park StRetsofNY14529-4963(716) 855-2209WG;7/#  @@EN1-41McDermottLucas273 Fireside DrDresdenNY14441-3652(315) 813-6488^NB>5$  @u@EN1-40WingAlexandra12 Danby DrHolleyNY14470-2396(315) 887-2985XH<80#  @EN1-39MeyerEdwardP.O.Box 7234WaylandNY14572-7234(315) 898-2944XH<8/!  @EN1-38SchaafCarol34 Sable AveGorhamNY14461-0749(315) 813-3397WG;7/!  @EN1-36RoslynElizabeth52 Pempleton DrWyomingNY14591-4693(315) 821-3782_OC?6%  @EN1-35BarancoSteven8165 Main StOaks CornersNY14518-0835(315) 887-3956_OC?1#  @s@EN1-33GuyaAmy81 Pleasing LaneRoseNY14542-4853(315) 813-5574UE95/  @EN1-30MicelliThomas99 Stonecreek RdGorhamNY14461-3683(315) 821-3730]MA=5#  p@EN1-28MillerAnthony127 Ford AveLakevilleNY14480-2874(315) 887-6975\L@<1#  @EN1-27OsborneSuzanne50 Dallas StSouth ByronNY14557-8423(315) 855-0856_OC?2$  @@EN1-26O'BrienSean23 Lakeside AvePultneyvilleNY14538-5327(315) 887-2208`PD@2!  W@EN1-25ChuLaurie32 Ash LanePerkinsvilleNY14529-1276(315) 876-4367ZJ>:,  @EN1-23OsborneWilliam50 Dallas StSouth ByronNY14557-8423(315) 855-0856_OC?2$  @@EN1-22HernandezNatalie50 Smart DrKnowlesvilleNY14479-0263(315) 821-7474aQEA3&  @EN1-20MacKenzieLauren21 Stonecreek RdShortsvilleNY14548-0863(315) 898-5664dTHD7%  @EN1-19MajidIndera12 West AveLeicesterNY14481-4847(716) 898-3966YI=9.!  @EN1-16GordonAnne10 Cory DrHulbertonNY14473-4875(315) 852-4703WG;7,   @EN1-15RubensteinSarah450 N. Madison StHolleyNY14470-3698(716) 855-8265`PD@8%  @EN1-12AndersonJacqueline82 East AveAdams BasinNY14410-2873(315) 855-0037bRFB5(  @EN1-10ColeDaniel34 Fields StWalworthNY14568-3689(315) 898-5931XH<8.  E ?@ @ @ Qb886AQb88:AQb88@AQb88BAQb88HAQb8:6AQb8::AQb8:<AQb8:@AQb8:BA Qb8:DA Qb8:FA Qb8<6A Qb8<<A Qb8<@AQb86AQb8>8AQb8><AQb8>@AQb8>FAQb8@6AQb8@<A YNDD Y  Y ( Y Y Y Y  Y strDeptCodestrEquipmentstrSerialNumberdtmPurchaseDateysnWarrantydblWtyDurationstrVendorID$$DF$$$DG$$$DH$YYYPrimaryKeystrDeptCodestrVendorIDv1@ v Cv6u/ w 0 e * w@@MSFax machineTO/444/14N604050# a@@SSLaser PrinterABA-6290602050%`@?CE386 PC968\45082010.)`@?CEDot Matrix Printer9-54-PO63458020=8* @@ESFaxfast8JA41337070350+@MSMini Calculator88-1534-003572'oI@?MSAnswering Maching87346-AT24040:5)`l@?MS386 PC823\22308025.)`@?MKExternal Modem5MD-3075801061& a@@EEPC5643-243-48D025-(@EEDeluxe Calculator54-1325-004094)o a@@CE286 PC5251-874-23T0101,`l@?MKPortable PC5123-354-42R02561#o@EEPencil sharpener43800353.(o@@@ESLaptop PC4235-234-980253.!@CEDeluxe calculator3387604050)or@SSCalculator with tape15845239040;6,o C@ @ 8@F>@::<@:<>HF#E>>:i#E@:@8FD>:8<:@6E@B><:><>FO#E@`O<6D@FEF:<)::<6FE FD<>BJm:>E FF8@<>6E F[J>8<fdB<>@F E HBF)>@6F:EJLJB:H6BEmd>>>8>bBE C @ @MQEMQEMQE MQEQQEQQEQQEQkEQkE `\E`\E`kE `kE `kE `kEkkEkkEv C@@@@686E686E686E6:6E 6:6E6:@E6:@E6:@E6:@E 6<@E6<@E 6<@E 6>6E6>6E6>6E6>6E 6>6E YNJJ Y  Y ( Y strDeptCodestrName strId$$JL$$$JM$$$JN$YYYDept CodePrimaryKey strIdv1@ ImH"SSSusan HartleEN74SADominick OsowEN13MSFrank DesotoEN23MKJudy WilsonEN41ESHanna HarperEN03EEAndrew WeinstEN72CEKen BeasleyEN71 I @MQKQQKQkK`\K`kKkJKkkK I @MQKQQKQkK`\K`kKkJKkkK I@ Qb6<KQb8<KQb:<KQb>8KQbD8KQbD:KQbD>K KYHNPPH HHHY  Y  Y Y dtmPeriodEndstrEmpIDstrProjectIDdblHours$$$PR$$$PS$$$$PT$YYY Emp IDPrimaryKeyProject IDv1rOHvHb4 | N h : T & n @  Z , tF`2zLf8 R$l>@W@L@EN1-8538-100-TC%@W@"@EN1-7742-390-TC%@W@;@EN1-7738-250-TC%@W@E@EN1-7736-124-TC%@W@?@EN1-4040-550-TC%@W@6@EN1-4038-100-TC%@W@J@EN1-3442-390-TC%@W@2@EN1-3440-550-TC%@W@L@EN1-2438-250-TC%@W@J@EN1-0536-124-TC%U@E@EN1-7742-390-TC%U@3@EN1-7738-250-TC%U@H@EN1-7736-124-TC%U@=@EN1-7640-550-TC%U@E@EN1-7638-250-TC%U@5@EN1-4031-450-TC%U@M@EN1-3431-450-TC%U@P@EN1-2442-390-TC%U@H@EN1-2438-250-TC%U@H@EN1-1842-390-TC%U@B@EN1-1038-250-TC%U@M@EN1-1036-124-TC%U@;@EN1-0540-550-TC%U@(@EN1-0531-450-TC%S@L@EN1-8538-100-TC%S@*@EN1-7742-390-TC%S@4@EN1-7738-250-TC%S@C@EN1-7736-124-TC%S@7@EN1-4040-550-TC%S@@@EN1-4038-100-TC%S@F@EN1-3442-390-TC%S@8@EN1-3440-550-TC%S@O@EN1-2438-250-TC%S@N@EN1-0536-124-TC%R@C@EN1-7742-390-TC%R@;@EN1-7738-250-TC%R@E@EN1-7736-124-TC%R@;@EN1-7640-550-TC%R@C@EN1-7638-250-TC%R@,@EN1-4031-450-TC%R@P@EN1-3431-450-TC%R@Q@EN1-2442-390-TC%R@H@EN1-2438-250-TC%R@K@EN1-1842-390-TC%R@F@EN1-1038-250-TC%R@@P@EN1-1036-124-TC%R@C@EN1-0540-550-TC%R@.@EN1-0531-450-TC%@P@O@EN1-8538-100-TC%@P@4@EN1-7742-390-TC%@P@.@EN1-7738-250-TC%@P@A@EN1-7736-124-TC%@P@4@EN1-4040-550-TC%@P@>@EN1-4038-100-TC%@P@4@EN1-4031-450-TC%@P@>@EN1-3442-390-TC%@P@>@EN1-3440-550-TC%@P@L@EN1-2442-390-TC%@P@L@EN1-2438-250-TC%@P@K@EN1-1842-390-TC%@P@J@EN1-1038-250-TC%@P@N@EN1-0536-124-TC%N@@EN1-7742-390-TC%N@4@EN1-7738-250-TC%N@D@EN1-7736-124-TC%N@4@EN1-7640-550-TC%N@A@EN1-7638-250-TC%N@Q@EN1-3431-450-TC%N@P@EN1-2438-250-TC%N@@P@EN1-1036-124-TC%N@C@EN1-0540-550-TC%N@(@EN1-0531-450-TC%O@ @ @ @ @ @ @ @ @ Qb86@QQb86@QQb86@Q Qb86@QQb86@QQb86@Q&Qb86@Q0Qb86@Q1Qb86@Q>Qb886QQb886Q Qb886QQb886QQb886Q2Qb886Q3Qb88FQ Qb88FQQb88FQ4Qb8:>QQb8:>Q Qb8:>QQb8:>QQb8:>QQb8:>Q'Qb8:>Q5Qb8:>Q6Qb8:>Q?Qb8<>QQb8<>QQb8<>QQb8<>QQb8<>Q(Qb8<>Q)Qb8<>Q7Qb8<>Q@Qb8<>QAQb8>6QQb8>6QQb8>6QQb8>6Q Qb8>6Q*Qb8>6Q+Qb8>6Q8Qb8>6QBQb8>6QCQb8DBQQb8DBQQb8DBQ!Qb8DBQ"Qb8DBQ9Qb8DBQ:Qb8DDQQb8DDQQb8DDQ Qb8DDQQb8DDQQb8DDQQb8DDQ#Qb8DDQ$Qb8DDQ%Qb8DDQ,Qb8DDQ-Qb8DDQ.Qb8DDQ;Qb8DDQ<Qb8DDQ=Qb8DDQDQb8DDQEQb8DDQFQb8F@QQb8F@Q/Qb8F@QGXO @ @ @ @ @ @ @ @ @NQb86@<8>@6mMQNQb86@>6@@6mMQNQb886mMQNQb8:><8>@6mMQNQb8DB6@@6mMQNQb8DDmMQNQb8DD:mMQ P@Qb886:>:>6@@6mMQP@Qb8<>>:6<8>@6mMQP@Qb8>66>6@@6mMQP@Qb8DDmMQP@Qb8DD:@6mMQRQb86@>6@@6mMQRQb886mMQRQb886:>:<8>@6mMQRQb8>6<8>@6mMQ RQb8DB6@@6mMQ"RQb8DDmMQ#RQb8DD:mMQ&SQb8:>>6@@6mMQ(SQb8<>>:66>6@@6mMQ+SQb8DDmMQ,SQb8DD:@6mMQ0UQb86@>6@@6mMQ1UQb886mMQ2UQb886:>:<8>@6mMQ7UQb8>6<8>@6mMQ8UQb8DB6@@6mMQ:UQb8DDmMQ;UQb8DD:mMQ>W@Qb8:>>6@@6mMQ@W@Qb8<>>:66>6@@6mMQCW@Qb8DDmMQDW@Qb8DD:@6mMQ<8>@6mMQ<8>@6mMQ<8>@6mMQ<8>@6mMQ<8>@6mMQ <8>@6mMQ0<8>@6mMQ7<8>@6mMQ8mMQmMQmMQ mMQmMQmMQ#mMQ&mMQ,mMQ2mMQ;mMQ>mMQD6@@6mMQ>6@@6mMQ>6@@6mMQ>6@@6mMQ>6@@6mMQ>6@@6mMQ">6@@6mMQ(>6@@6mMQ+>6@@6mMQ1>6@@6mMQ:>6@@6mMQ@>6@@6mMQC>:::::::::::::::  \#w?\$y@@EN87GardnerGayleMKEN80*$  ?@d@EN86MurrayNancyEEEN72)# ?D@EN85CassadaBruceCEEN69*$  ?#@EN83WarfieldCristinCEEN69-'# ?@@EN81DavisEugeneESEN40)# ?@EN80NelsonLukeMKEN41(" ?@EN79GradyEdwardSSEN62)# ?@EN78RussellLarryMSEN23*$  ?:@EN77ClarkThomasMKEN41)# ?t@EN76SmithPatriciaESEN40+%! ?@EN74HartleSusanSSEN30)# ?@EN73BerrySharonMKEN53)# ?`@EN72WeinsteinAndrewEEEN30-'# ?h@EN71BeasleyKenCEEN30(" ?@EN69PettySuzannaCEEN71*$  ?@@EN68StevensDavidCEEN71*$  ?r@EN66DonaldsonKathrynMSEN23.($ ?`@EN62BeatonRobertSSEN74*$  ?*@EN57CarterBenEEEN56'! ?@EN56MaoniBradEEEN72'! ?`@EN53BellWilliamMKEN26)# ?@EN50ClineDarrenSSEN74)# ? @EN41AbelGaryEEEN27&  ?v@EN40WardRodneyESEN20(" ?@@EN39EllisNajaSSEN74'! ?@EN38GerberJudyMKEN30(" ?B@EN36CastileAbrahamMKEN41,&" ?@EN34HornJasonSSEN74'! ?F@EN32VetchRandallSSEN19*$  ?@@EN30JonesHughCEEN30'! ?o@EN27ZangariNickEEEN72)# ?@EN26KylerDennisMKEN41)# ?@@EN24HenleyAlbertESEN03*$  ?-@EN23DesotoFrankMSEN30)# ?@EN20DeMarcoArleneESEN03+%! ?)@EN19ChaseWilmaSSEN74(" ?@j@EN18DuartePeterEEEN72)# ?@EN17ZambitoJosephCEEN71+%! ?7@EN16AbotRobertMKEN41(" ?@EN15AbelMurrayCEEN12(" ?@EN14BingaSamSSEN19&  ?@ @EN13OsowskiDominickSAEN30-'# ?P@EN12ConnerBillCEEN71(" ?@Y@EN11BingaAllisonEEEN27*$  ?@EN10MartinJaneEEEN27(" ?z@EN08EasterConnieEEEN72*$  ?@EN07SandersMariaESEN03*$  ?]@EN05BinderJuliaMSEN23)# ? @EN04PackerPennyMKEN41)# ?[@EN03HarperHannaESEN30)# ?@EN01JamesTedMKEN41&  ? U@ @ @ @ @ @ @Qb68WQb6<WQb6>WQb6@WQb6DWQb6FWQb86WQb88WQb8:WQb8<W Qb8>W Qb8@W Qb8BW Qb8DW Qb8FWQb8HWQb:6WQb:<WQb:>WQb:BWQb:DWQb<6WQb<:WQb<>WQb6WQb>8WQb@6WQb@<WQb@BWQb@DW QbB:W!QbBBW"QbBFW#QbBHW$QbD8W%QbD:W&QbD<W'QbD>W(QbDBW)QbDDW*QbDFW+QbDHW,QbF6W-QbF8W.QbF<W/QbF@W0QbFBW1QbFDW2 U@ @ @ @ @ @ @Qb6<WQb6<WQb6<WQb8:W Qb8HW Qb8HWQb:6WQb:<WQb:<W"Qb:<W+Qb:BWQb:DWQb:DWQb:DWQb<6WQb<6W Qb<6WQb<6WQb<6WQb<6W%Qb<6W&Qb<6W(Qb>6W)Qb>6W.Qb>8WQb>8WQb>8W Qb>8WQb>8WQb>8W*Qb>8W-Qb@<W'Qb@BW QbB:W,QbBHW/QbBHW0QbD8WQbD8W QbD8W#QbD8W$QbD:WQbD:WQbD:WQbD:WQbD:W1QbD>WQbD>WQbD>WQbD>WQbD>W!QbF6W2l 9f  tblPersonaltblHRDatatblHRDatastrEmpIdtblPersonalstrEmpID~nXH6{26B41148-03B6-11CF-98C6-0020AFD5DA48}tblEmpIDProjectstrEmployeeIDtblPersonalstrEmpIDxZ{26B41147-03B6-11CF-98C6-0020AFD5DA48}tblCustomerstrSalespersontblPersonalstrEmpIDpZ{26B41146-03B6-11CF-98C6-0020AFD5DA48}tblBookSalesstrCustomerIDtblCustomerstrCustomerIDrZ{26B41145-03B6-11CF-98C6-0020AFD5DA48}tblEmpIDProjectstrProjectNumbertblBookProjectstrPart#xZ{26B41144-03B6-11CF-98C6-0020AFD5DA48}tblBookSalesstrPartNumbertblBookProjectstrPart#rZ  OQK@e@L@tblProjectTimeȓ@eJJJ>>>>>>>< @,1x7@`wR@tblCustomerȓ_ @bDDD88888886 @  J@&- J@qselRetailPriceȓ-@^@]XLL@@@@@@@> @ ~9@ R@AccessLayoutȓ4MR2KeepLocal T@]zz:::::::8 @$1sI@$1sI@tblPersonaltblHRDataȓJJJJJJJJJJH AMvcP=*z @ -  } j C 0  m Z G p]I6#r_LK8J7#sȓ @IN\}Af 1*wMǑ5\9ه u mtKZSi~H q3_ L*Use to update Retail Book PriceMR2RecordLocksODBCTimeout FilterOrderByOrderByOnReplicableDescriptionMaxRecordsRecordsetTypec  <2 *Use for Practice Unit  MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnDescription  <  j bUse to display what customers ordered which booksMR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnDescription]  <  , $Use for outer joinMR20 Title AuthorCompany QueryDsn.mdb(  Software Manager, $Logical OperationsMR2AccessVersion Build6Track Name AutoCorrect Info0Perform Name AutoCorrectProjVerCpgConversionZ 08.50     8vcO<)   x e R > +  {  g T A -}jVC0 lUɓ UIN\}Af 9xlе;*xl5\9ه u Nx($goSrG+3_ L*DefaultValueDescriptionOrderByOnColumnWidthColumnOrderColumnHiddenDecimalPlacesRequiredDisplayControl FormatCaptionAllowZeroLength FilterOrderBy$lngQuantitySold  0   0 (Number of books sold   m$ General Number" Quantity Soldl dDate, book part number, Customer ID, Quantity sold lngOrderID   * "Unique identifier$ General Number Order ID*$dtmTransactionDate     Date of sale  Short Date( Transaction Date strPartNumber F  F >Same entry as in tblBookProject    m Part Number strCustomerID       m@ 8Same entry as in tblCustomer Customer IDMR2DescriptionColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlCaption FormatValidationRuleValidationTextDecimalPlacesDefaultValueInputMask FilterOrderByOrderByOnj bBook projects, costs, prices, dates, and managers strPart# F  6 .Unique book part number   m Part NumberS0*strProjectManagerCode   b ZThe employee ID number of the project manager  >   Like "EN*"2 *EN followed by digits m& Project Manager)*$curDevelopmentCost C  b ZCost to develop the book from start to finish2 *$#,##0.00;($#,##0.00)    0 (  Development CostcurBookPrice   4 ,Sale price of the book2 *$#,##0.00;($#,##0.00)    0 * "Retail Book PricedtmShipDate 8  ^ VDate the book is ready to ship to customers Short Date   99/99/00;0;# Ship Date(dtmStartDate &  r jDate the book project starts for the technical writer Short Date   99/99/00;0;#, $Project Start Date}strBookTitle H     m Book Title0LVALBMR2OrderByOnDescriptionColumnWidthColumnOrderColumnHiddenCaptionRequiredAllowZeroLengthDisplayControl{ f ^Employee IDs and their assigned project numbersw strEmployeeID 9    Emp ID   m& strProjectNumber c  $ Project Number   mMR2rDescriptionColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlCaption FormatValidationRuleValidationTextInputMask FilterOrderByOrderByOnDefaultValue]H @Address, phone, fax, salesperson  strCustomerID   N FUnique identifier for each customer   m Customer ID$strCustomerName   ( Name of business   m" Customer NamesstrAddress      m AddressgstrCity      m City strPostalCode    v nUSA Zip code or postal code for regions outside the USA   m Postal CodestrCountry u  b ZEnter data only for locations outside the USA   m CountryC"strSalesperson s  f ^Same entry as Employee ID number in tblPersonal  >   Like "EN*"2 *EN followed by digits m  Sales PersonstrRegion 9     m* "State or province  RegionstrPhone   * "Include area code4 ,!\(999") "000\-0000;;_  Phone   m strFax   * "Include area code4 ,!\(999") "000\-0000;;_ Fax   m.LVAL @MR2pDescriptionOrderByOnColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlCaption FormatValidationRuleValidationTextDecimalPlacesDefaultValueInputMaskM 8 0New Projects to be added strPartNumber F  6 .Unique book part number   m Part NumberS0*strProjectManagerCode   b ZThe employee ID number of the project manager  >   Like "EN*"2 *EN followed by digits m& Project Manager)*$curDevelopmentCost C  b ZCost to develop the book from start to finish2 *$#,##0.00;($#,##0.00)    0 (  Development CostcurBookPrice   4 ,Sale price of the book2 *$#,##0.00;($#,##0.00)    0 * "Retail Book PricedtmShipDate 8  ^ VDate the book is ready to ship to customers Short Date   99/99/00;0;# Ship Date dtmStartDate &  j bDate the book project starts fot technical writer Short Date   99/99/00;0;#, $Project Start Date}strBookTitle H     m Book TitleMR2OrderByOnDescriptionColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlCaption FormatDecimalPlacesValidationRuleValidationText FilterOrderByInputMaskDefaultValue_ J BHuman Resources confidential data}strDept      m Dept. Code  >}dblHours    Fixed    m  HourskcurPayRate       Pay RateystrHealth (     m Health CodestrParkLot      m Park Lot  >ocurParkRate 8      Park RatestrEmpId F    > Employee ID   mLVAL3/MR2$OrderByOnColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlCaption FormatDecimalPlaces FilterOrderByDescriptionG 2 *Use for Practice Unit{strDeptCode      m Dept. Code{strEquipment D     m Equipment$strSerialNumber      m" Serial Number$dtmPurchaseDate    Medium Date " Purchase DateysnWarranty     Yes/No  j Warranty"dblWtyDuration       m" Wty. DurationystrVendorID G     m Vendor IDMR2rDescriptionColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlValidationRuleValidationTextCaption FormatInputMask FilterOrderByOrderByOnDefaultValueu` XEmployee addresses, phone numbers, hire date UstrEmpID F     m` XUnique identifier with EN followed by digits Like "EN*"X PEmpID must include EN followed by digits Employee ID  >}strFirstName      m First NameystrLastName      m Last NamesstrAddress      m AddressgstrCity F     m CityustrState      m  > StatedtmHireDate     0 (Employee's hire date Short Date Hire DatestrPhone   , $Includes area code   m Home Phone4 ,!\(999") "000\-0000;;_strZipCode   ( 9-digit zip code Zip Code   m$ 00000\-9999;;_JLVALt ^MR2OrderByOnColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlCaptionInputMask FilterOrderByDescriptionO : 2Use to create a self-join_ strId v     m  IDystrLastName      m Last Name}strFirstName      m First NamesstrDept      m Dept. Code`dtmHired      Hire Date$strSupervisorId    "EN"00;0   m" Supervisor IDMR2OrderByOnColumnWidthColumnOrderColumnHidden FormatRequiredCaptionAllowZeroLengthDisplayControlDecimalPlacesDefaultValueValidationRuleValidationText FilterOrderByDescriptionInputMaskY D <Use to create a crosstab querydtmPeriodEnd    Short Date  Period EnddblHours   $ General Number    0  m  HoursestrEmpID     ID   m}strProjectID 8   Project ID   mMR2OrderByOnColumnWidthColumnOrderColumnHiddenDescriptionRequiredAllowZeroLengthDisplayControlCaptionValidationRule FilterOrderByG 2 *Use for Practice UnitstrDeptCode   & Department Code   m Dept. CodestrName E   Full Name   m  Manager Name strId v  | tUnique employee identification using EN followed by digits   Like "EN*" m  ID