FileMaker Pro 9: Beginner Training


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 beginner level and uses a single invoicing example to demonstrate all the features in FileMaker Pro 7, 8, 8.5 and 9 including: field creation, finding, sorting, layout mode, container fields, auto-entry, validation, printing, scripts, calculations, importing, exporting and interface design. Examples of the invoice file are provided at every stage of the creation process, so the user can easily review one section without starting from the beginning. To being learning today, simply click on one of the FileMaker Pro 9: Beginner links. The completed invoicing solution included on the beginner, intermediate (soon-to-be-released) and advanced (soon-to-be-released) FileMaker Pro 9 training is provided as a visual goal. Upon completion of all three titles, you will have created the exact same invoicing solution. If you would like to purchase the completed invoicing solution, please visit the www.databasepros.com web site. * Most techniques used in these videos are applicable to both FileMaker 8 and 7. Substitute techniques for FileMaker 7 users will be discussed when necessary. ** This tutorial is part one in an upcoming 3-part FileMaker Pro 9 series.

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	(04:19)
	FileMaker 9 Family of Products pt. 1	(05:15)
	FileMaker 9 Family of Products pt. 2	(04:46)
	New FileMaker Pro 9 Features pt. 1	(05:39)
	New FileMaker Pro 9 Features pt. 2	(05:47)
	New FileMaker Pro 9 Features pt. 3	(06:21)
	New FileMaker Pro 9 Advanced Features pt. 1	(04:11)
	New FileMaker Pro 9 Advanced Features pt. 2	(03:35)
	About the Tutorial Series pt. 1	(06:01)
	About the Tutorial Series pt. 2	(03:32)
	Why an Invoicing Solution? pt. 1	(07:15)
	Why an Invoicing Solution? pt. 2	(04:09)
	What is a Database? pt. 1	(06:00)
	What is a Database? pt. 2	(02:22)
	Planning Your Solution	(06:05)
Creating a Database
	Templates	(06:51)
	New Empty File	(03:25)
	Creating Fields	(06:53)
	Housekeeping Fields pt. 1	(06:57)
	Housekeeping Fields pt. 2	(02:15)
	Modifying Fields	(05:53)
	Organizing Fields	(04:41)
	Other Tabs	(04:59)
Working With the Database
	Data Entry pt. 1	(06:52)
	Data Entry pt. 2	(06:47)
	Status Area	(05:52)
	The Four Modes	(05:51)
	Records Menu pt. 1	(04:43)
	Records Menu pt. 2	(05:55)
	Previewing Pages	(06:48)
	New Layout pt. 1	(05:38)
	New Layout pt. 2	(07:19)
Finding & Sorting
	Basic Find	(06:09)
	How the Index Works pt. 1	(04:01)
	How the Index Works pt. 2	(06:07)
	New Requests	(04:29)
	Symbols pt. 1	(03:57)
	Symbols pt. 2	(05:47)
	Wildcards & More On Symbols pt. 1	(03:35)
	Wildcards & More On Symbols pt. 2	(06:01)
	Found Sets Without Find Mode	(04:14)
	Constrain & Extend	(03:42)
	Sorting Records	(06:59)
	New Window	(03:12)
Modifying Layouts
	Status Area	(06:18)
	Arrow Tool	(07:58)
	Text Tool pt. 1	(05:35)
	Text Tool pt. 2	(05:47)
	Line Tool	(06:22)
	Rectangle Tool	(05:51)
Modifying Layouts Advanced
	Tab Control pt. 1	(06:52)
	Tab Control pt. 2	(03:55)
	Field Control pt. 1	(07:06)
	Field Control pt. 2	(07:27)
	Parts pt. 1	(07:35)
	Parts pt. 2	(05:31)
	Layout Menu pt. 1	(04:41)
	Layout Menu pt. 2	(04:59)
	Format Menu pt. 1	(06:51)
	Format Menu pt. 2	(04:44)
	Arrange Menu pt. 1	(07:08)
	Arrange Menu pt. 2	(02:59)
	View Menu pt. 1	(07:20)
	View Menu pt. 2	(03:13)
Working With Container Fields
	Creating Container Fields	(04:16)
	Inserting a Picture	(06:51)
	Inserting a PDF pt. 1	(05:05)
	Inserting a PDF pt. 2	(02:44)
	Insert Other Files	(05:32)
	Miscellaneous	(05:11)
Auto-Entry
	Serial Numbers pt. 1	(06:16)
	Serial Numbers pt. 2	(04:40)
	Value from Last Visited	(03:07)
	Calculated Auto-Enter pt. 1	(04:30)
	Calculated Auto-Enter pt. 2	(05:41)
	Lookups pt. 1	(05:04)
	Lookups pt. 2	(04:41)
Validation
	Strict Data Type	(07:05)
	Not Empty / Unique / Existing	(07:13)
	Ranges	(06:39)
	Custom Messages pt. 1	(07:24)
	Custom Messages pt. 2	(02:28)
	Always vs. Data Entry	(06:19)
Printing
	Print Layouts pt. 1	(07:24)
	Print Layouts pt. 2	(04:26)
	Contact List pt. 1	(06:01)
	Contact List pt. 2	(03:30)
	Labels pt. 1	(05:36)
	Labels pt. 2	(04:02)
	Merge Letters pt. 1	(05:35)
	Merge Letters pt. 2	(06:55)
	Merge Letters pt. 3	(05:31)
	Sub-Summary Reports pt. 1	(06:47)
	Sub-Summary Reports pt. 2	(07:13)
	Improved Contact List pt. 1	(07:01)
	Improved Contact List pt. 2	(03:24)
Scripting & Calculations
	Definition of a Script pt. 1	(04:08)
	Definition of a Script pt. 2	(06:04)
	Definition of a Script pt. 3	(06:56)
	Definition of a Calculation pt. 1	(03:46)
	Definition of a Calculation pt. 2	(05:38)
	Navigation pt. 1	(05:37)
	Navigation pt. 2	(07:01)
	Advanced Navigation pt. 1	(05:50)
	Advanced Navigation pt. 2	(05:51)
	Advanced Navigation pt. 3	(06:31)
	Open Script pt. 1	(05:31)
	Open Script pt. 2	(03:18)
	Recreate the Status Area	(05:45)
	Billing or Shipping Labels pt. 1	(03:45)
	Billing or Shipping Labels pt. 2	(04:01)
	Billing or Shipping Labels pt. 3	(07:06)
	Birthdays pt. 1	(06:16)
	Birthdays pt. 2	(04:55)
Importing & Exporting
	Import & Export Defined	(06:41)
	Importing FileMaker Files pt. 1	(05:31)
	Importing FileMaker Files pt. 2	(07:44)
	Importing a Folder	(07:04)
	Data Sources pt. 1	(04:07)
	Data Sources pt. 2	(05:21)
	Exporting Files	(04:45)
	Group By	(06:52)
	Export to HTML	(04:28)
	Importing Schema pt. 1	(05:12)
	Importing Schema pt. 2	(03:43)
Miscellanneous Features
	Global Field pt. 1	(05:17)
	Global Field pt. 2	(06:06)
	Repeating Field pt. 1	(03:05)
	Repeating Field pt. 2	(05:16)
	Furigana	(03:39)
	Spell Checking	(06:05)
	Find & Replace	(03:58)
	Engraving & Embossing pt. 1	(03:47)
	Engraving & Embossing pt. 2	(03:24)
	Send Email pt. 1	(04:13)
	Send Email pt. 2	(04:21)
	Improved Print Script	(05:21)
	Tooltips pt. 1	(05:01)
	Tooltips pt. 2	(05:07)
Working With John Mark Osborne
	Free Resources pt. 1	(04:47)
	Free Resources pt. 2	(03:42)
	Training	(05:21)
	Consulting & Meta-Consulting	(02:21)
	Solutions	(06:03)
	Contacting John Mark Osborne	(01:54)

Email this Page

Send us Feedback

Tutorial Information / Pricing

Title:	FileMaker Pro 9: Beginner
Author:	John Mark Osborne
SKU:	33783
ISBN:	1-933736-95-X
Duration:	12.5 hrs / 145 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