?_j Z Q ') ); ,`'):(( %:(`,,`.aaccessandareAscendingBack1 02345"*6'7,819boundboxbtn_bB'buttonbycalculate` scanCgories @'0PNameCBBC@Ecombomcontrol)@sCtt:riteriaCus tomerPsdataDeleteMarkdialogD dis@played@sEmployeeseventfieldfollo"wfoo_fomsfunctionGotoZgroupGF+ Headerh IEini n?a7isIsAListlm@acroMisoftNorthxdofonOnClickororMO0WspagePivotTableprintprocedur @sProducP Ps0pert @y/ queryre cuR Navig Se 0sl R LlesS0vt!s,0Sett\s@Sub70@SuppliSwitchboardt ste xtthaeThetmtalu0sesviewwhichYesyou"")",#&(")+.)/00.2511012632256199735:;==[?[ ]]![atAA3ddAdde7safSAUpGeallAllalsoamvanAnalyHzeA?noraQaahmeticAsasocittra@veAutokeysa-lyava ilColorbasedbBbeenBee00begdinhgBp@D sid0tw=bb0BFbe2sak3sB;dSlledCancelCwCap"c|ar|SI DCCur6lchange0d reckchooseCityc | clscolumn3 0ar 0mb inj#>panyzC0I @`$ p1M[slyga.iU inuousror]po3%$c$0cC$'sc C DsCTRLcuEncy `?~00tIDPsCea#"@PSizo# sDefaPultd%dr ibedDgng lD@ s0sdidn't diffeDi#QEediv_sd@odocumGdoes3f-downEad oe$erEle/Ue`EE&6 0 d COsexae$exdE ed|5J#sq #t~ sCBirthH X#fpR}@ ВM 3LengthyB "#nodes0crip"#Nz@Y& h) p{r ,b*MZ j@P >VR8sTitleOfCoudsyYdye$b͠`, Plà_WY bject 30sB1ocu*;pJi}.sIw s.e/gram ;-w/tocol>.'M *{{eWUA{AAAdC-Baaax)iAR#A7AU]B@& qarbW>@3several+simpleq#can't.-Wk@' 6D>@:A' E-4-,`>[m6@;combinesnr%"-b9grk ~hCsuppliersSContactName]$"js`db`\k@A)@ "0 0'0z#unionNd0o[4:AA@'["[;CrosstabbAB(?bc!CQuarterlyjip!J9PmuchNe7$R0' .9!t:xACj :tȰRHOA !5`;@sT;DateP ~cHR)r+; COrde rYearU0! vBmE1-mEEMT \'d$N: d"d&(* ,.024$34$P7 p2^4@37 3 0323@QU M .M0M@os g ,g.g@ *,@ (*@ z&(@ "&@ !B ! "BHCE'(..E7.ll1omEF- (CuqxtD rE(!CdZemM!3e5#ESF'FxVkFGL f#S Ty3d2[discinued&%S"xr$]+CY@YPj3a#s3gre%$#2,(500-hippuP >2$PKSaled@;1/997( K12/30 #BE{rN7SF H'(n Be;promptti@run_.GkIN j]!54߉[Aak>lZ'<a` .uUO ?V!Uي݋@r @a)ge 'N1b>0D)T@hz +"|#DO pJ'5ACA(Kreferenc 6 X`zϑ IsNull2#!P>aIK9 @獪U5 5rv@"uxFFF>0JK's `P&aKL-@@;#Above3Age@#Price+ ip2yÐ$CJ Ll ;subqueryb9/KL'b ^P LM3 4mTenMo@stCExs*i L%*w=  ,) soe Kdescending#the0seJy6ׁ 3hig! t=lfhLO13OCO ET)@4ߣPc 92 MCO'@\AOO'4@Q"+eassCefficie !x2@= )bi,KK`)Į6$CO#P'UH IrOP-s ߰:x LN EdxtedI40,' E ]9+#PP'N VAAPQ3h'װ4g R+#fB1E`n AF".q! &aC=PR'(d z3R,t QS4 p6Ѣ%2ak(SU]6~ c 2SHpӜJ 6%258`J+VpFF4(xP>u>LM!NAp BRET4s6xD1gbqPʔ*Lr;v]Kspecify~"8lcC gorysFhiSU1UUnYj4P7////K   4!ETU'A B"&^ UV'(mA@}D-b1 ρ[man ipulaygD {&;intraPnet!*F6s`ݫ|Px #(ryϪ kh7archicallCanPalyz[b +(makgSje@ctions/U|W* "_Gk'pwha =#Z W$0 +p& 'sp i-: AE5VW'TjՄQ (W?.|WXDP V1@`6f@㣁nh Oy'uSc 3vely@<Bf' ,Csel\ Uq |>#Clicka*8M@u =? &P? J $+Choo* 7? 3appearsP`X6Y. VHWEY. ,, dV,!#E z;complete)XnY( 'K ! `_,/giEY818kTu2nY8nY$N: d"Pd&(*U ,.02%4$34$P7 p24@37 3 z0323@QU M .M0M@os g ,g^.g@ *,@ (*@ &(@ "&@ !B ! "3!nYk' B6'bj(84 6Q34@?PC0D3analyzeSdynamically>SrearrangingDbExpandItemsByDefaultcw#Neverx40!I3summary3visi@bleԏP#lj 3sU|\B?Ccomy's five ƅourcesB@L. t.dEk9D#X MD rB0P8QC (Y)CՂ|B#T" __Pl (v?q,9V#|X9PJbJ $.@ @rSShipCoudnt]%|JE#ZJ!_+_`i_;_Name\`V+E\V\\an0mTJ E^UBrv9$riMvEtllBol+rh\5 ҅@Ej(+[f\6v.El[[/[p&҅T% P:/gi.1> fl$5Pc/l63!T'( ]qBb0(2łv!vvt& h,%7#q%U~",]! &p3 .$P` 6] 5P Ĩ0X7n i Zu^ Aŗ/ . 0h8'V!bg#iA[gV%S! @y0r("*!bKdefinitionb!.Xb+aren'tj Q L8Y84ji6&X!V 093deletedg(1Op; jAG bX0t(8{OrdersNaviga  DetailsExten(ded!XS,ShowFiltePrBySc(B utton 0 ,.SortAsc/Vy *0 PDe iTogg,leo@9`^{0, (܀8q < [ 4@  *(@8-3 6'hG@JA`%[$ 6 H6C#V(` 9)C[Bi9Gii?{#ĀWj,jyE#  ,:Js%@)OGroupX2Co ol{Field?/h/g&͍@% x3':w QH͍HpCCB8H6#Z/[<aA///$/a%[$)9-6@'ZWӖV]cH[܀C888CB88vT܏b#~|<7^&LCcs&%'& :h/gkI1 I|] P *U* *+= )+C+/y ]+ 3#|' F]QIv(2 꼍:8>JiPJ *E GiZizFihF' EEE|F Z'-ʂ9|9D6t Y8# Where) H+3permits1sk] h+vv<bz CCCat@egorieProduct#9w^)0l)y^{v, O*Q(i3!L'8]]iFi%q@$ HLCP#)( CqBj#)p pGpp p,pp&͖% 3'*>Ѽq%͖%$HmCC%Blm7m#v>(Q4@)7!/&] %da71F [6w&ww$wwwUPwWwPw'XwPwwww0]'  2wZA(/!60 qwAsPIfn&Xs'q5Jy.!/T~p.FFf$ yProw$y58Vэ+l b&ʼn$ưң0jaB}r./t_E_D#X0 :3%X (apCB5j^_V#|6<uL E>rLN E#Zz2s-LL`iLM ]NZE#Z> $@ar|nW G#^gM; MPaM O0ON (rr)Q"ZEDm(+N&?% P:/'@ $4%1barX6wass >#Chart+Wizard+seriesb|#shown3columns.gi?+1H +^ub$N: d"d&(* ,.0J24$34@$P7 p24@37 3 0323@QU M z.M0M@os g ,g.g@ *^,@ (*@ &(@ "&@! !B ! "3!^' B6]q+N1 0qp("!1D#There)\B(!Bj,D@ ^Y8 .Vk$"QGsV tg[*x[ 3(8H^C#V(p A @$0?$CNB#T+G7CPD (v?uCNf#;9PJ$J $ 4*jp ?/ 'up&4$ t/c]N1 Pc3/u'*Y1'w|}mostϥ#!a&1Ceffective @R0Ldb3(M `f&@+@prompt!P$0z+aron6#9!ZD#l.9^XUP;j) "4v6d@'p zܯ#4@)'>R>E*>%J՝*W?R j^ tȰRHH湎 ] pģF!p,I) #^= j<W"~ ^T<3AnnE )'5Pz0P0+Q,Cincluding+c0^h24C2^fuK! 74 6(Q;lT'Z,P@Also\7L"_2Vg+f$Uec1 $@1z1$'6[Q"(1`^$ N#|Q3Ph`$eeSQt(zv= E   vPj\2 ;filt# d( @ !P)^(KBA0@2]$6 :KYe  iޥuVD  ]@<2 +rePopenSxv2 \3 VKdis0playzGv)?;"& Ec.S= :BFL f*Yp @`PG3!CanyNameF!s(? ASA=Alpha3ButPtons;at0tachL! ]![+5$n9`Az$H$STI@mx *2#`v: BI'r-"/AKey"dQ , K !j+S3p resse^pR"apsk7PL6G/@Iq.:_jFb( :.VNtcw #3whevt ~`U#z> ^L<%,#%.++CbB++ +,'u#~N/zr475H Q0i:?;8YB R-aaYVu(&CBIKeiAs'RontoHu4 M y3WX((B U^. 46) "<#;BSzK);67l-l.}1KFEVum: n%D>( |4H:zKt:M"KJ bEDtDREI<O @P@{RequeryReportsTo!Bza_R8 ƕ9W+.M0CPageBr eakV-@#below=;PTr45@6 QB0 ?P n#7LL RCABQ0  +secondHc!Baf==8keys)&Ca@mpersae(&)13Capption\GgiX1X  $N: d"d&(* ,.*024$34$P7 p24@37 3 0323@QU M .M0M@os g ,g.g@ z*,@ (*@ &^(@ "&@ !B ! "3!' B 6p ]qTXO' @$@>T0\lD$6QryG>C:h*B`$EE0P1B,{'@@=>O&/5uu%tX(_{P,!(((EDEcC&)5cControlS ource5@#refer4=x4-9 |+2e#TotalU@Q>xD[e)z@~5[Defaul tValuz@3@fill3today'sBG(nP!uV~XV xz~? uuwZyY 859%zbV 3dvancing&nePxt#|0{Hy,linkAd dressVsDisplayProducts%@@doc"@d#&`\\ lk2BTipTi}`'^tip(j"VPP#mouse3pointels@>>`(jap ;C!V \ d p  Gg;f0l\ ޚ@#leave03without`+add'W]o ' . ,~T D3r44J>> e (pV4_'  \p~p3OnErrorzqB+undoesanyi:?  5 LӈL9+#5s:t>K#Ev3{BeforeDel^firmd .#K;Ag@ @3changS##@". Kst alone)3attemptF .jve u1 u |PQ  "+6. ' \#z`\uc' Q1  |eFrom."*f,d*DT-xq&l0p 1@. =,'4Zc9(t#, +b@B c?Z/ .KsuppliH 'home/  .D[5H ^k*p_Sh[&Q1$2.{%  o `?3n\ kRevxiew "kl#B0 ,kCOzrwiseU+askqh>9P}ZT?xf&/AKP&o6de ,3invalid7qhZ+0Clos),1_W #S%#@:#nc.3_aa, #RiQynchroniz1 R V E/8 >02(r@'e"WKdu=ca t"( cfun ction1ty18J K3compar38spcorrelaJA I .)  fM) @d\\"[ļ??( ~%Rs1M@HRcRL R[OutputToHTtML*3p 5[Alphabetlp F>y (:3browserh%;Nwindahtm6;ne^FyM{/+T__4fO2t9,,$wI!-)? &c+0/):c (4c&c)b Gc5 XlE}3limitedDD2MT/(j'F}Q]XlK*C#V2 #  0CmB#TP FFPS w (v@Y?|$*_#H9PJp$ 0 PySDefaultV?KinuK/^mGN#l(/ Uj jKAllowEdits?/bN]0]]$]Nk]  ona bG Naaabia`]hN! !!!CDat@aEntry # "   th.@10 .@n@mK^h P 3 UM g 9  u ".@&P:@"d & B N "@Kn@' @6^h |8.@3A' q@4?f8|3covered#topic} +create0DP03actions6@0zF0 pC0!CfunE@*p.1n@dA'<Aqz73AB(:5o `!DƁC[!0x"p$x:q9dq:z  A X. A t:LdA_CB RtRH1 ZBe8mT<DȀ$]L(lI F @leAWsR8i+0GG0K +^^BC3 6̀J<M<)<_z2_CC)@ "8#"BCD) 21CSRy!\^2"G#> H 2Kcgori4esBJ"L;1CD(b#SDFH ^ jBRHp2!b`23enablkSelectC0y8ltq.Y̵cb1kJHk$cPreview_ ClickASPrint@0 '3lID&t  @{K8wCdependinZg\DFHR"XR{BGruc81FF)05iFSG)AG3VI{~~#4'6t!)quitDF7HB?>&??>>UExitMicrosoftAccessP%#es D}eDisplayDatabaseWindowTtFbPd5F SGH5 87Gdh]S%e1dcode cP ];JFKEv.*Q*!'JmK& ֺ/b_FKL1LL O @$+ K ( * , . 0 2 4 $34 $Kp2 4K37 3 z0 2LQU M . 0Los g ,8 ^.8L *R ,RL (l *lL & (L ".mKL' .X!LM' 9^ wq 3presentbSeffively  HÞ[;02݁ ;group}3sortbScalcHula 7Carrang ] #needsLJN*5 _@V U'p*. #WXL0]W+jp, f t iq8@*MN'JT W?0JNOn /a v@+Cz,!54d@#Mt 50#R'#Lis: J;sta1# [v ro,duN.& z3f<**Z[A ]J /P,, ,y !N+N JF !XGG@aYNQ1 QHQRKdKKKKKKKKKK1 KQK-OHQ'"KW%QmR@)X ӟ"]:/;YDss S;sc [dribu" ~< 4. B "e,v[R 6)F : Sd@escrip#Q . ;addi@D. =XSHQpS> J}`_sHeaderPageBreakV@” 0vmCLargeLogo{SmallPictur@;Nam #imXXS`v;#lAs m@6#frB@L+#photoJa][mRS. ,|71!w-(!zwmk2pS8TX#Pd ~ hk:I(; B`  ///CS{TBt;8ThU#.1{kP<p] &S+L?? :/@ / 0 /!' #Who%{TU$ !: qhUU- (5gH$J$C 00k2UiVX0r C%0000CUVB033iVW00B/80 0~:0=J&-M1b2B33&VW% NZ$N: d"d&(* ,.0J24$34@$P7 p24@37 3 0323@QU M z.M0M@os g ,g.g@ *^,@ (*@ &(@ "&@! !B ! "3#' F6D]q-; D!4"G2BRqбqB Spercentagesx"P6Hp .]@ w![ConfidHialbmp ,@j.Kbackground3picture#everye\ (8eF.k2X@#d 4ID q $(0#B` ///C-ۄB#Ts* bP  ~(vXi$?#.3$>@;OpT T'Ԏ~2D>Z?? : /@ / 0 ' ۄ@#e uE$Hb=[@ #]T/s,Dž4a#\XCf6+?()=Aq&  pc#t:q4 P n&tȰRtH#W p# ;OnNoD(ata'l{3cancelsKpreviewingp;pri;  ʔ҄O<!3.(Z+resetBs ԛ+^BB0\88KExceededGoalLabeljsSalescsonLineXr kD2\>:qI( t%SؑAXB D V/&BQ`Q#RangegG5AK qa1O>XHLaPc6Of Total]`֒99>4%1zcsJq's*Эa``C`try\\\rP]9I R rs!O!@J v~y@{#SbvV2iinqKemployeeVlqcX S`qMcbGrandDaP$#g+rz3 6Kq ffA"pdef 1 'HHDoPc  ;0''5 <ۼk Z(@ 0`jt J j `a  *; Xtro? <'=W 'H ^==5G{NumberOfProductULTotPJF#I6 (= `' YO'6P<0Scor4 ponds,#w0idth;3zf8m j%3matchP 3r'.See(uMCS. ,ߌ<%]U#@z2{ =q?v;% D\?5? ~51De#j7 8!"6!?3/}  ~@sƕdG~.}}Gp\?@#0.938B$|7D3dhn",r JrLSNewRowOrCol?:o/LF, (_U*(+7k23X#Pd+~M+7,(72"$B` ///C-B97s9S#.=:r:"F<F &t'L?? @:/@ / 0 /' Ws0-a#`ዔ(8A!8M?m(G#"8 *En1>VM+%=%d%$%s %] Y-%Us-% -%-% -%-%-% %98V' p{%Z1cqU' ':@1- +Al*J " 1XQ0Bo' t LHng B0,X$ ` .@~0VA'h6@DL @&XW-PխA PA\^ tȰRH`@@`#3BecauseH >HV1X &w 3.TSB< v.]3linkingrAmXDt+50[ProductLabelcKSahles 0X`xb D<`N` . *=OA+bottom#edges_3Graph10V#align #won'tgrow+filledv%#spacecqualL &?3YNF\i. , 4 q@tw!( 8Mk2X#d ~n b`(0B` ///CiB#T4 bbP"o (v?^#Ԁ =@Np$ 8 " 4<LS L?? :#Othera!3defau@lt)70' <6bC."z40@QSG!ihighwide+enou j0MND .##k2X### ##C;B####r2u####" #:MrM?-(A';& #Q/11YC(C'X W0WBX11 hTimes New RomanArialSymbol KB(OOO Oaa[P'^O^ڬPÍ OÍVPYPA XP OZP* OsOsdOʄ Oʄ:O:OOrrO,OOQ Q -$sraʄQ *r*rQ r:*aQ raQ ʄsʄsA '**'A '*A **A A *''ʄssʄʄʄas'A *s*A 'a^ss^arQ Q rA ssssQ :r:Q :rraa:assaQ :ʄrÍ^Q ^ʄÍ:rQ :aaarraassrsrQ A '**''A *A **A A *'rr:r::*ss:rrs:aaʄ*ʄʄ*A a'A Q ar:Í:raÍQ rA *sʄQ ʄr**rrasʄ*rQ *rQ 'a#?x/(&(;)F24!?access keysAfterUpdate propertyAnalyze Sales data access page AutoKeys key combinationsAutoNumber fieldsbackground picturesBeforeDelConfirm propertyBeforeUpdate property Between operator(calculations,0calculations, data access pagesHcalculations, formsPcalculations, queriesTcalculations, reportsXCancel macro`canceling printing of reports without datadCaption propertyhCatalog reportlCCur functionpcharts in data access pagestcharts in reportsxcolumnar forms|columns in multiple-column reportscombo boxes, requeryingconcatenating textcontinuous formsControlTipText propertyCount functioncriteria in queriescrosstab queriesCurrency fieldscurrency values, roundingcurrent date, adding to formscustom dialog boxes, using to get query criteriaCustomer Labels Dialog formCustomer Phone List formCycle propertydata access pages,data access pages, Analyze Salesdata access pages, chartsdata access pages, data entrydata access pages, Filter button on record navigation bardata access pages, Filter fields in PivotTable listsdata access pages, group filter controldata access pages, grouped recordsdata access pages, overview of pages in Northwinddata access pages, PivotTable lists data access pages, queriesdata access pages, read-only data access pages, Review Orders(data access pages, Review Products,data access pages, Sales0data access pages, View Products4data entry page8data types, field<Database window, opening from switchboard@DatePart functionDdates,Hdates, adding current date to formXdates, date range in query parameters`dates, returning date valuesddialog boxes,hdialog boxes, creatingp9dialog boxes, using to get query criteriatdisplaying Database window from switchboardxdisplaying messages|dynamic HTML pagesEmployees (page break) formEmployees formserror messagesexiting Microsoft Access using event procedureExpandItemsByDefault propertyfield data typesfiltering data,filtering data, command button in formfiltering data, Filter fields in PivotTable listsfiltering data, group filter control in data access pagesfiltering data, record navigation control in data access pagesfocus,focus, current recordfocus, moving using command buttonsforms,forms, Customer Labels Dialogforms, Customer Phone Listforms, Employeesforms, Main Switchboardforms, Orders forms, overview of forms in Northwindforms, Sales Reports Dialogforms, Suppliers, Products, and Product Listfunctions,functions, CCur function0functions, Count function4functions, DatePart function8functions, IsNull function<functions, MsgBox function@functions, OpenForms custom functionDfunctions, Sum functionHgroup filter controlPgrouped records in data access pagesTheaders in forms,\headers in forms, field information in form headerdheaders in forms, page numbers and print datehheaders in forms, printinglheaders in forms, titles and column headingspheaders in reports,theaders in reports, image controls inheaders in reports, page setup propertiesheaders in reports, printing on two pagesheaders in reports, printing report criteria inheaders in reports, resetting page numbers based on criteriahome pages, hyperlinks toHTML pagesHyperlink fieldsHyperlinkAddress propertyhyperlinks in formsimage controls in reportsInternet, hyperlink toIsNull functionlabels (mailing labels)Ilinking charts to reportslookup fieldsmacros,macros, AutoKeysmacros, Employees (page break) macro groupmacros, for previewing and printingmailing labelsmain formsmain reportsMain Switchboard formMemo fieldsmessage boxesmessages, displayingMsgBox functionmultiple-column reportsmultiple-page formsNorthwind, Northwind, data access pages@Northwind, formsDNorthwind, overviewHNorthwind, queriesLNorthwind, reports\Northwind, tablespNull valuestNumber fieldsxOLE Object control|OLE Object fieldsOnClick propertyOnClose propertyOnCurrent propertyOnError propertyOnFormat propertyOnNoData propertyOpenArgs propertyOpenForms functionopening Database window from switchboardopening forms using custom functionOrders form and subformoutputting to HTMLpage breaks in formspage headers in formspage numbers,page numbers, formspage numbers, reportspage setuppages,pages, Analyze Salespages, chartspages, data entrypages, Filter button on record navigation barpages, Filter fields in PivotTable listspages, group filter control pages, grouped recordspages, overview of pages in Northwindpages, PivotTable listspages, queries$pages, read-only0pages, Review Orders8pages, Review Products<pages, Sales@pages, View ProductsDpercentages in reportsHpictures,Lpictures, background picture in reportTpictures, image controls in report headers and footersXpictures, OLE Object control\PivotTable lists in data access pages`Preview macrohpreviewing reportslPrint macropprinting,xprinting, canceling printing of reports without dataprinting, labels using dialog box;Cprinting, records using AutoKey macroprinting, report header on two pagesprinting, reports from a formprinting, reports from dialog boxProduct List formProducts formprompting for critieriaqueries,queries, criteriaqueries, crosstabqueries, data access pagesqueries, overview of queries in Northwindqueries, unionquitting Microsoft Access using event procedureread-only data access pagesread-only formsrecord navigation controls in data access pagesRelationships windowreports,reports, Catalog$reports, Employee Sales by Country(reports, output to HTML format,reports, overview of reports in Northwind0reports, previewing4reports, printing from dialog box8reports, printing from form<reports, Products by Category@reports, Sales by CategoryDrequerying combo boxesHresetting page numbers in reportsLReview Orders data access pagePReview Products data access pageTrounding currency valuesXSales by Category report and subreport\Sales data access page`Sales Reports Dialog formdSample AutoKeys macro grouphSELECT statement (SQL)lsizing columns in multiple-column reportspsizing subreportstSQL SELECT statementxsubforms|subreportssubtotals,subtotals, data access pagessubtotals, formssubtotals, queriessubtotals, reportsSum functionSuppliers formswitchboard formstab controlstables in Northwindtabular formsText fieldsTopValues propertytotals,totals, data access pagestotals, formstotals, queriestotals, reportsupdating combo boxes values, returning date valuesView Products data access pageWeb, hyperlink toyear value, returningYes/No fields printing, labels using dialog boxdialog boxes, using to get query criterialinking charts to reportsprinting, records using AutoKey macroe\A *':sr^Q ʄÍa/&;)F24YacconDataAccessPagesInNorthwindacrefAnalyzeSalesDataAccessPageacrefReviewOrdersDataAccessPageacrefReviewProductsDataAccessPage acrefSalesProjectionsDataAccessPageacrefViewProductsDataAccessPageCatalogReportCustomerPhoneListFormEmployeeSalesByCountryReport EmployeesForm$FormsInNorthwind(OrdersForm,OverviewOfNorthwind0ProductsByCategory4QueriesInNorthwind8QueriesThatCalculateTotals<QueriesThatUseCriteria@ReportsInNorthwindDSalesByCategoryReportHSalesReportsDialogFormLSuppliersFormPTablesInNorthwindTUnionAndCrosstabQueriesX/&;)LzOverview of NorthwindTables in NorthwindQueries in NorthwindUnion and crosstab queriesʄQueries that use criteria or properties to limit the records returnedQueries that calculate totalsData access pages in NorthwindAnalyze Sales data access pageReview Orders data access pageA Review Products data access page*Sales data access page'View Products data access page^Forms in NorthwindsCustomer Phone List formEmployees and Employees (page break) formsOrders form and Orders SubformaSuppliers, Products, and Product List formsCustomer Labels Dialog, Sales Reports Dialog, and Main Switchboard formsÍReports in Northwind:Catalog reportrEmployee Sales by Country reportQ Products By Category reportSales By Category report, Sales by Category Subreport/&;)L48ʄA *'^saÍ:rQ /&;)L48湎s!Bʄ:͌!54rbK]d@Q <5:ģF,I;lTa V'U W^VgWuwzaÍ6fhA nMtOy*SPC(16777215):FH()CS():FH():CW(`main'):FH():RR("HLP95EN.DLL","MsoSF",""):RR("HLP95EN.DLL","MsoCF","I=SII"):FH():MsoCF("Arial",8,0):CBB(`btn_topics',`NS():JI(`>main',`HelpTopicsButton'):FH():CS():FH():FD()'):SPC(14811135):FH():RR("USER32.DLL","PostMessage","UUUU"):RR("USER32.DLL","FindWindow","U=su"):RR("USER32.DLL","RegisterWindowMessage","U=s"):RR("USER32.DLL","SetForegroundWindow","U"):RR("USER32.DLL","ShowWindow","UU"):RR("USER32.DLL","IsIconic","U=U"):RR("USER32.DLL","WinHelp","USUU")CS():FH():CW(`main'):FH():RR("HLP95EN.DLL","MsoSF",""):RR("HLP95EN.DLL","MsoCF","I=SII"):FH():MsoCF("Arial",8,0):CBB(`btn_topics',`NS():JI(`>main',`HelpTopicsButton'):FH():CS():FH():FD()'):SPC(14811135):FH():RR("USER32.DLL","PostMessage","UUUU"):RR("USER32.DLL","FindWindow","U=su"):RR("USER32.DLL","RegisterWindowMessage","U=s"):RR("USER32.DLL","SetForegroundWindow","U"):RR("USER32.DLL","ShowWindow","UU"):RR("USER32.DLL","IsIconic","U=U"):RR("USER32.DLL","WinHelp","USUU")CS():FH():CW(`main'):FH():RR("HLP95EN.DLL","MsoSF",""):RR("HLP95EN.DLL","MsoCF","I=SII"):FH():MsoCF("Arial",8,0):CBB(`btn_topics',`NS():JI(`>main',`HelpTopicsButton'):FH():CS():FH():FD()'):SPC(16777215):FH():RR("USER32.DLL","PostMessage","UUUU"):RR("USER32.DLL","FindWindow","U=su"):RR("USER32.DLL","RegisterWindowMessage","U=s"):RR("USER32.DLL","SetForegroundWindow","U"):RR("USER32.DLL","ShowWindow","UU"):RR("USER32.DLL","IsIconic","U=U"):RR("USER32.DLL","WinHelp","USUU")CS():FH():CW(`main'):FH():RR("HLP95EN.DLL","MsoSF",""):RR("HLP95EN.DLL","MsoCF","I=SII"):FH():MsoCF("Arial",8,0):CBB(`btn_topics',`NS():JI(`>main',`HelpTopicsButton'):FH():CS():FH():FD()'):SPC(14811135):FH():RR("USER32.DLL","PostMessage","UUUU"):RR("USER32.DLL","FindWindow","U=su"):RR("USER32.DLL","RegisterWindowMessage","U=s"):RR("USER32.DLL","SetForegroundWindow","U"):RR("USER32.DLL","ShowWindow","UU"):RR("USER32.DLL","IsIconic","U=U"):RR("USER32.DLL","WinHelp","USUU")CS():FH():CW(`main'):FH():RR("HLP95EN.DLL","MsoSF",""):RR("HLP95EN.DLL","MsoCF","I=SII"):FH():MsoCF("Arial",8,0):CBB(`btn_topics',`NS():JI(`>main',`HelpTopicsButton'):FH():CS():FH():FD()'):SPC(14811135):FH():RR("USER32.DLL","PostMessage","UUUU"):RR("USER32.DLL","FindWindow","U=su"):RR("USER32.DLL","RegisterWindowMessage","U=s"):RR("USER32.DLL","SetForegroundWindow","U"):RR("USER32.DLL","ShowWindow","UU"):RR("USER32.DLL","IsIconic","U=U"):RR("USER32.DLL","WinHelp","USUU")CS():FH():CW(`main'):FH():RR("HLP95EN.DLL","MsoSF",""):RR("HLP95EN.DLL","MsoCF","I=SII"):FH():MsoCF("Arial",8,0):CBB(`btn_topics',`NS():JI(`>main',`HelpTopicsButton'):FH():CS():FH():FD()'):SPC(16777215):FH():RR("USER32.DLL","PostMessage","UUUU"):RR("USER32.DLL","FindWindow","U=su"):RR("USER32.DLL","RegisterWindowMessage","U=s"):RR("USER32.DLL","SetForegroundWindow","U"):RR("USER32.DLL","ShowWindow","UU"):RR("USER32.DLL","IsIconic","U=U") CS():FH():CW(`main'):FH():RR("HLP95EN.DLL","MsoSF",""):RR("HLP95EN.DLL","MsoCF","I=SII"):FH():MsoCF("Arial",8,0):CBB(`btn_topics',`DeleteMark(`SerCard'):NS():JI(`>main',`HelpTopicsButton'):FH():CS():FH():FD()'):SPC(14811135):FH():BrowseButtons():RR("USER32.DLL","PostMessage","UUUU"):RR("USER32.DLL","FindWindow","U=su"):RR("USER32.DLL","RegisterWindowMessage","U=s"):RR("USER32.DLL","SetForegroundWindow","U"):RR("USER32.DLL","ShowWindow","UU"):RR("USER32.DLL","IsIconic","U=U"):RR("USER32.DLL","WinHelp","USUU")SPC(16777215):FH()