Standard ACE DBnb` Ugr@?~1y0̝cßFN5Y7u(`6{6F߱VC| 3y[!|*|hf_Љ$g'DeFx -bT4.0/dv YUS UU Y   Y Y  Y Y  Y   Y  Y  D Y  Y  Y  Y ? Y 2Y  Y  i Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortType3kDYYIdParentIdName        OYS  TY Y Y  Y 2ACMFInheritableObjectIdSID YObjectId YtFS  tY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order Y"ObjectIdAttribute   -YS  Y Y Y  Y yN Y ? Y -> Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship77 777 777 7YYYszObject$szReferencedObjectszRelationship v1b N  : k & p@@D@ @ @ @@ @@ @Si`kmdM\Si`kmdM\`Ji\ofSi`koff^YQi^YkmSi`koff^YQikifmiQmJY^Mokmd`Qi^JLQ^kifmiQmJY^fiYMQ^YkmifmkmdM\^Ykm ifmkoff^YQifidOoMm^Ykm!ifmkoff^YQifidOoMmko``Jiv"JO`Yb#OJmJJMMQkkfJUQkOJmJLJkQkSdi`k`dOo^QkiQ^JmYdbkWYfkiQfdimkkMiYfmkkvkiQ^mJL^Qk+kh+MSi`koff^YQik+kh+MMd`Ld8H$+kh+SSi`kmdM\%+kh+SSi`kmdM\`Ji\of&+kh+SSi`koff^YQi^Ykm'+kh+SSi`koff^YQik(+kh+iifmiQmJY^Mokmd`Qi^JLQ^k)+kh+iifmiQmJY^fiYMQ^Ykm++kh+iifmkmdM\^Ykm++kh+iifmkoff^YQifidOoMm^Ykm++kh+iifmkoff^YQifidOoMmko``Jiv+S+8:8L:LHF6@:B>SQDJQOH6SBH>FB>S>O6+OJmJ+YbqdYMQ+`kvkJMMQkkkmdiJUQ+`kvkJMMQkku`^+`kvkJMQk`kvkM`OLJik+`kvkMd`f^QuMd^o`bk`kvkMd`f^QumvfQ+JmmJMW`Qbm`kvkMd`f^QumvfQ+OQMY`J^`kvkMd`f^QumvfQ+UoYO`kvkMd`f^QumvfQ+YQQQOdoL^Q `kvkMd`f^QumvfQ+YQQQkYbU^Q `kvkMd`f^QumvfQ+^dbU `kvkMd`f^QumvfQ+kWdim `kvkMd`f^QumvfQ+mQum`kvkMd`f^QumvfQ+obkYUbQOLvmQ `kvkY`QuMd^o`bk+ `kvkY`QukfQMk+ `kvkbJqfJbQUidofMJmQUdiYQk+ `kvkbJqfJbQUidofk+ `kvkbJqfJbQUidofmddL[QMmk+ `kvkbJqfJbQdL[QMmYOk+`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfk`kvkiQkdoiMQk+hivMokmd`Qi^dd\of+hivOQ^QmQkJ^Qk+hivYbqdYMQOQmJY^k+hivfiYMQofOJmQ+hivfidOoMm^Ykm+hivfid[QMmQOfidSYmk+hiviQmJY^fiYMQ^Ykm+hivkQ^QMmhoQiv+mL^Ldd\k+mL^MJmQUdiYQk+mL^Q`f^dvQQk+mL^YbqdYMQOQmJY^k+mL^YbqdYMQWQJOQi+mL^fJv`QbmOQkMiYfmYdbk+mL^fidOoMmMdOQk+mL^hoJimQi^vkJ^Qk+mL^iQmJY^Mokmd`Qik+ mL^kWYffQik+!mL^kmdM\+"mL^koff^YQi^Ykm+#mL^koff^YQik+$JMMQkk^Jvdom`kvkOLko``JivYbSd+ DM86BL>:OFBQ>O@SLL:DQHDH<8J+ +;K[mL^MJmQUdiYQkmL^kmdM\ mL^YbqdYMQWQJOQimL^YbqdYMQOQmJY^k mL^iQmJY^Mokmd`QikmL^YbqdYMQWQJOQi mL^kmdM\mL^YbqdYMQOQmJY^k mL^koff^YQikmL^kmdM\ #  @ @ @ @ @ @ @ @ @ @       !"#$%&'()++++++++ +!+"+#+$% & ' ( )      !#%',+3+8+W+\+a+ e+ h+ l+ q+ v+y++++++++++ +!+"+#+$v1Q @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $%&' ( ) * + , - . / 0 1 2 3 4 5 6789:;<=>?@ABCDEFGHIJKLM     <=>?@ABCDE   !!!"" " # # # $5$6$7%8%9%:&;&<&='>'?'@(A(B(C)D)E)F,-./0+,-12345678234     !;!!#8#9#:%%%'5'6'7,,,3 3!3"8#8$8%8&W'W(W)W*\.\/\0\1aaaaeeeehhhhl l!l"l#q$q%q&q'v(v)v*v+y9y:y; !"#$%&'()*+,-./01234  !"#v1@@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ )))))))))) ) ) ) ) )))))))))))))))))) ))!)#)$)")%)')()&)))+),)-).)/)0)1)*)2)4)5)6)7)8)9)3):)<)=)>)?)@)A)B)C)D)E);)F)H)I)J)K)L)G )M )O )P )Q )R )S )T )N!)U!)W!)X!)Y!)Z!)[!~!~!)V"~"~"~"~"~"~"~ "~ " ~ " ~ " ~ "~#~#~#~#~#~#~#~#~#~#~v1@: @@+ DM86BL>:OFBQ>O@SLL:DQHDH<8J+ +;K[mL^MJmQUdiYQkmL^kmdM\mL^YbqdYMQWQJOQimL^YbqdYMQOQmJY^kmL^iQmJY^Mokmd`QikmL^YbqdYMQWQJOQimL^kmdM\mL^YbqdYMQOQmJY^kmL^koff^YQikmL^kmdM\ @ mL^YbqdYMQOQmJY^kmL^YbqdYMQOQmJY^kmL^YbqdYMQWQJOQimL^kmdM\mL^kmdM\mL^koff^YQik mL^MJmQUdiYQkmL^YbqdYMQWQJOQimL^fJv`QbmOQkMiYfmYdbkmL^iQmJY^Mokmd`QikmL^kmdM\mL^koff^YQik*d _ Z  G q  0 =XFbS,PB^AA~EuV@~EuV@~EuV@~EuV@~EuV@~EuV@~sq_rrptRetailCustomerLabelsXXXXXXXXXXX ̠nvR@̠nvR@~sq_ffrmSuppliers4MR2KeepLocal TDDDDDDDB @dnvR@dnvR@~sq_ffrmStockMarkup4MR2KeepLocal THHHHHHHF @nvR@nvR@~sq_ffrmStock4MR2KeepLocal T|||<<<<<<<: @&+ l@)9@Admin$ @8,,,,,,,,,* 놔,@놔,@rptSupplierProductSummaryTTTTTTTTTTR  ,@ ,@rptSupplierProductListNNNNNNNNNNL ,@,@rptStockList::::::::::8  ѕ,@ѕ,@rptRetailPriceListFFFFFFFFFFD   ,@ ,@rptRetailCustomerLabelsPPPPPPPPPPN  q ,@q ,@frmSuppliers::::::::::8  NDZ ,@NDZ ,@frmSupplierList@@@@@@@@@@>  ,@,@frmStockMarkup>>>>>>>>>>< 15,@15,@frmStock22222222220 %+ @ His%@@AccessLayout4MR2KeepLocal T"@zz:::::::8 @`H@`H@SysRel.........., @f@@f@Scripts0000000000. `@`@Reports0000000000. @@Modules0000000000. @@Forms,,,,,,,,,,* ꣡m@꣡m@DataAccessPages@@@@@@@@@@> 'atnvR@atnvR@MSysComplexType_AttachmentTTTTTTTTTTT %atnvR@btnvR@MSysComplexType_TextHHHHHHHHHHH #atnvR@btnvR@MSysComplexType_DecimalNNNNNNNNNNN !atnvR@btnvR@MSysComplexType_GUIDHHHHHHHHHHH atnvR@btnvR@MSysComplexType_IEEEDoubleTTTTTTTTTTT atnvR@btnvR@MSysComplexType_IEEESingleTTTTTTTTTTT atnvR@btnvR@MSysComplexType_LongHHHHHHHHHHH atnvR@btnvR@MSysComplexType_ShortJJJJJJJJJJJ atnvR@btnvR@MSysComplexType_UnsignedByteXXXXXXXXXXX atnvR@atnvR@MSysComplexColumnsDDDDDDDDDDD MSysRelationshipsDDDDDDDDDDB MSysQueries88888888886 MSysACEs22222222220 MSysObjects88888888886 )RFuV@MSysDb @:::......., @Relationships<<<<<<<<<<: Databases44444444442 Tables.........., D Ye gN Y Y  Y Y Y ColumnNameComplexID&ComplexTypeObjectID"ConceptualTableIDFlatTableIDsSArtrttritrCetteNYYY(IdxConceptualTableIDIdxFlatTableID IdxIDv1@ y,fYNY  ValuedvfY : DNY  ValuedvfYNY  ValuedvfY NY  ValuedvfYN  Y  ValuedvfYN""Y  ValuedvfYT01CN$$Y00 ValuedvfYN&& Y  ValuedvaYC:\WN(( Y rY  Y Y  Y  Y FileDataFileFlagsFileNameFileTimeStampFileTypeFileURL((((Hv1b\zP&bD h J , Z <  x J ,  h :  4 z\>zP2Z}4 bD&^@"w4~P!tblStock.curCost/ g!Full DescN@ */## o!tblStock!!! ! G! G! ! G tblStock.strColour1 g tblStock.strProductDesc6 g tblStock.strProductID4 g tblStock!!!   G  G    GZ@* 'tblStock.curSellingPrice[curSellingPrice]+15cA wtblStock!!!  G G  G~tblInvoiceHeadertblInvoiceDetails|@*_S1 ~B@* g~tblInvoiceDetails.intQuantity< g~ tblInvoiceDetails.strProductID= g~ tblInvoiceHeader.strCustomerID= g~tblInvoiceHeader.lngInvoiceID< g~tblInvoiceDetails333 ~tblInvoiceHeader111 ~ G~ G~ ~ G LiH@* 'LitblQuarterlySales.strYear8 gLitblQuarterlySales.*2 g LitblQuarterlySales333 Li GLi G Li Li G8F@@* 'F@D@* gF@D@* gF@"tblRetailCustomers.strCustomerID? g8F@tblRetailCustomers555 F@ GF@ G8F@ F@ GtblStock!!!   G  GtblStock!!!   G  GtblStock!!!   G  G~tblStock!!!  ~ G~ ~ GtblRetailCustomers555   G  G~tblSuppliers)))  ~ G~ ~ GvtblSuppliers)))  v Gv v GutotblStock!!!  to Guto to GrmstblStock!!!  ms Grms ms GtoT@* gtoN@* gutotblPaymentDescriptions=== uto to G LVAL ^ ~  Z  (((tblStock.strProductID) Like "L*"))[strProductID] & "-" & [strProductDesc](((tblStock.strProductDesc)="Kitchen chair"))tblInvoiceHeader.lngInvoiceID = tblInvoiceDetails.lngInvoiceIDtblInvoiceDetails.curSellingPrice(((tblQuarterlySales.strYear)="01"))(((tblRetailCustomers.strCustomerName) Like [What is the first character of the customer name?] & "*"))tblRetailCustomers.strCustomerCitytblRetailCustomers.strCustomerName[tblPaymentDescriptions].[strPaymentTerms][tblPaymentDescriptions].[lngPaymentID] 'SN f LS I EJ E HOieGw`D?"iXinvR@XinvR@~sq_cfrmSuppliers~sq_cCombo194MR2KeepLocal T\\\\\\\Z @ bo@{@SummaryInfo4MR2Company DCFxxx88888886 @,@ EuV@tblSuppliers @FFF:::::::8 @9,@,:,@tblSupplierList@LLL@@@@@@@> @ =ؓ @ EuV@tblStock @>>>22222220 @/ؓ @7ؓ @tblShippers@DDD88888886 @yZ,@EuV@tblRetailCustomers@RRRFFFFFFFD @x<ד @ Q@tblQuarterlySales| @PPPDDDDDDDB @Ƭ ,@ ,@tblProductCodes@LLL@@@@@@@> @Mד @EuV@tblInvoiceHeader@NNNBBBBBBB@ @_ד @EuV@tblInvoiceDetailsl@PPPDDDDDDDB @]. ,@h,@tblEmployees::::::::::8 ,rNד @sEuV@tblCategories@HHH<<<<<<<: @S ,@@tblBooks@>>>22222220 @#*D,@!DF,@qrySelectQuery@ |@VJJ>>>>>>>< @" ,@ ,@qryRetailPriceList'@|@^RRFFFFFFFD @ ,@,@qryProductList'@|@VJJ>>>>>>>< @hk,@hk,@0qryPriceUpdate@|@VJJ>>>>>>>< @E-,@hk,@qryInvoiceDetails'@@\PPDDDDDDDB @,@Nz,@qryCustomerLookup'@|@\PPDDDDDDDB @y5D@V@ MSysResources<<<<<<<<<<: vLEmvR@LEmvR@ MSysNavPaneObjectIDs4MR2KeepLocal  TJJJJJJJH @l8lvR@8lvR@ MSysNavPaneGroups4MR2KeepLocal  TDDDDDDDB @h'lvR@^̕lvR@ MSysNavPaneGroupCategories4MR2KeepLocal  TVVVVVVVT @e:@@cs%@MSysIMEXSpecs<<<<<<<<<<: a`E:@rߥ.T@MSysIMEXColumns@@@@@@@@@@> \0T@0T@MSysCmdbars88888888886 8nvR@nvR@ MSysAccessStorageDDDDDDDDDDB 3b,@)@INVOICEj@<<<0000000. @,>תE[ڀZلC۽s=@ʉ_a [y6'$m{pwuY:˱_å[YLC&_IqoN~NU>5jF*(a0la %sG2jT'nN?( *Qg t ӁڔHZLQ uF]HX1A9]7jl^<@㧛1TJSF$2sD1ס#eZrOg F@o92+-)el=#h%c@^?v+C`yzӡA)NdcMw5y`@ЙGeFiM eH\| ^Ÿ>𳦨c<;Ehu'J TՏKXU})xr=SvhYˮyp<@*WC]$t*PV‡UXXwqGׯэCacl& 6'eO~vr@.:cKxeR#ҍC'ÈRǢ2 NJ3*oI@ -Zԝb>qL@%'ACNnX \+I@a+M!K ] _D"H5]m}6 : 1u-Y--?4=@/o-dTuCiרW #Z& 60Fg#JӔtlgth|0 ӏh=e&SL]:pFC|(5;j/_ k y) w:R)mDc9#ltW5KmMl/oȉ7bd̥5ocH(Nl/D'b[+MB_H$KTA_FdU<0JN{/6Vydqsih 'VZRЖ147m"7m5r VPy!",t,$ PfRԎٺkeo9Ƕ'sc!?&EKSe.g }=Uކ*FeXO}5Jqfǰ^1Nfc| fԄ)8n"QvjEM^0cX/#w}3Eg/w-A\Fw$HjhAO#q5f;Pwխt.=s7+WQQxg*UE>dZ4Sa.n3`-[ =IhlIoEO9r]ܢeKGK_{PMr +1xմS0!2L E[6!`b@%Y)\G|?b;;I2XiQY넫 m(*EmVdoNX[0*/V ԅaK[sW9 nn,Cfv#ysG$(q&8exFDEIH+y|plWǓ/[Z㑫Kp#huBnvR@HnvR@:PropData8PLH8 nvR@HnvR@9&K$Blob82.*" nvR@HnvR@83(  wnvR@/nvR@7BlobDelta30,( wnvR@/nvR@6V@JTypeInfo3:62" -OnvR@/nvR@5PropData3PLH8 -OnvR@/nvR@4@JBlob32.*" -OnvR@/nvR@32(  w-OnvR@ nvR@2BlobDelta.0,( w-OnvR@ nvR@1@>TypeInfo.:62" -OnvR@ nvR@0PropData.PLH8 -OnvR@ nvR@/!G$Blob.2.*" -OnvR@ nvR@.1(  w-OnvR@N&nvR@-BlobDelta)0,( w-OnvR@N&nvR@,]@>TypeInfo):62" -OnvR@N&nvR@+PropData)PLH8 -OnvR@N&nvR@*/F$Blob)2.*" -OnvR@N&nvR@)0(  w-OnvR@nvR@(Reports,($ w-OnvR@-OnvR@'Modules,($ w-OnvR@nvR@&("Custom Toolbar1DirData#b^ZJ -OnvR@nvR@%P@>Blob$2.*" -OnvR@nvR@$0#  w-OnvR@nvR@#Cmdbars,($ w-OnvR@nvR@"0 3CB0 1CB0 4CB0 5CB0PropDataCopy rnjR -OnvR@nvR@!0 1CB0 3CB0 0CB0 2CB0PropData jfbR -OnvR@nvR@ ~@>DirData :62" -OnvR@dnvR@BlobDelta0,( w-OnvR@dnvR@@>TypeInfo:62" -OnvR@dnvR@ PropDataGC?/ -OnvR@dnvR@ C$Blob2.*" -OnvR@dnvR@3   w-OnvR@̠nvR@BlobDelta0,( w-OnvR@̠nvR@@>TypeInfo:62" -OnvR@̠nvR@PropDataPLH8 -OnvR@̠nvR@A$Blob2.*" -OnvR@̠nvR@2   w-OnvR@LEnvR@BlobDelta0,( w-OnvR@LEnvR@@>TypeInfo:62" -OnvR@LEnvR@PropDataPLH8 -OnvR@LEnvR@?$Blob2.*" -OnvR@LEnvR@1   w-OnvR@`nvR@BlobDelta 0,( w-OnvR@`nvR@b@>TypeInfo :62" -OnvR@`nvR@PropData PLH8 -OnvR@`nvR@ ' ;$Blob 2.*" -OnvR@`nvR@ 0   w-OnvR@nvR@ Forms($  w-OnvR@EuV@VBA$  w-OnvR@EuV@VBAProject2.* w-OnvR@EuV@VBA$  wnvR@nvR@MSysAccessStorage_SCRATCHPLH wnvR@nvR@MSysAccessStorage_ROOTJFB wLVAL$<u08=5B>a)b*ce gh6xijhk  ?l*`wQ,@ tblSuppliers @ Arial1D/1Fd2" @ Tahoma    i1g4h5    k1    mf45I" @ Tahoma     `, FormHeaderx iFhFbDNXd5U`6habc,d#e% Label12 Supplier Listx Q0HmtEe`,0   Detailx ŢB5 m7UF{`6ae strSupplierID strSupplierID Enter the first letter of the Supplier's name followed by three numbers.H  >L000x y9RK.h'+d5U`6-abc,  Label2 Supplier ID:x 7><@m7UF{`6ae| k strSupplierName strSupplierNamex 9P4eA 9+d5Uabc,  Label3 Supplier Name:x 6,\IJ)Tm7UF{`6ak $strSupplierAddress $strSupplierAddressx <8H%)un+d5U`6abc,  Label4 Address:x yޡVE汿wm7UF{`6ack strSupplierCity strSupplierCityx /%͕?C8(U$+LVAL=d5U`6acbc,  Label5  City:x  Ozڷm7UF{`6aRk &strSupplierProvince &strSupplierProvince NAbbreviate the province to two letters.x BB1NhKs|+d5U`6aRbc,  Label6 Province:x ;gMe"m7UF{`6a k *strSupplierPostalCode *strSupplierPostalCode FLetters are converted to uppercase.H >L0L\ 0L0x *K#CEN?^&+d5U`6-a bc,  Label7 Postal Code:x fpB@g̣km7UF{`6a,ek $strSupplierContact $strSupplierContactx UoB.H"^k+d5U`6a,bc,  Label9 Contact Name:x /Bnhm7UF{`6aHk  strSupplierPhone  strSupplierPhoneH &!\(999") "000\-0000x jVH^{+d5U`6 aHbc, Label10 Phone Number:x 7*~2N{ˆpYk5U`6abc,i Frame13 lngPaymentID 1x U{BHL( d25`64abc, Label14 Payment Termsx Lz@S]i2W`6va~: Option16x y3TB\Zpd5`6\abbIc, Label17  C.O.D.x @\f,6N-/li2W`6va: Option18x  Ws*^G<4~!d5`6\abgc, Label19 Prepaidx `:ǍdG/Gei2W`6va : Option20x I^ NXd5`6\a bc, Label21 On accountx rMDԄ`,hLVAL FormFooterx {^:K LVAL  i> 2rptRetailCustomerLabels(rptRetailPriceListrptStockList0rptSupplierProductList6rptSupplierProductSummaryͬXVn@Dg 0ReportHeaderd0Label100PageHeaderSectiond0strSupplierID_Labeld0strProductID_Labeld0strColour_Labeld0strProductDesc_Labeld0curSellingPrice_Labelf0Line14f0 Line15d0 Label160 GroupHeader0m0 strSupplierID0 Detailm0strProductIDm0strColourm0strProductDescm0curSellingPricem0curCost0PageFooterSectionm0Text11m0Text120ReportFooter0lngCategoryID0intUnitsInStock0ysnDiscontinuedͬ5^}N7jܙ0ReportHeaderd0Label80PageHeaderSectiond0strProductID_Labeld0strColour_Labeld0strProductDesc_Labeld0curSellingPrice_Labelf0Line110Detailm0 strProductIDm0 strColourm0 strProductDescm0 curSellingPrice0 PageFooterSectionm0Text9m0Text10f0Line120ReportFooter0strSupplierID0lngCategoryID0curCost0intUnitsInStock0ysnDiscontinuedͬR*:G3_㔛0PageHeaderSection0Detailm0Text2m0Text3m0Text4m0Text50PageFooterSection0strCustomerID0strCustomerName0 strCustomerAddress0 strCustomerCity0 strCustomerProvince0 strCustomerPostalCode0 strCustomerPhoneCustom Toolbar1+8F@frmStock frmStockMarkup"frmSupplierListfrmSuppliersͬ @RG쎺0FormHeader0Detailm0strProductIDd 0strProductID_Labelm0strProductDescd 0strProductDesc_Labelm0strSupplierIDd 0strSupplierID_Labelm0curCostd 0 curCost_Labelm0 Text11d 0 Label120 FormFooter0 strColour0lngCategoryID0curSellingPrice0intUnitsInStock0ysnDiscontinuedͬLRF"~@[ 0Detailm0strSupplierIDd 0Label1m0strSupplierNamed 0Label3m0strSupplierContactd 0Label5m0strSupplierAddressd 0Label7m0 strSupplierCityd 0 Label9m0 strSupplierProvinced 0 Label11m0 strSupplierPostalCoded 0Label13m0strSupplierPhoned 0Label15p0Child18o0Combo19d 0Payment_Terms_LabelPayment Terms_Label0lngPaymentIDͬUjiiF.ۯ0FormHeader0Detailm0strProductIDd 0strProductID_Labelm0strProductDescd 0strProductDesc_Labelm0strSupplierIDd 0strSupplierID_Labelm0curCostd 0 curCost_Label0 FormFooter0 strColour0 lngCategoryID0 curSellingPrice0intUnitsInStock0ysnDiscontinuedͬX(CcGU0FormHeaderd 0Label120Detailm0strSupplierIDd 0Label2m0strSupplierNamed 0Label3m0strSupplierAddressd 0Label4m0 strSupplierCityd 0 Label5m0 strSupplierProvinced 0 Label6m0 strSupplierPostalCoded 0Label7m0strSupplierContactd 0Label9m0strSupplierPhoned 0Label10k0Frame13d 0Label14i0Option16d 0Label17i0Option18d 0Label19i0Option20d 0Label210FormFooter0lngPaymentIDLVAL$@9u08B>a)b*ce gh6ijk ?l%U1 ,@ tblStock frmStock @ Arial1D/1Fd2    e12    g23I75    hg#h%" @MS Sans Serif    i1g4h5    j1g4h5    k1    l23I:    mf4     n2     o2     p5 LVAL   r35I    zi#j%" @MS Sans Serif    {5    `, FormHeaderx .z}GKFBaI&`,5  Detailx /oGʃ Cm7UF{`6Taxbc,e strProductID strProductIDH >L\-999x `=qGت+d5U`6<axbHc, $strProductID_Label Product IDx jM0枝{0m7UF{`6Tab6c,e6k strProductDesc strProductDescx R!E˨@*.+d5U`6<abfc, (strProductDesc_Label Descriptionx ~j8LG(m7UF{`6Tab9c,e9k strSupplierID strSupplierIDH  >L000x @]VD];+d5U`6<abWc, &strSupplierID_Label Supplier IDx ukdSPERϣefm7UF{`6Tadb$ c,e$ k curCost curCost& *$#,##0.00;($#,##0.00)x L~A9M`"+d5U`6<adbc, curCost_Label Costx  B^=cm`, FormFooterx #T4.gEZbyu6<LVAL$Bu08w=5B>a)b*ce gh6ijk ?l9,@ tblSuppliers tblSuppliers @ Arial1D/1Fd2" @ Tahoma    mf45I" @ Tahoma     o2" @ Tahoma     p5    `,  Detailx @CM$-] m7UF{`6axb e strSupplierID strSupplierID Enter the first letter of the Supplier's name followed by three numbers.H  >L000x e:@ L@0\+d5U`6xaxbWc,  Label1 Supplier IDx QCptKqZm7UF{`6ab e| k strSupplierName strSupplierNamex 4h|@T+d5U`6xabGc,  Label3 Supplier Namex eIu[,m7UF{`6aHb ek $strSupplierContact $strSupplierContactx dg}K+!j~+d5U`6xaHbGc,  Label5 Contact Namex )i:iL|_m7UF{`6ab k $strSupplierAddress $strSupplierAddressx 73]HE'TU+d5U`6xabc,  Label7 Addressx e 삙G8O4LVALm7UF{`6ab k strSupplierCity strSupplierCityx ;[9]DՍ+d5U`6xabhc,  Label9 Cityx ~BxBN}{m7UF{`6ab k &strSupplierProvince &strSupplierProvince NAbbreviate the province to two letters.H >LLx QDD #+d5U`6xabc, Label11 Provincex LAlMA(^mm7UF{`6ab k *strSupplierPostalCode *strSupplierPostalCode FLetters are converted to uppercase.H >L0L\ 0L0x c@hgGVs]v+d5U`6xabc, Label13 Postal Codex EVFK< f~m7UF{`6aP b k  strSupplierPhone  strSupplierPhoneH &!\(999") "000\-0000x פ2OХ'+d5U`6xaP bec, Label15 Phone Numberx s Cp3U`6,a bc,@ d Child18 Table.tblStock1 strSupplierID2 strSupplierIDx xlZJwѭ2o5UD{`Fb@ c6d n Z &"";"";"";"";"4";"4"x թPO)@eF Combo19 lngPaymentID] Table/Query[ SELECT [tblPaymentDescriptions].[lngPaymentID], [tblPaymentDescriptions].[strPaymentTerms] FROM [tblPaymentDescriptions] 1440;14402d5U`6xa bc, &Payment Terms_Label Payment Terms &Payment_Terms_Labelx  Z:/@,LVAL$D9u08B>a)b*ce g h6S%ijx-k ?l%U1 ,@ tblStock frmStock @ Arial1D/1Fd2    e12    g23I75    hg#h%" @MS Sans Serif    i1g4h5    j1g4h5    k1    l23I:    mf4     n2     o2     p5 LVALE   r35I    zi#j%" @MS Sans Serif    {5    `, FormHeaderx >70@_F~9`,  Detailx 'M]'mm7UF{`6Taxbc,e strProductID strProductIDH >L\-999x >#F;D+56<axbHc, $strProductID_Label Product IDx ?<&EEy[j wm7UF{`6Tab6c,e6k strProductDesc strProductDescx  >.2+56<abfc, (strProductDesc_Label Descriptionx Ïm7UF{`6Tab9c,e9k strSupplierID strSupplierIDH  >L000x D>UEw +d5U`6<abWc, &strSupplierID_Label Supplier IDx  DDг{m7UF{`6Tadb$ c,e$ k curCost curCost& *$#,##0.00;($#,##0.00)x @sLHe<o༡+d5U`6<adbc, curCost_Label Costx ͺ7 Gp+m7UF{`6Tabk  Text11 8=[curSellingPrice]-[curCost]& *$#,##0.00;($#,##0.00)x S:Lן;L+d5U`6xabc, Label12 Markup:x FD$q6QNQHZ`, LVALFormFooterx >K"Ѿqմ$08:<=5B>a)b*ce gh6iXjk ?l@b+@ $tblRetailCustomers @ Arial 8 4S odXXLetterDINU"4 z"C:\Documents and Settings\All Users\Application Data\TechSmith\SnagIt 8\PrinterPortFile1D1Fd28" @ Arial    m9f5Ij%," @ Arial      strCustomerName`, "PageHeaderSectionx IPEb\tK  Detailx $]@acDm0G;F{`6Hab  Text2 strCustomerNamex {GG.+m0G;F{`6Habk  Text3 $strCustomerAddressx  dsJyc3Ą+m;F{`6Habk  Text4 r= Trim( [strCustomerCity] & ", " & [strCustomerProvince])x %!c>CSn+m0G;F{`6Habk  Text5 *strCustomerPostalCodex avMLp]+`, "PageFooterSectionx hVi OLoLVAL$Hu08w:<=5B>a)b*c$e g iXj+k ?l",@ tblStock $rptRetailPriceList @ Arial 8 h 4S odXXLetterDINU"4 z"C:\Documents and Settings\All Users\Application Data\TechSmith\SnagIt 8\PrinterPortFile1D1Fd27d# " @ Haettenschweiler    e24     g3I75    jg4h5    mf5ICi# " @ Arial     nj# " @ Arial     o3IAl# " @ Arial     p4I     strProductIDKLVALI`,) ReportHeaderx L44O!{%ʜd`6<a<b? c,d#  Label8 $rptRetailPriceListx }9\wE`, "PageHeaderSectionx Gi)΁B|>6<a<bc,Yd# $strProductID_Label Product ID  DetachedLabelx ߐ[>ùnT67<bc,Yd# strColour_Label  Colour  DetachedLabelx iBEd`6 a<bc,Yd# (strProductDesc_Label Description  DetachedLabelx m:=E:;td7`6ha<b c,Yd# *curSellingPrice_Label Selling Price  DetachedLabelx h4yEڙ?%f2 `6<ab2  Line11x m۳[ML@NW    K`,  Detailx ށɄJW/mF{`6<a<bc, strProductID strProductIDH >L\-999x :Eày+mF{`67a<bc,ek strColour strColourx l;Fl#+mF{`6 a<bc,ek strProductDesc strProductDescx !M{B-!+mF{`6ha<b c,edk curSellingPrice curSellingPrice& *$#,##0.00;($#,##0.00)x m x~OhW+`, "PageFooterSectionx @#˘K.#km;F{`6<abc,i#  Text9  =Now()& Long Datex 뱟L[{Ց+m;F{`6abc,i#k  Text10 H="Page " & [Page] & " of " & [Pages]x j;uQN);+f2 `6<a!LVAL1b$  Line12x s[,H|d+    K`, ReportFooterx m5gUCf(LVAL~(ͬ)^3BG\ b0ReportHeaderd0Label4d0Label50Detailm0strProductDescm0strProductIDm0Text60ReportFooter0strColour0 strSupplierID0 lngCategoryID0 curCost0 curSellingPrice0 intUnitsInStock0ysnDiscontinuedu08w:<=5B>a)b*e gh6ij"k ?l,@ tblStock @ Arial 8 h 4S odXXLetterDINU"4 z"C:\Documents and Settings\All Users\Application Data\TechSmith\SnagIt 8\PrinterPortFile1D1Fd28" @ Arial    mf5I<" @ Arial     K`,h ReportHeaderx >J\8Xd8"`6axb*c,  Label4 Product IDx dOlcd8"`6l axbuc,  Label5 Descriptionx B8MRni!K`,  Detailx ^r%@ !mF{`6 ae strProductDesc strProductDescx 4 NJ?Cf0+mF{`6Tak strProductID strProductIDH >L\-999x !-߿FW 9+mF{`6(ak  Text6 8=[curSellingPrice]-[curCost]& *$#,##0.00;($#,##0.00)x Kz Aƽ`.+K`,h ReportFooterx ԯۙEUu-$uLVAL$Lu08w:<=5B>a)b*c$e gh6ijx-k ?l,@ tblStock ,rptSupplierProductList @ Arial 8$hh 4S odXXLetterDINU"4 z"C:\Documents and Settings\All Users\Application Data\TechSmith\SnagIt 8\PrinterPortFile1D1Fd!278d# e%" @Times New Roman    e24     f    g3I75    jg4h5    mf5IC" @ Arial     n=I" @ Arial     o3IA" @ Arial     LVALMp4I     strSupplierID strProductIDK`, ReportHeaderx 9@7ydxHd27`6xaxb#c,d# Label10 *Supplier Product Listx A~J`, "PageHeaderSectionx ޫ>&C܌ﰿ6<a<bc,, &strSupplierID_Label SupplierID  DetachedLabelx e!UK\,IBd`6@ a<bc,, $strProductID_Label Product ID  DetachedLabelx @0f}C4`d`6a<bc,, strColour_Label  Colour  DetachedLabelx  C@Pd`6a<bc,, (strProductDesc_Label Description  DetachedLabelx at1C$mmBd7`6Na<b c,, *curSellingPrice_Label Selling Price  DetachedLabelx C33Lx=G]f2 b$  Line14x cLcFsw#f2 ab$  Line15x ł"H{0d`6raZbc,, Label16 Costx %*sO.8K`, GroupHeader0x 2MV |GIbcm !0G<F{`6<b c,Jei# j%f strSupplierID strSupplierID" @Times New RomanH  >L000x ShDڍ8I +K`,h  Detailx \hY#BFb?mF{`6@ bc, strProductID strProductIDH >L\-999x ;8AQ Pq+mF{`6bc,ek strColour strColourx ؤ@QkE+mF{`6bc,ek strProductDesc strProductDescx LVAL\JG!k+mF{`6Nb c,edk curSellingPrice curSellingPrice& *$#,##0.00;($#,##0.00)x zߓp K0+mF{`6ra<bek curCost curCost& *$#,##0.00;($#,##0.00)x H/ƑIsX+`, "PageFooterSectionx NOKt 3īm !;<F{`6<abc,,i# j%  Text11  =Now()& Long Date" @Times New Romanx |"|NH,+m !;<F{`6abc,,i# j%k  Text12 H="Page " & [Page] & " of " & [Pages]" @Times New Romanx  Ɓv~D"O`+K`, ReportFooterx EN4oDxb-8p=H 0 K  | 9 @ W EuV@EuV@5@SPROJECT840" z EuV@EuV@PROJECTwm>:6$ DEuV@EuV@/@Rdir0,("  EuV@EuV@ @R_VBA_PROJECTB>:"  EuV@EuV@ AcessVBADataNJF. nvR@nvR@LDataAccessPages<84 wnvR@nvR@KCustomGroups62. wnvR@nvR@JImExSpecs0,( wnvR@nvR@IMSysDbDirDataFPLH8 nvR@nvR@HBlobG&" wnvR@nvR@G0F  wnvR@nvR@FDatabases0,( wnvR@nvR@EjiPropDataPLH8 nvR@nvR@DScripts,($ wnvR@nvR@C; 0CB0 1CB0 2CB0 3CB0 4CB0PropData(uqm] nvR@nvR@B@ >DirData(:62" nvR@UԮnvR@ABlobDelta=0,( wnvR@UԮnvR@@@@RTypeInfo=:62" nvR@UԮnvR@?PropData=PLH8 nvR@UԮnvR@>/O$Blob=2.*" nvR@UԮnvR@=4(  wnvR@HnvR@<BlobDelta80,( wnvR@HnvR@;d@>TypeInfo8:62" LVAL$Pu08w:<=5B>a)b*c$e giXj+k x?lli,@ tblStock 2rptSupplierProductSummary @ Arial 8 h 4S odXXLetterDINU"4 z"C:\Documents and Settings\All Users\Application Data\TechSmith\SnagIt 8\PrinterPortFile1D1Fd27d# " @ Haettenschweiler    e24     g3I75    jg4h5    mf5ICi# " @ Arial     nj# " @ Arial     o3IAl# " @ Arial     p4I    LVALQ strSupplierID strProductIDK`,) ReportHeaderx hxW@܅֬d`6<a<bc,d# Label17 2rptSupplierProductSummaryx LhFGjl}f2 a<b$  Line20x UO V#,     `, "PageHeaderSectionx c0H>6<a<b4c,Yd# &strSupplierID_Label strSupplierID  DetachedLabelx ߠx!0N?(=3d`6a<btc,Yd# $strProductID_Label Product ID  DetachedLabelx B5$Ifd`6\ a<b8c,Yd# strColour_Label  Colour  DetachedLabelx ץnB d`6a<bc,Yd# (strProductDesc_Label Description  DetachedLabelx jJګбd7`6a<b4c,Yd# curCost_Label Cost  DetachedLabelx G}@k'Ad7`6 a<b8c,Yd# *curSellingPrice_Label Selling Price  DetachedLabelx /C `Ξ~f2 b$  Line21x  v]OԵfm    f2 ab$  Line22x *c`ED*e    K`,Y GroupHeader0x 쿔J`L_Һm0GF{`6<b4c,e strSupplierID strSupplierIDH  >L000x PnX(A]joz+K`,Y  Detailx 먤\1@@=k9\mF{`6btc, strProductID strProductIDH >L\-999x LVAL)^9MT'+mF{`6\ b8c,ek strColour strColourx $ZF =/H+mF{`6c,ek strProductDesc strProductDescx  UC.4 +mF{`6b4c,ek curCost curCost& *$#,##0.00;($#,##0.00)x lFF̾+mF{`6 b8c,edk curSellingPrice curSellingPrice& *$#,##0.00;($#,##0.00)x  Y9ΟGh^mU+K`, GroupFooter1x C$ nN +Hՙ%mF{`6<b$i#j%  Text12 &="Summary for " & "'strSupplierID' = " & " " & [strSupplierID] & " (" & Count(*) & " " & IIf(Count(*) = 1, "detail record", "detail records") & ")"x  dED3c#D*+d`6<abc,d#e% Label13 Sum" @ Arialx 3iA1$mF{`6 ab8i#j%k ,Sum Of curSellingPrice .=Sum([curSellingPrice])& *$#,##0.00;($#,##0.00) ,Sum_Of_curSellingPricex k :Gn +`, "PageFooterSectionx MǷG2$m;F{`6<abc,i#  Text18  =Now()& Long Datex ͆wE2=0+m;F{`6abc,i#k  Text19 H="Page " & [Page] & " of " & [Pages]x 1*%H@[Ia˷+K`,J ReportFooterx ~L> mF{`6 b8c,i# >curSellingPrice Grand Total Sum .=Sum([curSellingPrice])& *$#,##0.00;($#,##0.00) >curSellingPrice_Grand_Total_Sumx Lw*ۄLH#Ñ+d`6<bc,d# Label15 Grand Total" @ Arialx NJnF:45LVAL $+0* pHd Orders2.mdb8@ = t  xT(] J< VBIDE> VBIDE *\G{0002E157-:0C  0046}#5.3#0#C:\Program Files\Common Microsoft Shar@ed\VBA6E6EXT.OLB#Visual Basic for Applications Extensibility '?Wst dole>xstdoljemh^m0,43jf-m2.0mWindows\System32\22.tlb#OLE Au8tomO0BDAO>JDPAOA A4AC9E1DA-5BAD-@7-86E3-24F4CDCECA28}#c AiWOFFIC@n\ACE .DLLWOffice 15.0 Access database engine Object Libra,ry,¤"a  *\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office15\MSACC.OLB#Microsoft Access 15.0 Object LibraryZ*\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*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\System32\stdole2.tlb#OLE Automation\*\G{4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}#c.0#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE15\ACEDAO.DLL#Microsoft Office 15.0 Access database engine Object Library  xT]x &AccessVBAWin16~Win32Win64xMacVBA6#VBA7# Orders2.mdb;utility1JVBIDEAstdole`DAOH ͬ!L$lAUH0ReportHeaderd0Label17f0Line200PageHeaderSectiond0strSupplierID_Labeld0strProductID_Labeld0strColour_Labeld0strProductDesc_Labeld0curCost_Labeld0 curSellingPrice_Labelf0 Line21f0 Line220 GroupHeader0m0 strSupplierID0Detailm0strProductIDm0strColourm0strProductDescm0curCostm0curSellingPrice0GroupFooter1m0Text12d0Label13m0Sum_Of_curSellingPriceSum Of curSellingPrice0PageFooterSectionm0Text18m0Text190ReportFooterm0curSellingPrice_Grand_Total_SumcurSellingPrice Grand Total Sumd0Label150lngCategoryID0intUnitsInStock0 ysnDiscontinuedLVALID="{3D276BD3-354B-11D4-8AFC-00609443FEB8}" Name="Orders2.mdb" HelpContextID="0" VersionCompatible32="393222000" CMG="92904658865C865C865C865C" DPB="CECC1A9C6AE4A7E5A7E5A7" GC="0A08DEE01BE11BE1E4" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] t 8 @ @ @ @ @ @ @ @ @::::: : : ::: : : : : :::::::::::: :!:":#:$:%:&: ':!(:"):#*:$+:%,:&-:'.:(/:)0:*1:+2:,3:-4:.5:/6:07:18:29:3::4;N<N=N>N?N@NANBNCNDN EN FN GN HN INJNKNLNNNNNN 8@@@@@@@@@@@@@@@@@@@:: :#:':!(:"DN EN FN JNKNLN::N:NNNN  : :  : :  : !: ":  : : :  : : : ::::::::::#$:#&: $%:():#(.:((3:-(8:2(=N(BN(CN)*:$)+:%),:&)-:'./:).0:*.1:+.2:,34:.35:/36:037:189:38::48;N8<N=>N=?N=@N=ANFGN FINGHN `8@@@@ @@@@  @@   @ @M`OLJik:Mokmd`UidofkNOJmJJMMQkkfJUQkNOJmJLJkQkN Sdi`k:Y`QukfQMkN`dOo^Qk:!`kvkJMMQkkkmdiJUQ+iddm:fidfOJmJN iQfdimk:"kMiYfmkN qLJ:`kvkJMMQkkkmdiJUQ+kMiJmMW:JMQkkqLJOJmJNqLJfid[QMm:fid[QMmNfid[QMms`NqLJ:+qLJ+fid[QMmNOYiN 6: 8:  :: <: OYiOJmJ: fidfOJmJ: fidfOJmJMdfv: L^dL: L^dLOQ^mJ:  fidfOJmJ: mvfQYbSd: L^dL: L^dLOQ^mJ:fidfOJmJ: mvfQYbSd:L^dL:L^dLOQ^mJ:fidfOJmJ:mvfQYbSd:L^dL:L^dLOQ^mJ:fidfOJmJ:mvfQYbSd:#6:#OYiOJmJ: $L^dL:(6:#(8:((::-(<:2(>N(OYiOJmJN(fidfOJmJN)L^dL:$)L^dLOQ^mJ:')fidfOJmJ:%)mvfQYbSd:&.L^dL:).L^dLOQ^mJ:,.fidfOJmJ:*.mvfQYbSd:+3L^dL:.3L^dLOQ^mJ:13fidfOJmJ:/3mvfQYbSd:08L^dL:38L^dLOQ^mJN8fidfOJmJ:48mvfQYbSdN=L^dLN=L^dLOQ^mJN=fidfOJmJN=mvfQYbSdNF6N FOYiOJmJNGL^dLN S YprNXXY  Y Y  Y  Y  Y Id LValueObjectGuidObjectNameProperty ValueXYXZX[YYYId$ObjectGuidProperty$ObjectNamePropertyXHv1b W W WYchinN]] Y c Y 2Grptbcd TbName5ATeb]`YTbIndex]]v1@@LVALCustom Toolbar1+8F@\P@^Custom Toolbar1 \@Mokmd`mdd^LJi8_ qYFNbbY Y  Y Y Y Y $Y Y AttributesDataTypeFieldNameIndexTypeSkipColumn SpecID Start Widthc_tbcCbdYY Index1PrimaryKeyv1 a a YǝwTTN  ff Y 1Y Y Y  Y  Y fY Y 0 Y Y  Y  g Y  4 Y  DateDelim"DateFourDigitYear DateLeadingZerosDateOrderDecimalPointFieldSeparatorFileType SpecIDSpecNameSpecTypeStartRowTextDelimTimeDelimByzfg]h YPrimaryKeyv1 e>YNii Y Y Y  Y Y Y Y  Filter FlagsIdNamePosition SelectedObjectIDTypej=ikYIdv1ehyCustom ^TablesW Vhjjj RY Nmm  Y Y Y  Y wY wwY wwY w FlagsGroupCategoryIDIdName"Object Type GroupObjectIDPositionmompYYGroupCategoryIDIdv1@@ l yL|O"   w  w  w  wCustom Group 162.*  w w w w w w w l @n n n nnnnnnnnn l @nnnnnnnn n n  n  n  Y(EWNrr(((Y Y Y Y o Y tY rY  FlagsGroupIDIconIdNameObjectIDPositionjtsrtruYYGroupIDIdv1 q(yLk> ] 0  | O " n A  ` 3   R % E# oD" oC! oB oA o@ o? o>  o=  o<  o;  o:  o9 o8 o73 o5 o/ o.v o+l o*h o)\ o(W o#  o" o! o  o o  o  o  o  o  o  o  o  o o o o o o q @ @ @ @ @sssssssssssssssssss s!s"s#s$s sssss%s&s'ssssss s s s  q @ @ @ @ @ssssssss s s  s  s  s s  s!s"s#s(s)s*s+s.s/s5s7s8s9s:s;s<s=s>s ?s!@s"As#Bs$Cs%Ds&Es'RY8ER\SNwwY 6 Y Y lIdNameTypedv|v8NL } : ^ + U  j G  T P!Q {V'MZ'tblSuppliers"tblSupplierList($tblStocktblShippers tblRetailCustomers.*tblQuarterlySales,(tblProductCodes($tblPaymentDescriptions62tblInvoiceHeader*&tblInvoiceDetails,(tblEmployees"tblCategories$ tblBooks#qrySelectQuery&""qryRetailPriceList.*!qryProjectedProfits0, qryProductList&"qryPriceUpdate&"qryInvoiceDetails,(qryDeleteSales&"qryCustomerLookup,(yMSysResources$ vMSysNavPaneObjectIDs2.qMSysNavPaneGroupToObjects<8lMSysNavPaneGroups,(hMSysNavPaneGroupCategories>:eMSysIMEXSpecs$ aMSysIMEXColumns($\MSysCmdbars WMSysAccessXML$ 8MSysAccessStorage,(3INVOICE,f_121B2B9805264FE7AED90F694864F4D0_DataXTrptSupplierProductSummary<8rptSupplierProductList62rptStockList" rptRetailPriceList.* rptRetailCustomerLabels84 frmSuppliers" frmSupplierList($ frmStockMarkup&"frmStock'MSysComplexType_Attachment>:%MSysComplexType_Text2.#MSysComplexType_Decimal84!MSysComplexType_GUID2.MSysComplexType_IEEEDouble>:MSysComplexType_IEEESingle>:MSysComplexType_Long2.MSysComplexType_Short40MSysComplexType_UnsignedByteB>MSysComplexColumns.*MSysRelationships,(MSysQueries MSysACEsMSysObjects  YFNzzY Y \Y F Y 0 Y \ DataExtensionIdNameTypemz|z}YYJData_BC2842196B91417CA6B964BD94CDA5E3Idv1 ythmxOffice Themethmx2*y{y{ iK-? z < R  L " #J@ * '#tblStock.curSellingPrice7 g#tblStock.strColour1 g#tblStock.strProductDesc6 g#tblStock.strProductID4 g#tblStock!!! # G# G# # G" tblStock.curSellingPrice7 '" tblStock.strColour1 '" tblStock.strProductDesc6 '"tblStock.curSellingPrice7 g"tblStock.strColour1 g"tblStock.strProductDesc6 g"tblStock.strProductID4 g"tblStock!!! " G" G" " G!Profit[curSellingPrice]-[curCost]F o!tblStock.curSellingPrice7 glYcb}cbNY  Y |FY Y  Y  SaleIDDiscountCategoryIDStartDateLocationJYPrimaryKeyv1x,@Third Book FreeABC RadioB0,+@$10.00 OffUsed Books and ThingsP& @(@20% OffBooks R Us4  d%@15% OffCampus Book StoreB     Y FN Y  Y \( Y FlngCategoryIDstrCategoryNamememCategoryDesc.TP.7YYY.rClngCategoryIDPrimaryKeyHv1b@@  |[&p+  Window CoveringsDrapes, blinds, sheers< Coffee Table2@ Dining RoomDinette sets, dining tables<DrawersDressers, wardrobes0Single SeatingChairs, stools2SeatingSofas, loveseats, sectionals9ShelvingShelving units,Beds%@ Screws/NailsAssorted bolts, nuts, screws>HardwareMiscellaneous hardware4LVALCoffee tables, side tabCoffee tables, side tables, end tables, ottomansMattresses, box springs, bed frames  @    @   Y N Y  Y  Y  Y   Y .Y Y  Y A Y  Y   Y   Y   Y  Y >T Y  i Y   Y  @Employee IDLast NameFirst Name Title"Title Of CourtesyBirth DateHire DateAddressCity RegionPostal CodeCountryHome PhoneExtension Photo NotesReports To Yn |ۉYYPostal CodePrimaryKeyv1@  (7@@@ @BuchananStevenSales ManagerMr.14 Garrett HillLondonSW1 8JRUK(71) 555-48483453Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree. Upon joining the company as a sales representative, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London, wFuller, AndrewtVP6*@@@@@PeacockMargaretSales RepresentativeMrs.4110 Old Redmond Rd.RedmondWA98052USA(206) 555-81225176Margaret holds a BA in English literature from Concordia College and an MA from the American Institute of Culinary Arts. She was temporarily assigned to the London office before returning to her permanent post in Seattle.Fuller, Andrewh`8(@`+@@LeverlingJanetSales RepresentativeMs.722 Moss Bay Blvd.KirklandWA98033USA(206) 555-34123355Janet has a BS degree in chemistry from Boston College). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate and was promoted to sales representative.Fuller, Andrewxd^6,@q@@FullerAndrewVice President, SalesDr.908 W. Capital WayTacomaWA98401USA(206) 555-94823457Andrew received his BTS commercial and a Ph.D. in international marketing from the University of Dallas. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager and was then namb\2&?@@`@DavolioNancySales RepresentativeMs.507 - 20th Ave. E. Apt. 2ASeattleWA98122USA(206) 555-98575467Education includes a BA in psychology from Colorado State University. She also completed "The Art of the Cold Call." Nancy is a member of Toastmasters International.Fuller, AndrewD(`Z2( "@@`@DodsworthAnneSales RepresentativeMs.7 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.Buchanan, Stevenb\4, @B@@CallahanLauraInside Sales CoordinatorMs.4726 - 11th Ave. N.E.SeattleWA98105USA(206) 555-11892344Laura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French.Fuller, Andrew$jd4*@@@KingRobertSales RepresentativeMr.Edgeham Hollow Winchester WayLondonRG1 9SPUK(71) 555-5598465Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan and then joining the company. After completing a course entitled "Selling in Europe," he was transferred to the London ofBuchanan, Steven\V."@@ @SuyamaMichaelSales RepresentativeMr.Coventry House Miner Rd.LondonEC2 7JRUK(71) 555-7773428Michael is a graduate of Sussex University (MA, economics) and the University of California at Los Angeles (MBA, marketing). He has also taken the courses "Multi-Cultural Selling" and "Time Management for the Sales Professional." He is fluent in JapanesBuchanan, Stevenb\4& @HF6<<HF6@:HF86@HF8::HF>68QM:D[iiU8Hkfks8F[isU:D^m @  " JY4FN4444*Y  Y Y Y Y  lngInvoiceIDstrProductIDintQuantitysglDiscountcurSellingPrice A...7YYYYYInvoiceIDPrimaryKeystrProductIDBtblInvoiceHeadertblInvoiceDetails2tblStocktblInvoiceDetailsv14|[:tS2 l K * d C "  } \ ;  u T 3  m L vL=|H112vL=\H110u` W106u` W105u` W103u` W100uL=prL142t` W107t` W102tE<L138t >~C805s=0ZL100s0B122rL111rWL104r0ZL100r=~D818q@ D707p=E<L108p0ZD705oL=`#B245o=4B230oL=E<B200oL=B121n,0uH120nL=\H116nL=H113m\H110mLH100l >-202E<B235kL=B101jD710jL=0ZD704jL=OB295i > =B242i >%B203i >-202E<B102h0ZL100h[D708h =@ D706hE<B102g =D711g=D710f=p-L106ePb%L119eB101dL=%B203dL=p-B202dL=E<B200dE<B120L  @ @ @ @ @ @ddddeefggh h h h i iiijjjkklmmnnnoooop p!q"r#r$r%r&s's(t)t*t+t,u-u.u/u0u1v2v3 dL8:6dL:66dL:6:dL:6<eL868e^88Hf^86BgOD86gOD88hL86: hOD6B hOD6F h^866 iL86: iL:6:iL:6<iL:>::ᰪ6>86868:<@lL:6:mW866mW886nW88<nW88BnW8:6oL8:8oL:66oL:<6oL:>@pOD6@ p^86F!qOD6D"rOF8F#r^866$r^86>%888&8::'866(ѹ6)8:-866.86</us86@0us86B1vW8862vW88:3 @ @ @ @ @ @ @L868L868L86: L86: L8:6L8:8L8::'L:66L:66L:6:L:6:L:6:L:6<L:6<L:<6L:<@L:>:L:>@L:H@MF6@)OD6>OD6@ OD6B OD6D"OD6F OD86OD86OD88OF8F#W866W886W8862W88:3W88<W88BW8:6^866 ^866$^866(^86>%8686!888&888:-866.86:+86</s86@0s86B1s86D, JYN Y  Y  Y lngInvoiceIDstrCustomerIDdatInvoiceDateDaitaalaTiYYYY.rCCustomerIDPrimaryKeyDtblRetailCustomerstblInvoiceHeaderv1 y^C( kP5 v4@J001u3@M003t3@T100s3@R100r`3@M003q 3@F001p 3@F002o2@C101n2@J001m2@C103l1@K001k1@R100j0@T102i0@C101h0@M001g/@F002f/@M003e@/@T100d@/@F003O @ @ @M868M868 M86< S668 S66:S66: S66<[668 [668\668`668`66<`66<`66<i866i866m866m866m86:u  @ @defghijklm n o p q rstuvEYC:\WNY  Y lngPaymentIDstrPaymentTermsrpIDiPvcSuYYY.rCPaymentIDPrimaryKeyv1@ On AccountPrepaidC.O.D./Y cN Y \ Y 2(strProductCode*strProductDescriptionYPrimaryKeyv1 {Z@"W004Coffee TableT002Dining RoomR002DrawersR001Single SeatingM007SeatingJ001ShelvingF004BedsC002Screw/NailsC001Hardware @ M668M66:S66>[668`66Di668i66:m66:s66> Y\\N\ \\\\Y  Y Y  Y  Y  Y (Y  lngQtrSalesIDstrYearlngQuarterstrTerritorylngCategoryIDstrSalespersoncurPeriodSalesotidatpScamettwYYYlngCategoryIDlngSalesIDPrimaryKeyv1@`EUx@ R  q :  [ # w >  _ ( }BWu>_'u9Ss;ZE@u13MB/SKKapers, Sharon1!D X13MB/SKOlaffson, Oly0!Cnc13MB/SKOlaffson, Oly0!B7p13MB/SKReyes, Amelia0!Ap>r13BCReyes, Amelia-@ vv13BCGrimes, Fred,?V13BCGrimes, Fred,>0Ft13BCReyes, Amelia-=9E13ABBrahms, Eileen.< P 13ABFulton, John,;'lk13ABFulton, John,:Щ+13ABBrahms, Eileen.9`12ONMerius, Phil,8 Z12ONBouvier, Aurelle07t12ONMacKenzie, Bill/6uh12ONCaruthers, Bill/5@sD12MB/SKKapers, Sharon1!4 Т12MB/SKOlaffson, Oly0!3.12MB/SKOlaffson, Oly0!2X12MB/SKKapers, Sharon1!1812BCReyes, Amelia-0h12BCGrimes, Fred,/k912BCGrimes, Fred,.0\12BCReyes, Amelia--12ABBrahms, Eileen.,`12ABFulton, John,+y12ABFulton, John,*PL12ABBrahms, Eileen.)12ONMerius, Phil,(I12ONBouvier, Aurelle0'z12ONMacKenzie, Bill/&K12ONCaruthers, Bill/%`z12MB/SKKapers, Sharon1!$12MB/SKOlaffson, Oly0!# 12MB/SKOlaffson, Oly0!"e12MB/SKKapers, Sharon1!!12BCReyes, Amelia- y12BCGrimes, Fred,Ўz12BCGrimes, Fred,Z12BCReyes, Amelia-ݥs12ABBrahms, Eileen.\12ABFulton, John,12ABFulton, John,12ABBrahms, Eileen.-W12ONMerius, Phil,J+12ONBouvier, Aurelle0\N12ONCaruthers, Bill/Zn12BCReyes, Amelia-pQ12BCGrimes, Fred,p%12BCGrimes, Fred,@B=12BCReyes, Amelia-V12ABBrahms, Eileen.ZF~12ABFulton, John,612ABFulton, John,PG12ONMerius, Phil,ps+12ONMacKenzie, Bill/ p{d,12ONCaruthers, Jim. .l12MB/SKKapers, Sharon1!  12MB/SKOlaffson, Oly0! f12MB/SKOlaffson, Oly0! 0cY12MB/SKKapers, Sharon1!2h12BCReyes, Amelia-,Z12BCGrimes, Fred,px12BCGrimes, Fred,`$^12BCReyes, Amelia-P]12ABFulton, John,^12ABBrahms, Eileen.F12ABFulton, John,D12ABBouvier, Aurelle0 Qs: \ n 4 Q  \O414MB/SKSeaton, Greg/![ 14ABMorrison, Jack.Z14ONFrank, Paula,Yd13ONMerius, Phil,X 9113ONBouvier, Aurelle0Wj13ONMacKenzie, Bill/V҂13ONCaruthers, Bill/UQ13MB/SKKapers, Sharon1!T 13MB/SKOlaffson, Oly0!S113MB/SKOlaffson, Oly0!R Dg13MB/SKKapers, Sharon1!Q!13BCReyes, Amelia-P 13BCGrimes, Fred,O?13BCGrimes, Fred,N13BCReyes, Amelia-M+13ABBrahms, Eileen.L 13ABFulton, John,K`ny13ABFulton, John,Jp 13ABBrahms, Eileen.Ij13ONMerius, Phil,H '13ONBouvier, Aurelle0G'ޒ13ONMacKenzie, Bill/FNnn13ONCaruthers, Bill/  @ @ @ @ @ @ @ @ @ @ @ -A%9=  :>B   #'+/   $(,048<@D !)15"&*.26 3 7 ; ? C       @ @ @ @ @ @ @ @ @ @ @       ! "!#"$#%$&%'&(')(*)+*,+-,.-/.0/102132435465768798:9;:<;=<>=?>@?A@BACBDCEDFGHIJKLMNO P Q R S TUVWXYZ[\  @ @ @ @ @ @ @ @ @ @ @       ! "!#"$#%$&%'&(')(*)+*,+-,.-/.0/102132435465768798:9;:<;=<>=?>@?A@BACBDCEDFGHIJKLMNO P Q R S TUVWXYZ[\ dYN Y (' Y d Y Jd Y Nd Y @( Y  Y <strCustomerIDstrCustomerName$strCustomerAddressstrCustomerCity&strCustomerProvince*strCustomerPostalCode strCustomerPhoneYYYY.rDCompanyNamePostalCodePrimaryKeyv1@  :o  B  [ 5 T102Time Euro Designs1900 Oak St.VancouverBCV3F2K16045557293L@84)T100Tredway Furniture10030 Jasper AvenueEdmontonABT5J4K84034248047RF>:0R101Rooms for Life2710 Portage AvenueWinnipegMBR2K4V92048886135OC;7-R100Rooms for Life199 Albert StreetWinnipegMBR3B3K32046685135MA95+M003Montreal Casual Living10 rue BoivinMontrealPQH3C5V25148127751QE=9/ M002Main Patio World3600 Hartley StreetReginaSKS8Z1F23068230034OC;7/M001My Northern Dcor1223 Sutton RoadTimminsONN3B4Y77054993700NB:6-K001Kids Korners2200 Martindale Ave.TorontoONM4V8B74164432020MA95,J001Just Off the Shelf99 Martingrove WayMonctonNBB3C8T19024453030QE=90F003For Sweet Dreams1251 Lonestar DriveHalifaxNSB9V7R29024421515PD<8/F002Fur & Pine Dreams1100 Mandrake Road N.CalgaryABT4T2Y24039821022SG?;2F001French Craft Corners126 Queen Street ESaskatoonSKS7B9M93066778080UIA=2C103Cast Iron Works25 Northwind PlaceVancouverBCV4B7N86043358876PD<8-C102Cute Baby Things195 Market SquareHalifaxNSB4B7T79023310002NB:6-C101Cobb Bedding and Beyond1 Walden Ave.HamiltonONL4B8V54168820101RF>:0! @ @  MJkmYidbsdi\kMdLLLQOOYbUJbOLQvdbOMomQLJLvmWYbUkSdiksQQmOiQJ`kSiQbMWMiJSmMdibQikSoifYbQOiQJ`k[okmdSSmWQkWQ^S\YOk\dibQik`JYbfJmYdsdi^O `dbmiQJ^MJkoJ^^YqYbU `vbdimWQibOQMdiidd`kSdi^YSQ idd`kSdi^YSQ mY`QQoidOQkYUbkmiQOsJvSoibYmoiQ ] @ @Lٳپ:簪>󳢶vDi:\>qH im:v:m@[>\F qLDbF{ @ @ M868M86:M86<S668S66:S66<[668\668`668`66: `66< i866 i868 m866 m86:ZYNY  Y P Y 0lngShipperIDstrShipCompany$strShipPhoneNumberYShipperIDv1qE Go Cargo2048718826Package Express6139906747#Federal Shipping(416) 555-9931(United Package(514) 555-3199&Speedy Express(403) 555-9831&  ^ YjN  jjjjj j Y  Y .P Y n  Y  Y Y Y  Y Y strProductIDstrProductDescstrColourstrSupplierIDlngCategoryIDcurCostcurSellingPriceintUnitsInStockysnDiscontinued??WW?4 a.L YYYYYYY.rFItem CodePrimaryKeystrCategoryIDstrSupplierID*tblCategoriestblStock(tblSupplierstblStockHv1b/6l&N k  4 S s ) H  v2T {3\>e!U; @+H113Shelf Bracket 8GoldH003;5/ |-H112Shelf Bracket 1GoldH003;5/ @2H111Shelf Bracket 8GoldH003;5/ \VH110Shelf Bracket 6GoldH003;5/ >LJH102Caster 1 inn/aH00160+ .LPH100Caster 3/4 inn/aH00382- A~(D818Bar StoolAshE0034.) A~(D809Bar StoolWhiteE00360) A~D808Bar StoolBlackE00360) `;@T D733Dinette 5 pieceBeigeF004<6/  = D724Dinette 7 pieceOakF004:4/  D717Kitchen TableBlueF00493- S@ -D716Kitchen ChairWhiteT003:4- [poD715Dinette 8 pieceOakF007:4/ pdOD714Dining ChairMapleT00393, pdO&D713Dining ChairMapleT00393,  .D712Dining ChairMapleT00393, `# = D711Dinette CabinetOakF004:4/ D710Dinette CabinetOakF004:4/ -.c D709Dinette 7 pieceOakT002:4/ %&[D708Dinette 7 pieceMapleF004<6/ S@ -D707Kitchen ChairBeigeT003:4- S@ (D706Kitchen ChairGreyT00393- 20Z D705Dinette 5 pieceWhiteM004<6/ 20Z D704Dinette 5 pieceBlackF007<6/ :cD703Dinette 5 pieceBeigeJ001<6/ A~C805Bar StoolBrownW00460) ' OB295Dining ChairPineH00182, 0W` B294Dining ChairGreenH00193, ` "B293Dining ChairRedH00171, B292King MattressGoldS00193- 0`#B245Queen Box SpringYellowS001>80 P%&B244King Box SpringNavy BlueS001@:/ Pb%g5B243Queen MattressYellowS001<6. o( =B242King MattressLight BlueS001?9- `k*E<B235King MattressNavy BlueS001>8- `#E<B234King MattressRoseB00193- 9P"B233Queen Box SpringNavy BlueB001A;0 %B232King Box SpringWhiteB001<6/ @'E<B231King MattressWhiteB001:4- $4B230Queen MattressLight GreenB001A;. 2)E<&B205King MattressDark GreenB001?9- 9P"#B204Queen Box SpringYellowS001>80 %B203King Box SpringLight BlueB001A;/ p-(B202Twin MattressNavy BlueB001>8- $4$B201Queen MattressYellowB001<6. @'E<!B200King MattressLight BlueB001?9- 0B122Dresser 5-DrawerFirW004;50  B121Dresser 5-DrawerFirW004;50 К&E< B120WardrobeMahoganyW00482( К&E< B102WardrobeMahoganyW00482(  B101Dresser 4-DrawerPineJ001<60 0B100Dresser 6-DrawerPineJ001<604q(a 6 V  ; r ' I  l$U@u*>f%=c ` 8W107SheersWhiteW0023-& ` PW106Vertical BlindsWhiteW002<6/ ` AW105Vertical BlindsDark GreenW002A;/ ` FW104Vertical BlindsLight GreenW002B</ ` KW103Vertical BlindsBrownW002<6/ ` LW102Vertical BlindsNavy BlueW002@:/ 0W <W101SheersCreamW0023-& ` .W100Venetian BlindsOakW002:4/ g5prL142SectionalBlackC00160) g50fL141Dresser 5-DrawerYellowT001>80 @3.cL140Dresser 4-DrawerLight GreenB001C=0  u8PnL139Dresser 6-DrawerLight BlueF004B<0  E< L138Wall Unit 7-ShelfPineF007=71 Xp- L136Wall Unit 6-ShelfPineM002=71  L122OttomanGreyF0033-' L&CL121Coffee TableMapleF00493, `-L120Side TableOakJ0015/* Pb%L119Coffee TableMapleT00593, p-L118Coffee TablePineE00382, `(JL117CouchMoss GreenM00471% 9 L116Side TableAshM0045/* 9 L115Side TableAshM0025/* @'XO L114Coffee TableMapleM00293, L&C L113Coffee TableAshJ00171, "ipoL112Couch - LeatherRedE003:4/ pbL111Couch - LeatherDark GreenM002A;/ pbL110Couch - LeatherBlackF003<6/ \  L109End TableMapleF00460)  E< L108Wall Unit 5-ShelfOakJ001<61 e4 L107Wall Unit 5-ShelfOakF007<61 Xp-L106Wall Unit 3-ShelfOakF007<61 HL105Sectional 5 SeatWhiteC001=70 pH`WL104Sectional 7 SeatGreyT005<60  I L103CouchGreyF0031+% 0wSL102CouchBlackF0032,% 7Pkb L101LoveseatNavy BlueC00193(  "10Z L100LoveseatDark GreenC001:4( Y0uxH201Caster 3/4 inn/aH00382- 8J L:6@ L:<6 L:<8 L:<:L:<<L:<>:<@L:>::><L:>>:>:::<L:H>:ᰪѹ66<OD6>OD6@OD6BOD6DOD6F OD6H!OD86"OD88#OD8:$OD8<%OD8>&8'8(8):>*<<+OF6F,OF6H-OF8F.W866/W8680W86:1W8862W8883W88:4W88<5W88>88888888888:68:88::8:< W8:> W8:@ W8:B W:66 W:68^866^868^86:^86<^86>868686868688688888:88<^88>^88@^88B^88D ^88F!^88H"^8:6#^8:8$^8::%^86)8>8*8>:+866,868-86:.86</s86>0s86@1s86B2s86D3 @ @ @ @ @ @ @ @ @ @ @ @ @ @L866L868L86:L8:6L8:8L8::L:66L:68L:6:L:6< L:6> L:6@ L:<6 L:<8 L:<:L:<<L:<>:<@L:>::><L:>>:>:::<L:H>:ᰪѹ66<OD6>OD6@OD6BOD6DOD6F OD6H!OD86"OD88#OD8:$OD8<%OD8>&8'8(8):>*<<+OF6F,OF6H-OF8F.W866/W8680W86:1W8862W8883W88:4W88<5W88>88888888888:68:88::8:< W8:> W8:@ W8:B W:66 W:68^866^868^86:^86<^86>868686868688688888:88<^88>^88@^88B^88D ^88F!^88H"^8:6#^8:8$^8::%^86)8>8*8>:+866,868-86:.86</s86>0s86@1s86B2s86D3f  @ @ @ @ @ @ @ @ @ @ @ @ @/012345          &' +$%&(,-.()* !"#')*+      ! " # $ % , - . / 0 1 2 3 @ @ @ @ @ @ @ @ @ @ @ @ @ @L668L668L668L668 L668 L668 L668 L668L668L668L668)M668M668M668M668+Q66<,Q66<-Q66<.Q66<Q66<!S66<S66<S66<S66<%S66> S66>"66>#66>)66>*66>+66>66>$66>(6666'666666'668668668668166</W66<0W66<2W66<3W66<4W66<5W66<W66<W66<W66< W66<[668[668[668[668[668[668#`66:`66:`66:`66:&`66>`66>`66> k668 k668k668k668k668k668k668k66:k66:k66:k66:k66:k66:k66: k66: k66: k66: m668*m66:!m66<m66<m66<$m66<%m66<&m66<(m66@m66@"s66:,s66:-s66:.s66:/s66:0s66:1s66:2s66:3s66>s66>s66>s66>s66> Y'N Y d Y d Y d Y d Y d Y d Y  dstrSupplierIDstrSupplierName$strSupplierAddressstrSupplierCity&strSupplierProvince$strSupplierContact,strSupplierPhoneNumberrtI' YYPrimaryKeystrSupplierIDv1@   ,YN   Y  Y d Y d Y  Y d Y ( Y ( Y <Y strSupplierIDstrSupplierName$strSupplierContact$strSupplierAddressstrSupplierCity&strSupplierProvince*strSupplierPostalCode strSupplierPhonelngPaymentIDsnYYYYYYYY.rGL{7C106B42-D86E-4D5F-B3D7-74B27E97931A}ContactNamelngPaymentIDPostalCodePrimaryKeySupplierNamev1b@ F D  n .0~ lJ W004Woodworkers Inc.Barbara Denison315 Park PlaceVancouverBCV5B7Y26047860909~zhL. W002Window DressersAndrew Thompson55 Ingot PlaceHalifaxNSB6C3P19027620991xtfJ, T005The Idea PlaceMarie-Claude Boisvert300 Vincent StreetHalifaxNSB3T7W19026260018xT* T003Three ChairsSonia Martin1083 Maplehurst DriveEtobicokeONM8G7W24167218801~zh>& T002Thompson Furniture TradersHenry Chiu275 Overlea BlvdTorontoONM5X2P74164335656vVB T001Twin TowersPaul Robinson185 Park DriveReginaSKS5Y3T83064452312vjfZ>$ S002The Silver ShopPauline Samuels109 WestmorelandCalgaryABT3C4T44037739977|xjJ, S001Sleep RightAnita Marguallis87 Winston PlaceMississaugaONL5M2C89052238845~zdD$ R001Rugs & ThingsSandra Singh41 Lowell LaneHalifaxNSB3G8S39025115242znj\@( M007Mobile HomesHugh Samson200 Walden RoadSaskatoonSKS2K3T33067641737|plZ<& M004Modern DesignsFrank Chung10 Burnamthorpe RoadMississaugaONL3Z7T89059216509~h@* M002Mason and Johnstone CompanyKaren Johnstone11000 Boulevard Rene LevesqueMontrealPQH2T8B55146219929bD J001Just WoodDennis Gilbert35 John StreetWinnipegMBR2B3G22047251215xlhX<  H003House & Home Ltd.Helen James5900 Yonge StreetTorontoONM3B2Y24169801122zvhF0 H001Home AccessoriesGuy Hubert900 Queen Street WestOakvilleONL4V7T29053213434|lB. F007Fine FurnishingsBrent Carter2424 Place BoisvertMontrealPQH5V6B35168831213|lF. F004Furniture WarehouseMarc Desjardins2800 place BertrandHullPQH8K3T26139923144xR4 F003Furnish It RightAnna Polowski99 Valmount AveVancouverBCV3C7V86046221313|xfH. E003Euro MobileCarla Martinez400 Bond StreetWinnipegMBR2Y5V82046631070~rn^@$ C001Carter CushionsJohn Ramsey125 Oak StreetEdmontonABT3R4T64038873422~rn^B, B001Beds for LifePeter McNally245 South Vanhussen St.HamiltonONL3C2E59058763358pB(p @ @@@ JbOiQsmWd`fkdbJbYmJ`JiUoJ^^Yk JbbJfd^dsk\YLJiLJiJOQbYkdbLiQbmMJimQiMJi^J`JimYbQxOQbbYkUY^LQimSiJb\MWobU UovWoLQimWQ^Qb[J`QkWQbivMWYoWoUWkJ`kdb [dWbiJ`kQv\JiQb[dWbkmdbQ `JiMOQk[JiOYbk`JiYQM^JoOQLdYkqQimfJo^idLYbkdbfJo^YbQkJ`oQ^kfQmQi`MbJ^^vkJbOiJkYbUW kdbYJ`JimYbc  @ @       @ @ LqDm:^@`:MF `>6666866<[668`66: `66> `66D i668 k668 k66:m668m66:m66<m66@s66:s66>O   @LQOkSdi^YSQMJimQiMokWYdbkQoid`dLY^QSYbQSoibYkWYbUkSoibYkWYmiYUWmSoibYmoiQsJiQWdokQWd`QJMMQkkdiYQkWdokQWd`Q^mO[okmsddO`JkdbJbO[dWbkmdbQMd`fJbv `dLY^QWd`Qk `dOQibOQkYUbk ioUkmWYbUk k^QQfiYUWm mWQYOQJf^JMQmWQkY^qQikWdfmWd`fkdbSoibYmoiQmiJOQikmWiQQMWJYikmsYbmdsQiksYbOdsOiQkkQiksddOsdi\QikYbM',yData,NvcP=*z @ -  } j C 0  m Z G 3 p\I6"r_K8%ts` 6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp # ' '6*>H8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp '  6*>H8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  \6*>H8+b|тHp5~~,ӵA/?Nb Ն aˌ]F^~^UZDp \ \6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp W W6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp 8 86*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp BYT0< H D l)_,@_,@tblSupplierstblStockJJJJJJJJJJH (7,@7,@tblStocktblInvoiceDetailsTTTTTTTTTTR 'KQj,@KQj,@tblRetailCustomerstblInvoiceHeaderffffffffffd &,@,@tblInvoiceHeadertblInvoiceDetailsddddddddddb %8F(:,@8F(:,@tblCategoriestblStockLLLLLLLLLLJ $,@,@{7C106B42-D86E-4D5F-B3D7-74B27E97931A}nnnnnnnnnnl ,@sEuV@tblPaymentDescriptions@ZZZNNNNNNNL @!c ,@c ,@qryProjectedProfits@|@`TTHHHHHHHF @,@,@ qryDeleteSales@|@VJJ>>>>>>>< @q#lvR@#lvR@ MSysNavPaneGroupToObjects4MR2KeepLocal  TTTTTTTTR @WB1,,@J1,,@MSysAccessXML4MR2KeepLocal  T|||<<<<<<<: @LnvR@LnvR@~sq_rrptSupplierProductList4MR2KeepLocal TXXXXXXXV @¨nvR@¨nvR@~sq_rrptRetailCustomerLabels4MR2KeepLocal TZZZZZZZX @{nvR@{nvR@~sq_ffrmSupplierList4MR2KeepLocal TJJJJJJJH @pFvcO<)   x e R > +   { h U T A @-,{hgTA.~jWD0   6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp v v6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp q q6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp l l6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp h h6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  % %6*>H8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp %  6*>H8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp   6*>H8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp   6*>H8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp   6*>H8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp  ! !6*>H8+>HW~~,ӵA/?Nb Ն aˌ]F^~^UZDp `LVALh pxάi&tblStockάN&tblStockά(Y&qtblStockά(C&tblStockά$"tblInvoiceHeaderBtblInvoiceDetailsGvcO<)   x e R > +  {  g T A -}jVC0 lYE2 n[) )6*>H8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټH8+ 2B5/7..|u~~,ӵA/?Nb zټL\-000 Product ID   m  Table/Query       720;1440   0twip  tblStock$curSellingPrice   2 *$#,##0.00;($#,##0.00)   0 " Selling PriceMR2OrientationOrderByOnNameMapColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLength$UnicodeCompressionCaptionDisplayControl(     U/kC /k@Categoriesx\Jy/kC /CategoryIDc~֚.8Aj/kC /CategoryNameuT@`p'P/kC /Description$memCategoryDesc       Descriptione lngCategoryID    Category ID$strCategoryName T  " Category Name    m MR2Orientation FilterOrderByOrderByOnDefaultViewColumnWidthColumnOrderColumnHiddenGUID8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexTextAlignAggregateTypeCurrencyLCIDPublishToWeb    P.*xI&1.ӈ           B B   B B   Z SaleID      ^Discount      bCategoryID      `StartDate      ^Location      LVAL MR2OrderByOnColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlCaption 0*strProductDescription R     m. &Product Description"strProductCode      m  Product CodeMR2OrientationOrderByOnColumnWidthColumnOrderColumnHiddenCaptionRequiredAllowZeroLengthDisplayControl$UnicodeCompression  alngPaymentID    Payment ID$strPaymentTerms c     m  " Payment TermsMR2OrderByOnOrientationRequiredCaption FormatInputMaskColumnWidthColumnOrderColumnHiddenValidationRuleValidationTextAllowZeroLengthDisplayControl$UnicodeCompressionRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsListRowsListWidthLimitToListColumnWidthsDescriptionDecimalPlacesDefaultValue FilterOrderBy  "datInvoiceDate   Invoice Date Medium Date 99/99/00    >=Date()P HInvoice Date cannot be before today.B strCustomerID    Customer ID     m    >L999 Table/Query, $tblRetailCustomers      0twip  720;1440lngInvoiceID   R JThe number found on the invoice form.  Invoice ID  0   mtLVALMR2OrderByOnOrientationColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlCaption$UnicodeCompressionDecimalPlaces FormatDefaultValueRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListInputMaskValidationRuleValidationText FilterOrderByDescriptionDefaultViewGUID8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexTextAlignAggregateTypeCurrencyLCIDPublishToWeb    NuDd     ! " #B $B % & 'B (B ) * .strTerritory      m Territory   + , -"strSalesperson      m Salesperson   + , -"curPeriodSales U       Period Sales2 *$#,##0.00;($#,##0.00) + , -strYear      m Year   + , -H lngCategoryID      Category ID  0  m Table/Query" tblCategories    720;1440   0twip  + , - lngQtrSalesID     Qtr Sales ID + , -lngQuarter f      9 Quarter  1 & Between 1 And 4H @Quarter must be between 1 and 4. m + , -SLVALX eMR2OrientationOrderByOnColumnWidthColumnOrderColumnHiddenCaptionRequiredAllowZeroLengthDisplayControl$UnicodeCompressionInputMask  alngShipperID    Shipper ID"strShipCompany   (  Shipping Company   m  *$strShipPhoneNumber '    Phone Number   m  . &!\(999") "000\-0000MR2.OrderByOnOrientationAllowZeroLengthRequiredCaptionColumnWidthColumnOrderColumnHiddenDescriptionDisplayControl$UnicodeCompressionInputMask  4 strCustomerID   Customer ID    Enter the first letter of the customer's name followed by three numbers.  m   >L999$strCustomerName  " Customer Name     m  $strCustomerCity       m City  & strCustomerPhone    Phone Number '    m  *$strCustomerAddress    Address    m  ,&strCustomerProvince   R JAbbreviate the Province to 2 letters. >LL Province    m  0*strCustomerPostalCode   P HLetters are converted to upper-case. >L9L\ 9L9 Postal Code    m  3LVALEMR2JOrientationOrderByOnDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionCaption'    strSupplierID      m       SupplierID$strSupplierName      m      " Supplier Name*$strSupplierAddress      m       Address$strSupplierCity      m       City,&strSupplierProvince      m        Province*$strSupplierContact      m       Contact2,strSupplierPhoneNumber      m        Phone NumberMR2OrderByOn4DatasheetGridlinesBehavior(DatasheetCellsEffectRowHeightOrientationColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlCaption$UnicodeCompressionRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListInputMaskDecimalPlacesDefaultValue FormatDescription FilterOrderBy<    ; 6 strSupplierID        m Supplier ID   Table/Query  tblSuppliers    720;1440   0twip   >L000curCost      0  Cost2 *$#,##0.00;($#,##0.00)$curSellingPrice d     0 " Selling Price2 *$#,##0.00;($#,##0.00)$intUnitsInStock      0   m$ Units In Stock$ysnDiscontinued     Yes/No  No   j  Discontinuedf ^Check off if the product has been discontinued. lngCategoryID     Category ID  0   m Table/Query" tblCategories      0twip xstrColour    Colour     m  strProductID    >L\-999 Product ID     m  "strProductDesc    Description     m  LVALMR2OrientationOrderByOnAllowZeroLengthRequiredCaptionColumnWidthColumnOrderColumnHiddenDisplayControl$UnicodeCompressionInputMaskDescriptionDecimalPlaces FilterOrderByDefaultViewGUID8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexTextAlignAggregateTypeCurrencyLCIDPublishToWeb    ZL000 Enter the first letter of the Supplier's name followed by three numbers.    $strSupplierName  " Supplier Name |   m      *$strSupplierContact    Contact Name    m      *$strSupplierAddress   Address    m      $strSupplierCity   City    m      ,&strSupplierProvince   Province    m  V NAbbreviate the province to two letters.    #0*strSupplierPostalCode   Postal Code >L0L\ 0L0    m  N FLetters are converted to uppercase.    & strSupplierPhone    Phone Number. &!\(999") "000\-0000    m      &lngPaymentID    zEnter the Supplier's payment Terms (eg. COD, Prepaid etc...).  " Payment Terms  m    h #~ # tblSupplierstblStocktblStockstrSupplierIDtblSuppliersstrSupplierIDx`F6tblStocktblInvoiceDetailstblInvoiceDetailsstrProductIDtblStockstrProductIDzb@tblRetailCustomerstblInvoiceHeadertblInvoiceHeaderstrCustomerIDtblRetailCustomersstrCustomerIDrRtblInvoiceHeadertblInvoiceDetailstblInvoiceDetailslngInvoiceIDtblInvoiceHeaderlngInvoiceIDrPtblCategoriestblStocktblStocklngCategoryIDtblCategorieslngCategoryID|bH8{7C106B42-D86E-4D5F-B3D7-74B27E97931A}tblSupplierslngPaymentIDtblPaymentDescriptionslngPaymentIDrZ LVAL MR20AccessVersion Build6Track Name AutoCorrect Info0Perform Name AutoCorrectCpgConversionProjVerNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort ByHasOfflineLists>Show Navigation Pane Search BarWebDesignMode&Theme Resource Name 09.50 ~             F     Office ThemeMR20AccessVersion Build6Track Name AutoCorrect Info0Perform Name AutoCorrectCpgConversionProjVerNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort ByHasOfflineLists>Show Navigation Pane Search BarWebDesignMode&Theme Resource Name 09.50 ~             F     Office Theme