{\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 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-700915072{\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 ;}\listid520093794}{\list\listtemplateid1790575138{\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 ;}\listid1336419264}{\list\listtemplateid-965570880{\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 ;}\listid1721394258} {\list\listtemplateid1012807626{\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 ;}\listid2041513337}}{\*\listoverridetable{\listoverride\listid1336419264\listoverridecount0\ls1}{\listoverride\listid520093794 \listoverridecount0\ls2}{\listoverride\listid1721394258\listoverridecount0\ls3}{\listoverride\listid2041513337\listoverridecount0\ls4}}{\*\pgptbl {\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}}{\*\rsidtbl \rsid3146346\rsid12853009}{\*\generator Microsoft Word 11. 0.5604;}{\info{\title - FileMaker\'ae Pro 9: Level 2 (Macintosh) }{\author tayub}{\operator tayub}{\creatim\yr2010\mo2\dy24\hr17\min40}{\revtim\yr2010\mo2\dy24\hr17\min44}{\version3}{\edmins1}{\nofpages2}{\nofwords547}{\nofchars3121} {\*\company Element K India}{\nofcharsws3661}{\vern24689}}\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\allowfieldendsel\nojkernpunct\rsidroot12853009\newtblstyruls \fet0\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\cf1\insrsid12853009\charrsid3146346 FileMaker\'ae Pro 9: Level 2 (Macintosh) \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\cf1\insrsid12853009\charrsid3146346 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\cf1\insrsid12853009\charrsid3146346 Course number: }{ \f1\fs20\cf1\insrsid12853009\charrsid3146346 084285\line }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Course length: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 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\cf1\insrsid12853009\charrsid3146346 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\cf1\insrsid12853009\charrsid3146346 Course Objective: }{ \f1\fs20\cf1\insrsid12853009\charrsid3146346 You will create a database model based on relationships between tables that hold data. You will automate tasks based on scripts and work with functions and data found in external data sources. In addition, you will publish your database on the web and pro vide utilitarian features to users.\line \line }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Target Student: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 This course is for students who have some experience using FileMaker Pro and are aware that their need for managing data exceeds their current capabilities. In addition, this course is for the FileMaker P ro 9 user who needs to share databases with other users on a network or over the Internet.\line \line }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Prerequisites: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Before taking this course, students should have completed the }{\i\f1\fs20\cf1\insrsid12853009\charrsid3146346 FileMaker\'ae Pro 9: Level 1 (Macintosh)}{\f1\fs20\cf1\insrsid12853009\charrsid3146346 course. 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, pasting, and formatting text, 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\cf1\insrsid12853009\charrsid3146346 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\cf1\insrsid12853009\charrsid3146346 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\cf1\insrsid12853009\charrsid3146346 \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\cf1\insrsid12853009\charrsid3146346 PowerPC G3, G4, G5, or Intel-based Mac \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}256 MB RAM (512 MB RAM recommended) \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Access to 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\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Mouse or other pointing device \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}VGA or higher video adapter and monitor \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Network cards and cabling for local network access \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Internet access (see your local network administrator) \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Printer (optional) \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Projection system to display the instructor's computer screen \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\cf1\insrsid12853009\charrsid3146346 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\cf1\insrsid12853009\charrsid3146346 Each computer requires the following software: \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \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\cf1\insrsid12853009\charrsid3146346 Default Installation of FileMaker\'ae Pro 9 \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Default installation of Microsoft\'ae Office\'ae 2008 \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Printer driver \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}MySQL Server Community Edition 5.0 or above \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}MySQL-Connector-ODBC version 3.51 or above \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \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\cf1\insrsid12853009\charrsid3146346 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\cf1\insrsid12853009\charrsid3146346 Upon successful completion of this course, students will be able to: \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \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\cf1\insrsid12853009\charrsid3146346 create relationships between tables in a database file. \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}create buttons to perform tasks. \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}access data from external FileMaker sources or from an external database. \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}enhance the layout of your database. \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}prepare and publish your database on the web. \par {\listtext\pard\plain\f3\fs20\cf1\insrsid12853009\charrsid3146346 \loch\af3\dbch\af0\hich\f3 \'b7\tab}follow some of the best practices to keep data safe and prevent information loss. \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\cf1\insrsid12853009\charrsid3146346 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\cf1\insrsid12853009\charrsid3146346 Lesson 1: Creating Relationships Between Databases \par }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 1A: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Create Relationships \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 1B: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Access Data Using a Portal \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 1C: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Create a Lookup \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 1D: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Create a Relationship Using an Intermediate Table \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 1E: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Access Data from Related Tables \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 1F: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Summarize Related Data \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 1G: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Create a Value List \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 {\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Lesson 2: Creating Buttons \par }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 2A: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Create Buttons to Execute Simple Tasks \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 2B: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Create Buttons to Execute Complex Tasks \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 2C: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Create Buttons to Execute Scripts \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 {\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Lesson 3: Sharing and Exchanging Data \par }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 3A: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Share a Database with All Users on a Network \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 3B: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Share a Database Based on a Predefined Privilege Set \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 3C: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Share a Database Based on a Customized Privilege Set \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 3D: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Access Remote Data \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 3E: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Access Data from External Data Sources \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 {\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Lesson 4: Enhancing the Database Layout \par }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 4A: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Add Tab Controls \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 4B: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Create a Layout Using Fields from Related Tables \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 4C: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Enhance the Layout \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 {\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Lesson 5: Publishing a Database on the Web \par }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 5A: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Prepare a Database for Publishing \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 5B: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Publish a Database for the Web \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 5C: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Work with the Web Viewer Tool \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\ipgp1 {\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Lesson 6: Protecting Data \par }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\ipgp1 {\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 6A: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Create a Backup of Database files \par }{\b\f1\fs20\cf1\insrsid12853009\charrsid3146346 Topic 6B: }{\f1\fs20\cf1\insrsid12853009\charrsid3146346 Maintain Data Security \par }}