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 intermediate level and uses a single invoicing example to demonstrate FileMaker Pro features and techniques including interface design, relational database design, relationship operators, multiple predicates, table occurrences, portal filters, security, scripts, calculations, FileMaker Pro Advanced, multi-user solutions, record locking, multi-keys and deleting duplicate records. 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 FileMaker Pro 8 today, simply click on one of the links below.
lt;pgt;lt;font color='red'gt;The completed invoicing solution included on the beginner, intermediate and advanced FileMaker Pro 8 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 lt;a class='linkNineAlt' href='http://www.vtc.com/products/fmpro8adv.htm' target='_blank'gt;databasepros.comlt;/agt; web site.lt;/fontgt;lt;/pgt;
lt;pgt;lt;igt;* Most techniques used in these videos are applicable to both FileMaker 8 and 7. Substitute techniques for FM7 users will be discussed when necessary. lt;/igt;lt;/pgt;
lt;pgt;lt;igt;** This tutorial is part two in a 3-part FileMaker Pro 8 series. lt;/igt;lt;/pgt;
IntroductionAbout John Mark OsborneFileMaker 8 Family of ProductsAbout the Tutorial SeriesWhy an Invoicing Example?Interface DesignScreen SizeBackgroundTabs / Bars / ButtonsField OutlinesSub-AreasFinishing Touches pt. 1Finishing Touches pt. 2Tabbed Layouts pt. 1Tabbed Layouts pt. 2List ViewList View without Status AreaDesign ConsiderationsRelationshipsRelational TheoryData ModelingEntity-Relationship DiagramsCreating a RelationshipRelated Fields pt. 1Related Fields pt. 2Many-To-Many Relationship pt. 1Many-To-Many Relationship pt. 2Creating a PortalPortal ImprovementsTwo-Way RelationshipsCompleting the InterfaceTable OccurrencesWhat are Table Occurrences? pt. 1
What are Table Occurrences? pt. 2
Filtered Portals
Calculated Portals
Date Range Portals pt. 1
Date Range Portals pt. 2
Self-Relationships
Table Occurrence Tricks
Conditional Value Lists pt. 1
Conditional Value Lists pt. 2
Scripts and Calculations pt. 1
Scripts and Calculations pt. 2
Organizing the Graph pt. 1
Organizing the Graph pt. 2
SecurityComplete Approach pt. 1
Complete Approach pt. 2
Accounts
Privilege Sets pt. 1
Privilege Sets pt. 2
Extended Privileges
No Access Layout
Overdue Invoices pt. 1
Overdue Invoices pt. 2
Capturing Errors pt. 1
Capturing Errors pt. 2
Tracking Accounts pt. 1
Tracking Accounts pt. 2
Random Passwords
Override Account pt. 1
Override Account pt. 2
ScriptingMenu Button
Script Parameters
Find Rolodex
Dynamic Messages
Duplicate Invoices
Dynamic Layouts
Print Invoice Layout pt. 1
Print Invoice Layout pt. 2
Print Invoice Script
Inventory Control
Transitions
CalculationsGrand Total pt. 1
Grand Total pt. 2
Basic Phone Filter pt. 1
Basic Phone Filter pt. 2
Phone Number Validation
Remove Text Formatting
Overdue Invoice Display
Parsing Text pt. 1
Parsing Text pt. 2
Field Level Tracking pt. 1
Field Level Tracking pt. 2
Parent and Child Tracking
FileMaker Pro AdvancedAdvanced Features
Recover
Configuring Plug-Ins
Plug-In Examples pt. 1
Plug-In Examples pt. 2
Database Design Report
Developer Utilities
File Maintenance
Debugging Script pt. 1
Debugging Script pt. 2
Custom Functions pt. 1
Custom Functions pt. 2
Custom Menus pt. 1
Custom Menus pt. 2
Multi-User SolutionsSetup
FileMaker Server Sharing
Record Locking
Testing for Locked Records
Looping and Replace Scripts
Marking Records pt. 1
Marking Records pt. 2
Save a Found Set
Working with John Mark OsborneFree Resources
Training
Consulting and Meta-Consulting
Solutions
Contacting Me
Click here to find out more about the FileMaker Pro 8: Intermediate Training CD 
