{\rtf1\ansi\ansicpg1252\uc1\deff0\stshfdbch0\stshfloch0\stshfhich0\stshfbi0\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;}{\f10\fnil\fcharset2\fprq2{\*\panose 05000000000000000000}Wingdings;} {\f36\froman\fcharset238\fprq2 Times New Roman CE;}{\f37\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f39\froman\fcharset161\fprq2 Times New Roman Greek;}{\f40\froman\fcharset162\fprq2 Times New Roman Tur;} {\f41\froman\fcharset177\fprq2 Times New Roman (Hebrew);}{\f42\froman\fcharset178\fprq2 Times New Roman (Arabic);}{\f43\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f44\froman\fcharset163\fprq2 Times New Roman (Vietnamese);} {\f46\fswiss\fcharset238\fprq2 Arial CE;}{\f47\fswiss\fcharset204\fprq2 Arial Cyr;}{\f49\fswiss\fcharset161\fprq2 Arial Greek;}{\f50\fswiss\fcharset162\fprq2 Arial Tur;}{\f51\fswiss\fcharset177\fprq2 Arial (Hebrew);} {\f52\fswiss\fcharset178\fprq2 Arial (Arabic);}{\f53\fswiss\fcharset186\fprq2 Arial Baltic;}{\f54\fswiss\fcharset163\fprq2 Arial (Vietnamese);}{\f56\fmodern\fcharset238\fprq1 Courier New CE;}{\f57\fmodern\fcharset204\fprq1 Courier New Cyr;} {\f59\fmodern\fcharset161\fprq1 Courier New Greek;}{\f60\fmodern\fcharset162\fprq1 Courier New Tur;}{\f61\fmodern\fcharset177\fprq1 Courier New (Hebrew);}{\f62\fmodern\fcharset178\fprq1 Courier New (Arabic);} {\f63\fmodern\fcharset186\fprq1 Courier New Baltic;}{\f64\fmodern\fcharset163\fprq1 Courier New (Vietnamese);}}{\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\cgrid\langnp1033\langfenp1033 \snext0 Normal;}{ \s2\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel1\adjustright\rin0\lin0\itap0 \b\fs36\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext2 \styrsid6579671 heading 2;}{ \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext3 \styrsid6579671 heading 3;}{\*\cs10 \additive \ssemihidden Default Paragraph Font;}{\*\ts11\tsrowd\trftsWidthB3\trpaddl108\trpaddr108\trpaddfl3\trpaddft3\trpaddfb3\trpaddfr3\trcbpat1\trcfpat1\tscellwidthfts0\tsvertalt\tsbrdrt\tsbrdrl\tsbrdrb\tsbrdrr\tsbrdrdgl\tsbrdrdgr\tsbrdrh\tsbrdrv \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs20\lang1024\langfe1024\cgrid\langnp1024\langfenp1024 \snext11 \ssemihidden Normal Table;}{ \s15\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext15 \styrsid6579671 Normal (Web);}} {\*\latentstyles\lsdstimax156\lsdlockeddef0}{\*\listtable{\list\listtemplateid-1989387096{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fs20\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 }{\listlevel \levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0 \levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0 \levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li4320\jclisttab\tx4320\lin4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5040\jclisttab\tx5040\lin5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5760\jclisttab\tx5760\lin5760 } {\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li6480\jclisttab\tx6480\lin6480 }{\listname ;}\listid623266962} {\list\listtemplateid2134825366{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listlevel\levelnfc23 \levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fs20\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1 \levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li4320\jclisttab\tx4320\lin4320 } {\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5040\jclisttab\tx5040\lin5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0 \leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5760\jclisttab\tx5760\lin5760 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0 \levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li6480\jclisttab\tx6480\lin6480 }{\listname ;}\listid1006439612}{\list\listtemplateid-411672808{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1 \levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01o;}{\levelnumbers;}\f2\fs20\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 } {\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0 \leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li4320\jclisttab\tx4320\lin4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0 \levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5040\jclisttab\tx5040\lin5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5760\jclisttab\tx5760\lin5760 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li6480\jclisttab\tx6480\lin6480 }{\listname ;}\listid1987393552}{\list\listtemplateid169617250{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;} \f3\fs20\fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fs20\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 } {\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0 \leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0 \levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li4320\jclisttab\tx4320\lin4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5040\jclisttab\tx5040\lin5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5760\jclisttab\tx5760\lin5760 } {\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li6480\jclisttab\tx6480\lin6480 }{\listname ;}\listid2018263564}} {\*\listoverridetable{\listoverride\listid1987393552\listoverridecount0\ls1}{\listoverride\listid1006439612\listoverridecount0\ls2}{\listoverride\listid2018263564\listoverridecount0\ls3}{\listoverride\listid623266962\listoverridecount0\ls4}}{\*\pgptbl {\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}}{\*\rsidtbl \rsid6579671}{\*\generator Microsoft Word 11.0.5604;}{\info{\title Microsoft\'ae Office Access\'ae 2010: Level 1}{\author IndumathiD}{\operator IndumathiD}{\creatim\yr2010\mo12\dy30\hr11\min36} {\revtim\yr2010\mo12\dy30\hr11\min40}{\version1}{\edmins4}{\nofpages3}{\nofwords622}{\nofchars3546}{\*\company Element K India}{\nofcharsws4160}{\vern24689}} \widowctrl\ftnbj\aenddoc\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb\nospaceforul\formshade\horzdoc\dgmargin\dghspace180\dgvspace180\dghorigin1800\dgvorigin1440\dghshow1\dgvshow1 \jexpand\viewkind1\viewscale100\pgbrdrhead\pgbrdrfoot\splytwnine\ftnlytwnine\htmautsp\nolnhtadjtbl\useltbaln\alntblind\lytcalctblwd\lyttblrtgr\lnbrkrule\nobrkwrptbl\snaptogridincell\allowfieldendsel\wrppunct \asianbrkrule\rsidroot6579671\newtblstyruls\nogrowautofit \fet0\sectd \linex0\endnhere\sectlinegrid360\sectdefaultcl\sftnbj {\*\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\pararsid6579671 \b\fs36\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid6579671 Microsoft\'ae Office Access\'ae 2010: Level 1 \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid6579671 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid6579671 Course Specifications \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid6579671 Course number: }{\f1\fs20\insrsid6579671 084587\line }{ \b\f1\fs20\insrsid6579671 Course length: }{\f1\fs20\insrsid6579671 1.0 day(s)\line }{\b\f1\fs20\insrsid6579671 Certification: }{\f1\fs20\insrsid6579671 MOS: Microsoft Office Access 2010 Exam 77\endash 885 \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid6579671 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid6579671 Course Description \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid6579671 Course Objective: }{\f1\fs20\insrsid6579671 You will create and modify new databases and their various objects.\line \line }{\b\f1\fs20\insrsid6579671 Target Student: }{\f1\fs20\insrsid6579671 This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and who want to use the appl ication to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.\line \line }{ \b\f1\fs20\insrsid6579671 Prerequisites: }{\f1\fs20\insrsid6579671 To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Spe c ifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take one of Element K's introductory Windows courses, such as either of the following, or have equivalent skills and knowledge: \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\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\pararsid6579671 { \f1\fs20\insrsid6579671 Windows XP Professional: Level 1 or \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Windows XP: Introduction \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid6579671 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid6579671 Certification \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid6579671 This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certificati on skill sets. The MOS and certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid6579671 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid6579671 Hardware Requirements \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid6579671 For this course, you will need one compu ter for each student and one for the instructor. Each computer will need the following minimum hardware components: \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls2\adjustright\rin0\lin720\itap0\pararsid6579671 { \f1\fs20\insrsid6579671 1 GHz Pentium-class processor or faster \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Minimum 256 MB of RAM. 512 MB of RAM is recommended \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}10 GB hard disk or larger. (You should have at least 1 GB of free hard disk space available for the Office installation.) \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}CD-ROM drive \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Mouse or other pointing device \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}1024 x 768 resolution monitor recommended \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Network cards and cabling for local network access \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Internet access (contact your local network administrator) \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Printer (optional) or 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\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Projection system to display the instructor\rquote s computer screen \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid6579671 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid6579671 Software Requirements \par }\pard\plain \s15\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid6579671 Each computer requires the following software: \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\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\pararsid6579671 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid6579671 Microsoft\'ae Office Professional Plus 2010 Edition \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Microsoft\'ae Office Suite Service Pack 1 \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Microsoft\'ae Windows\'ae XP Professional with Service Pack 2 \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid6579671 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid6579671 Course Objectives \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid6579671 Upon successful completion of this course, students will be able to: \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls4\adjustright\rin0\lin720\itap0\pararsid6579671 { \f1\fs20\insrsid6579671 identify the basic components of an Access database. \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}build the structure of a database. \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}manage data in tables. \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}query a database. \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}design forms. \par {\listtext\pard\plain\f3\fs20\insrsid6579671 \loch\af3\dbch\af0\hich\f3 \'b7\tab}generate reports. \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid6579671 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid6579671 Course Content \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid6579671 Lesson 1: Getting Started with Access Databases}{ \b\f1\fs20\insrsid6579671 \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Topic 1A: }{\f1\fs20\insrsid6579671 Identify the Elements of the Access 2010 Interface \par }{\b\f1\fs20\insrsid6579671 Topic 1B: }{\f1\fs20\insrsid6579671 Identify the Components of a Database \par }{\b\f1\fs20\insrsid6579671 Topic 1C: }{\f1\fs20\insrsid6579671 Examine the Relational Database Design Process }{\f1\fs20\insrsid6579671 \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Lesson 2: Building the Structure of a Database}{\b\f1\fs20\insrsid6579671 \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Topic 2A: }{\f1\fs20\insrsid6579671 Create a New Database \par }{\b\f1\fs20\insrsid6579671 Topic 2B: }{\f1\fs20\insrsid6579671 Create a Table Using the Design View \par }{\b\f1\fs20\insrsid6579671 Topic 2C: }{\f1\fs20\insrsid6579671 Manage Tables \par }{\b\f1\fs20\insrsid6579671 Topic 2D: }{\f1\fs20\insrsid6579671 Establish Table Relationships }{\f1\fs20\insrsid6579671 \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Lesson 3: Managing Data in a Table}{\b\f1\fs20\insrsid6579671 \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Topic 3A: }{\f1\fs20\insrsid6579671 Modify Table Data \par }{\b\f1\fs20\insrsid6579671 Topic 3B: }{\f1\fs20\insrsid6579671 Sort and Filter Records \par }{\b\f1\fs20\insrsid6579671 Topic 3C: }{\f1\fs20\insrsid6579671 Work with Subdatasheets }{\f1\fs20\insrsid6579671 \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Lesson 4: Querying a Database}{\b\f1\fs20\insrsid6579671 \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Topic 4A: }{\f1\fs20\insrsid6579671 Create a Query \par }{\b\f1\fs20\insrsid6579671 Topic 4B: }{\f1\fs20\insrsid6579671 Add Criteria to a Query \par }{\b\f1\fs20\insrsid6579671 Topic 4C: }{\f1\fs20\insrsid6579671 Add a Calculated Field to a Query \par }{\b\f1\fs20\insrsid6579671 Topic 4D: }{\f1\fs20\insrsid6579671 Perform Calculations on a Record Grouping }{\f1\fs20\insrsid6579671 \par \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Lesson 5: Designing Forms}{\b\f1\fs20\insrsid6579671 \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Topic 5A: }{\f1\fs20\insrsid6579671 Create a Form \par }{\b\f1\fs20\insrsid6579671 Topic 5B: }{\f1\fs20\insrsid6579671 Modify the Design of a Form \par }{\b\f1\fs20\insrsid6579671 Topic 5C: }{\f1\fs20\insrsid6579671 View and Edit Data Using an Access Form }{\f1\fs20\insrsid6579671 \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Lesson 6: Generating Reports}{\b\f1\fs20\insrsid6579671 \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Topic 6A: }{\f1\fs20\insrsid6579671 Create a Report \par }{\b\f1\fs20\insrsid6579671 Topic 6B: }{\f1\fs20\insrsid6579671 Add a Control to a Report \par }{\b\f1\fs20\insrsid6579671 Topic 6C: }{\f1\fs20\insrsid6579671 Format the Controls in a Report \par }{\b\f1\fs20\insrsid6579671 Topic 6D: }{\f1\fs20\insrsid6579671 Enhance the Appearance of a Report }{\f1\fs20\insrsid6579671 \par }{\b\f1\fs20\insrsid6579671 Topic 6E: }{\f1\fs20\insrsid6579671 Prepare a Report for Print }{\f1\fs20\insrsid6579671 \par }{\f1\fs20\insrsid6579671 \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid6579671 {\b\f1\fs20\insrsid6579671 Appendix A: Microsoft Office Access 2010 Exam 77\endash 885}{\insrsid6579671 \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\insrsid6579671 \par }}