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.
* 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.
Introduction
About John Mark Osborne FileMaker 9 Family of Products pt. 1 FileMaker 9 Family of Products pt. 2 New FileMaker Pro 9 Features pt. 1 New FileMaker Pro 9 Features pt. 2 New FileMaker Pro 9 Features pt. 3 New FileMaker Pro 9 Advanced Features pt. 1 New FileMaker Pro 9 Advanced Features pt. 2 About the Tutorial Series pt. 1 About the Tutorial Series pt. 2 Why an Invoicing Solution? pt. 1 Why an Invoicing Solution? pt. 2 What is a Database? pt. 1 What is a Database? pt. 2 Planning Your Solution Creating a Database
Templates New Empty File Creating Fields Housekeeping Fields pt. 1 Housekeeping Fields pt. 2 Modifying Fields Organizing Fields Other Tabs Working With the Database
Data Entry pt. 1 Data Entry pt. 2 Status Area The Four Modes Records Menu pt. 1 Records Menu pt. 2 Previewing Pages New Layout pt. 1 New Layout pt. 2
Finding & Sorting
Basic Find
How the Index Works pt. 1
How the Index Works pt. 2
New Requests
Symbols pt. 1
Symbols pt. 2
Wildcards & More On Symbols pt. 1
Wildcards & More On Symbols pt. 2
Found Sets Without Find Mode
Constrain & Extend
Sorting Records
New Window
Modifying Layouts
Status Area
Arrow Tool
Text Tool pt. 1
Text Tool pt. 2
Line Tool
Rectangle Tool
Modifying Layouts Advanced
Tab Control pt. 1
Tab Control pt. 2
Field Control pt. 1
Field Control pt. 2
Parts pt. 1
Parts pt. 2
Layout Menu pt. 1
Layout Menu pt. 2
Format Menu pt. 1
Format Menu pt. 2
Arrange Menu pt. 1
Arrange Menu pt. 2
View Menu pt. 1
View Menu pt. 2
Working With Container Fields
Creating Container Fields
Inserting a Picture
Inserting a PDF pt. 1
Inserting a PDF pt. 2
Insert Other Files
Miscellaneous
Auto-Entry
Serial Numbers pt. 1
Serial Numbers pt. 2
Value from Last Visited
Calculated Auto-Enter pt. 1
Calculated Auto-Enter pt. 2
Lookups pt. 1
Lookups pt. 2
Validation
Strict Data Type
Not Empty / Unique / Existing
Ranges
Custom Messages pt. 1
Custom Messages pt. 2
Always vs. Data Entry
Printing
Print Layouts pt. 1
Print Layouts pt. 2
Contact List pt. 1
Contact List pt. 2
Labels pt. 1
Labels pt. 2
Merge Letters pt. 1
Merge Letters pt. 2
Merge Letters pt. 3
Sub-Summary Reports pt. 1
Sub-Summary Reports pt. 2
Improved Contact List pt. 1
Improved Contact List pt. 2
Scripting & Calculations
Definition of a Script pt. 1
Definition of a Script pt. 2
Definition of a Script pt. 3
Definition of a Calculation pt. 1
Definition of a Calculation pt. 2
Navigation pt. 1
Navigation pt. 2
Advanced Navigation pt. 1
Advanced Navigation pt. 2
Advanced Navigation pt. 3
Open Script pt. 1
Open Script pt. 2
Recreate the Status Area
Billing or Shipping Labels pt. 1
Billing or Shipping Labels pt. 2
Billing or Shipping Labels pt. 3
Birthdays pt. 1
Birthdays pt. 2
Importing & Exporting
Import & Export Defined
Importing FileMaker Files pt. 1
Importing FileMaker Files pt. 2
Importing a Folder
Data Sources pt. 1
Data Sources pt. 2
Exporting Files
Group By
Export to HTML
Importing Schema pt. 1
Importing Schema pt. 2
Miscellanneous Features
Global Field pt. 1
Global Field pt. 2
Repeating Field pt. 1
Repeating Field pt. 2
Furigana
Spell Checking
Find & Replace
Engraving & Embossing pt. 1
Engraving & Embossing pt. 2
Send Email pt. 1
Send Email pt. 2
Improved Print Script
Tooltips pt. 1
Tooltips pt. 2
Working With John Mark Osborne
Free Resources pt. 1
Free Resources pt. 2
Training
Consulting & Meta-Consulting
Solutions
Contacting John Mark Osborne