{\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;\red0\green0\blue102;} {\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 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 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 Normal (Web);}}{\*\latentstyles\lsdstimax156\lsdlockeddef0}{\*\listtable {\list\listtemplateid-2096990362{\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 ;}\listid325791998}{\list\listtemplateid-267079924{\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 ;}\listid442572894}{\list\listtemplateid-1312393630{\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 ;}\listid1800882199} {\list\listtemplateid1596220980{\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 ;}\listid1966741045}}{\*\listoverridetable{\listoverride\listid442572894\listoverridecount0\ls1}{\listoverride\listid1800882199 \listoverridecount0\ls2}{\listoverride\listid325791998\listoverridecount0\ls3}{\listoverride\listid1966741045\listoverridecount0\ls4}}{\*\pgptbl {\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}}{\*\rsidtbl \rsid8611170}{\*\generator Microsoft Word 11.0.5604;}{\info {\title - FileMaker\'ae Pro 10: Level 2 }{\author Vanithak}{\operator Vanithak}{\creatim\yr2009\mo10\dy20\hr13\min48}{\revtim\yr2009\mo10\dy20\hr13\min48}{\version2}{\edmins0}{\nofpages2}{\nofwords633}{\nofchars3611}{\*\company Element K India} {\nofcharsws4236}{\vern24689}}\widowctrl\ftnbj\aenddoc\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb\nospaceforul\formshade\horzdoc\dgmargin\dghspace180\dgvspace180\dghorigin1701\dgvorigin1984\dghshow1\dgvshow1 \jexpand\viewkind5\viewscale100\pgbrdrhead\pgbrdrfoot\splytwnine\ftnlytwnine\htmautsp\nolnhtadjtbl\useltbaln\alntblind\lytcalctblwd\lyttblrtgr\lnbrkrule\allowfieldendsel\nojkernpunct\rsidroot8611170\newtblstyruls \fet0{\*\background {\shp{\*\shpinst\shpleft0\shptop0\shpright0\shpbottom0\shpfhdr0\shpbxmargin\shpbxignore\shpbymargin\shpbyignore\shpwr0\shpwrk0\shpfblwtxt1\shpz0\shplid1025{\sp{\sn shapeType}{\sv 1}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}} {\sp{\sn fillColor}{\sv 13421772}}{\sp{\sn fFilled}{\sv 1}}{\sp{\sn lineWidth}{\sv 0}}{\sp{\sn fLine}{\sv 0}}{\sp{\sn bWMode}{\sv 9}}{\sp{\sn fBackground}{\sv 1}}{\sp{\sn fLayoutInCell}{\sv 1}}}}}\sectd \linex0\endnhere\pgbrdropt32\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\ipgp1 \b\fs36\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\cf17\insrsid8611170 FileMaker\'ae Pro 10: Level 2 \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\ipgp1 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\cf17\insrsid8611170 Course Specifications \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\cf17\insrsid8611170 Course number: }{\f1\fs20\cf17\insrsid8611170 084708\line }{ \b\f1\fs20\cf17\insrsid8611170 Course length: }{\f1\fs20\cf17\insrsid8611170 1.0 day(s) \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\ipgp1 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\cf17\insrsid8611170 Course Description \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\cf17\insrsid8611170 Course Objective: }{\f1\fs20\cf17\insrsid8611170 You will create a database model based on relationships between tables that hold data. You will automate tasks based on scripts, work with functions and data found in external data sources. In addition, you will publish your database on the web and provide utilitarian features to users.\line \line }{ \b\f1\fs20\cf17\insrsid8611170 Target Student: }{\f1\fs20\cf17\insrsid8611170 This course is for students who have some experience using FileMaker Pro 10, but are finding that their needs for managing data exceeds their current capabilities. This course is also relevant for students who need to share databases with other users on a network or ove r the Internet.\line \line }{\b\f1\fs20\cf17\insrsid8611170 Prerequisites: }{\f1\fs20\cf17\insrsid8611170 Before taking this course, students should have completed the FileMaker\'ae Pro 10: Level 1 course or possess similar knowledge. In addition, they should be familiar with the basic functions of their computer\rquote s operating system. Students should also have basic word processing skills, such as copying and pasting text, formatting type, and so on. \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\ipgp1 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\cf17\insrsid8611170 Hardware Requirements \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\cf17\insrsid8611170 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\cf17 \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\ipgp1 {\f1\fs20\cf17\insrsid8611170 Intel \'ae Pentium\'ae II or higher (Intel\'ae Pentium\'ae III/IV-class recommended) \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}256 MB of RAM (512 MB of RAM recommended) \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}5 GB hard disk or higher if you use Windows XP Professional as your operating system (You should have at least 600 MB free hard-disk space for Microsoft Office installation) \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Access to any one of the following: a local CD-ROM drive, a local DVD drive, or access to a networked CD-ROM drive \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Mouse or other pointing device \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Network cards and cabling for local network access \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Internet access (see your local network administrator) \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Printer (optional) \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Projection system to display the instructor's computer screen \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Printer driver (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.) \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\ipgp1 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\cf17\insrsid8611170 Software Requirements \par }\pard\plain \s15\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\cf17\insrsid8611170 Each computer requires the following software: \par {\listtext\pard\plain\f3\fs20\cf17 \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\ipgp1 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\cf17\insrsid8611170 Microsoft\'ae Windows\'ae XP SP2\~or Vista \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Default installation of FileMaker\'ae Pro 10 \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Default installation of Microsoft\'ae Office 2007 \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}MySQL Server Community Edition 5.0 or above \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}MySQL-Connector-ODBC version 3.51 or above \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Adobe\'ae Reader\'ae 8.0 and above \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\ipgp1 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\cf17\insrsid8611170 Course Objectives \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\cf17\insrsid8611170 Upon successful completion of this course, students will be able to: \par {\listtext\pard\plain\f3\fs20\cf17 \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\ipgp1 {\f1\fs20\cf17\insrsid8611170 create relationships between databases and view relationship graphs in a database. \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}create buttons using the Button Setup feature to execute simple and complex tasks, and the Manage Scripts window to work with scripts. \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}share and exchange data over the network based on a predefined privilege set and a customized privilege set. \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}enhance the database layout using the various layout options available in FileMaker Pro. \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}publish a database on the web using the Instant Web Publishing option. \par {\listtext\pard\plain\f3\fs20\cf17 \loch\af3\dbch\af0\hich\f3 \'b7\tab}back up and protect data by adhering to the listed security guidelines. \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\ipgp1 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\cf17\insrsid8611170 Course Content \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\cf17\insrsid8611170 Lesson 1: Creating Relationships Between Databases \par }{\f1\fs20\cf17\insrsid8611170 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf17\insrsid8611170 Topic 1A: }{\f1\fs20\cf17\insrsid8611170 Create Relationships \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 1B: }{\f1\fs20\cf17\insrsid8611170 Access Data Using a Portal \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 1C: }{\f1\fs20\cf17\insrsid8611170 Create a Lookup \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 1D: }{\f1\fs20\cf17\insrsid8611170 Create a Relationship Using an Intermediate Table \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 1E: }{\f1\fs20\cf17\insrsid8611170 Access Data from Related Tables \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 1F: }{\f1\fs20\cf17\insrsid8611170 Summarize Related Data \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 1G: }{\f1\fs20\cf17\insrsid8611170 Create a Value List \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 {\b\f1\fs20\cf17\insrsid8611170 Lesson 2: Creating Buttons \par }{\f1\fs20\cf17\insrsid8611170 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf17\insrsid8611170 Topic 2A: }{\f1\fs20\cf17\insrsid8611170 Create Buttons to Execute Simple Tasks \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 2B: }{\f1\fs20\cf17\insrsid8611170 Create Buttons to Execute Complex Tasks \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 2C: }{\f1\fs20\cf17\insrsid8611170 Create Buttons to Execute Scripts \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 {\b\f1\fs20\cf17\insrsid8611170 Lesson 3: Sharing and Exchanging Data \par }{\f1\fs20\cf17\insrsid8611170 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf17\insrsid8611170 Topic 3A: }{\f1\fs20\cf17\insrsid8611170 Share a Database with All Users on a Network \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 3B: }{\f1\fs20\cf17\insrsid8611170 Share a Database Based on a Predefined Privilege Set \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 3C: }{\f1\fs20\cf17\insrsid8611170 Share a Database Based on a Customized Privilege Set \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 3D: }{\f1\fs20\cf17\insrsid8611170 Access Remote Data \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 3E: }{\f1\fs20\cf17\insrsid8611170 Access Data from External Data Sources \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 {\b\f1\fs20\cf17\insrsid8611170 Lesson 4: Enhancing the Database Layout \par }{\f1\fs20\cf17\insrsid8611170 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf17\insrsid8611170 Topic 4A: }{\f1\fs20\cf17\insrsid8611170 Add Tab Controls \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 4B: }{\f1\fs20\cf17\insrsid8611170 Create a Layout Using Fields from Related Tables \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 4C: }{\f1\fs20\cf17\insrsid8611170 Enhance the Layout \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 {\b\f1\fs20\cf17\insrsid8611170 Lesson 5: Publishing a Database on the Web \par }{\f1\fs20\cf17\insrsid8611170 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf17\insrsid8611170 Topic 5A: }{\f1\fs20\cf17\insrsid8611170 Prepare a Database for Publishing \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 5B: }{\f1\fs20\cf17\insrsid8611170 Publish a Database on the Web \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 5C: }{\f1\fs20\cf17\insrsid8611170 Work with the Web Viewer Tool \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 5D: }{\f1\fs20\cf17\insrsid8611170 Send Email \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 {\b\f1\fs20\cf17\insrsid8611170 Lesson 6: Protecting Data \par }{\f1\fs20\cf17\insrsid8611170 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf17\insrsid8611170 Topic 6A: }{\f1\fs20\cf17\insrsid8611170 Create Backups of Database Files \par }{\b\f1\fs20\cf17\insrsid8611170 Topic 6B: }{\f1\fs20\cf17\insrsid8611170 Maintain Data Security \par }}