{\rtf1\ansi\ansicpg1252\uc1 \deff28\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\panose 02020603050405020304}Times New Roman;}{\f1\fswiss\fcharset0\fprq2{\*\panose 020b0604020202020204}Arial;}
{\f2\fmodern\fcharset0\fprq1{\*\panose 02070309020205020404}Courier New;}{\f3\froman\fcharset2\fprq2{\*\panose 05050102010706020507}Symbol;}{\f14\fnil\fcharset2\fprq2{\*\panose 05000000000000000000}Wingdings;}
{\f28\fswiss\fcharset128\fprq2{\*\panose 020b0604020202020204}Arial Unicode MS;}{\f29\fswiss\fcharset128\fprq2{\*\panose 00000000000000000000}@Arial Unicode MS;}{\f46\froman\fcharset238\fprq2 Times New Roman CE;}
{\f47\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f49\froman\fcharset161\fprq2 Times New Roman Greek;}{\f50\froman\fcharset162\fprq2 Times New Roman Tur;}{\f51\froman\fcharset177\fprq2 Times New Roman (Hebrew);}
{\f52\froman\fcharset178\fprq2 Times New Roman (Arabic);}{\f53\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f54\fswiss\fcharset238\fprq2 Arial CE;}{\f55\fswiss\fcharset204\fprq2 Arial Cyr;}{\f57\fswiss\fcharset161\fprq2 Arial Greek;}
{\f58\fswiss\fcharset162\fprq2 Arial Tur;}{\f59\fswiss\fcharset177\fprq2 Arial (Hebrew);}{\f60\fswiss\fcharset178\fprq2 Arial (Arabic);}{\f61\fswiss\fcharset186\fprq2 Arial Baltic;}{\f62\fmodern\fcharset238\fprq1 Courier New CE;}
{\f63\fmodern\fcharset204\fprq1 Courier New Cyr;}{\f65\fmodern\fcharset161\fprq1 Courier New Greek;}{\f66\fmodern\fcharset162\fprq1 Courier New Tur;}{\f67\fmodern\fcharset177\fprq1 Courier New (Hebrew);}
{\f68\fmodern\fcharset178\fprq1 Courier New (Arabic);}{\f69\fmodern\fcharset186\fprq1 Courier New Baltic;}{\f272\fswiss\fcharset0\fprq2 Arial Unicode MS Western;}{\f270\fswiss\fcharset238\fprq2 Arial Unicode MS CE;}
{\f271\fswiss\fcharset204\fprq2 Arial Unicode MS Cyr;}{\f273\fswiss\fcharset161\fprq2 Arial Unicode MS Greek;}{\f274\fswiss\fcharset162\fprq2 Arial Unicode MS Tur;}{\f275\fswiss\fcharset177\fprq2 Arial Unicode MS (Hebrew);}
{\f276\fswiss\fcharset178\fprq2 Arial Unicode MS (Arabic);}{\f277\fswiss\fcharset186\fprq2 Arial Unicode MS Baltic;}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;
\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128;\red192\green192\blue192;}
{\stylesheet{\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\f28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 \snext0 Normal;}{
\s2\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs36\lang1033\langfe1033\loch\f28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext2 heading 2;}{
\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel3\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\f28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext3 heading 3;}{\*\cs10 \additive 
Default Paragraph Font;}{\s15\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\f28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext15 Normal (Web);}}
{\*\listtable{\list\listtemplateid-247024244\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid953690820\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\chbrdr
\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li720\jclisttab\tx720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-28779318\'01o;}{\levelnumbers;}
\f2\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li1440\jclisttab\tx1440 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-968181794
\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2160\jclisttab\tx2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext
\leveltemplateid1566320686\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2880\jclisttab\tx2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0
\levelindent0{\leveltext\leveltemplateid-358718230\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li3600\jclisttab\tx3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0
\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-1050908452\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li4320\jclisttab\tx4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0
\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid376453838\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5040\jclisttab\tx5040 }{\listlevel\levelnfc23
\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1699897728\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5760\jclisttab\tx5760 }
{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-365284630\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 
\fi-360\li6480\jclisttab\tx6480 }{\listname ;}\listid23674756}{\list\listtemplateid-1238231648\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-106947600
\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li720\jclisttab\tx720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext
\leveltemplateid350391514\'01o;}{\levelnumbers;}\f2\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li1440\jclisttab\tx1440 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0
{\leveltext\leveltemplateid161898062\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2160\jclisttab\tx2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1
\levelspace0\levelindent0{\leveltext\leveltemplateid1682861466\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2880\jclisttab\tx2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0
\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid405590720\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li3600\jclisttab\tx3600 }{\listlevel\levelnfc23\levelnfcn23
\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-1359723470\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li4320\jclisttab\tx4320 }{\listlevel
\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-1013520902\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5040
\jclisttab\tx5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid818848158\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 
\chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5760\jclisttab\tx5760 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-895189048\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20
\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li6480\jclisttab\tx6480 }{\listname ;}\listid1174999242}{\list\listtemplateid-1201520310\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1
\levelspace0\levelindent0{\leveltext\leveltemplateid336217276\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li720\jclisttab\tx720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0
\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1364102052\'01o;}{\levelnumbers;}\f2\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li1440\jclisttab\tx1440 }{\listlevel\levelnfc23\levelnfcn23
\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-1828659032\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2160\jclisttab\tx2160 }{\listlevel
\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid362033436\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2880
\jclisttab\tx2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1298726672\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 
\chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li3600\jclisttab\tx3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-1528382726\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20
\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li4320\jclisttab\tx4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-1803280748
\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5040\jclisttab\tx5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext
\leveltemplateid2078172478\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5760\jclisttab\tx5760 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0
\levelindent0{\leveltext\leveltemplateid1835809978\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li6480\jclisttab\tx6480 }{\listname ;}\listid1312295147}}{\*\listoverridetable
{\listoverride\listid23674756\listoverridecount0\ls1}{\listoverride\listid1174999242\listoverridecount0\ls2}{\listoverride\listid1312295147\listoverridecount0\ls3}}{\info{\title 076402}{\author Cory  Brown}{\operator Cory  Brown}
{\creatim\yr2003\mo1\dy7\hr15\min22}{\revtim\yr2003\mo1\dy7\hr15\min36}{\version3}{\edmins1}{\nofpages2}{\nofwords763}{\nofchars4350}{\*\company Element K}{\nofcharsws0}{\vern8269}}
\widowctrl\ftnbj\aenddoc\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb\nospaceforul\hyphcaps0\formshade\horzdoc\dgmargin\dghspace180\dgvspace180\dghorigin1701\dgvorigin1984\dghshow1\dgvshow1
\jexpand\viewkind5\viewscale100\pgbrdrhead\pgbrdrfoot\splytwnine\ftnlytwnine\htmautsp\nolnhtadjtbl\useltbaln\alntblind\lytcalctblwd\lyttblrtgr\lnbrkrule \fet0\sectd \linex0\endnhere\pgbrdropt32\sectlinegrid360\sectdefaultcl {\*\pnseclvl1
\pnucrm\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl2\pnucltr\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl3\pndec\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl4\pnlcltr\pnstart1\pnindent720\pnhang{\pntxta )}}{\*\pnseclvl5
\pndec\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl6\pnlcltr\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl7\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl8\pnlcltr\pnstart1\pnindent720\pnhang
{\pntxtb (}{\pntxta )}}{\*\pnseclvl9\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}\pard\plain \s2\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel1\adjustright\rin0\lin0\itap0 
\b\fs36\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\hich\af28\dbch\af28\loch\f28 Access 2000: Advanced
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1 \hich\af1\dbch\af28\loch\f1 
Course Specifications
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Course number: 076402\line Course length: 
\hich\af1\dbch\af28\loch\f1 1 day\line Software: Access 2000\~9.0
\par \hich\af1\dbch\af28\loch\f1 Certification: Microsoft Office Specialist
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1 \hich\af1\dbch\af28\loch\f1 
Course Description
\par }\pard\plain \s15\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Access 2000: Advanced }{\f1\fs20 
\hich\af1\dbch\af28\loch\f1 
is a hands-on instruction book that will introduce you to advanced techniques in Access 2000. You will learn how to perform complex queries, create efficient forms and reports, create and use macros, use Internet-related Web tools, and carry out data inte
\hich\af1\dbch\af28\loch\f1 g\hich\af1\dbch\af28\loch\f1 ration procedures. 
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\b\f1\fs20 
\par \hich\af1\dbch\af28\loch\f1 Target Student:\~\~}{\f1\fs20 \hich\af1\dbch\af28\loch\f1 Students enrolling in this course should be able to work with Access at an intermediate level and understand Access terminology.\line \line }{\b\f1\fs20 
\hich\af1\dbch\af28\loch\f1 Prerequisites:\~\~}{\f1\fs20 \hich\af1\dbch\af28\loch\f1  To ensure your success with this course, we recommend that you first tak\hich\af1\dbch\af28\loch\f1 
e the following Element K Content courses or have equivalent knowledge: 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls1\adjustright\rin0\lin720\itap0 {\i\f1\fs20 
\hich\af1\dbch\af28\loch\f1 Access 2000: Level 1 }{\f1\fs20 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}{\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Access 2000: Level 2 }{\f1\fs20 
\par }\pard \ql \li0\ri0\sa240\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Delivery Method:\~\~}{\f1\fs20 \hich\af1\dbch\af28\loch\f1 
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.\line \line }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Benefits:\~\~}{\f1\fs20 \hich\af1\dbch\af28\loch\f1 
Students will learn how to analyze data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros, and become familiar with Internet-related Access tools.\line \line }{\b\f1\fs20 
\hich\af1\dbch\af28\loch\f1 What's Next:\~\~}{\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Access 2000: Introduction to Appli\hich\af1\dbch\af28\loch\f1 cation Development}{\f1\fs20 \hich\af1\dbch\af28\loch\f1 
, the next course in this series, teaches students how to develop custom applications by using Access.
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1 \hich\af1\dbch\af28\loch\f1 
Certification
\par }{\b0\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Access\hich\af1\dbch\af28\loch\f1  2000: \hich\af1\dbch\af28\loch\f1 Advanced}{\b0\f1\fs20 \hich\af1\dbch\af28\loch\f1 
 is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (Office Special\hich\af1\dbch\af28\loch\f1 ist) skill sets. The Office Specialist program is for individuals who use Microsoft\hich\f1 \rquote \loch\f1 
s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficien\hich\af1\dbch\af28\loch\f1 c\hich\af1\dbch\af28\loch\f1 
y exams in order to earn Office Specialist certification.}{\f1 
\par \hich\af1\dbch\af28\loch\f1 Hardware/Software Requirements
\par }\pard\plain \s15\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 
This course was developed using the Windows 98 platform; however, the manufacturer\hich\f1 \rquote \loch\f1 s documentation state\hich\af1\dbch\af28\loch\f1 
s that Office 2000 can also run on Windows 95 or Windows NT 4.0 with Service Pack 3 or higher installed, though some of the screen displays might be slightly different. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}\pard\plain \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls2\adjustright\rin0\lin720\itap0 
\fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 A Pentium 75 PC with 16 MB of RAM. (We recommend a Pentium 133 or faster with 32 MB \hich\af1\dbch\af28\loch\f1 or more.) 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 
600 MB of free hard-disk space. For optimal performance, we recommend an additional 100 MB of free hard-disk space for user graphics and temporary image caches. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Either a local CD-ROM drive or access to a networked CD-ROM drive for installat\hich\af1\dbch\af28\loch\f1 ion purposes. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 A 3.5"-disk drive. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 A two-button mouse, an IntelliMouse, or compatible pointing device. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 VGA or higher-resolution monitor; Super VGA is recommended. (The EGA display adapter is not supported.) 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 An installed printer driver. (Printers \hich\af1\dbch\af28\loch\f1 
are not required; however, each PC must have an installed printer driver to use Print Preview.) 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 An Internet \hich\af1\dbch\af28\loch\f1 
connection with access to the World Wide Web. The connection is necessary to complete some tasks and Web tips throughout the book. (Note: Internet access may require payment of a separate fee to a service provider.) 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Microsoft Windows 95 (or later) opera\hich\af1\dbch\af28\loch\f1 
ting system, Microsoft Windows 2000 operating system, Microsoft Windows NT Workstation operating system version 4.0 Service Pack 3 (or later). If you are running Windows NT, make sure that you have at least 4 MB of free Registry space. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 A custom installa\hich\af1\dbch\af28\loch\f1 tion of Microsoft Office 2000 Premium Edition\hich\f1 \emdash \loch\f1 
see the following section, Class Requirements, for additional instructions. 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1 \hich\af1\dbch\af28\loch\f1 
Performance-Based Objectives
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}\pard\plain \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls3\adjustright\rin0\lin720\itap0 
\fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Make select queries more versatile and useful by using parameters; and use action queries to update d\hich\af1\dbch\af28\loch\f1 
ata values and add or delete records. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Generate different query types by creating various types of joins between tables; and use crosstab queries to summarize data. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Use advanced form features including properties, functions, and design tools to facili\hich\af1\dbch\af28\loch\f1 
tate data entry and improve accuracy in forms; and display table information that has a one-to-many relationship by creating forms that contain subforms. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Automate tasks by creating macros to open forms and control form properties. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Make forms more fun\hich\af1\dbch\af28\loch\f1 ctional by using macros to provide user interaction and automate data entry. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Make reports more concise and easier to understand by using properties and functions in report controls. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Use Internet-related Access tools by inserting hyperlinks and using \hich\af1\dbch\af28\loch\f1 
the Web toolbar; and integrate Access data with other Office 2000 applications. 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1 \hich\af1\dbch\af28\loch\f1 
Course Content
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 1: Parameter and Action Queries }{
\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 1A: Creating Parameter Queries 
\par \hich\af1\dbch\af28\loch\f1 Topic 1B: Creating Action Queries 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 2: Query Joins and Crosstab Queries }{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 T\hich\af1\dbch\af28\loch\f1 opic 2A: Joining Tables and Working with Join Properties 
\par \hich\af1\dbch\af28\loch\f1 Topic 2B: Creating Crosstab Queries 
\par \hich\af1\dbch\af28\loch\f1 Topic 2C: Editing Limitations in Query Datasheets 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 3: Using Advanced Form Techniques }{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 3A: Organizing Field Placement 
\par \hich\af1\dbch\af28\loch\f1 Topic 3B: Using Functions to Control Data Entry 
\par \hich\af1\dbch\af28\loch\f1 Topic 3C: Adding an Option Group to a Form 
\par \hich\af1\dbch\af28\loch\f1 Topic 3D: Using a Form as the User Interface 
\par \hich\af1\dbch\af28\loch\f1 Topic 3E: Creating a Form that Contains a Subform 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 4: Creating Basic Macros to Automate Forms }{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 4A: Macro Basics 
\par \hich\af1\dbch\af28\loch\f1 Topic 4B: Attaching a Macro to a Command Button 
\par \hich\af1\dbch\af28\loch\f1 Topic 4C: Revising a Macro 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 5: Using Macros to Provide User Interaction and Automate Tasks }{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 5A: Using a Macro to Provide User Interaction 
\par \hich\af1\dbch\af28\loch\f1 Topic 5B: Using Macros to Auto\hich\af1\dbch\af28\loch\f1 mate Data Entry 
\par \hich\af1\dbch\af28\loch\f1 Topic 5C: AutoKeys and AutoExec Macros 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 6: Using Advanced Report Techniques }{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 6A: Customizing the Appearance and Functionality of a Report 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 7: Web Capabilities and Data Integration }{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 7A: Creating and Using Hyperli\hich\af1\dbch\af28\loch\f1 nks 
\par \hich\af1\dbch\af28\loch\f1 Topic 7B: Data Integration 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Appendix A: Replicating Databases }{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Using Simple Replication 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Appendix B: Encrypting Databases }{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Encrypting and Decrypting a Database 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Appendix C: Mailing Labels }{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 The Mailing Label Report Wizard 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {
\par }}