{\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\listtemplateid1305135044\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1053591528\'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\leveltemplateid1250707754\'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\leveltemplateid630461580 \'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 \leveltemplateid2094836472\'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\leveltemplateid1655880670\'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-1393402240\'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-390808252\'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\leveltemplateid2105158914\'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\leveltemplateid712698098\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li6480 \jclisttab\tx6480 }{\listname ;}\listid115221810}{\list\listtemplateid-1824733330\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1429387344 \'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 \leveltemplateid2113023258\'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-1055080226\'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\leveltemplateid-1194526904\'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\leveltemplateid546442432\'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-2041959962\'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-1363104048\'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\leveltemplateid-466569730\'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\leveltemplateid1872890576\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20 \chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li6480\jclisttab\tx6480 }{\listname ;}\listid1292133684}}{\*\listoverridetable{\listoverride\listid1292133684\listoverridecount0\ls1}{\listoverride\listid115221810\listoverridecount0\ls2} }{\info{\title 076401}{\author Cory Brown}{\operator Cory Brown}{\creatim\yr2003\mo1\dy7\hr15\min18}{\revtim\yr2003\mo1\dy7\hr15\min33}{\version3}{\edmins2}{\nofpages2}{\nofwords777}{\nofchars4433}{\*\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: Level 2 \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: 076401\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: Level 2 }{\f1\fs20 \hich\af1\dbch\af28\loch\f1 is a hands-on instru\hich\af1\dbch\af28\loch\f1 ction book that will help you enhance your database designs by using the principles of data normalization and table relationships, querying multiple tables for data used in customized forms and reports, and using data access pages. \par }\pard\plain \ql \li0\ri0\sa240\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 Studen\hich\af1\dbch\af28\loch\f1 ts enrolling in this course should have a basic level of understanding of the Access 2000 interface, and should have experience designing tables, simple queries, forms, and reports.\line \line }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Prerequisites:\~\~}{ \f1\fs20 \hich\af1\dbch\af28\loch\f1 We designed }{\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Access 2000: Level 2 }{\f1\fs20 \hich\af1\dbch\af28\loch\f1 for the student who has\hich\af1\dbch\af28\loch\f1 a basic level of understanding of the Access 2000 interface, and has designed tables, simple\hich\af1\dbch\af28\loch\f1 queries, forms, and reports. \hich\af1\dbch\af28\loch\f1 The prerequisite for this course is }{\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Access 2000: Level 1}{\f1\fs20 \hich\af1\dbch\af28\loch\f1 .\line \line }{\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 learn \hich\af1\dbch\af28\loch\f1 ing 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 take the guesswork out of creating databases by using data-normalization techniques. They will learn how to take advantage of relational database efficiency to maintain d\hich\af1\dbch\af28\loch\f1 ata by establishing relationships and enforcing referential integrity. In addition, students will save data entry time by using sound table design techniques to control data entry and automate tasks. Students will also benefit by becoming familiar with Ac \hich\af1\dbch\af28\loch\f1 c\hich\af1\dbch\af28\loch\f1 ess features that will enable them to customize forms and reports, and to share data over an intranet or the Internet by creating and using data access pages.\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: Level 2}{\f1\fs20 \hich\af1\dbch\af28\loch\f1 is the second course in this series. }{\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Access 2000: Advanced}{\f1\fs20 \hich\af1\dbch\af28\loch\f1 , t\hich\af1\dbch\af28\loch\f1 he next course in this series, teaches students how to use a variety of query techniques, and how to create more efficient forms and reports, and macros. After taking the Advanced course, students who want to learn how to develop an application and tie th \hich\af1\dbch\af28\loch\f1 e\hich\af1\dbch\af28\loch\f1 objects together into a cohesive system by using macros and Visual Basic for Applications code can take }{\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Access 2000: Introduction to Application Development }{\f1\fs20 \hich\af1\dbch\af28\loch\f1 . \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 Level 2}{\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 states that Office 2000 can also run on Windows 95, Windows 2000, or Windows NT 4.0 with Service Pack 3 or higher installed, though some of the screen displ\hich\af1\dbch\af28\loch\f1 a\hich\af1\dbch\af28\loch\f1 ys 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\ls1\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 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 \hich\af1\dbch\af28\loch\f1 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 installation 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 mo\hich\af1\dbch\af28\loch\f1 nitor; Super VGA 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 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 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 \hich\af1\dbch\af28\loch\f1 later) operating system, Microsoft Windows 2000, 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 installation \hich\af1\dbch\af28\loch\f1 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\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 Normalize tables through fifth normal form. \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 Establish relationships between tables and enforce referent\hich\af1\dbch\af28\loch\f1 ial integrity. \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 Maintain data integrity in tables by setting properties, creating a Lookup list, and creating indexes. \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 queries to calculate expressions and extract data from multiple tables. \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 Improve form designs by adding bound controls, calcul\hich\af1\dbch\af28\loch\f1 ated fields, and a combo box. \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 Create and modify data access pages, and integrate data with other applications. \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 Create and modify reports with the Report Wizard and Design View, add a subreport, and add a calculated control. \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:\hich\af1\dbch\af28\loch\f1 Principles of Table Design }{\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: Normalizing Data \par \hich\af1\dbch\af28\loch\f1 Topic 1B: Normalizing Data for Fourth and Fifth Normal Forms \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: Principles of Table Relationships }{\f1\fs20 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 2A: Analyzing Table Relationships \par \hich\af1\dbch\af28\loch\f1 Topic 2B: Establishing and Testing Referential Integrity \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: Table Design 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: Data Validation Techniques \par \hich\af1\dbch\af28\loch\f1 Topic 3B: Indexing Techniques \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: Designing Select 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 4A: Using Calculated Fields in Queries \par \hich\af1\dbch\af28\loch\f1 Topic 4B: \hich\af1\dbch\af28\loch\f1 Creating Multiple-table 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 5: Customizing Form Designs }{\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: Customizing the Form Design \par \hich\af1\dbch\af28\loch\f1 Topic 5B: Performing Calculations on a Form \par \hich\af1\dbch\af28\loch\f1 Topic 5C: Adding Combo Boxes to a Form \par \hich\af1\dbch\af28\loch\f1 Topic 5D: Adding Unbound Controls \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: Working with Dat\hich\af1\dbch\af28\loch\f1 a Access Pages }{\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: Creating Data Access Pages \par \hich\af1\dbch\af28\loch\f1 Topic 6B: Integrating with Other Applications \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: Customizing Reports }{\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: Customizing a Report Created by the Report Wizard \par \hich\af1\dbch\af28\loch\f1 Topic 7B: Working with Subreports \par \hich\af1\dbch\af28\loch\f1 Topic 7C: Creating a Report\hich\af1\dbch\af28\loch\f1 in Design View \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 { \par }}