FileMaker Pro 8: Expert Tutorials


Course Content


FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical "how to" course by FileMaker expert John Mark Osborne, starts from an expert level and uses a calendar example to demonstrate FileMaker Pro theta join relationships, complex calculations and sophisticated scripting techniques. Moreover, relationships, calculations, scripts and other features are combined to show the true power of a FileMaker solution. Even if you don't want to create a calendar, this tutorial will teach you techniques you can use in any solution. Examples of the calendar file are provided at every stage of the creation process, so the user can easily review one section without starting from the beginning. To begin learning more, simply click on one of the FileMaker Pro 8: Expert movie links. * Most techniques used in these videos are applicable to both FileMaker 7 and 8 (including 8.5). Substitute techniques for FileMaker 7 users will be discussed when necessary.

To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality. Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie. «« Hide This
Introduction
	About John Mark Osborne	(01:46)
	Why a Calendar Solution?	(05:25)
	Exploring the Calendar	(06:07)
	Which FileMaker Version?	(03:24)
	Interface	(03:56)
New 8.5 Features
	Overview pt. 1	(03:41)
	Overview pt. 2	(04:18)
	Layout Object Naming pt. 1	(03:13)
	Layout Object Naming pt. 2	(04:10)
	Go To Object Ideas pt. 1	(06:11)
	Go To Object Ideas pt. 2	(03:42)
	New Functions pt. 1	(04:04)
	New Functions pt. 2	(03:10)
	List Function pt. 1	(04:14)
	List Function pt. 2	(04:34)
	Web Viewer Basics pt. 1	(04:12)
	Web Viewer Basics pt. 2	(03:43)
	Set Web Viewer	(07:00)
	Scraping	(04:57)
	Paths	(04:29)
Relational Structure
	Tables	(02:49)
	Fields	(02:07)
	Relationships	(03:41)
	Generate Days Script pt. 1	(06:38)
	Generate Days Script pt. 2	(03:18)
	Generate Days Script pt. 3	(04:13)
	Variables For Speed	(07:06)
	Generate Events Script pt. 1	(04:44)
	Generate Events Script pt. 2	(04:43)
	Import For Speed pt. 1	(02:54)
	Import For Speed pt. 2	(05:38)
Month View
	Global Navigation Fields	(05:45)
	Convert Month To Number	(06:12)
	Custom Functions	(05:31)
	Filter the Relationship	(06:28)
	Plethora of Portals pt. 1	(03:01)
	Plethora of Portals pt. 2	(05:42)
	Highlight Colors pt. 1	(05:57)
	Highlight Colors pt. 2	(03:39)
	Highlight Colors pt. 3	(05:39)
	Highlight Colors pt. 4	(06:31)
	Dimmed Day Numbers pt. 1	(04:45)
	Dimmed Day Numbers pt. 2	(02:56)
	Navigation Buttons pt. 1	(06:18)
	Navigation Buttons pt. 2	(03:47)
	Navigation Buttons pt. 3	(06:06)
	Navigation Buttons pt. 4	(03:28)
Week View
	Table Occurrence Groups	(02:01)
	Add Relationships	(04:24)
	Create Week Layout pt. 1	(04:27)
	Create Week Layout pt. 2	(03:41)
	Column Headers pt. 1	(06:01)
	Column Headers pt. 2	(05:08)
	Adding Appointments pt. 1	(06:33)
	Adding Appointments pt. 2	(05:54)
	Adding Appointments pt. 3	(05:45)
	Adding Appointments pt. 4	(04:54)
	Adding Appointments pt. 5	(06:07)
	Deleting Appointments pt. 1	(05:24)
	Deleting Appointments pt. 2	(06:25)
	Changing Appointments pt. 1	(04:34)
	Changing Appointments pt. 2	(05:36)
	Changing Appointments pt. 3	(06:22)
	Navigating Weeks	(04:24)
	Interface Considerations pt. 1	(05:09)
	Interface Considerations pt. 2	(06:24)
Day View
	Add Relationships	(04:10)
	Create Day Layout	(06:24)
	Revise Delete Appointment Script	(03:41)
	Revise Add Appointment Script	(02:53)
	Revise Change Appointment Script	(04:49)
	Navigating Days Script	(03:57)
	Month View Appointments pt. 1	(04:53)
	Month View Appointments pt. 2	(04:26)
	Month View Appointments pt. 3	(04:08)
	Month View Appointments pt. 4	(05:04)
	Month View Appointments pt. 5	(02:28)
	Add Appointments To Month View	(06:13)
Navigation
	Monthly To Daily pt. 1	(03:24)
	Monthly To Daily pt. 2	(03:51)
	Monthly To Weekly	(06:33)
	Weekly To Daily pt. 1	(07:09)
	Weekly To Daily pt. 2	(05:02)
	Weekly To Daily pt. 3	(04:21)
	Weekly To Daily pt. 4	(06:07)
	Weekly To Daily pt. 5	(06:19)
	Daily To Weekly pt. 1	(06:25)
	Daily To Weekly pt. 2	(06:58)
	Daily & Weekly To Monthly pt. 1	(06:39)
	Daily & Weekly To Monthly pt. 2	(06:26)
	Today Selector	(06:19)
	Open Script pt. 1	(06:55)
	Open Script pt. 2	(05:59)
Finding & Reporting
	Find Layouts pt. 1	(05:36)
	Find Layouts pt. 2	(03:47)
	Find Script pt. 1	(05:57)
	Find Script pt. 2	(05:01)
	Supporting Scripts pt. 1	(03:49)
	Supporting Scripts pt. 2	(03:47)
	Display Found Events in Calendar	(05:00)
	Print Layout pt. 1	(02:59)
	Print Layout pt. 2	(05:51)
	Printing Hit List pt. 1	(06:29)
	Printing Hit List pt. 2	(02:42)
	Printing Standard Views pt. 1	(05:49)
	Printing Standard Views pt. 2	(06:31)
Multi-User
	Accounts & Privileges	(03:41)
	Add Fields	(07:15)
	Modify Relationships	(05:15)
	Set Perspective Script pt. 1	(06:08)
	Set Perspective Script pt. 2	(05:12)
	Record Generation Scripts pt. 1	(04:07)
	Record Generation Scripts pt. 2	(04:22)
	Fixing Preferences	(05:23)
	Default Event Duration	(05:27)
	Adding a Labels Interface pt. 1	(05:15)
	Adding a Labels Interface pt. 2	(05:13)
	Testing the Solution pt. 1	(04:53)
	Testing the Solution pt. 2	(02:53)
	Fixing the Bug	(04:48)
Working With John Mark Osborne
	Free Resources	(03:43)
	Training	(02:34)
	Consulting & Meta-Consulting	(01:53)
	Solutions	(06:13)
	Contacting Me	(00:42)

Email this Page

Send us Feedback

Tutorial Information / Pricing

Title:	FileMaker Pro 8: Expert
Author:	John Mark Osborne
SKU:	33712
ISBN:	1-933736-40-2
Duration:	10 hrs / 125 Lessons
Compatibility:	Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30

The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP	LEARN MORE »


Get this title on CD


Single User: US$ 99.95 - Purchase CD / Add to Cart Multi User (10): US$ 500.00 - Purchase CD / Add to Cart


Select Bandwidth


Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming. Select:


Select Category


Animation & 3D Audio Business Applications Databases Graphics & Page Layout Multimedia & Video Networking & Security Operating Systems Programming Internet & Web Design Special Groups New Releases All Titles Publisher or Products Adobe Tutorials Apple Tutorials Cakewalk Tutorials Corel Tutorials Dreamweaver Tutorials Macromedia Tutorials Microsoft Tutorials Oracle Tutorials Photoshop Tutorials Sony Tutorials