
FileMaker Pro 9: Intermediate
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 intermediate level and uses a single invoicing solution to demonstrate FileMaker Pro 7, 8, 8.5 and 9 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 begin learning today, simply click on one of the FileMaker Pro 9: Intermediate links.rn<p>rn<font color="red">The completed invoicing solution included on the beginner, intermediate 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 <a class="linkNineAlt" href="http://www.databasepros.com" target="_blank">www.databasepros.com</a> web site.</font></p>rn<p><i>* 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. </i></p>rn<p><i>** This tutorial is part two in an upcoming 3-part FileMaker Pro 9 series. </i></p>rn<p ><i>*** Captions not yet available on CD version.</i></p>rn
Course content
Introduction7 lessons
Interface Design20 lessons
- Recap Previous Tutorial2:221 credit or ad
- Screen Size pt. 15:081 credit or ad
- Screen Size pt. 24:321 credit or ad
- Background pt. 13:371 credit or ad
- Background pt. 24:221 credit or ad
- Tabs and Bars5:521 credit or ad
- Buttons3:211 credit or ad
- Field Outlines pt. 15:341 credit or ad
- Field Outlines pt. 22:371 credit or ad
- Sub-Areas pt. 12:151 credit or ad
- Sub-Areas pt. 25:401 credit or ad
- Finishing Touches pt.13:041 credit or ad
- Finishing Touches pt. 26:161 credit or ad
- Tabbed Buttons7:031 credit or ad
- Notes Layout7:091 credit or ad
- List View pt. 15:141 credit or ad
- List View pt. 24:381 credit or ad
- List View without Status Area pt. 14:421 credit or ad
- List View without Status Area pt. 23:211 credit or ad
- Design Considerations5:161 credit or ad
Relationships18 lessons
- Relational Theory6:201 credit or ad
- Data Modeling pt. 13:271 credit or ad
- Data Modeling pt. 25:441 credit or ad
- Entity-Relationship Diagrams pt. 15:271 credit or ad
- Entity-Relationship Diagrams pt. 23:281 credit or ad
- Creating a Relationship7:001 credit or ad
- Related Fields7:171 credit or ad
- Populating Related Fields pt. 14:361 credit or ad
- Populating Related Fields pt. 23:081 credit or ad
- Many-To-Many Relationship pt. 13:411 credit or ad
- Many-To-Many Relationship pt. 24:311 credit or ad
- Many-To-Many Relationship pt. 34:231 credit or ad
- Creating a Portal pt. 13:011 credit or ad
- Creating a Portal pt. 24:481 credit or ad
- Portal Improvements pt. 13:441 credit or ad
- Portal Improvements pt. 25:021 credit or ad
- Two-Way Relationships6:061 credit or ad
- Completing the Interface6:311 credit or ad
Table Occurrences15 lessons
- What are Table Occurrences?5:011 credit or ad
- Where are Table Occurrences Used?6:161 credit or ad
- Filtered Portals7:081 credit or ad
- Calculated Portals5:381 credit or ad
- Date Range Portals pt. 14:341 credit or ad
- Date Range Portals pt. 23:381 credit or ad
- Self-Relationships pt. 12:361 credit or ad
- Self-Relationships pt. 24:571 credit or ad
- Table Occurrence Tricks6:181 credit or ad
- Conditional Value Lists pt. 14:181 credit or ad
- Conditional Value Lists pt. 25:201 credit or ad
- Scripts and Calculations pt. 12:491 credit or ad
- Scripts and Calculations pt. 25:331 credit or ad
- Organizing the Graph pt. 13:161 credit or ad
- Organizing the Graph pt. 24:171 credit or ad
Security15 lessons
- Complete Approach pt. 14:261 credit or ad
- Complete Approach pt. 24:321 credit or ad
- Accounts6:361 credit or ad
- Other Privileges4:381 credit or ad
- Data Access and Design6:021 credit or ad
- Extended Privileges4:281 credit or ad
- No Access Layout5:021 credit or ad
- Overdue Invoices pt. 16:261 credit or ad
- Overdue Invoices pt. 25:541 credit or ad
- Capturing Errors7:041 credit or ad
- Add Account5:091 credit or ad
- Delete Account6:441 credit or ad
- Random Passwords6:251 credit or ad
- Reset Password and Re-Login5:151 credit or ad
- Discount Override5:501 credit or ad
Scripting12 lessons
- Menu Button pt. 13:071 credit or ad
- Menu Button pt. 24:311 credit or ad
- Script Parameters pt. 15:271 credit or ad
- Find Rolodex6:221 credit or ad
- Dynamic Messages5:171 credit or ad
- Duplicate Invoices6:471 credit or ad
- Dynamic Layouts4:261 credit or ad
- Print Invoice Layout pt. 15:141 credit or ad
- Print Invoice Layout pt. 23:521 credit or ad
- Print Invoice Script6:081 credit or ad
- Inventory Control Add4:081 credit or ad
- Inventory Control Subtract4:091 credit or ad
Calculations12 lessons
- Sales Tax7:161 credit or ad
- Grand Total5:461 credit or ad
- Basic Phone Filter7:251 credit or ad
- Phone Number Validation6:321 credit or ad
- Remove Text Formatting5:101 credit or ad
- Overdue Invoice Display5:361 credit or ad
- Parsing Text pt. 14:201 credit or ad
- Parsing Text pt. 24:301 credit or ad
- Parsing Text Advanced5:261 credit or ad
- Field Level Tracking4:581 credit or ad
- Field Level Tracking Advanced6:581 credit or ad
- True Modification Timestamp5:461 credit or ad
FileMaker Pro Advanced15 lessons
- Advanced Features pt. 14:101 credit or ad
- Advanced Features pt. 23:351 credit or ad
- Recover5:131 credit or ad
- Configuring Plug-Ins5:451 credit or ad
- Plug-In Examples5:261 credit or ad
- Database Design Report3:391 credit or ad
- Developer Utilities5:361 credit or ad
- File Maintenance2:341 credit or ad
- Debugging Scripts pt. 14:491 credit or ad
- Debugging Scripts pt. 23:581 credit or ad
- Custom Functions5:491 credit or ad
- Recursive Custom Functions pt. 13:351 credit or ad
- Recursive Custom Functions pt. 23:451 credit or ad
- Custom Menus Layout Driven5:521 credit or ad
- Custom Menus Scripted5:181 credit or ad
Multi-User Solutions10 lessons
- Hosts and Guests4:091 credit or ad
- Sharing a File2:541 credit or ad
- Record Locking Defined5:451 credit or ad
- Scripting for a Locked Record6:281 credit or ad
- Scripting for Multiple Locked Records pt. 14:561 credit or ad
- Scripting for Multiple Locked Records pt. 24:041 credit or ad
- Marking Records pt. 14:391 credit or ad
- Marking Records pt. 25:501 credit or ad
- Saving a Found Set5:471 credit or ad
- Retrieving a Found Set3:051 credit or ad