Standard ACE DBnb` Ugr@?~1y0̝cßFNb7,ݜ(b/`% {6߱mC63Ey[,|*|&ө\f_Љ$g'DeFx -bT4.0;dv@ Y>S >> Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName        OY S  =Y Y Y  Y 2ACMFInheritableObjectIdSID wQ  YObjectId YS  Y  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order Y"ObjectIdAttribute   -YS  Y Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationship v1b N  : k & `p`v@@%@@   @ @ @  @  Si`Mokmd`QikSi`diOQiQbmivSkoLdiOQiQbmivMokmd`QidiOQikJO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k`dOo^QkiQ^JmYdbkWYfkiQfdimkkMiYfmkkvkiQ^mJL^Qk+kh+MSi`diOQiQbmiv+kh+MMokmd`QiYO +kh+MSi`diOQiQbmiv+kh+MQ`f^dvQQYO!+kh+MSi`diOQiQbmiv+kh+MSkoLdiOQiQbmiv"+kh+SSi`Mokmd`Qik#+kh+SSi`diOQiQbmiv$+kh+SSkoLdiOQiQbmiv%+kh+iMokmd`QidiOQik&Mokmd`Qik'OQ^QmQd^OQ`f^dvQQk(Q`f^dvQQk)SYbOOof^YMJmQMokmd`Qik6`kvkJMMQkkkmdiJUQ6`kvkJMQk`kvkMd`fJMmQiidi6`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 `kvkbJqfJbQUidofMJmQUdiYQk6`kvkbJqfJbQUidofk6`kvkbJqfJbQUidofmddL[QMmk6`kvkbJqfJbQdL[QMmYOk6`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkdiOQiOQmJY^k6diOQik6fidOoMmk6hkQ^Mokmd`QidiOQik6 kQ^QMmMokmd`Qik6 ofOJmQfidOoMmfiYMQk6 JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO`kvkJMMQkkkmdiJUQkmUiQ^6iQSQiQbMQ6iQSQiQbMQ86iQSQiQbMQ:6mL^Q`f^dvQQkmL^diOQik6mL^diOQikmL^diOQiOQmJY^k6mL^fidOoMmkmL^diOQiOQmJY^k6  @ @ @ @ @ @ @ @      !"#$%&(66 6 6 666666 6     !#%','1)86N6R6W6\6_6f6m66v1 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @))) )!)#)$)%)&)')()))*)/)0)1)2)3)4)5)6)7)8)9):)B)C )D )E )F )G )H )I )J )K )L )M )N )O )P w wwwwwwwww w w w w wwwwwwwwwwwwww!w"w#{ { { {{{{{{{{{{{{{{{{{{ {!{"{#{${%{& {' {( {)w:w;w<w(w)w=w>w?w@{{)) ))) ))) ))) )))))))!)!)!)#)#)#)%)%)%)') ')'),w,w,w1w1w1w 8w$8w%8w&8w'Nw*Nw+Nw,Nw-Rw.Rw/Rw0Rw1Ww2Ww3Ww4Ww5\w6\w7\w8\w9_{_{_{f{f{f{m{m{ m{ {);)<)=)>)")+),)-).)?)@)Av1i @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ ********* * * ** ***** ************** *!*"*#*$*%*&*'*(*)***+*, *- *. */ *0 *1*2*3*4*5*6*7*8*9*:*;*<*=**>*@*A*B*C*D*E*?*F*H*I*J*K*L7777 7 7 7 7 77 7 7 7 7  7 7 7*G77777777777777 7  7! 7" 7# 7$7%7&7'7(7)7*7+7,7-7.7/70771737475767778797:7;7<7= 7> 7? s s ssssss72ss s s s s v1@t @@`kvkJMMQkkkmdiJUQkmUiQ^iQSQiQbMQiQSQiQbMQ8iQSQiQbMQ:mL^Q`f^dvQQkmL^diOQikmL^diOQikmL^diOQiOQmJY^kmL^fidOoMmkmL^diOQiOQmJY^k @`kvkJMMQkkkmdiJUQdiOQiOQmJY^kdiOQiOQmJY^kdiOQiOQmJY^kdiOQikdiOQikdiOQik  Mokmd`QikQ`f^dvQQkQ`f^dvQQk`kvkJMMQkkkmdiJUQdiOQikfidOoMmkfidOoMmkG*d Oc L p ) Y & CF~EC0BA1{R0.@{R0.1{R0.@{R0.@Employ1(,-@l*:@Employees^@v@@@44444442 @QD%-@5!*:@ Delete Old Employees@v|@xbVVJJJJJJJH @,y-@D-@Customersy5@@@44444442 @6qH%-@qH%-@~sq_ffsubOrderEntry4MR2KeepLocal THHHHHHHF @6Jv"-@Jv"-@~sq_ffrmCustomers4MR2KeepLocal TDDDDDDDB @L%-@L%-@~sq_cfrmOrderEntry~sq_cfsubOrderEntry4MR2KeepLocal Tlllllllj @6:,I%-@^jI%-@~sq_cfrmOrderEntry~sq_cCustomerID4MR2KeepLocal Tdddddddb @  !-@pTF*:@Admin@x8,,,,,,,,,*  6 CyG%-@CyG%-@fsubOrderEntry@uJJJ>>>>>>>< @ nB%-@nB%-@frmOrderEntry@uHHH<<<<<<<: @ "-@"-@frmCustomers8@uFFF:::::::8 @ +-@+-@UserDefinedA@uDDD88888886 @ +-@+-@SummaryInfol@uDDD88888886 @ wl-@<,p@AccessLayout4MR2KeepLocal T.@tzz:::::::8 @+-@+-@SysRel.........., Y+-@Y+-@Scripts0000000000. Y+-@Y+-@Reports0000000000. Y+-@Y+-@Modules0000000000. Y+-@Y+-@Forms,,,,,,,,,,* +-@+-@DataAccessPages@@@@@@@@@@> '4R0.@4R0.@MSysComplexType_AttachmentTTTTTTTTTTT %4R0.@5R0.@MSysComplexType_TextHHHHHHHHHHH #4R0.@5R0.@MSysComplexType_DecimalNNNNNNNNNNN !4R0.@5R0.@MSysComplexType_GUIDHHHHHHHHHHH 4R0.@5R0.@MSysComplexType_IEEEDoubleTTTTTTTTTTT 4R0.@5R0.@MSysComplexType_IEEESingleTTTTTTTTTTT 4R0.@5R0.@MSysComplexType_LongHHHHHHHHHHH 4R0.@5R0.@MSysComplexType_ShortJJJJJJJJJJJ 4R0.@5R0.@MSysComplexType_UnsignedByteXXXXXXXXXXX 4R0.@4R0.@MSysComplexColumnsDDDDDDDDDDD 1*-@1*-@MSysRelationships DDDDDDDDDDB 1*-@1*-@MSysQueries 88888888886 1*-@1*-@MSysACEs 22222222220 1*-@1*-@MSysObjects 88888888886 61*-@1*-@Relationships <<<<<<<<<<: 1*-@1*-@Databases 44444444442 1*-@1*-@Tables .........., D YN Y Y  Y Y Y ColumnNameComplexID&ComplexTypeObjectID"ConceptualTableIDFlatTableIDYYY(IdxConceptualTableIDIdxFlatTableID IdxIDv1@    fYw@nNY  ValuedvfYw@nNY  ValuedvfYw@nNY  ValuedvfYw@nNY  ValuedvfYw@nN  Y  ValuedvfYw@nN""Y  ValuedvfYw@nN$$Y@n ValuedvfYw@nN&& Y @n ValuedvaYN(( Y Y  Y Y  Y  Y FileDataFileFlagsFileNameFileTimeStampFileTypeFileURL((((Hv1bQQ{hUBT f x   v c P = *   T A .   ~kX n[H!^K8%uaN;'      7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp       7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp       7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp       7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp      7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp      7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp    7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp      7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp      7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp  ' % # !       ' )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp % )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp # )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp ! )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp  )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp  )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp  )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp  )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp  )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp  )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp ' % # !       MG: z \  i 3  m O  w M  d _$e `'g&^rT6R( w9[CustomerID]+ g[CustomerCompany]0 g[CustomerLastName]1 g[CustomerFirstName]2 gtblCustomers)))   GH@+ 'Employees.[Last Name]4 g Employees.** gEmployees###  G G  GOrdersOrder DetailsX@+C7 ProductsOrder Detailsd@+G;! EmployeesOrdersX@+;/# CustomersOrdersX@+;/# Orders.[Order ID]0 gCustomers.[Customer ID]6 gEmployees.[Last Name]4 gEmployees.[First Name]5 g[Order Details].Quantity7 gProducts.Price- gProducts.Size, gProducts.[Product Name]6 g Orders.[Ship Date]1 g Orders.[Order Date]2 g Customers.[Email Address]8 g Customers.[Fax Number]5 g Customers.[Phone Number]7 gCustomers.Zip, gCustomers.State. gCustomers.City- gCustomers.[Address 2]4 gCustomers.[Street Address]9 gCustomers.[Company Name]7 gCustomers.[Last Name]4 gCustomers.[First Name]5 gOrder Details+++ Products!!! Orders Customers### Employees###   GtblOrderDetails///   G  GWtblOrders###  W GW W GWtblCustomers)))  W GW W GW([__OrderID] = OrderID)6 'WtblOrderDetailsfrmOrderEntryII/  W GW__OrderID### OW W G J<B@+ g J<D@+ g J<[tblEmployees].[EmployeeID]: g J<tblEmployees)))  J<  J< G4B@+ g4D@+ g4[tblCustomers].[CustomerID]: g4tblCustomers))) 4 4 GLVALz6D @  l  d L(((Customers.[Company Name]) Like "A*"))Products.[Product ID]=[Order Details].[Product ID]Products.[Product ID]=[Order Details].[Product ID]Orders.[Order ID]=[Order Details].[Order ID]Employees.[Employee ID]=Orders.[Employee ID]Employees.[Employee ID]=Orders.[Employee ID]Customers.[Customer ID]=Orders.[Customer ID]Products!Price*[Order Details]!Quantity[CustomerFirstName] In (SELECT [CustomerFirstName] FROM [tblCustomers] As Tmp GROUP BY [CustomerFirstName],[CustomerLastName],[CustomerCompany] HAVING Count(*)>1 And [CustomerLastName] = [tblCustomers].[CustomerLastName] And [CustomerCompany] = [tblCustomers].[CustomerCompany])(((Employees.[Last Name])="Gumman"))Orders.[Order ID]=[Order Details].[Order ID]Products.[Product ID]=[Order Details].[Product ID]Employees.[Employee ID]=Orders.[Employee ID]Customers.[Customer ID]=Orders.[Customer ID][tblEmployees].[EmployeeLastName][tblEmployees].[EmployeeFirstName][tblCustomers].[CustomerLastName][tblCustomers].[CustomerFirstName] IY N --Y  Y d Y d Y d Y d Y d Y d Y  d Y  Y  d Y  d Y  tdCustomer IDFirst NameLast NameCompany NameStreet AddressAddress 2City StateZipPhone NumberFax NumberEmail Address-/Cte-0YYCustomerIDPrimaryKeyv1@@b ,b1  | AmyPrestonPreston Publishing1214 North Ave.Suite 18RedmondWA9804942555561134255557441amy@prestonpub.comocWPLC9(   LucyRedmanBBC Express Inc.94 Pulaski Rd.Suite 221St. LouisMO6312631455599673145552159l.redman@bbc-c-inc.comocWPLA6&   KlausHoffmeister87 Towson Rd.BaltimoreMD2121241055536454105559984WWK?84))   AdrianMcKinneyAdrian's Wholesale35546 York Ave.Unit LNovatoCA9494541555532324155557487adrian@adrianwhlsl.compdXQME=,  JaneDoeBlue Star Vending224 Main St.MiamiFL3316230555525463055557787djoe@blue--star.comq\PD=922$   JohnSmithACME Corp.123 First St.Suite 111Ft. LauderdaleFL3333095455512129545552121j.smith@acmecorp.coml`TMI9.   , @..... . , @..... .FYN22Y  Y d Y dEmployee IDFirst NameLast Name2425YYEmployeeIDPrimaryKeyv1 1StephanieBelmontNormanMcDonaldJeffTracy 13331333$q  x  a o IA2PۅR0.@ۅR0.@MSysCompactErrorBBBBBBBBBB@  b"-@b"-@tblProductstblOrderDetailsVVVVVVVVVVT Cg!-@Cg!-@tblOrderstblOrderDetailsRRRRRRRRRRP !-@!-@tblEmployeestblOrdersLLLLLLLLLLJ j%-@j%-@Reference266666666664 \R%-@\R%-@Reference166666666664 X -@X -@Reference44444444442 E@E@MSysAccessStorageSTGRELPPPPPPPPPPN v'@v'@~sq_rCustomer Orders4MR2KeepLocal TJJJJJJJH @^jI%-@I%-@~sq_ffrmOrderEntry4MR2KeepLocal TFFFFFFFD @H%-@:,I%-@~sq_cfrmOrderEntry~sq_cEmployeeID4MR2KeepLocal Tdddddddb @ t3l&-@t3l&-@Customer Orders$MR2 GUIDNameMapppp@@@@@@@> @1*-@oCN.@MSysDbd@:::......., @%-@9-*:@0Update Product Pricesf@~|@dXXLLLLLLLJ @ O$-@VV*:@Select Customers@|@ZNNBBBBBBB@ @n&+&-@S<*:@qselCustomerOrders' @@^RRFFFFFFFD @m:J)-@nt*:@Products @~>>>22222220 @fc{& -@q*:@Orders @}:::......., @_-@Ho*:@Order DetailsE @|HHH<<<<<<<: @\:6$ R0.@ܽR0.@l\@Jdir0,(" R0.@ܽR0.@kI @J_VBA_PROJECTB>:" R0.@ܽR0.@j AcessVBADataNJF. !8nv'@!8nv'@CImExSpecs0,( w>@tU?N.@2BlobDelta0,( wz@z@+DataAccessPages<84 wz@z@*CustomGroups62. wE@z@)MSysDbDirData&PLH8 E@z@(Blob'&" wE@z@'0&  wE@z@&Databases0,( wE@!8nv'@%jiPropDataPLH8 E@E@$Scripts,($ wE@z@# 1CB0PropDataIEA1 E@z@"("Customer OrdersDirDatab^ZJ E@tU?N.@!@TypeInfo:62" E@PcU?N.@ PropDataPLH8 E@tU?N.@v?!Blob2.*" E@PcU?N.@1  wE@z@Reports,($ wE@E@Modules,($ wE@E@Cmdbars,($ wE@q,nv'@% 1CB0 0CB0 3CB0PropData _[WG E@z@d@=DirData :62" E@z@PropDataCopyXTP8 E@z@@=TypeInfo:62" E@z@PropDataPLH8 E@z@l@?Blob2.*" E@z@3   wE@z@h@?TypeInfo:62" E@z@PropDataPLH8 E@z@@>Blob2.*" E@z@1   wE@z@@=TypeInfo :62" E@z@PropData PLH8 E@z@ @;Blob 2.*" E@z@ 0   wE@q,nv'@ Forms($  wE@;N.@VBA$  wE@;N.@VBAProject2.* wE@;N.@VBA$  wE@E@MSysAccessStorage_SCRATCHPLH wE@!8nv'@MSysAccessStorage_ROOTJFB wLVAL<087=Babche g!V((tblCustomers.CustomerLastName="Preston")) %"-@,dTCz]LF Ul1ؔ*I"VA -@tblCustomersB3ɳOj鸬Yl1ؔ*I"VCustomerFirstName,KAQGV'l1ؔ*I"VCustomerLastName2}L0/l1ؔ*I"VCustomerCompany<~N3CMivl1ؔ*I"VCustomerShipStreet1Z,LD }l1ؔ*I"VCustomerShipCity `dN]c`Ql1ؔ*I"VCustomerShipState/CJ<͗,l1ؔ*I"VCustomerShipZIPvg量rGHriql1ؔ*I"VCustomerBillStreet1%UA`&Hl1ؔ*I"VCustomerBillStreet2Q+aNAB mPl1ؔ*I"VCustomerBillCityvQEB[l1ؔ*I"VCustomerBillState?@1Vkrl1ؔ*I"VCustomerBillZIP]b@nt\l1ؔ*I"VCustomerPhoneނUCf#Ol1ؔ*I"VCustomerFax^L/l1ؔ*I"VCustomerEmailN ($C8{l1ؔ*I"VCustomerShipStreet2tblCustomersfrmCustomers Ariald2e12f5g237hghMS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zijMS Sans Serif{5`FormHeaderz=FU;m` DetailRI_M?`yDm7U`<abce "CustomerFirstName"CustomerFirstName*Customer's First Name-VPCF+&Uemd5U`<axbc.CustomerFirstName_LabelFirst Name؛쬣L.F.m7U` abce k CustomerLastName CustomerLastName(Customer's Last Name2]~¢NNyd5U` axbc,CustomerLastName_LabelLast Name4HpҿMJA^m7U`abce kCustomerCompanyCustomerCompany}m7U`Dabce k&CustomerBillStLVALreet2&CustomerBillStreet2JCustomer's Billing Address - Street 24cS@;d5U7`abc2CustomerBillStreet2_Label Street Address 21\3@'!m7U`Dapbce k CustomerBillCity CustomerBillCityBCustomer's Billing Address - Citylw>C@,Hd5U7`apbc,CustomerBillCity_LabelCityHAdbm7U`Da bce k "CustomerBillState"CustomerBillStateDCustomer's Billing Address - StateD܄A1(A.d5U7`a bc.CustomerBillState_Label State"rMY_m7U`Da@ bce k CustomerBillZIPCustomerBillZIP@Customer's Billing Address - ZIP.vO ]m7W`aDbk&CustomerShipStreet2&CustomerShipStreet2LCustomer's Shipping Address - Street 2xXSMFCZd5]7`<aDbEcLabel30 Street Address 2W6> I  (d5U`abc,Label31 Shipping Address²8A(7g[d5U`DabchLabel32Billing Address0>)SNBOE%`FormFooterMG=D=u f}! LVAL  frmCustomersfrmOrderEntry fsubOrderEntryͬ &{jBހcDetailFormHeaderFormFooteroProductIDd ProductID_LabelmQuantityd Quantity_LabelOrderDetailIDOrderIDͬ&DUODetailFormHeaderFormFootermCustomerFirstNamed CustomerFirstName_LabelmCustomerLastNamed CustomerLastName_LabelmCustomerCompanyd CustomerCompany_Labelm CustomerShipStreet1m CustomerShipCityd CustomerShipCity_Labelm CustomerShipStated CustomerShipState_LabelmCustomerShipZIPd CustomerShipZIP_LabelmCustomerBillStreet1d CustomerBillStreet1_LabelmCustomerBillStreet2d CustomerBillStreet2_LabelmCustomerBillCityd CustomerBillCity_LabelmCustomerBillStated CustomerBillState_LabelmCustomerBillZIPd CustomerBillZIP_LabelmCustomerPhoned CustomerPhone_LabelmCustomerFaxd CustomerFax_LabelmCustomerEmaild CustomerEmail_Label!CustomerIDd CustomerStreet1_Labelm"CustomerShipStreet2d #Label30d $Label31d %Label32 LVAL008=Babche g nB%-@HIJج:\ Uq΅C;6d6R%-@tblOrdersO>q΅C;6dOrderID[m/&M25 q΅C;6dOrderDateOOlZtKdjq΅C;6dCustomerIDl1ؔ*I"VA -@08tblCustomersNfi.F?+vl1ؔ*I"VCustomerIDB3ɳOj鸬Yl1ؔ*I"VCustomerFirstName,KAQGV'l1ؔ*I"VCustomerLastName3']cwKvUk\q΅C;6dEmployeeIDeDeUr/d%-@08tblEmployeesoV\@L.V]eDeUr/EmployeeID aEty\eDeUr/EmployeeFirstNamekw8͈G"eDeUr/EmployeeLastNamehFGIdAXhq΅C;6dShipDate5H>DW0G%-@΅Ca0fsubOrderEntry`{lAJ^`$x%-@F5HtblOrderDetails ":"EL]*Ȋ^^|`{lAJ^`OrderIDtblOrdersfrmOrderEntry Ariald2e12f5g237hghMS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zijMS Sans Serif{5`FormHeadernuOK4KݔwJ` Detail-u&bXDeixm7U`axceOrderIDOrderID.Generic Order ID NumberSvE4( d5U`<axbcOrderID_LabelOrderIDC{Ͼgm7U`ab9ce9kOrderDateOrderDateShort Date2Date the order was placed;MݣEQ`@d5U`<abcOrderDate_LabelOrderDatevQ8897HxMHNo5U`b@ cdHe fh n8"";"";"";"";"";"";"10";"100"FhM8KCustomerIDCustomerIDTable/QuerySELECT [tblCustomers].[CustomerID], [tblCustomers].[CustomerFirstName], [tblCustomers].[CustomerLastName] FROM tblCustomers; 0;1440;1440\ID Number of the Customer who placed the orderd5U`<aHbc CustomerID_LabelCustomerID@B4hL?4jVo5U`b@ cde fh n8"";"";"";"";"";"";"10";"100"=DKYCUqEmployeeIDEmployeeIDTable/QuerySELECT [tblEmployees].[EmployeeID], [tblEmployees].[EmployeeFirstName], [tblEmployees].[EmployeeLastName] FROM tblEmployees; 0;1440;1440XID Number of the Employee who took the orderd5U`<abc EmployeeID_LabelEmployeeID YKy?Բm7U`ab9ce9kShipDateShipDateShort Date4Date the order was shippedHD񄊷?]d5U`<abcShipDate_LabelShipDate х:ɧA)8p3W`<a4bcdfsubOrderEntry&Form.fsubOrderEntryOrderIDOrderID_pY/G@l{Նud5]`<aDbec(fsubOrderEntry_LabelfsubOrderEntryrdK'Mw,^`FormFooterT@oF8ڽ~LVAL,08=Babc> e gCyG%-@5H>DW0 U`{lAJ^`$x%-@tblOrderDetailsf!AvDBr+]j`{lAJ^`ProductIDU!KH,E2fש -@0. -tblProducts,P#YKrpU!KH,E2ProductIDW‰G[p~U!KH,E2ProductNamebGl$U!KH,E2ProductSize"D0}F>Xm`{lAJ^`QuantitytblOrderDetailsfsubOrderEntry Ariald2e12f5g237hghMS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zijMS Sans Serif{5`hFormHeaderK=sFBػcd5U7`<a<b cProductID_LabelProductIDDetachedLabel_V + B'Pd5U7`~ a<bcQuantity_LabelQuantityDetachedLabel `>KAt 0`w Detail5PMGGo5U`b@ c<d<e fh 8"";"";"";"";"";"";"10";"100"-O#Ii2YfProductIDProductIDTable/QuerySELECT [tblProducts].[ProductID], [tblProducts].[ProductName], [tblProducts].[ProductSize] FROM tblProducts; 0;1440;1440RProduct Number this record corresponds toN"SELECT [tblProducts].[ProductID], [tblProducts].[ProductName], [tblProducts].[ProductSize] FROM tblProducts; ";"tblProducts";"";"ProductID";"ProductName";"PrimaryKey"m7U`~ a<bcekQuantityQuantity>Quantity of the product orderedRXa)b*c2e g@h6ij+k !?l\7@x Cq IZT1y  UeDeUr/l*:@Employeesl1ؔ*I"VD-@aMkCustomersq΅C;6dq*:@aMkOrdersU!KH,E2nt*:@aMkProducts`{lAJ^`Ho*:@aMkOrder DetailsB3ɳOj鸬Yl1ؔ*I"VFirst Name,KAQGV'l1ؔ*I"VLast Name2}L0/l1ؔ*I"VCompany Name<~N3CMivl1ؔ*I"VStreet AddressN ($C8{l1ؔ*I"VAddress 2Z,LD }l1ؔ*I"VCity `dN]c`Ql1ؔ*I"VState/CJ<͗,l1ؔ*I"VZip]b@nt\l1ؔ*I"VPhone NumberނUCf#Ol1ؔ*I"VFax Number^L/l1ؔ*I"VEmail Address[m/&M25 q΅C;6dOrder DatehFGIdAXhq΅C;6dShip DateW‰G[p~U!KH,E2Product NamebGl$U!KH,E2Size $!Io/'-U!KH,E2Price"D0}F>Xm`{lAJ^`Quantity aEty\eDeUr/First Namekw8͈G"eDeUr/Last NameNfi.F?+vl1ؔ*I"VCustomer IDO>q΅C;6dOrder IDOOlZtKdjq΅C;6dCustomer IDoV\@L.V]eDeUr/Employee ID3']cwKvUk\q΅C;6dEmployee ID,P#YKrpU!KH,E2Product IDf!AvDBr+]j`{lAJ^`Product ID ":"EL]*Ȋ^^|`{lAJ^`Order ID`0)oO}qYsCq IZT1CustomerCompany  SELECT Customers.[First Name], Customers.[Last Name], Customers.[Company Name], Customers.[Street Address], Customers.[Address 2], Customers.City, Customers.State, Customers.Zip, Customers.[Phone Number], Customers.[Fax Number], Customers.[Email Address], Orders.[Order Date], Orders.[Ship Date], Products.[Product Name], Products.Size, Products.Price, [Order Details].Quantity, Employees.[First Name], Employees.[Last Name], Customers.[Customer ID], Orders.[Order ID] FROM (Employees INNER JOIN (Customers INNER JOIN Orders ON Customers.[Customer ID]=Orders.[Customer ID]) ON Employees.[Employee ID]=Orders.[Employee ID]) INNER JOIN (Products INNER JOIN [Order Details] ON Products.[Product ID]=[Order Details].[Product ID]) ON Orders.[Order ID]=[Order Details].[Order ID];  "LVALBrptCustomerOrders @ Arial 82h X odXXLetterDINU"L r SMTJMicrosoft XPS Document WriterInputBinFORMSOURCERESDLLUniresDLLInterleavingOFFImageTypeJPEGMedOrientationPORTRAITCollateOFFResolutionOption1PaperSizeLETTERColorMode24bpp MXDW K1XPSPort:nt WriterXPSPort1D1Fd27d# e%" @ Arial    e24     g3I75    jg4h5    mf5I<Ci# " @Times New Roman     n7=Ij# " @Times New Roman     o3I:Al# " @Times New Roman     p4I    r5ILVALC     Company Name Customer ID Order ID Product NameK`,) ReportHeaderx c2 y׿E/rd2`6<a<bc,Xd#e% Label49 Customer Ordersx hO6KHbcfa<b2  Line52x 2O%G    faZb2  Line53x ^C@/pKA    fab2  Line54x ?`b uH\f>    fab2  Line55x F`8ODH)[    `, "PageHeaderSectionx c{?Jx21HK`,  GroupHeader0x }!{"C<m0G<"`6| a<bc,i#j% CustomerCompany Company Name <Name of the Customer's Company" @ Arialx `0)oO}qYs+d`6<a<b c,d# *CustomerCompany_Label Companyx  E?KK`, a GroupHeader2x  _A `A m:<"`6<ab4c,i#  "CustomerFirstName ,Customers.[First Name] *Customer's First Name" @ Arialx > G )8+d6`6<a<b,c, .CustomerFirstNLVALDame_Label Customer Namex  QWED*m:<"`6abc,i# k  CustomerLastName *Customers.[Last Name] (Customer's Last Name" @ Arialx 1BNBtr +m:<"`6`a<bc,i# k &CustomerShipStreet1 Street Address LCustomer's Shipping Address - Street 1" @ Arialx h>;"GB7 R+d6`6a<bac, 2CustomerShipStreet1_Label  Streetx OoXG3TUm:<"`6`abc,i# k &CustomerShipStreet2 Address 2 LCustomer's Shipping Address - Street 2" @ Arialx Ou8]>GduFz`+m:<"`6`abc,i# k  CustomerShipCity City DCustomer's Shipping Address - City" @ Arialx zzVB?}7d7`6Cab(c,e% $ProductPrice_Label ProductPrice  DetachedLabelx >- HHdxy.d7`6abc,e% Quantity_Label Quantity  DetachedLabelx +*`o@? f2 `6Tab  Line56  DetachedLabelx  MStLyԍѡ    f2 `6Tab  Line57  DetachedLabelx =pARPMB-    f2 `6Ta(b  Line58  DetachedLabelx khh^qE[:    f2 `6Tab  Line59  DetachedLabelx  $K7wU    eb2c,  Box61x r$wx˻QF}vbK`,  Detailx nnq Ey+Fgm<"`6Ta<b c,Je%i#  ProductName Product Name &Name of the Product" @ Arialx )6"C8Y+m<"`LVALG6Xa<bc,Ji# k ProductSize Size :Size of the Product in ounces" @ Arialx PD C>+#<+m0G<"`6Ca<b(c,Ji# k ProductPrice  Price& *$#,##0.00;($#,##0.00) 6Retail Price of the Product" @ Arialx 8hJΆr+m<"`6a<bc,Ji# k Quantity Quantity >Quantity of the product ordered" @ Arialx qնGO"Y+K`,a GroupFooter5x  UvDR" bm<"C`6bH0i#  Text34  ="Summary for " & "'Order ID' = " & " " & [Order ID] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"" @ Arialx IB9U+d`6abc,d#e% Label35 Sumx 9X}%DHnpm0G<"C`6Cab(c,i#k &Sum Of ProductPrice =Sum([Price])& *$#,##0.00;($#,##0.00)" @ Arial &Sum_Of_ProductPricex *%Irsb+f`6bH0  Line60x ŰMKDO$$    K`,a GroupFooter3x % DжBYm<"C`6,b81i#  Text24 ="Summary for " & "'Customer ID' = " & " " & [Customer ID] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"" @ Arialx xOi/J3b+d`6,abc,d#e% Label25 Sumx WG^m0G<"C`6Cab(c,i#k (Sum Of ProductPrice1 =Sum([Price])& *$#,##0.00;($#,##0.LVALH00)" @ Arial (Sum_Of_ProductPrice1x -N]CNP"P+K0`, GroupFooter1x S 8F,`Sm<"C`6<b(2i#  Text2 &="Summary for " & "'CustomerCompany' = " & " " & [CustomerCompany] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"" @ Arialx _4;JQD+d`6<abc,d#e%  Label3 Sumx [k 0%DnCm0G<"C`6Cab(c,i#k (Sum Of ProductPrice2 =Sum([Price])& *$#,##0.00;($#,##0.00)" @ Arial (Sum_Of_ProductPrice2x dZNyM+`,  "PageFooterSectionx }SHM_-;&!m;<"C`6<abc,i# j%  Text50  =Now()& Long Date" @ Arialx 쁂>IsbB+m;<"C`6abc,i# j%k  Text51 H="Page " & [Page] & " of " & [Pages]" @ Arialx _C.M9׀l+f2 b2  Line62x )y+G6DO&    f2 ab2  Line63x fk /@ J    K`,Y ReportFooterx P 5D? odm0G<"`6Cb(c,i# j% 8ProductPrice Grand Total Sum =Sum([Price])& *$#,##0.00;($#,##0.00)" @ Arial 8ProductPrice_Grand_Total_Sumx Cu5|J 0I+d`6<b8c,d#  Label45 Grand Totalx .(pƋBoqH;_LVAL LVALͬ]ЪEktQy/ReportHeaderdy/Label49fy/Line52fy/Line53fy/Line54fy/Line55y/PageHeaderSectiony/GroupHeader0my/CustomerCompanydy/ CustomerCompany_Labely/ GroupHeader2my/ CustomerFirstNamedy/ CustomerFirstName_Labelmy/ CustomerLastNamemy/CustomerShipStreet1dy/CustomerShipStreet1_Labelmy/CustomerShipStreet2my/CustomerShipCitydy/CustomerShipCity_Labelmy/CustomerShipStatedy/CustomerShipState_Labelmy/CustomerShipZIPdy/CustomerShipZIP_Labelmy/CustomerPhonedy/CustomerPhone_Labelmy/CustomerFaxdy/CustomerFax_Labelmy/CustomerEmaildy/CustomerEmail_Labely/GroupHeader4my/ OrderDatedy/!OrderDate_Labelmy/"ShipDatedy/#ShipDate_Labelmy/$EmployeeFirstNamedy/%EmployeeFirstName_Labelmy/&EmployeeLastNamedy/'EmployeeLastName_Labeldy/(ProductName_Labeldy/)ProductSize_Labeldy/*ProductPrice_Labeldy/+Quantity_Labelfy/,Line56fy/-Line57fy/.Line58fy//Line59ey/0Box61y/1Detailmy/2ProductNamemy/3ProductSizemy/4ProductPricemy/5Quantityy/6GroupFooter5my/7Text34dy/8Label35my/9Sum_Of_ProductPriceSum Of ProductPricefy/:Line60y/;GroupFooter3my/<Text24dy/=Label25my/>Sum_Of_ProductPrice1Sum Of ProductPrice1y/?GroupFooter1my/@Text2dy/ALabel3my/BSum_Of_ProductPrice2Sum Of ProductPrice2y/CPageFooterSectionmy/DText50my/EText51fy/FLine62fy/GLine63y/HReportFootermy/IProductPrice_Grand_Total_SumProductPrice Grand Total Sumdy/JLabel45y/KCustomers.First Namey/LCustomers.Last Namey/MCompany Namey/NStreet Addressy/OAddress 2y/PCityy/QStatey/RZipy/SPhone Numbery/TFax Numbery/UEmail Addressy/VOrder Datey/WShip Datey/XProduct Namey/YSizey/ZPricey/[Employees.First Namey/\Employees.Last Namey/]Customer IDy/^Order IDLVALФ [.aID="{C9AA69E3-AA64-4D4E-B6C2-CE82BA53ABFB}" Name="store" HelpContextID="0" VersionCompatible32="393222000" CMG="BCBEFFBD077D0B7D0B7D0B7D0B" DPB="787A3BBC3CBC3CBC" GC="343677C58F809080907F" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office12\MSACC.OLB#Microsoft Access 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\system32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\System\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library*\G{0002E550-0000-0000-C000-000000000046}#1.1#0#C:\Program Files\Microsoft Office\Office12\OFFOWC.DLL#Microsoft Office XP Web ComponentsZ*\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 bHn>x  (%AccessVBAWin16~Win32MacVBA6#storeQstdole`ADODBsOWC10LPVBIDEAT  X0* pHd store @8= Vh @bH J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\system32\e2.tlb#OLE Autom`ation`mADODB> ADOBDDEB1D10-8DAA006D2EA 4D1DProgram Files\CommonSM\ado\$ms21NMicrosoft ActiveX Data Objects 2.1 LibraryH\OWC10\OWC10\\2E551.R.G%Office\12\OFF .DLL# X@P Web =ponents"A,VBIDE,VPBI[E,,157[00-P}5.3[&Shared\(VBA6E6EXT.OLB0Visual Basic for ApplicBs Extensibility +n> 8 @ @ @ @ @ ::::: : : ::: : : : : :::::::::::: :!:":#:$:%:&: ':!(:"):#*:$+:%2:&C:'o:Fp:Gq:Hr:Is:Ju:Lvv 8@@@@@@@@@@@@:: ::::$:%:&: *:$+:%C:'::o:F:r:Is:Jp:Gq:H  : :  : : :  : : : : : : :::::":#:: :!:2:&&':!&):#'(:"'(:"'(:"'(:" 8@@@@ @    @ @M`OLJik:Mokmd`Uidofk:$OJmJJMMQkkfJUQk:%OJmJLJkQk: Sdi`k:Y`QukfQMk:'`dOo^Qk:`kvkJMMQkkkmdiJUQ+iddm:fidfOJmJ:iQfdimk:kMiYfmk:qLJ:`kvkJMMQkkkmdiJUQ+kMiJmMW:JMQkkqLJOJmJ:FqLJfid[QMm:fid[QMm:Jfid[QMms`:IqLJ:+qLJ+fid[QMm:GOYi:H 6: 8:  <: OYiOJmJ: fidfOJmJ: L^dL: fidfOJmJ: mvfQYbSd: L^dL: fidfOJmJ: mvfQYbSd: L^dL:fidfOJmJ:fidfOJmJMdfv:mvfQYbSd:8:OYiOJmJ:fidfOJmJ:L^dL:L^dLOQ^mJ:&fidfOJmJ:mvfQYbSd:&6:!&OYiOJmJ:#'L^dL:":#'L^dL:":#'L^dL:":#'L^dL:">YNOO Y Y )Y  Y Y ,Y Y  Filter FlagsIdNamePosition SelectedObjectIDType,,OQ,YIdv1_NsCustom ^Reports$ w VNPPP RYNSSY Y Y  Y @Y ,Y Y  FlagsGroupCategoryIDIdName"Object Type GroupObjectIDPosition,,SU,,,SV,YYGroupCategoryIDIdv1@  RyL|O" n A   w w_ w m w f w , w 1 w  wCustom Group 162.*  w w w w w w w R @ @T T T T T TTTTTTTTTTT R @ @TTTTTTTT T T  T  T  T T TT Y##NXX" "#Y Y Y Y @ Y ,Y Y  FlagsGroupIDIconIdNameObjectIDPosition,,XZ,,,X[,YYGroupIDIdv1 W#yLk> ] 0  | O " n A  ` 3  #  o"  o !  o  o   o   oW oR oN o  o  o  o  om  of  o_  o8 o o1  o o,  o o  o  o  o  o  o  o  o  o  o o o o o W @ @ @ @YYYYYYYYYYYYYY"YY Y Y Y Y YYYYYYYYYY Y Y Y Y Y! W @ @ @ @YYYYYYYY Y Y  Y  Y  Y Y YYYYYYYYYYYYYYYYY Y!Y "Y!#Y"RY7\\.PN]]Y  Y Y eIdNameTypedv\\,h=dA W * x Q  q B ! O T  }FdMSysNavPaneObjectIDs2.\MSysNavPaneGroupToObjects<8XMSysNavPaneGroups,(UMSysNavPaneGroupCategories>:tblProductstblOrderDetails>:tblOrderstblOrderDetails:6tblEmployeestblOrders40Reference2Reference1ReferenceMSysAccessStorageSTGREL84Update Product Prices40Select Customers*&qselCustomerOrders.*;Products4Orders-Order Details$ MSysAccessStorage,(Find Duplicate Customers:6EmployeesDelete Old Employees2.Customers Admin  Customer Orders($ fsubOrderEntry&" frmOrderEntry$  frmCustomers"UserDefined SummaryInfo AccessLayout "SysRelScriptsReportsModulesFormsDataAccessPages($MSysRelationships,(MSysQueries MSysACEsMSysObjects MSysDbRelationships$ DatabasesTables YN``Y Y Y Y  Order Detail IDOrder IDProduct IDQuantity>,>,`b,>>,>,`c,>>,>,`d,>>,>,`e,>YYYYCustomerIDOrderIDPrimaryKey,tblOrderDetailsOrderIDHv1b _{hUB/             _ @ @aaa aa aaa a aaaaa aaa _ @ @aaaaaaaa a a  a  a  a a aaa _ @ @aaaaaaaa a a  a  a  a a aaa _ @ @aaaaaaaaaa a a a a  a a a Y NggY Y Y  Y Y Order IDOrder DateCustomer IDEmployee IDShip Date>,>,>gi,>>,>,>gj,>>,>,>gk,>>,>,>gl,>YYYYCustomerIDEmployeeIDOrderIDPrimaryKeyHv1bfeF' `*@*@`*@*@)@ )@)@)@)@)@)@)@)@)@)@)@ f @hhhhhhh h f @hhhhhhhh f @hhhhhhh h f @hhhhhhh h ZYNnnY  Y d Y Y Y Y Y Product IDProduct NameDescriptionSize PriceCostStart Date>,>,>nq,>>,>,>nr,>YYPrimaryKeyProductIDnnHv1b LVALpP " World-renowned taste makes this coffee one of the best there is!Delicate, luxurious - and available now!Smooth and creamy - direct from the Swiss Alps.Smooth and creamy - direct from the Swiss Alps.Everyone's favourite! Directly imported from Belgium, these dark chocolates are sure to be a hit!Everyone's favourite! Luscious dark Belgian chocolate imported directly.+mj"E8@Blue Mountain Coffee@oD8"d,<@French TrufflesP@o?3"P `@Swiss Chocolate^@o?3"d `@Swiss Chocolate^@o?3"@@@Belgian Chocolates@oB6" hn$@@Belgian Chocolates@oB6" m @pppppp m @pppppp t/f!  K tblProducts.ProductPrice[ProductCost]*1.25aA wtblProducts'''  G G  G[PrP@+ 'PrCustomers.[Email Address]8 gPrCustomers.[Fax Number]5 gPrCustomers.[Phone Number]7 gPrCustomers.[Bill-to ZIP]6 gPr Customers.[Bill-to State]8 gPr Customers.[Bill-to City]7 gPr Customers.[Bill-to Street 2]; gLVALʾ OrdersqselCustomerOrdersCreate form in Design viewCustomer Ordersg^3LVALДS oaMR24ODBCTimeoutMaxRecords" < MR2 GUIDNameMap 5H>DW0  U`{lAJ^`$x%-@tblOrderDetailsf!AvDBr+]j`{lAJ^`ProductIDU!KH,E2fש -@0. -tblProducts,P#YKrpU!KH,E2ProductIDW‰MR24ODBCTimeoutMaxRecords" < MR2 GUIDNameMap 5H>DW0  U`{lAJ^`$x%-@tblOrderDetailsf!AvDBr+]j`{lAJ^`ProductIDU!KH,E2fש -@0. -tblProducts,P#YKrpU!KH,E2ProductIDW‰G[p~U!KH,E2ProductNamebGl$U!KH,E2ProductSize"D0}F>Xm`{lAJ^`QuantityMR2 GUIDNameMap HIJج:d \ Uq΅C;6d6R%-@tblOrdersO>q΅C;6dOrderID[m/&M25 q΅C;6dOrderDateOOlZtKdjq΅C;6dCustomerIDl1ؔ*I"VA -@08tblCustomersNfi.F?+vl1ؔ*I"VCustomerIDB3ɳOj鸬Yl1ؔ*I"VCustomerFirstName,KAQGV'l1ؔ*I"VCustomerLastName3']cwKvUk\q΅C;6dEmployeeIDeDeUr/d%-@08tblEmployeesoV\@L.V]eDeUr/EmployeeID aEty\eDeUr/EmployeeFirstNamekw8͈G"eDeUr/EmployeeLastNamehFGIdAXhq΅C;6dShipDate5H>DW0G%-@΅Ca0fsubOrderEntry`{lAJ^`$x%-@F5HtblOrderDetails ":"EL]*Ȋ^^|`{lAJ^`OrderIDMR2 GUIDNameMap ,dTCz]LF  Ul1ؔ*I"VA -@tblCustomersB3ɳOj鸬Yl1ؔ*I"VCustomerFirstName,KAQGV'l1ؔ*I"VCustomerLastName2}L0/l1ؔ*I"VCustomerCompany<~N3CMivl1ؔ*I"VCustomerShipStreet1Z,LD }l1ؔ*I"VCustomerShipCity `dN]c`Ql1ؔ*I"VCustomerShipState/CJ<͗,l1ؔ*I"VCustomerShipZIPvg量rGHriql1ؔ*I"VCustomerBillStreet1%UA`&Hl1ؔ*I"VCustomerBillStreet2Q+aNAB mPl1ؔ*I"VCustomerBillCityvQEB[l1ؔ*I"VCustomerBillState?@1Vkrl1ؔ*I"VCustomerBillZIP]b@nt\l1ؔ*I"VCustomerPhoneނUCf#Ol1ؔ*I"VCustomerFax^L/l1ؔ*I"VCustomerEmailN ($C8{l1ؔ*I"VCustomerShipStreet2MR2( ReplicateProject MR20 Title AuthorCompany8 store Tony Hall LVALЀ" MR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatCaptionInputMaskDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionGUIDDefaultViewIMEModeIMESentenceModeA    UeDeUr/l*:@EmployeesoV\@L.V]eDeUr/Employee ID aEty\eDeUr/First Namekw8͈G"eDeUr/Last Name eDeUr/ Employee ID    , $Employee ID Number oV\@L.V]First Name    2 *Employee's First Name   m   aEty\  Last Name    0 (Employee's Last Name   m  kw8͈G"  MR2RecordLocksODBCTimeoutUseTransactionFailOnErrorOrientationNameMapDOLGUID  <    | UeDeUr/l*:@Employeeskw8͈G"eDeUr/Last Name t=O.cB:MR2 GUIDNameMap, Cq IZT1  UeDeUr/l*:@Employeesl1ؔ*I"VD-@aMkCustomersq΅C;6dq*:@aMkOrdersU!KH,E2nt*:@aMkProducts`{lAJ^`Ho*:@aMkOrder DMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatCaptionInputMaskDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionGUIDDefaultViewIMEModeIMESentenceModeA    UeDeUr/l*:@EmployeesoV\@L.V]eDeUr/Employee ID aEty\eDeUr/First Namekw8͈G"eDeUr/Last Name eDeUr/ Employee ID    , $Employee ID Number oV\@L.V]First Name    2 *Employee's First Name   m   aEty\  Last Name    0 (Employee's Last Name   m  kw8͈G"  MR2RecordLocksODBCTimeoutUseTransactionFailOnErrorOrientationNameMapDOLGUID  <    | UeDeUr/l*:@Employeeskw8͈G"eDeUr/Last Name t=O.cB:uAvcO<)   x e R > + *   z g S@-,{zgfSR?+   7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp   T 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp  \ )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp \ \ 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp \ W )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp W W 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp W R )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp R R 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp R N )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp N N 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp N T 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp  8 )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp 8 8 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp 8   7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp  1 1 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp 1   7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp  , , 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp ,  )P9߲°hv#ft[KQglVuJ.yv8mRK9I# ZODDL!Rx*ېp   7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp       7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp LVAL ά&bEmployeesά@~CustomersCustomersKEmployeesEmployees X|Order DetailsOrder Details?/OrdersOrders>ProductsProductsLVAL5zMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatCaptionInputMaskDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionGUIDDefaultViewIMEModeIMESentenceMode    Ul1ؔ*I"VOk*:@CustomersNfi.F?+vl1ؔ*I"VCustomer IDB3ɳOj鸬Yl1ؔ*I"VFirst Name,KAQGV'l1ؔ*I"VLast Name2}L0/l1ؔ*I"VCompany Name<~N3CMivl1ؔ*I"VShip-to Street 1N ($C8{l1ؔ*I"VShip-to Street 2Z,LD }l1ؔ*I"VShip-to City `dN]c`Ql1ؔ*I"VShip-to State/CJ<͗,l1ؔ*I"VShip-to ZIPvg量rGHriql1ؔ*I"VBill-to Street 1%UA`&Hl1ؔ*I"VBill-to Street 2Q+aNAB mPl1ؔ*I"VBill-to CityvQEB[l1ؔ*I"VBill-to State?@1Vkrl1ؔ*I"VBill-to ZIP]b@nt\l1ؔ*I"VPhone NumberނUCf#Ol1ؔ*I"VFax Number^L/l1ؔ*I"VEmail Address l1ؔ*I"V Customer ID    < 4ID Number for the Customer Nfi.F?+vFirst Name    2 *Customer's First Name   m  B3ɳOj鸬Y  Last Name    0 (Customer's Last Name   m  ,KAQGV'  Company Name    D <Name of the Customer's Company   m  2}L0/  "Street Address    T LCustomer's Shipping Address - Street 1   m  <~N3CMiv  Address 2    T LCustomer's Shipping Address - Street 2   m  N ($C8{  City    L DCustomer's Shipping Address - City   m  Z,LD }   State    N FCustomer's Shipping Address - State   m   `dN]c`Q   Zip    J BCustomer's Shipping Address - ZIP   m  /CJ<͗,  Phone Number    6 .Customer's Phone Number   m 4 ,!\(999") "000\-0000;;_ ]b@nt\  Fax Number    2 *Customer's Fax Number   m 4 ,!\(999LVAL") "000\-0000;;_ ނUCf#O   Email Address    8 0Customer's Email Address   m  ^L/  *vcO<)   x e R +   { h T A . }j    7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp    7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp    7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp    7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp    7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp    7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp     7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp    7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp    7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp  m m 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp m f f 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp f _ _ 7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp _   7ګM츕g\9 %Ҷ[KQglVuJ.yv8|KD7n=# ZODDL!Rx*ېp LVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatCaptionDecimalPlacesInputMaskDefaultValueRequiredDisplayControlGUIDRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListDefaultView  @ 8 U`{lAJ^`$o*:@Order DetailsΖ4KL1!`{lAJ^`Order Detail ID ":"EL]*Ȋ^^|`{lAJ^`Order IDU!KH,E2]*:@aProducts,P#YKrpU!KH,E2ProductIDW‰G[p~U!KH,E2ProductNamebGl$U!KH,E2ProductSizef!AvDBr+]j`{lAJ^`Product ID"D0}F>Xm`{lAJ^`Quantity `{lAJ^` $Order Detail ID    4 ,Order Detail ID Number Ζ4KL1!Order ID    V NOrder Number this record corresponds to    0  m  ":"EL]*Ȋ^^|Product ID    Z RProduct Number this record corresponds to    0  o f!AvDBr+]j Table/Query SELECT Products.ProductID, Products.ProductName, Products.ProductSize FROM Products;    0;1440;1440  2880twip Quantity    F >Quantity of the product ordered    0  m "D0}F>XmLVAL*MR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatCaptionInputMaskDefaultValueRequiredDecimalPlacesDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListGUIDDefaultViewIMEModeIMESentenceMode  b Z Uq΅C;6dq*:@OrdersO>q΅C;6dOrder ID[m/&M25 q΅C;6dOrder Datel1ؔ*I"VOk*:@xCustomersNfi.F?+vl1ؔ*I"VCustomer IDB3ɳOj鸬Yl1ؔ*I"VFirst Name,KAQGV'l1ؔ*I"VLast NameOOlZtKdjq΅C;6dCustomer IDeDeUr/l*:@xEmployeesoV\@L.V]eDeUr/Employee ID aEty\eDeUr/First Namekw8͈G"eDeUr/Last Name3']cwKvUk\q΅C;6dEmployee IDhFGIdAXhq΅C;6dShip Date q΅C;6d Order ID    6 .Generic Order ID Number O>Order Date    : 2Date the order was placed  Short Date [m/&M25  /Customer ID    d \ID Number of the Customer who placed the order   0  o Table/Query SELECT Customers.[Customer ID], Customers.[First Name], Customers.[Last Name] FROM Customers;    0;1440;1440  2880twip  OOlZtKdj+Employee ID    ` XID Number of the Employee who took the order   0  o 3']cwKvUk\ Table/Query SELECT Employees.[Employee ID], Employees.[First Name], Employees.[Last Name] FROM Employees;    0;1440;1440  2880twip Ship Date    < 4Date the order was shipped  Short Date hFGIdAXh  LVAL3MR2AccessVersion BuildProjVerNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By.CheckTruncatedNumFields6Track Name AutoCorrect Info0Perform Name AutoCorrect 09.50  V           MR2AccessVersion BuildProjVerNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By.CheckTruncatedNumFields6Track Name AutoCorrect Info0Perform Name AutoCorrect 09.50  V           MR2RecordLocksODBCTimeoutUseTransactionFailOnErrorOrientationNameMapDOL  <     UU!KH,E2fש -@0fa tblProducts8N;[U!KH,E2ProductCostMR2.ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatCaptionInputMaskDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionDecimalPlacesGUIDDefaultViewIMEModeIMESentenceMode    UU!KH,E2('t*:@Products,P#YKrpU!KH,E2Product IDW‰G[p~U!KH,E2Product NamexrB$eU!KH,E2DescriptionbGl$U!KH,E2Size $!Io/'-U!KH,E2Price8N;[U!KH,E2Cost4$ucjD4hU!KH,E2Start Date U!KH,E2 Product ID    8 0ID Number of the Product ,P#YKrpProduct Name %   . &Name of the Product   m  W‰G[p~  Description    < 4Description of the Product    xrB$e  Size    B :Size of the Product in ounces   0  m bGl$ Price    > 6Retail Price of the Product2 *$#,##0.00;($#,##0.00)   0   $!Io/'-Cost    B :Wholesale Cost of the Product2 *$#,##0.00;($#,##0.00)   0  8N;[Start Date    l dDate the Product was introduced into the inventory Short Date  4$ucjD4h  LVAL άs?pC&qtblProductsά&qCustomersά&qProducts bEmployees2qCustomersqOrders>qOrder Details