{\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 \styrsid9835896 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 \styrsid9835896 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 \styrsid9835896 Normal (Web);}}
{\*\latentstyles\lsdstimax156\lsdlockeddef0}{\*\listtable{\list\listtemplateid-751653010{\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 ;}\listid691689607}
{\list\listtemplateid-1815692008{\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 ;}\listid1034383265}{\list\listtemplateid19289118{\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 ;}\listid1700546994}}{\*\listoverridetable{\listoverride\listid1034383265\listoverridecount0\ls1}{\listoverride\listid1700546994\listoverridecount0\ls2}{\listoverride\listid691689607
\listoverridecount0\ls3}}{\*\pgptbl {\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}}{\*\rsidtbl \rsid9835896}{\*\generator Microsoft Word 11.0.5604;}{\info{\title Microsoft\'ae Office Access\'ae 2010: Level 2}{\author IndumathiD}{\operator IndumathiD}
{\creatim\yr2010\mo9\dy1\hr11\min57}{\revtim\yr2010\mo9\dy1\hr12\min2}{\version1}{\edmins5}{\nofpages2}{\nofwords542}{\nofchars3096}{\*\company Element  K India}{\nofcharsws3631}{\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\rsidroot9835896\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\pararsid9835896 \b\fs36\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9835896 Microsoft\'ae Office Access\'ae
 2010: Level 2
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid9835896 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9835896 Course Specifications
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9835896 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid9835896 Course number: }{\f1\fs20\insrsid9835896 084588\line }{
\b\f1\fs20\insrsid9835896 Course length: }{\f1\fs20\insrsid9835896 1.0 day(s)
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid9835896 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9835896 Course Description
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9835896 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid9835896 Course Objective: }{\f1\fs20\insrsid9835896 
You will improve and customize tables, queries, forms and reports, and share Access data with other applications.\line \line }{\b\f1\fs20\insrsid9835896 Target Student: }{\f1\fs20\insrsid9835896 
This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft\'ae Office Access\'ae program. The target student may also include individuals whose job responsibilities include creating dat
abases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.\line \line }{
\b\f1\fs20\insrsid9835896 Prerequisites: }{\f1\fs20\insrsid9835896 To ensure your success, we recommend that you first take one of Element K\rquote s introductory courses, such as }{\i\f1\fs20\insrsid9835896 Microsoft\'ae Office Access\'ae 2010 : Level 1,
}{\f1\fs20\insrsid9835896  or have equivalent knowledge and skills. 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid9835896 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9835896 Hardware Requirements
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9835896 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid9835896 
\par }{\f1\fs20\insrsid9835896 For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configuration: 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \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\pararsid9835896 {
\f1\fs20\insrsid9835896 1 GHz Pentium-class processor or faster. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Minimum 1 GB of RAM is recommended. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \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 Office installation.) 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}CD-ROM drive. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Mouse or other pointing device. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}1024 x 768 resolution monitor. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Network cards and cabling for local network access. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Internet access. (Contact your local network administrator.) 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \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\insrsid9835896 \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\pararsid9835896 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9835896 
\par }{\f1\insrsid9835896 Software Requirements
\par }\pard\plain \s15\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9835896 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid9835896 Each computer requir
es the following software:
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \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\ls2\adjustright\rin0\lin720\itap0\pararsid9835896 
\fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid9835896 Microsoft\'ae Office Professional Plus 2010. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Windows XP Professional with Service Pack 3. 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid9835896 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9835896 
\par }{\f1\insrsid9835896 Course Objectives
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9835896 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid9835896 Upon successful completion of this course, students will be able to: 

\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls3\adjustright\rin0\lin720\itap0\pararsid9835896 {
\f1\fs20\insrsid9835896 streamline data entry and maintain data integrity. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}join tables to retrieve data from unrelated tables. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}improve forms. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}customize reports to organize the displayed information and produce specific print layouts. 
\par {\listtext\pard\plain\f3\fs20\insrsid9835896 \loch\af3\dbch\af0\hich\f3 \'b7\tab}share data between Access and other applications. 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid9835896 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9835896 Course Content
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9835896 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid9835896 Lesson 1: Controlling Data Entry}{\f1\fs20\insrsid9835896 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9835896 {\b\f1\fs20\insrsid9835896 Topic 1A: }{\f1\fs20\insrsid9835896 Constrain Data Entry Using Field Properties 
\par }{\b\f1\fs20\insrsid9835896 Topic 1B: }{\f1\fs20\insrsid9835896 Establish Data Entry Formats for Entering Field Values 
\par }{\b\f1\fs20\insrsid9835896 Topic 1C: }{\f1\fs20\insrsid9835896 Create a List of Values for a Field 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9835896 {\b\f1\fs20\insrsid9835896 Lesson 2: Joining Tables}{\f1\fs20\insrsid9835896 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9835896 {\b\f1\fs20\insrsid9835896 Topic 2A: }{\f1\fs20\insrsid9835896 Create Query Joins 
\par }{\b\f1\fs20\insrsid9835896 Topic 2B: }{\f1\fs20\insrsid9835896 Join Tables with No Common Fields 
\par }{\b\f1\fs20\insrsid9835896 Topic 2C: }{\f1\fs20\insrsid9835896 Relate Data Within a Table 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9835896 {\b\f1\fs20\insrsid9835896 Lesson 3: Creating Flexible Queries}{\f1\fs20\insrsid9835896 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9835896 {\b\f1\fs20\insrsid9835896 Topic 3A: }{\f1\fs20\insrsid9835896 Set the Select Query Properties 
\par }{\b\f1\fs20\insrsid9835896 Topic 3B: }{\f1\fs20\insrsid9835896 Retrieve Records Based on Input Criteria 
\par }{\b\f1\fs20\insrsid9835896 Topic 3C: }{\f1\fs20\insrsid9835896 Create Action Queries 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9835896 {\b\f1\fs20\insrsid9835896 Lesson 4: Improving Forms}{\f1\fs20\insrsid9835896 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9835896 {\b\f1\fs20\insrsid9835896 Topic 4A: }{\f1\fs20\insrsid9835896 Restrict Data Entry in Forms 
\par }{\b\f1\fs20\insrsid9835896 Topic 4B: }{\f1\fs20\insrsid9835896 Organize Information with Tab Pages 
\par }{\b\f1\fs20\insrsid9835896 Topic 4C: }{\f1\fs20\insrsid9835896 Add a Command Button to a Form 
\par }{\b\f1\fs20\insrsid9835896 Topic 4D: }{\f1\fs20\insrsid9835896 Create a Subform 
\par }{\b\f1\fs20\insrsid9835896 Topic 4E: }{\f1\fs20\insrsid9835896 Display a Summary of Data in a Form 
\par }{\b\f1\fs20\insrsid9835896 Topic 4F: }{\f1\fs20\insrsid9835896 Change the Display of Data Conditionally 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9835896 {\b\f1\fs20\insrsid9835896 Lesson 5: Customizing Reports}{\f1\fs20\insrsid9835896 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9835896 {\b\f1\fs20\insrsid9835896 Topic 5A: }{\f1\fs20\insrsid9835896 Organize Report Information 
\par }{\b\f1\fs20\insrsid9835896 Topic 5B: }{\f1\fs20\insrsid9835896 Format Reports 
\par }{\b\f1\fs20\insrsid9835896 Topic 5C: }{\f1\fs20\insrsid9835896 Control Report Pagination 
\par }{\b\f1\fs20\insrsid9835896 Topic 5D: }{\f1\fs20\insrsid9835896 Summarize Report Information 
\par }{\b\f1\fs20\insrsid9835896 Topic 5E: }{\f1\fs20\insrsid9835896 Add a Subreport to an Existing Report 
\par }{\b\f1\fs20\insrsid9835896 Topic 5F: }{\f1\fs20\insrsid9835896 Create a Mailing Label Report 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9835896 {\b\f1\fs20\insrsid9835896 Lesson 6: Sharing Data Across Applications}{\f1\fs20\insrsid9835896 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9835896 {\b\f1\fs20\insrsid9835896 Topic 6A: }{\f1\fs20\insrsid9835896 Import Data into Access 
\par }{\b\f1\fs20\insrsid9835896 Topic 6B: }{\f1\fs20\insrsid9835896 Export Data to Text File Formats 
\par }{\b\f1\fs20\insrsid9835896 Topic 6C: }{\f1\fs20\insrsid9835896 Export Access Data to Excel 
\par }{\b\f1\fs20\insrsid9835896 Topic 6D: }{\f1\fs20\insrsid9835896 Create a Mail Merge 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\insrsid9835896 
\par }}