Standard ACE DBnb` Ugr@?~1y0̝cßFNc7ܜS(.` {6`߱lCZ73y[-|*|Ab,f_Љ$g'DeFx -bT4.0 dv@ YRCoS RR Y   Y 5Y  Y Y  Y  Y  Y  s Y  Y  Y 0 Y a Y 2Y  Y   Y  BY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypezL0,enYYIdParentIdName        OYS  RY Y Y  Y 2ACMFInheritableObjectIdSID YObjectId Y66S  Y  Y dY Y  Y / Y yY  Y ,AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order,, ,Y"ObjectIdAttribute   -YS  Y Y Y  Y ۿ Y  Y  Y ۿ Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship ۿIeee ID ۿYYYszObject$szReferencedObjectszRelationship v1b N  : k &   9  @@@ @  @@ @ @  @ @@ JOOMiQOYmMJiOJOOMiQOYmMJiO+koLSdi`JOOfidOoMmMokmd`QidiOQimdmJ^kMokmd`QidiOQimdmJ^k+koLSdi`Mokmd`QikYUboff^JMQdiOQi f^JMQdiOQi+koLSdi`!iQqYQsdiOQiOQmJY^k"kWYfdiOQik#ksJfmsdmQumLduQk$qJ^YOJmYdb%JO`Yb&OJmJJMMQkkfJUQkOJmJLJkQkSdi`k`dOo^QkiQ^JmYdbkWYfkiQfdimkkMiYfmkkvkiQ^mJL^Qk+kh+MJOOMiQOYmMJiO+koLSdi`+kh+MMJiOmvfQYO'+kh+MJOOMiQOYmMJiO+kh+MMWY^O:>(+kh+MJOOfidOoMm+kh+MfidOoMmMJmQUdivYO)+kh+MMokmd`QidiOQimdmJ^k+koLSdi`+kh+MdiOQiYO*+kh+MMokmd`QidiOQimdmJ^k+kh+MMWY^O::*+kh+Mf^JMQdiOQi+koLSdi`+kh+MfidOoMmYO*+kh+Mf^JMQdiOQi+kh+MMokmd`QiYO*+kh+Mf^JMQdiOQi+kh+Mf^JMQdiOQi+koLSdi`*+kh+MfidOoMmLidskQi+kh+MfidOoMmMJmQUdivYO*+kh+MkWYfdiOQik+kh+MMokmd`QiYO*+kh+MkWYfdiOQik+kh+MkmJmokYO*+kh+SJOOMiQOYmMJiO*+kh+SJOOMiQOYmMJiO+koLSdi`* +kh+SJOOfidOoMm* +kh+SMokmd`QidiOQimdmJ^k* +kh+SMokmd`QikYUbof* +kh+Sf^JMQdiOQi* +kh+Sf^JMQdiOQi+koLSdi`*+kh+SkWYfdiOQik*MJiOmvfQk*MiQOYmMJiOk*Mokmd`Qik*`kvkJMMQkkkmdiJUQ*`kvkJMMQkku`^*`kvkJMQk`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^JmYdbkWYfkdiOQiOQmJY^k*diOQik*diOQikmJmok*diOQimdmJ^k*fidOoMmMJmQUdiYQk*fidOoMmk* iQqYQsdiOQiOQmJY^k*!`kvkOLko``JivYbSdokQiOQSYbQOdiOQikdiOQiOQmJY^k diOQikmJmokdiOQik fidOoMmMJmQUdiYQkfidOoMmk fidOoMmkdiOQiOQmJY^k iQSQiQbMQ iQSQiQbMQ8>  @ @ @ @ @ @ @ @ @ @      !"#$%&'()******** *!* "* #* $* %* &*'*(*)*!* + , - . /     !#%',*0*5*;*z************ v1 B q @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $%&'( ) * + , - . / 0 1 2 3 4 5 6 789:;<=>?@ABCDEFGHIJKLMNOP        ! !!!""#"$"%#&#'#($)$*$+%,%-%.&/&0&1'2'3'4(>(?(@)G)H)I*J**+++,,,-- - . . . ///,-.DE/01234FGH     !!!###%%%'I'',5,6,708090:5;5<5=;>;?;@zAzBzC !"#$%&'()*+56789:;<=ABCDEF  !"#v1 L @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ )))) ))))) ) ) )) ))) )) ))))))))))))))  )!))")$)%)&)' )( )))#)*),)-).)/)+)0)2)3)4 )5)1)6)8)9):); )< )=)7)>)@)A)B)? )C )E )F )D!)G!)I!)J!)H")K")M")N")L#)O#)Q#)R#)P$)S$+$+$+%+%+%+%+%+%+ %+ %+ %+ %+ %+%+%+&+&+&+&+'+'+'+'+(+(+(+(+(+(+(+( + ( +!( +"( +#(+)+$)+&)+')+()+))+*)++)+,)+-)+.)+/)+%v1@  diOQikdiOQiOQmJY^kdiOQikmJmokdiOQikfidOoMmMJmQUdiYQkfidOoMmkfidOoMmkdiOQiOQmJY^kiQSQiQbMQiQSQiQbMQ8   MiQOYmMJiOkdiOQiOQmJY^kdiOQiOQmJY^kdiOQikdiOQikfidOoMmk MJiOmvfQkMiQOYmMJiOkdiOQikdiOQikmJmokfidOoMmMJmQUdiYQkfidOoMmk7*d _ Z  G q  0 =X1-F]u84Cv!Bb=@=@~sq_cAddO4@O4@~sq_cAddProduct~sq_cProductCategoryID4MR2KeepLocal Tlllllllj @ /@ /@~sq_cAddCreditCard~sq_cChild244MR2KeepLocal T^^^^^^^\ @$* "Vs@ƱѴ@Admin@8,,,,,,,,,* ~'a.@~'a.@Validation66666666664 a@a@SwapTwoTextBoxes~@NNNBBBBBBB@ @#*`$5@`$5@ReviewOrderDetails@RRRFFFFFFFD @=2@=2@PlaceOrder_Subform@RRRFFFFFFFD @"!2@"!2@PlaceOrder@BBB66666664 @ `/$@`/$@CustomerSignUp@JJJ>>>>>>>< @ Ag#@Ag#@CustomerOrderTotals_Subform@dddXXXXXXXV @ e#@e#@CustomerOrderTotalst@TTTHHHHHHHF @ v3@v3@AddProduct@BBB66666664 @"*3.@3.@AddCreditCard0@HHH<<<<<<<: @ Ӣ@Ӣ@UserDefined@DDD88888886 @ Ӣ@Ӣ@SummaryInfo@DDD88888886 @@@SysRel.........., @@Scripts0000000000. Ӣ@Ӣ@Reports0000000000. @@Modules0000000000. Ӣ@Ӣ@Forms,,,,,,,,,,* @@DataAccessPages@@@@@@@@@@> 'U)@U)@MSysComplexType_AttachmentTTTTTTTTTTT %U)@V)@MSysComplexType_TextHHHHHHHHHHH #U)@V)@MSysComplexType_DecimalNNNNNNNNNNN !U)@V)@MSysComplexType_GUIDHHHHHHHHHHH U)@V)@MSysComplexType_IEEEDoubleTTTTTTTTTTT U)@V)@MSysComplexType_IEEESingleTTTTTTTTTTT U)@V)@MSysComplexType_LongHHHHHHHHHHH U)@V)@MSysComplexType_ShortJJJJJJJJJJJ U)@V)@MSysComplexType_UnsignedByteXXXXXXXXXXX U)@U)@MSysComplexColumnsDDDDDDDDDDD U)@U)@MSysRelationshipsDDDDDDDDDDB U)@U)@MSysQueries88888888886 U)@U)@MSysACEs22222222220 U)@U)@MSysObjects88888888886 U)@B@MSysDb@:::......., @U)@U)@Relationships<<<<<<<<<<: U)@U)@Databases44444444442 U)@U)@Tables.........., D YN Y Y  Y Y Y ColumnNameComplexID&ComplexTypeObjectID"ConceptualTableIDFlatTableID , , ,  , , ,  , , , YYY(IdxConceptualTableIDIdxFlatTableID IdxIDv1@    fYNY  ValuedvfYNY  ValuedvfYNY  ValuedvfYNY  ValuedvfYN  Y  ValuedvfYN""Y  ValuedvfYN$$Y' ValuedvfYN&& Y ' ValuedvaYN(( Y Y  Y Y  Y  Y nFileDataFileFlagsFileNameFileTimeStampFileTypeFileURL((((Hv1bTX~` U { ] ?  z \  W  c 3 ~@7}1g7v? [qS5y[=$ G#Customers### #  G# # G"Products!!! "  G" " G!CreditCards''' !  G! ! G Customers###    G    G[OrderStatus].[Status]5 g[OrderStatus].[ID]1 gOrderStatus'''   G  [LastName]) '  [FirstName]* '[Customers].[FirstName]6 g[Customers].[LastName]5 g[Customers].[ID]/ gCustomers###   G "[ProductCategories].CategoryName? '[ProductCategories].ID5 g"[ProductCategories].CategoryName? gProductCategories333   G([__ID] = OrderID)1 'OrderDetailsPlaceOrder==)   G__ID O  G Customers.FirstName2 ' Customers.LastName1 'Customers.FirstName2 gCustomers.LastName1 gCustomers.ID+ gCustomers###   G [ProductName], '[Products].[ProductName]7 g[Products].[ID]. gProducts!!!   G([__ID] = CustomerID)4 'OrderTotalsCustomerOrderTotalsMM'   G__ID O  G[Orders].[ID], gOrders   G "[ProductCategories].CategoryName? '[ProductCategories].ID5 g"[ProductCategories].CategoryName? gProductCategories333   G([__ID] = CustomerID)4 'CreditCardsAddCreditCardAA'   G__ID O  G  [CardType]) '[CardTypes].[CardType]5 g[CardTypes].[ID]/ gCardTypes###   G%)%O\ M  Lj J Jc HU62G|($E}b^CGv}p/@p/}p/@p/@~sq_cAddCreditCard_Subform~sq_cCardTypeID4MR2KeepLocal Ttttttttr @|4@|4@ShipOrders@BBB66666664 @ t.@t.@AddCreditCard_Subform@XXXLLLLLLLJ @)Y?4@05@ReviewOrderDetails@@^RRFFFFFFFD @yẂ@D&@Products>>>22222220 @@E&@ProductCategories@PPPDDDDDDDB @}u@E&@OrderStatus@DDD88888886 @k@D&@Orders:::......., @>3l@E&@OrderDetailsU @FFF:::::::8 @'#@'#@ MSysNavPaneObjectIDs4MR2KeepLocal  TJJJJJJJH @O@O@ MSysNavPaneGroups4MR2KeepLocal  TDDDDDDDB @@O@ MSysNavPaneGroupCategories4MR2KeepLocal  TVVVVVVVT @L@L@MSysIMEXSpecs<<<<<<<<<<: sM@5N@MSysIMEXColumns@@@@@@@@@@> ;!@WW@ MSysAccessStorageDDDDDDDDDDB 5 {(6$@.6$@Customers|@@@44444442 @0-pT@ -.@CreditCardsJ @DDD88888886 @,v:.@ @CardTypes@@@@44444442 @&^¬@8¬@~sq_fPlaceOrder_Subform4MR2KeepLocal TPPPPPPPN @%@^P4@@^P4@~sq_fPlaceOrder4MR2KeepLocal T@@@@@@@> @#2@2@~sq_fCustomerOrderTotals4MR2KeepLocal TRRRRRRRP @!p/@p/@~sq_fAddCreditCard_Subform4MR2KeepLocal TVVVVVVVT @  /@ /@~sq_fAddCreditCard4MR2KeepLocal TFFFFFFFD @ Kd5@ Kd5@~sq_cShipOrders~sq_cCustomerID4MR2KeepLocal T^^^^^^^\ @B@B@~sq_cProductBrowser~sq_cProductCategoryID4MR2KeepLocal Ttttttttr @^P4@^P4@~sq_cPlaceOrder~sq_cCustomerID4MR2KeepLocal T^^^^^^^\ @^¬@^¬@~sq_cPlaceOrder_Subform~sq_cProductID4MR2KeepLocal Tlllllllj @<ɵ@<ɵ@~sq_cCustomerOrderTotals_Subform~sq_cOrderID4MR2KeepLocal Tzzzzzzzx @0vX(T [  u W !   a 7  y < P  lB L ] )ruitProductsOrderDetailsD@E9! )ruitOrdersOrderDetails Orders.ID=OrderDetails.OrderIDa5 )ruitOrderDetails.OrderID3 g)ruitProducts.Discontinued4 g)ruitProducts.PartNumber2 g)ruitOrderDetails.Quantity4 g)ruitProducts.ProductName3 g)FruitOrderDetails))) )FruitOrders )FruitProducts!!! )Fruit )ruit G( CanceOrders.CustomerID0 '( anceOrders.CustomerID0 g( anceOrderDetails.OrderID3 g( ance[Price]*[Quantity]1 g(anceOrdersOrderDetails Orders.ID=OrderDetails.OrderIDa5 (anceOrders.CustomerID0 g(anceOrderDetails.OrderID3 g(anceTotal[Price]*[Quantity]; o(CanceOrderDetails))) (CanceOrders (Cance (ance G'Orders '  G' ' G&OrderDetails))) &  G& & G%CustomersOrders Customers.ID=Orders.CustomerID[/# %Customers.EmailAddress5 g%Customers.PhoneNumber4 g%Customers.PostalCode3 g%Customers.Country0 g%Customers.State. g%Customers.City- g%Customers.Street/ g% Orders.*' g%Orders %Customers### % % G$Customers### $  G$ Y4*  5 B!@888888888 8 F6H688`BkA_  D;5@c$ o q ( =   g  M cQx3@ {HN 3.@G /@@@TypeInfo:62" 3.@G /@P2L+Blob2.*" 3.@G /@4  w򡧚.@=e2@ 0CB0PropDataIEA1 ~'a.@Ϙe2@ValidationDirDataXTP@ ~'a.@~'a.@ PropDataGC?/ ~'a.@~'a.@0  wd/$@MDh$@[BlobDeltaU0,( w7/a/$@MDh$@XPropDataUPLH8 `/$@MDh$@W @@TypeInfoU:62" `/$@MDh$@VNG+BlobU2.*" `/$@MDh$@U3  wi#@:lɵ@ PropDataPLH8 e#@:lɵ@BlobDelta0,( we#@:lɵ@@@TypeInfo:62" e#@:lɵ@U6C+Blob2.*" e#@:lɵ@2  w1g#@Cɵ@PropDataPLH8 Ag#@fɵ@BlobDelta0,( wAg#@Cɵ@@>TypeInfo:62" Ag#@Cɵ@.A!Blob2.*" Ag#@Cɵ@1  w @I^5@@>PropData:62" Ha@I@ PropDataGC?/ Ha@%5@@@DirData:62" a@ @BlobDelta0,( wa@ @@>TypeInfo:62" a@ @k@?Blob2.*" a@I@0  w{ô@!hô@J@>DirDataCopyB>:" $wô@3ô@ 0CB0 1CB0PropDataCopy\XT<  b@d@ PropDataCopy62. wv@Z1@U"Import-Book2DirData\XTD v@v@T@>BlobS2.*" @v@S0  wzm"@Jz¬@VBA$  wzm"@Jz¬@VBAProject2.* w@@MSysDbDirData PLH8 z@v@ImExSpecs0,( wz@z@CustomGroups62. wz@z@ Blob &" wz@z@ 0   wz@@ Databases0,( wz@z@ DataAccessPages<84 wz@z@ Cmdbars,($ wz@z¬@VBA$  wz@{ p@Scripts,($ wz@Ϙe2@Modules,($ wz@̅ô@Reports,($ wz@I^5@Forms($  wz@zm"@ijPropDataPLH8 z@z@MSysAccessStorage_SCRATCHPLH wz@zm"@MSysAccessStorage_ROOTJFB wQLVAL^  Ggmͬ ʻ.qH~fĂ0FormHeaderd 0Label5d 0Label7d 0Label9d 0Label130Detailo0ProductIDm0Pricem0Quantitym0 Text120 FormFooter0 ID0 OrderID CustomerSignUp*OrderTotals_Subform$SwapTwoTextBoxesCustomersAddCreditCard.AddCreditCard_Subformͬ 3BH~@?p;%0FormHeader0Detailm0Totald 0Label1o0OrderIDd 0Label30FormFooterd 0 TotalWithTax0 CustomerID 3CB0 0CB0 4CB0 5CB0 2CB0 1CB0 6CB0 7CB0 8CB0 11CB0 9CB0ͬxz0@Uo\0Detailm0TextBoxOned 0Label7d 0Label9m0TextBoxTwoh 0SwapButton ProductCatalog"Labels Products<?xml version="1.0" encoding="utf-8" ?> <ImportExportSpecification Path = "C:\Documents and Settings\Faria MacDonald\Desktop\Book2.xlsx" xmlns="urn:www.microsoft.com/office/access/imexspec"> <ImportExcel FirstRowHasNames="true" Destination="xls" Range="Sheet1$" > <Columns PrimaryKey="{Auto}"> <Column Name="Col1" FieldName="IDE" Indexed="YESDUPLICATES" SkipColumn="false" DataType="Double" /> <Column Name="Col2" FieldName="F2" Indexed="NO" SkipColumn="false" DataType="Text" /> <Column Name="Col3" FieldName="F3" Indexed="NO" SkipColumn="false" DataType="Text" /> </Columns> </ImportExcel> </ImportExportSpecification>LVAL:u07=5B>a)b*cLe g j k ala@x i*t֘De ݮͬy . U  @Calibri1D/1<FPd2d# " @Calibri    hg# h%" @Calibri    mfg4i# " @Calibri     oj4l# " @Calibri     *,-8`,  Detailx b%6yMATPm7UF{`6Dabc,; TextBoxOnex  p5JQFɽ\a+.JD/K0L 1M+d5U`6abc,;  Label7 TextBoxOne:x h&CLfי0FormHeaderd 0Label1d 0Label3d 0Label5d 0Label70Detailm0IDo0CustomerIDm0DatePlacedo0 StatusIDh 0 ProcessOrder0 FormFooterg0 Auto_Logo0d 0 Auto_Title00OnHold0CreditCardIDͬTJTDܧ? 0FormHeaderg0Auto_Logo00Detailm0ProductNamed 0Label5m0 Descriptiond 0 Label7m0 Priced 0 Label9m0 UnitsInStockd 0Label11m0UnitsOnOrderd 0Label130FormFooter0Discontinued0PartNumberd 0Auto_Title00IDo0ProductCategoryIDd 0Label17ͬ!lL*K +00FormHeaderg0Auto_Logo0d 0Auto_Title00Detailm0IDd 0Label1o0CustomerIDm0DatePlacedd 0Label5{ 0 Tabs|!0 Products_To_OrderProducts To Orderp0 PlaceOrder_Subform|!0 Customer_InformationCustomer Informationm0 Streetd 0Label27m0Cityd 0Label29m0Stated 0Label30m0Countryd 0Label31m0PostalCoded 0Label32m0PhoneNumberd 0Label33m0Text24d 0Label250FormFooterd 0Label30StatusID0OnHold0CreditCardID0 EmailAddressͬGE@D2Ι0FormHeader0Detailm0IDd 0Label1o0CardTypeIDd 0Label3m0CardHolderd 0Label5m0CardNumberd 0 Label7m0 ExpiryDated 0 Label90 FormFooter0 CustomerIDͬW%H^kJ)#Ch|0FormHeaderg0Auto_Logo0d 0Auto_Title00Detailm0IDd 0Label1m0FirstNamed 0Label3m0LastNamed 0 Label5p0 Child240 FormFooter0 Street0 City0State0Country0PostalCode0PhoneNumber0EmailAddress0Notes0WantsEmailͬN{8ETg )vx0FormHeaderg0Auto_Logo0d 0Auto_Title00Detailm0FirstNamed 0Label3m0LastNamed 0Label5m0Streetd 0 Label7m0 Cityd 0 Label9m0 Stated 0 Label11m0Countryd 0Label13m0PostalCoded 0Label15m0EmailAddressd 0Label19j0WantsEmaild 0Label58d 0Label59m0IDd 0Label610FormFooter0PhoneNumber0Notesͬ]ќJĤS 0FormHeaderg0Auto_Logo0d 0Auto_Title00Detailm0IDd 0Label1m0FirstNamed 0Label3m0LastNamed 0 Label5m0 Countryd 0 Label13p0 Child22d 0 Label230FormFooter0Street0City0State0PostalCode0PhoneNumber0EmailAddress0Notes0WantsEmail CustomerSignUp$SwapTwoTextBoxesAddCreditCard.AddCreditCard_Subform*CustomerOrderTotals:CustomerOrderTotals_SubformPlaceOrder(PlaceOrder_SubformAddProductShipOrders (ReviewOrderDetails LVAL!B:u07=5B>a)b*ce glAg#@x Vpgr@ل"y > UXDB'NJDrZ>4c#@ OrderTotalso(ATXDB'NJDrZ>Total t4H&;xXDB'NJDrZ>OrderIDāHDj leˬ@Orders MM yM*4(āHDj leID  OrderTotalsW "[Event Procedure] @Calibri 8hhhh h h -SdXXLetterPRIV ''''  dArialBRSPL00A.EXEd@ArialdEOSC I%BUSB0011D/1<FPd2d# " @Calibri    g23I6Y75LVAL    mfg4i# " @Calibri     oj4l# " @Calibri     *,-8`,$ FormHeaderx )PaAd`,  Detailx ( Bz9LG-m7U;F{`6a*bc,gkmnpq  Total  Totalx  MGbib+.J/K*0L\ 1Md5U7`6a*bc,gghjk!  Label1  Total:x L;1A\D1@=YQJK*LdMo5U9D{bc6dxef,gZ "";"";"4";"4"x {]CNE.)  OrderID OrderID] Table/Query[ DSELECT [Orders].[ID] FROM Orders;  1440./0126J7Kx8L\ 9Md5U7`6axbc,gghjk!  Label3 OrderID:x #̹)DR. 3JKxLdMd5U6`6atbXc,,e% TotalWithTaxx rNKX=LJKtL M`, FormFooterx =_OvJ\]7LVAL+D:u07=5B>a)b*ce gle#@x YQI*)7y $ U;e@$.6$@g gCustomersVpgr@ل"62@CustomerOrderTotals_SubformXDB'NJDrZ>4c#@{OrderTotals_bB%FXDB'NJDrZ>CustomerIDIL  PNG  IHDR6*Q=gAMA7tEXtSoftwareAdobe ImageReadyqe< IDATxb?p0L@ [ )ϖ/@?P2@ d pPQh>0*[:9`Dǀ1hC 1@Ҍ fx$ X̀ez?[|@ Tb"_p3B!Nj@pSC= a@(Hb'խDfȀpP|,L#`Hd"9)>_s_g@dpAB/R^߿s~]۷or~/Ps @,BMFd (2G!$0; } 6V?llL,X5,0ٌL-#ghl21"#x|d2A_P/66b"wdqrpR1Ѓ`bQF20"bXFMpyx9`ȅ ς?,,,=w/ $`X9##l"Qr#FpakW~ @L4QfDπ  rdW0ʆh! 2b%@?Rci dŦ?|L#rѼB1ER9 ؾçK *h (WM Dא: =&IP 9"Cb>0x CFvQPJV j LA9(l&POeX@c{r{f& y nR b ,Ca< Ky<"%s# 6SLR)7_~ NV}Y @;PhBQKD?rAR5@z !Xw?`7@aMl5\oQµ!uR@0O؂(1 c,yBK W HK !f`fviX?}t6 0<ș _|Py Ԅz ܜ/$c+. )G_ N81zlʭH6I`bϧ/^K4Mo C'W}%W[U)S_AM(~)ul+R14LTP@=ĀSl@>h'-3OWK}{ʍί^k[~@k?acHBg%/تm{M'H Ck2 a = V$*_0J!@=,"ܸG^Z+?/w!0Tihہ$"LEԢ% R;=O_-PJDOG%mc7<\)GRT;RR߉n@#bdrQZ"yu4y/>j [@,Nƭ;|t513C Xu R  (E@g3".<#W= ?zfOm`6|-{yrsr0#[ !EQDia0SSc}u=cX>VPYYYC!bCPc *e= l${w5? @,?fD3Ru/, A=ƀIz@aa6>٫w@IżL/EI^7DA R(bFJaIRRD6/߼gs"@E&H ?_K 2qsb5,9bs?~[A`sHh`0O;ۙQe #g߼}$W9y(@ٿБ?%EXZ<,~x˗P(LVALF>.v8݇be$a u_" V†# p//ۏ& jmzOZ}2)tvA>rs&OF`/;+`+ aXPw@|XI@zd#gMKQA3:.H;sjyp4{,Tj|fw@['@%׃ 4@14lW а@Sñ!IENDB`J+K<LU Md5U7`6a<b c,d#ghjk! Auto_Title0 Customer Totals" @Segoe UIx Yv uE*lO  JK<LM`,(  Detailx Ď4L$eY=m7U;F{`6ahbO c,gmnpq ID IDx J6iMvڑ +.J/Kh0L1Md5U7`6hahbc,gghjk!  Label1 ID:x BL,@IMK JhKhLpMm7U;F{`6abO c,gekmnpq FirstName FirstNamex QcL^#j,J +.J/K0L1Md5U7`6habc,gghjk!  Label3 FirstName:x XԠEP;K' JhKLpMm7U;F{`6abO c,geqkmnpq LastName LastNamex V7C.v +.J/K0L1M3d5U7`6habc,gghjk!  Label5 LastName:x aUKNRXhg JhKLpM3m7U;F{`6a~bO c,gkmO LVAL_ npq Country Countryx VL߈Aa_1C +.J/K~0L1Md5U7`6ha~bc,gghjk! Label13 Country:x x!sA8z4&h JhK~LpMp3U`6ha bc,$ d Child22 @Form.CustomerOrderTotals_Subform1 CustomerID2 IDx kׇHuoVxS JhK LMd5U`6ha$ b c, Label23 FThe order totals for this customer:x ! X׶M AJhK$ LMA `, FormFooterx APpFE,a eLVAL+H:Ru07=5B>a)b*ce g>j+k  :(((Customers.FirstName)="a"))lN@x  (xHE<>sy  U;e@$.6$@=0Customers/x:,Eh U;e@$FirstNameʙ/BNJN*;e@$LastNamec G-g;e@$Street%RnM>  PNG  IHDR6*Q=gAMA7tEXtSoftwareAdobe ImageReadyqe< IDATxb?p0L@ [ )ϖ/@?P2@ d pPQh>0*[:9`Dǀ1hC 1@Ҍ fx$ X̀ez?[|@ Tb"_p3B!Nj@pSC= a@(Hb'խDfȀpP|,L#`Hd"9)>_s_g@dpAB/R^߿s~]۷or~/Ps @,BMFd (2G!$0; } 6V?llL,X5,0ٌL-#ghl21"#x|d2A_P/66b"wdqrpR1Ѓ`bQF20"bXFMpyx9`ȅ ς?,,,=w/ $`X9##l"Qr#FpakW~ @L4QfDπ  rdW0ʆh! 2b%@?Rci dŦ?|L#rѼB1ER9 ؾçK *h (WM Dא: =&IP 9"Cb>0x CFvQPJV j LA9(l&POeX@c{r{f& y nR b ,Ca< Ky<"%s# 6SLR)7_~ NV}Y @;PhBQKD?rAR5@z !Xw?`7@aMl5\oQµ!uR@0O؂(1 c,yBK W HK !f`LVALJfviX?}t6 0<ș _|Py Ԅz ܜ/$c+. )G_ N81zlʭH6I`bϧ/^K4Mo C'W}%W[U)S_AM(~)ul+R14LTP@=ĀSl@>h'-3OWK}{ʍί^k[~@k?acHBg%/تm{M'H Ck2 a = V$*_0J!@=,"ܸG^Z+?/w!0Tihہ$"LEԢ% R;=O_-PJDOG%mc7<\)GRT;RR߉n@#bdrQZ"yu4y/>j [@,Nƭ;|t513C Xu R  (E@g3".<#W= ?zfOm`6|-{yrsr0#[ !EQDia0SSc}u=cX>VPYYYC!bCPc *e= l${w5? @,?fD3Ru/, A=ƀIz@aa6>٫w@IżL/EI^7DA R(bFJaIRRD6/߼gs"@E&H ?_K 2qsb5,9bs?~[A`sHh`0O;ۙQe #g߼}$W9y(@ٿБ?%EXZ<,~x˗P(>.v8݇be$a u_" V†# p//ۏ& jmzOZ}2)tvA>rs&OF`/;+`+ aXPw@|XI@zd#gMKQA3:.H;sjyp4{,Tj|fw@['@%׃ 4@14lW а@Sñ!IENDB`J+K<LU Md57`6a<bc,Wd#ghjk! Auto_Title0 &New Customer Signup" @Segoe UIx %?IoF`c  JK<LM`,  Detailx  7CRK5){ m7U;F{`6pa b c,Jmnpq FirstName FirstNamex N3̻.D )_/ +.Jp/K 0L'1MVd5U7`6,a bc,Jghjk!  Label3 First Name:x ^YrN.JT1j J,K L4MVm7U;F{`6pab c,gkmnpq LastName LastNamex m턚tN#H +.Jp/K0L'1Md5U7`6,abc,gghjk!  LaLVALKbel5 Last Name:x T5K J,KL4Mm7U;F{`6paDb c,gkmnpq  Street  Streetx 9$BB,,-R+.Jp/KD0L'1Md5U7`6,aDbc,gghjk!  Label7 Street:x %Hx *J,KDL4Mm7U;F{`6pab c,gkmnpq City Cityx mf4%EΜu+.Jp/K0L'1M] d5U7`6,abc,gghjk!  Label9  City:x q6VL  jJ,KL4M] m7U;F{`6pa b c,gkmnpq  State  Statex 3Ή{5A}+.Jp/K 0L'1M d5U7`6,a bc,gghjk! Label11  State:x Q-ݟF8ARJ,K L4M m7U;F{`6paZ b c,gkmnpq Country Countryx /I;B_T A+.Jp/KZ 0L'1M d5U7`6,aZ bc,gghjk! Label13 Country:x ջ9NE=J,KZ L4M m7U;F{`6paLVAL b c,gkmnpq PostalCode PostalCodex a)b*ce gj+k  l3.@x 8K@DAi|y  U;e@$.6$@CustomersNvI7U.Y/@AddCreditCard_Subform]2K-:gDD -.@qCreditCards5 AI]2]2K-:gDDCustomerIDIL  PNG  IHDR6*Q=gAMA7tEXtSoftwareAdobe ImageReadyqe< IDATxb?p0L@ [ )ϖ/@?P2@ d pPQh>0*[:9`Dǀ1hC 1@Ҍ fx$ X̀ez?[|@ Tb"_p3B!Nj@pSC= a@(Hb'խDfȀpP|,L#`Hd"9)>_s_g@dpAB/R^߿s~]۷or~/Ps @,BMFd (2G!$0; } 6V?llL,X5,0ٌL-#ghl21"#x|d2A_P/66b"wdqrpR1Ѓ`bQF20"bXFMpyx9`ȅ ς?,,,=w/ $`X9##l"Qr#FpakW~ @L4QfDπ  rdW0ʆh! 2b%@?Rci dŦ?|L#rѼB1ER9 ؾçK *h (WM Dא: =&IP 9"Cb>0x CFvQPJV j LA9(l&POeX@c{r{f& y nR b ,Ca< Ky<"%s# 6SLR)7_~ NV}Y @;PhBQKD?rAR5@z !Xw?`7@aMl5\oQµ!uR@0O؂(1 c,yBK W HK !f`fviX?}t6 0<ș _|Py Ԅz ܜ/$c+. )G_ N81zlʭH6I`bϧ/^K4Mo C'W}%W[U)S_AM(~)ul+R14LTP@=ĀSl@>h'-3OWK}{ʍί^k[~@k?acHBg%/تm{M'H Ck2 a = V$*_0J!@=,"ܸG^Z+?/w!0Tihہ$"LEԢ% R;=O_-PJDOG%mc7<\)GRT;RR߉n@#bdrQZ"yu4y/>j [@,Nƭ;|t513C Xu R  (E@g3".<#W= ?zfOm`6|-{yrsr0#[ !EQDia0SSc}u=cX>VPYYYC!bCPc *e= l${w5? @,?fD3RLVALOu/, A=ƀIz@aa6>٫w@IżL/EI^7DA R(bFJaIRRD6/߼gs"@E&H ?_K 2qsb5,9bs?~[A`sHh`0O;ۙQe #g߼}$W9y(@ٿБ?%EXZ<,~x˗P(>.v8݇be$a u_" V†# p//ۏ& jmzOZ}2)tvA>rs&OF`/;+`+ aXPw@|XI@zd#gMKQA3:.H;sjyp4{,Tj|fw@['@%׃ 4@14lW а@Sñ!IENDB`J+K<LU Md5U7`6a<b c,d#ghjk! Auto_Title0  Add Credit Cards" @Segoe UIx  /C   JK<L#MW`,  Detailx OO ˍm7U;F{`6pab c,gmnpq ID IDx kH[K0{Jn +.Jp/K0Ls1MWd5U7`6,abc,gghjk!  Label1 ID:x l^Dv!GZ J,KL4MWm7U;F{`6pab c,gekmnpq FirstName FirstNamex dPIC݄ +.Jp/K0Ls1M d5U7`6,abc,gghjk!  Label3 First Name:x 2!IIsj!c J,KL4M m7U;F{`6paTb c,geqkmnpq LastName LastNamex +cICWS +.Jp/KT0Ls1Md5U7`6,aTbc,gghjk!  Label5 Last Name:x xwֈ;CnzqU0^T LVALd  J,KTL4Mp3U`6,abGc,@ d Child24 4Form.AddCreditCard_Subform1 CustomerID2 IDx ?)ijdMS6J,KLsM`, FormFooterx d WȳAoT}O<;.c0[q  v 1 > y  [  h3>68Ndzx¬@z¬@ @pAQHMNHJWRPAYPDQJNRZSBYMISPHHb^Z" x¬@z¬@ q+RNCEOKHQQHZOPDLRDCYJKQZBYYCDb^Z" kx¬@z¬@ @pHEMYUDIKRWCIPDZHOAIS_RMNAJPCb^Z" kx¬@z¬@ Un+UICKJULOAGHSYDOZEMJKHUYOBTPGb^Z" kx¬@z¬@ 2@mEPFLRSHPEBQZYDERLSOUHOMYKDAMb^Z" GSx¬@z¬@ @mFGGHZAJORMKOVDKHJYYO_SFSKFGHb^Z" GSx¬@z¬@ @lDTBCFMDGCVGQTDTMGHXOLBZHDHHKb^Z" GSx¬@z¬@ @kKIYKZBJBJSAOVDSVJHWVGMRTWDHLb^Z" ޘw¬@z¬@ v @jEZPRKQCRUNXQFEZSIWIENSGBUZD_b^Z" ?r¬@z¬@ @iSIMZCAEBAMBKBEHUAQZTDCBEEYBNb^Z" r¬@z¬@  AcessVBADataNJF. 4&5@vʵ@ PropData GC?/ `$5@vʵ@ BlobDelta 0,( w`$5@vʵ@ A@@TypeInfo :62" `$5@vʵ@ 6e+Blob 2.*" `$5@vʵ@ 9  w4@Р˵@ BlobDelta 0,( w|4@˵@ PropData PLH8 |4@˵@ C@@TypeInfo :62" |4@˵@ $>a+Blob 2.*" |4@˵@ 11" wp 3@ȵ@ BlobDelta 0,( wv3@ȵ@ PropData PLH8 v3@ȵ@ @@TypeInfo :62" v3@ȵ@ ?]+Blob 2.*" v3@ȵ@ 8  w@2@~¬@R BlobDeltaE 0,( w=2@~¬@H PropDataE PLH8 =2@~¬@G @>TypeInfoE :62" =2@~¬@F *Z+BlobE 2.*" =2@~¬@E 7  w*2@¬@@ BlobDelta3 0,( w`!2@¬@6 PropData3 PLH8 "!2@¬@5 @@TypeInfo3 :62" "!2@¬@4 sYT+Blob3 2.*" "!2@¬@3 6  w]d2@^d2@ ValidationDirDataCopy`\X@ J]d2@;C^d2@ @>DirDataCopyB>:" @Y.@~Y.@; 3CB0 1CB0 0CB0 2CB0 4CB0PropDataCopy}yu] .@KD0@ PropDataGC?/ Ԕ.@KD0@BlobDelta0,( wt.@KD0@@@TypeInfo:62" t.@gKD0@,Q+Blob2.*" t.@gKD0@5  w.@G /@ PropDataGC?/ 3.@G /@BlobDelta0,( wLVAL+R:u07=5B>a)b*che g h6IiB jk VlԔ.@x NvI7Uy 8 U]2K-:gDD -.@pCreditCards̐2F]96.]2K-:gDDID 2kJSi]2K-:gDDCardTypeIDv:GrAp<f.@j2 4CardTypessR`gCA=!v:GrApa)b*ce g#l23@x =` "Bl#agy x U;e@$.6$@CustomersāHDj le۹@a 4Ordersc G-g;e@$Street%RnM> |JFIFC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Pk"6!1QAa"qBR#23b$!A"1QB ?XA-$]QxǨ5=fr׫IVyjtH:Nki{IQ^-3_ezvI1$`Ev)-qӺu&<8׃+:m\Eq ܏i_,&2.0#U$βjhFP%Xx ŽTCb}RP״V#>$aPtbUf<1A~XP{Ne`hcT;ǑU`gcio|h! FČ]%:i&'@3CcQykTF#<]BIHhVS"}M,,|jP?L>}$2}7\Ը0|)x?P};b2k? eU!g/s?[suL+6=M>|3O0QLVALW%~G9w1"*W>|j۬q3lsL[J j'c%{)7wRrǹ*6ϗ큸hF zBcKƳ84IRE vdGF*͇&GpZ=kww*\M4͛i0Ni71Oߞ< 1#Vj(_#G!#QefŷPKm"8ې{UylcbG\<ԅ#m$M/xmOV2C2ϧ@-]]r tH8=u/t.ĦʩA $g|ev{>%+۸SF5|vu.+\jΰ6+G# k;@<1s9J$E[bdqv}fxy@͉8\?3QSγn<\ Ճ䝸6IGM&ם6\JDē.6'i"3wqooof Fy;k sr0v9:TJ.(9#x3[8n0{UrO wL[υUҹ ` ;NƞVYUeq`FA1r g:͈?8!j9n33ZCҽBN6(fu|T:(ڧzz r _q«0M$3 S80[Ȁ.N-ozdxU'1aJ! lS ikNa $ 8N'AAX3]M"6 rWr *ίw&.!ꘐ$q3#fh Ҫ`a)b*c,e g{ "[Event Procedure]} "[Event Procedure]l됛9l@x ?dAFLÇN_y 0 U#_~I9Rt۹@>OrderDetailsWIw8[#_~I9RtProductIDjMNeLq۹@Q|xProducts `0G0Y| $jMNeLqIDjKeNYDK~jMNeLqProductNameX}#H ?D#_~I9RtPriceN3 MJJ>mgL#_~I9RtQuantityHKI419?dAFLÇN_Quantitye@ea?dAFLÇN_Price  OrderDetailsW "[Event Procedure]V "[Event Procedure] @Calibri 8hhhh h h -SdXXLetterPRIV ''''  dArialBRSPL00A.EXEd@ArialdEOSC I%BUSB0011D/1<Fd2d# " @CalibriLVAL\    mfg4i# " @Calibri     oj4l# " @Calibri     *,-8`,\ FormHeaderx mK@'٢d25U`6hab2 c,ghjk\  Label5 ProductIDx |(ZZF L    JhKL Md25U7`6 abc,ghjk\  Label7  Pricex ?OCpp    J KLwMd25U7`6abc,ghjk\  Label9 Quantityx "}i@̦2   JKLMd25U`6abc,ghjk\ Label13 Line Totalx ~C9Cm   JKLmM`,  Detailx Atd,A!#yoC3I5UD{`Fbc6hd%e2 f,h" Z ,"";"";"";"";"10";"100"x JA Lϲ*W ProductID ProductID] Table/Query[ SELECT [Products].[ID], [Products].[ProductName] FROM Products ORDLVALER BY [ProductName];   0;1440r "[Event Procedure]x "[Event Procedure]Y "SELECT [Products].[ID], [Products].[ProductName] FROM Products ORDER BY [ProductName]; ";"Products";"";"ID";"ProductName";"PrimaryKey"  ./0126Jh7K%8L 9Mm85I7UF{`6 a%bc,kmnpq  Price  Price& *$#,##0.00;($#,##0.00)x e@ea  +.J /K%0Lw1Mm5I7UF{`6a%bc,kmnpq Quantity Quantityx HKI419  +.J/K%0L1Mm5I7UF{`6a%c,kmnpq  Text12 L=Format([Quantity]*[Price],"Currency")x 1T# K&Nn^  +.J/K%0Lm1M`, FormFooterx 0ݐC_) LVAL+^Z>:Ru08=5B>a)b*ce gh6 i j k  lSr@x ͻwEܙHy  UjMNeLqˬ@g gProductsjKeNYDK~jMNeLqProductNameJ(?` rjMNeLqDescriptionX.|G"T[MjMNeLqPrice+`|6A!jMNeLqUnitsInStock;RF&jMNeLqUnitsOnOrderѾMICi.jMNeLqProductCategoryID(e5[oM[ऻ^ˬ@ProductCategoriesadM(e5[oM[ऻ^CategoryName$-L4z(e5[oM[ऻ^ID  ProductsM "[Event Procedure] @Calibri 8hhhh h h -SdXXLetterPRIV ''''  dArialBRSPL00A.EXEd@ArialdEOSC I%BUSB001 "[Event Procedure]1D/1<LVAL_Fd2d# " @Calibri    j1g4h5    mfg4i# " @Calibri     oj4l# " @Calibri     *,-8p    `,\ FormHeaderx e%(aTDIqZqgb(c,\ Auto_Logo0 chocolate.jpgx N=-[OD     > JFIFC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;dh"5!1AQ"aq2B#$CRSb!!1A"Qa ?( ( ( (ß//>U??ctjMDK/ſt~Fͅ-޴VInYzl{j(PM*BI_ҧΟhF(qHUt{K6,$q`$<Y,(BW*]~m6jk)8Gg9/1.~y-%[ĸl dl:Tk Cq!$I5eD{O< :c\NfcoC @[`{fhTjtH`a7 NYį<6çxl&CyH)}v {q.`*M*km!NIJE|a12I89 %d:*5Ԫ4E_]7)O=$6\H!oҙ>)nsg/+Kfo Cbn;dt! o98Uv20#XGɂ<0uA|.l&u3qxgOcEk.ћ+#WUb:MeY^;Ķ^-H"`T^/o5C0> rA* [kDθqٷtښ{1$w&ZU71,rMl*qWၐsUd&qRn.uεU3F%sE2cY3cT\_\u0#fl ҧ%K b?zœ9\,qFq-9FUrr0irΠ籨p\$I!]Nuސ!lzo/ -Ig!;wjآ `v *zrLVAL`˦I>9ɏ*K#9W]E' OR)%> 9:g(Z9&#(̎˦F#E0չx`8z.َV_VkY}{}j+39TR$ 09pp=4dcVM,E|LhQ\3Gxc{ 3)浫@2:t'VX`yAhTaңA#$zQh{$1ib )؍?N۠ fjJ2 skMu=OsЊƕGjgҺXsH;R2yNkC1edIR1Ҋ6V_3e#'J5\9c"9fxoV\fI#“lh"KCBrf#*+z,54QE(L( Md5U678`6a,bz c,vd#ghjk Auto_Title0 New Product" @Cambriax 3 D/K7"  JK,L M`,  Detailx 5`\iK(m7U;F{`6Cabc,Jkmnpq ProductName ProductNamex {(FYհl +.JC/K0LD1Md5U7`6abc,Jghjk\  Label5 Product Name:x #l@ .nG6 JKLMm7U;F{`6Ca7bc,kmnpq Description Descriptionx ɡMglD +.JC/K70LD1M d5U7`6a7bc,ghjk\  Label7 Description:x f hkH9 JK7LM m7U;F{`6Ca^ bc,gkmnpq  Price  Pricex ` lG|n +.JC/K^ 0LD1M d5U7`6a^ bc,gghjk\  Label9  Price:x ̟bE;+A? JK^ LM mLVAL7U;F{`6Ca bc,gkmnpq UnitsInStock UnitsInStockx \a)b*c8"e g K *[Orders].[DatePlaced]l[u@x Cѩ{Kٱy  UāHDj leˬ@g gOrders"%M 2.āHDj leDatePlaced MM yM*4(āHDj leID_bB%FāHDj leCustomerID;e@$.6$@a 4CustomersIL JFIFC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;fh"8!1AQq"a2B#3RCbr)!1ABaq2QR ?-+;Ght)>fGj:'rIOK8{{[XGw=qRj#t3BH#AUEf_$쯉EsOZ5u!b #֛R4r{_e@~ͧ8_OgȘUH9hTdoQ^j+X>+=WT|~E7cikY{O ʻ_3HwG81 V5 cjNg#)6.W)1$R,z2|ү.|((kJ<(,~9Q<G=͞$; * aFH\l7~6Ex6ǫ;9vh 2șy[Szff\Rz*^ERHX14/zfP ewg'OkMYG5Cvq pCq>x墌ZV{kFmUTU5NYdwasT\,$܏!銱ڑLq?M[iD UKn>~Owo"@;I9S;g;#K~0KjT` ^|#!9\8֥˛9BA\+KxY'}:UD aIrj~ir̍<HATL7t%` A:ZmWM0XV-l(cOʺP@:#e׹f2!h:D ֊y)~0W"g~Q^5coZW}chNAc=+MBRxd }cncIm]2;=F(X/}nrÝݓ*=3=FC$1tC.zv۹6FKsB;۫-:FINs^ڄפ*ۃT};54u֩ e 1k䢘+e}yy+Emi-ihьbT=p]}43 󧡥V^.=xMĦW QaKg S^O&.޽&r%] ۗf.㹵p\pI <C^vf`Ahݑ|ԏW^-x}3ڳ"ET$P8W cֳzu-6kAZYVn+Gzm,s>6mLVALd{yҥAf5$I;F3tڽ{\U, PO+Þ>DM`8BQ" g#kI @ǖH g /<iz\E MmtK3ml MVeDi qMQ@4QQS@J.T O֞0 0kkLi>C sZgţZwM/;* CustomerID CustomerID] Table/Query[ SELECT [Customers].[ID], [Customers].[LastName], [Customers].[FirstName] FROM Customers ORDER BY [FirstName], [LastName];  0;1440;1440Y P"SELECT [Customers].[ID], [Customers].[LastName], [Customers].[FirstName] FROM Customers ORDER BY [FirstName], [LastName]; ";"Customers";"";"ID";"LastName";"PrimaryKey"  ./0126J7K%8L$9Mnm85I7UF{`6ha%c,Ikmnpq DatePlaced DatePlaced& Medium Datex URהKmť9  +.Jh/K%0L1MnoC83I5UD{`Fbc6Sd%ef,InZ ,"";"";"";"";"10";"510"x  AUDkGLq0! StatusID StatusID] Table/Query[ SELECT [OrderStatus].[ID], [OrderStatus].[Status] FROM OrderStatus;   0;1440Y "SELECT [OrderStatus].[ID], [OrderStatus].[Status] FROM OrderStatus; ";"OrderStatus";"";"ID";"Status";"PrimaryKey"  ./0126JS7K%8L<9Mnh1U4`6b8c,i ProcessOrder Process~ "[Event Procedure]x 6t@wQS!%J'L!(M`, FormFooterx )rr8 a$/:FSu7=5B>a)b*cxe g h6 i j k  OrderID=1ln.5@x "EKk:kuy  UFBDO05@CgReviewOrderDetails t4H&;xFBDOOrderIDjKeNYDK~FBDOProductNameN3 MJJ>mgLFBDOQuantity]<&WLb!FBDOPartNumberv5FC8FBDODiscontinued  $ReviewOrderDetails @Calibri 8hhhh h h -SdXXLetterPRIV ''''  dArialBRSPL00A.EXEd@ArialdEOSC I%BUSB0011D/1<FPd2d# " @CalibriLVALg    g23I6Y75    hg# h%" @Calibri    j1g4h5    mfg4i# " @Calibri     `, FormHeaderx j<gKC C"g26Y75b Auto_Logo0 package.jpgx H1 (@[ > JFIFC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;fh"8!1AQq"a2B#3RCbr)!1ABaq2QR ?-+;Ght)>fGj:'rIOK8{{[XGw=qRj#t3BH#AUEf_$쯉EsOZ5u!b #֛R4r{_e@~ͧ8_OgȘUH9hTdoQ^j+X>+=WT|~E7cikY{O ʻ_3HwG81 V5 cjNg#)6.W)1$R,z2|ү.|((kJ<(,~9Q<G=͞$; * aFH\l7~6Ex6ǫ;9vh 2șy[Szff\Rz*^ERHX14/zfP ewg'OkMYG5Cvq pCq>x墌ZV{kFmUTU5NYdwasT\,$܏!銱ڑLq?M[iD UKn>~Owo"@;I9S;g;#K~0KjT` ^|#!9\8֥˛9BA\+KxY'}:UD aIrj~ir̍<HATL7t%` A:ZmWM0XV-l(cOʺP@:#e׹f2!h:D ֊y)~0W"g~Q^5coZW}chNAc=+MBRxd }cncIm]2;=F(X/}nrÝݓ*=3=FC$1tC.zv۹6FKsB;۫-:FINs^ڄפ*ۃT};54u֩ e 1k䢘+e}yy+Emi-ihьbT=p]}43 󧡥V^.=xMĦW QaKg S^O&.޽&r%] ۗf.㹵p\pI <C^vf`Ahݑ|ԏW^-x}3ڳ"ET$P8W cֳzu-6kAZYVn+Gzm,s>6m{yҥAf5$I;F3tڽLVALh{\U, PO+Þ>DM`8BQ" g#kI @ǖH g /<iz\E MmtK3ml MVeDi qMQ@4QQS@J.T O֞0 0kkLi>C sZgţZwM/; !%J&K<'L(MLVAL #;3~xME (S<S<S<<N0{7A78F78C-91EF-4030-A0C6-55DA6F9B005C}  @ X%pXX " <  ` .p B xp]@5 Copy the text from the first text box for later use. !'' Change the text in the first text box. ! (< Change the text in the second text box, using the variable.  (oAttribute VB_Name = "Form_SwapTwoTextBox es" Bas0{7A78F78C-91EF-4030-A0C6-55DA6F9B005C} |Global!SpacIFalse dCreatablTru Predecl2aId"Ex0pose_TemplateDerivCust0omizD$Option Com2p@ DT  @ /i@@B @D @F @H `J 2 B   B`h  Fp 0  (  @ Ph  x 8 6 $   ( .0`h  ,p  . 2  0@ :H xp< This is the running total (created using Luhn's algorithm).invali]`'B? This keeps track of whether you're at an odd or even position.) You start on an odd number position (1).]x'D] F @] @ F$'H D Double the digit. H'H H  1 If this number is two digits, add them together. 0 This is the wacky part, because you need to use  string conversion functions.] H'J J$$L J$N$L 'Hkk% Add the number to the running total. B H 'B( Switch from odd to even or even to odd.+ This line of code changes True to False or False to True D'D4 If the sum is divisible by 10, it's a valid number. B '>dP'>k@i80:Attribute VB_Name = "Validation" Op Compare Da@tabase`Explicit FuncZeCard(Number As Sng)   ' This the running total (created usLuhn's algor@ithm).BDim SumOfDigits0rkeeps track of whe@@r you'tat an odd or even` posin:' You start onnt (1ROdd9edERTruniFDiLen@) To 1ep -1 Current8' &MiIh, 0i, 1@g If (Falsel enpDouble pdaH1 * 2G >= 10 t]wo a s, ao$mgBw%Awy t, becau9 netofsB convers@ fĿsb`0TextG; 9= J>I D= (Left(Ao) +RighEnd Ifi#' A' D+@ ;*tkm+ Switch fromm ?mnod vlineucode changes f@< cSor kYNot[nN4W' $ZsumadivisiA]byRet!| vA$% S)!Mod!X= XiqGEm#!Be7a LVALK3xME (S<S<S<<N0{6C1FA500-1E4C-4B2A-8B0C-CCC82B30A9B4}8(%H xpݰAttribute VB_Name = "Form_PlaceOrder" Bas0{6C1FA500-1E4C-4B2A-8B0C-CCC82B30A9B4} |GlobdalSppFalse dCre atabliTru PredecdlaIdB"E`xpose_TemplateDerivCus`tomizD$Option Codmp@ DT  $+3xME (S<S<S<<N0{C98E859A-A747-4515-A640-441432EFAECE} R@i2`%h`` "    0PfX  :  (8xpT` @ <%>Your card is valid.A@: ad( Your card is invalid. 7Did you forget a number, or are you trying to cheat us?A@: Y'2k0|(T 0Oops. Does your credit card number have letters?A@:'2o;Attribute VB_Name = "Form_AddCreditCard_SubfT"  Basb0{C98E859A-A747-4515-A640-441432EFAECE} |GlobalvSpacIFalse d atablTr u PeclaId"Expose_TemplateDerivCustomizD$Option Comp@ DT  , 3Mtry2 to cheat us?AE = CwEnd IfGExitAV J H:C.Oops. DoesA&@=@?C' have letter"!@!t LVAL+o| 3xME (S<S<S<<N0{BBCA7F8C-712E-48CC-8A7E-E7AB66FEC482} Z@ ^ `ib d  n`*ipir@t % A "8 "@Hh " px ". "  08N@ < <    8 2H $  H  B(P  Dx .    F(<p    xp PlaceOrder$$B@\o@@ PlaceOrder$$B@\o PlaceOrder$$B@\o` f$8G|jPriceProductsID= f$j'h'lo * Show a Yes/No message and get the result.]%Do you want to add a new product for p? v$:'t5 Visual Basic gives you hand vbYes and vbNo constants6 that you can use to find out what button was clicked.x t x Cancel the edit. fB@z+ Tell Access not to show the error message. You've already dealt with it. |'rdHB Tell Access not to worry, because you're adding the missing item. ~'r; Open the AddProduct form, with three additional arguments. AddProduct  p B@= Cancel the edit. That's because you need to refresh the list' before you can select the new product. fB@z Refresh the list. fB@? Now find the ProductID for the newly added item using DLookup.IDProducts ProductName=' p'$j'f Refresh the price.A@dk oAttribute VB_Name = "Form_PlaceOrder_Sub"fH" Bas0{BBCA7F8C-712E-48CC-8A7E-E7AB66FEC482} |GlobalsSpjxFalse dCreatabliTru PredeclaIdB"Expose_TemplateDerivCustomizD$Option Comp@ DT  b >a\=a' CancelB'edi'a5 .UndoTe@ll Acc0 no /o LVALsA3!0errore3c You'v5ldy deal0ith ?= DacaCErrftin!#E C worry, Nb |' ;'rddingmissaitemxAddG c#O>pi`D&Dm, w!thre@AargumentsHDoCmd.! a "G J , #`!ialo?cN : }at's neIrefeh!lq)be]eOsexlecCl(bhER Requery MN}b^!,F q!@lyu8d!:$ }ID+g$ ='!}|'"z#?pA X3U qfIfg LVAL DK3xME (S<S<S<<N0{7C5ED4A2-6B1E-40EC-84F8-9FFCF857F3CF} @  %H@ "  0 *@p  "  *8 P &hxp Close this form. B@B'$ Switch back to the ShipOrders form. ShipOrders B@ Update the order. ShipOrders$$(  B@o(@ Close this form. B@B o$ Switch back to the ShipOrders form.n. ShipOrders B@ Update the order. The StatusID for Shipped is 4.de ShipOrders$$('  B@ Go80ʱAttribute VB_Name = "Form_ReviewOrderDetails" Bas0{7C5ED4A2-6B1E-40EC-84F8-9FFCF857F3CF} |GlobalsSpacI False dCr@eatablTru PredeclaId"Expose_Template DerivCustomizD$Option Comp@ DT    < Pp\x    6 8 H  P h x   .     ( @Pxp B@ '  B@ReviewOrderDetails OrderID =  B@A@ e`Already taken.A@:d@Not available.A@:k o@> If an error occurs, jump down to the DataAccessError section. Create a SELECT command.];SELECT ProductID, Quantity FROM OrderDetails WHERE OrderID= '$ Get a recordset using this command.]  %.4 Move through the recordset, looking at each record.- Each record is a separate item in the order. !a8 For each item, get the product ID and quantity details.] ProductID$'fQuantity$'l6 Using this information, create an UPDATE command that changes the stock levels.] 0UPDATE Products SET UnitsInStock = UnitsInStock- l WHERE ID= f' Run the command.  B@/ Move to the next order item (if there is one). B@ Time to clean up. B@B B@B|ph' You only get here if an error occured. Show the error. !A@: Try to clean up.Recordset.CloseCurrentDb.Closeo̴Attribute VB_Name = "Form_ShipOrders" Bas0{1E26683E-43B9-4CA0-8581-F89566E11CD7} |GlobalSpacI False dCr@eatablTru PredeclaId"Expose_Template DerivCustomizD$Option Comp@ DT  .: Not av@%f @:If E\_9]Do#A[C' $an error occurs, jump down to theBvAclE (secA~.On GoTo  A/' Be a SELECT c omdDim Query|" ductID,@ antity FROM e@ WHEREI D=IeC' Ge)K rsusing8iscD;SF`CurrentDb.;E&(bZMove rougheG, lookat eacFhD"' Eg aa semaiite'LVAL7m i4@4YDere)o U@$l f.EOFC#2[# , g=proa- Z Afqu-de_ A603g %$"V"$ Q =(."%U7infaR, ca Mn UPDATvEE;/a a' changes2ck levelsLfD" s]T1itsInStoU =-T_ G[& "YX&&'' kjTExecܴ UAcnext K M(ifA reQpone)%M!N  #Loop#a' Ticlean up G ClףCExit dȕ:gYou onlyb]hef\ ed' Sh|owbQdWO.DescripA'CS0 r[o , vRResu@4'8]LVAL+tam  *\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\Office12\MSACC.OLB#Microsoft Access 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINNT\system32\stdole2.tlb#OLE Automation:*\G{4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}#c.0#0#C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL#Microsoft Office 12.0 Access database engine Object Library  F 3 8SIMZCAEBAMBKBEHUAQZTDCBEEYBN0146cea612*Form_SwapTwoTextBoxes~A8EZPRKQCRUNXQFEZSIWIENSGBUZD_0246cea612@Form_CustomerOrderTotals_SubformQ)8KIYKZBJBJSAOVDSVJHWVGMRTWDHL0346cea612/&Form_CustomerSignUpTF08DTBCFMDGCVGQTDTMGHXOLBZHDHHK0446cea612<Validation6Hu 8FGGHZAJORMKOVDKHJYYO_SFSKFGH0546cea612Q4Form_AddCreditCard_Subform`8EPFLRSHPEBQZYDERLSOUHOMYKDAM0646cea612WForm_PlaceOrderxQ8UICKJULOAGHSYDOZEMJKHUYOBTPG0746cea612Y.Form_PlaceOrder_Subform 8HEMYUDIKRWCIPDZHOAIS_RMNAJPC0846cea612Form_AddProduct08RNCEOKHQQHZOPDLRDCYJKQZBYYCD0946cea612Form_ShipOrders 8AQHMNHJWRPAYPDQJNRZSBYMISPHH0:46cea612.Form_ReviewOrderDetails0x`H̏eDŎROIP@J9zxF\DӺ6F*A~rN}I^`2AccessVBAWin16~Win32MacVBA6# BoutiqueFudge˓stdole`DAOForm_SwapTwoTextBoxes6 _EvaluateSwapButton_Click#| TextContentF TextBoxOneValueK TextBoxTwo Form_CustomerOrderTotals_Subform  Form_CurrentCountryFormsTaxRateg TotalWithTax;#CaptionxTotalUForm_CustomerSignUprKForm_BeforeUpdateP-Cancel WantsEmailm EmailAddressuIsNullMsgBoxR Validation  ValidateCard CardNumber SumOfDigits Od} LVAL dNumberedi` CurrentNumber NumberTextn:ValRight Form_AddCreditCard_SubformCardNumber_BeforeUpdateFErrorHandlingCodelForm_PlaceOrder[Form_PlaceOrder_SubformgForm_AfterInsertwRecalcӬForm_AfterUpdateForm_AfterDelConfirmStatus+ProductID_Change* ProductIDvPricegDLookupFQuantityProductID_NotInListNewDatax_Response ButtonClickedvbYesNovbNo%UndoÞacDataErrContinueDacDataErrAddedDoCmdƧOpenFormacDialogaRequeryForm_AddProduct Form_Load{ ProductNameFormOpenArgsBForm_ShipOrders|ProcessOrder_ClickǪRefreshStatusID޼ RunCommand`acCmdSaveRecord>ID]DoUpdateDataAccessErroriQuery% Recordset CurrentDbS OpenRecordset|EOF UpdateCommandFExecuteYMoveNextL!Erro Description Form_ReviewOrderDetailsm( Cancel_Click Ship_ClickY/=  QW;h Ry¬@z¬@ m@vPROJECT840" y¬@z¬@ u@vPROJECTwm<84" x¬@z¬@ @vdir0,(" x¬@z¬@ Ws+_VBA_PROJECTB>:"  LVAL !ID="{09AF1F42-9382-4468-ABF2-97838BE05E48}" DocClass=Form_SwapTwoTextBoxes/&H00000000 DocClass=Form_CustomerOrderTotals_Subform/&H00000000 DocClass=Form_CustomerSignUp/&H00000000 Module=Validation DocClass=Form_AddCreditCard_Subform/&H00000000 DocClass=Form_PlaceOrder/&H00000000 DocClass=Form_PlaceOrder_Subform/&H00000000 DocClass=Form_AddProduct/&H00000000 DocClass=Form_ShipOrders/&H00000000 DocClass=Form_ReviewOrderDetails/&H00000000 Name="BoutiqueFudge" HelpContextID="0" VersionCompatible32="393222000" CMG="1A18CACCEAD0EAD0EAD0EAD0" DPB="3E3CEE2836685B695B695B" GC="6260B214D715D71528" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_SwapTwoTextBoxes=22, 29, 309, 272, C Form_CustomerOrderTotals_Subform=66, 87, 353, 330, C Form_CustomerSignUp=22, 29, 309, 272, C Validation=110, 145, 728, 630, C Form_AddCreditCard_Subform=154, 203, 772, 688, C Form_PlaceOrder=154, 203, 841, 688, C Form_PlaceOrder_Subform=0, 0, 687, 485, C Form_AddProduct=0, 0, 0, 0, C Form_ShipOrders=22, 29, 709, 514, Z Form_ReviewOrderDetails=66, 87, 753, 572, Form_SwapTwoTextBoxesForm_SwapTwoTextBoxesForm_CustomerOrderTotals_SubformForm_CustomerOrderTotals_SubformForm_CustomerSignUpForm_CustomerSignUpValidationValidationForm_AddCreditCard_SubformForm_AddCreditCard_SubformForm_PlaceOrderForm_PlaceOrderForm_PlaceOrder_SubformForm_PlaceOrder_SubformForm_AddProductForm_AddProductForm_ShipOrdersForm_ShipOrdersForm_ReviewOrderDetailsForm_ReviewOrderDetails0* pHd Boutique@Fudge@T@ = +x F J< rstdole>std@olerf%\*\G{00020430-;C 0046}#2.0#0#C:\WINNT\system32\c2.tlb#OLE AutomatioFn/DAO>IDAjO@ @4AC9E1DA- 5BAD-7-86E3-24F4CDCECA28}#c@PROGRA~1\COMMONMICROSOFFICE12\ACE9.DLL#Microsoft Office 1e Access database engine Object LibraryOE 3 Form_SwapTwoTextBox`esG* rm_Sw@apToQ@exaBxAas SIMZCAEBAMBKBEHUAQZTDCBEE@YBN28AIMZC@OEB@M@KEHUQ@TD@BE@jYNB@j1A@B,4~"(Bb+B 9CusterOrderTotals_Subf@GBF;Cuo@?er@zrAjTtBlEu0bf CAEZPRKQCRUNXQFEZSIWIENSGBUZD_CAE8PRPKQ9R=NTXF;ZZIDWIENGu?U D@aXKAS@MAQ)QAMASignUpG&0_# >SiPgn@p=2@PBP DPFPHPOYiOJmJ=OYiOJmJMdfvPfidfOJmJ=fidfOJmJMdfvPOYiOJmJMdfv=fidfOJmJMdfv=6=.OYiOJmJ=0OYiOJmJMdfvP fidfOJmJ=1fidfOJmJMdfv=JMQkkqLJOJmJP#qLJfid[QMm= 6=  OYiOJmJ= L^dL= 6=OYiOJmJ=fid[QMmufid[QMms`uqLJ=+qLJ+fid[QMmuJhW`bW[sifJvfOh[bixkLv`YkfWWP-OYiuOmLMS`OUMqUhmOm`UWud^LxWOWW\P'QfS^ikWfQLhxvOQi^kdoWd`v\OJ`P)Qxfi\hMiobuhSQxkYsYQbkULoxO+P%SUUWxJ[di`\dqO\W[vvd+kSk\SUWP(WQ`voOY\isMYfOxWdJYk+i`bJ[fMP+\Yv\xL[L[kJdqOkq[WsqU`imsOW^P&ibMQd\WhhWxdfO^iOMv[\hxLvvMOP,kY`xMJQLJ`L\LQWoJhxmOMLQQvLbP$oYM\[o^dJUWkvOdxQ`[\WovdLmfUP*SL^dL=L^dL=L^dLOQ^mJ=fidfOJmJ=mvfQYbSd=L^dL= L^dLOQ^mJ="fidfOJmJ=#mvfQYbSd=!L^dL=%L^dLOQ^mJ='fidfOJmJ=(mvfQYbSd=&UL^dL=*UL^dLOQ^mJ=-UfidfOJmJ=,UmvfQYbSd=+fidfOJmJ=/L^dL=3L^dLOQ^mJPfidfOJmJPmvfQYbSd=4L^dLPL^dLOQ^mJPfidfOJmJPmvfQYbSdP 3L^dLP  3L^dLOQ^mJP 3fidfOJmJP  3mvfQYbSdP  EL^dLP EL^dLOQ^mJP EfidfOJmJP EmvfQYbSdP L^dLP L^dLOQ^mJP fidfOJmJP mvfQYbSdP L^dLP L^dLOQ^mJP fidfOJmJP mvfQYbSdP L^dLP L^dLOQ^mJP! fidfOJmJP" mvfQYbSdP S YN{{Y  \ Y Y   Y , Y , Y Id LValueObjectGuidObjectNameProperty Value,,,{,,,{,,,{,YYYId$ObjectGuidProperty$ObjectNameProperty{Hv1bpLVAL@}<xml xmlns:x="urn:schemas-microsoft-com:office:excel"> <x:PivotTable> <x:OWCVersion>12.0.0.4017 </x:OWCVersion> <x:NoDisplayToolbar/> <x:DisplayScreenTips/> <x:NoAutoFit/> <x:Height>537</x:Height> <x:Width>512</x:Width> <x:CubeProvider>msolap.2</x:CubeProvider> <x:DisplayFieldList/> <x:FieldListTop>208</x:FieldListTop> <x:FieldListLeft>836</x:FieldListLeft> <x:FieldListBottom>579</x:FieldListBottom> <x:FieldListRight>1036</x:FieldListRight> <x:CacheDetails/> <x:Name>Microsoft Office PivotTable 10.0</x:Name> <x:PivotField> <x:Name>ID</x:Name> <x:DataType>Integer</x:DataType> <x:EncodedType>adInteger</x:EncodedType> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> <x:NoDisplayInFieldList/> </x:PivotField> <x:PivotField> <x:Name>CategoryID</x:Name> <x:DataType>Integer</x:DataType> <x:Orientation>Row</x:Orientation> <x:EncodedType>adInteger</x:EncodedType> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> <x:Expanded/> </x:PivotField> <x:PivotField> <x:Name>ProductName</x:Name> <x:Orientation>Column</x:Orientation> <x:EncodedType>adLongVarWChar</x:EncodedType> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> <x:Expanded/> </x:PivotField> <x:PivotField> <x:Name>Description</x:Name> <x:EncodedType>adLongVarWChar</x:EncodedType> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Price</x:Name> <x:DataType>Number</x:DataType> <x:PLDataOrientation/> <x:EncodedType>adCurrency</x:EncodedType> <x:NumberFormat>Currency</x:NumberFormat> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>UnitsInStock</x:Name> <x:DataType>Integer</x:DataType> <x:PLDataOrientation/> <x:PLPosition>2</x:PLPosition> <x:EncodedType>adInteger</x:EncodedType> <x:CompareOrderedMembLVAL~ersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>UnitsOnOrder</x:Name> <x:DataType>Integer</x:DataType> <x:PLDataOrientation/> <x:PLPosition>3</x:PLPosition> <x:EncodedType>adInteger</x:EncodedType> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Discontinued</x:Name> <x:EncodedType>adBoolean</x:EncodedType> <x:NumberFormat>Yes/No</x:NumberFormat> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Data</x:Name> <x:Orientation>Column</x:Orientation> <x:Position>-1</x:Position> <x:DataField/> </x:PivotField> <x:PivotField> <x:Name>Sum of Price</x:Name> <x:PLName>Total1</x:PLName> <x:TotalNumber>0</x:TotalNumber> <x:Orientation>Data</x:Orientation> <x:Position>1</x:Position> <x:ParentField>Price</x:ParentField> <x:NumberFormat>Currency</x:NumberFormat> </x:PivotField> <x:PivotField> <x:Name>Average of Price</x:Name> <x:PLName>Total2</x:PLName> <x:TotalNumber>1</x:TotalNumber> <x:Orientation>Data</x:Orientation> <x:Position>2</x:Position> <x:ParentField>Price</x:ParentField> <x:NumberFormat>Currency</x:NumberFormat> <x:Function>Avg</x:Function> </x:PivotField> <x:PivotField> <x:Name>Sum of Price (2)</x:Name> <x:PLName>Total4</x:PLName> <x:TotalNumber>2</x:TotalNumber> <x:Orientation>Data</x:Orientation> <x:Position>3</x:Position> <x:ParentField>Price</x:ParentField> <x:NumberFormat>Currency</x:NumberFormat> </x:PivotField> <x:PivotData> <x:Top>0.0</x:Top> <x:TopOffset>0</x:TopOffset> <x:Left>0.0</x:Left> <x:LeftOffset>0</x:LeftOffset> <x:SeqNum>1</x:SeqNum> <x:Expanded/> </x:PivotData> <x:PivotView> <x:IsNotFiltered/> <x:Label> <x:Caption>Microsoft Office PivotTable 10.0</x:Caption> <x:NotVisible/> </x:Label> <x:AllowEdits>fLVALalse</x:AllowEdits> <x:AllowAdditions>false</x:AllowAdditions> <x:AllowDeletions>false</x:AllowDeletions> </x:PivotView> </x:PivotTable> </xml>4zF