
FileMaker Pro 12: 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 intermediate level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 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, deleting duplicate records and new FileMaker Pro 11 features. 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 the movie links.
Course content
Introduction7 lessons
Interface Design21 lessons
- Recap Previous Tutorial8:031 credit or ad
- Screen Size5:291 credit or ad
- Background pt. 14:191 credit or ad
- Background pt. 29:131 credit or ad
- Tabs/Bars and Buttons pt. 15:551 credit or ad
- Tabs/Bars and Buttons pt. 23:361 credit or ad
- Tabs/Bars and Buttons pt. 35:101 credit or ad
- Field Outlines6:081 credit or ad
- Sub-Areas10:111 credit or ad
- Buttons6:571 credit or ad
- Finishing Touches pt. 14:331 credit or ad
- Finishing Touches pt. 24:331 credit or ad
- Tabbed Buttons pt. 15:171 credit or ad
- Tabbed Buttons pt. 23:151 credit or ad
- Tabbed Sub Area7:241 credit or ad
- List View pt. 14:251 credit or ad
- List View pt. 27:551 credit or ad
- List View pt. 34:301 credit or ad
- Autosizing pt. 16:151 credit or ad
- Autosizing pt. 25:231 credit or ad
- Design Considerations6:101 credit or ad
Relationships23 lessons
- Relational Theory6:111 credit or ad
- Data Modeling pt. 17:281 credit or ad
- Data Modeling pt. 26:201 credit or ad
- Entity-Relationship Diagrams pt. 14:401 credit or ad
- Entity-Relationship Diagrams pt. 26:211 credit or ad
- Invoices ERD5:051 credit or ad
- Creating a Relationship6:391 credit or ad
- Related Fields3:471 credit or ad
- Populating a Foreign Key pt. 16:111 credit or ad
- Populating a Foreign Key pt. 26:511 credit or ad
- Live Links6:231 credit or ad
- Many-To-Many Relationship pt. 14:501 credit or ad
- Many-To-Many Relationship pt. 25:101 credit or ad
- Creating a Portal8:281 credit or ad
- How the Join Works4:151 credit or ad
- Portal Improvements6:271 credit or ad
- Aggregating Portals7:331 credit or ad
- Two-Way Relationships8:421 credit or ad
- Sorting a Portal3:541 credit or ad
- Start and End5:361 credit or ad
- Go to Related Record5:231 credit or ad
- Organizing Layouts7:031 credit or ad
- Completing the Interface6:531 credit or ad
Table Occurrences18 lessons
- What are Table Occurrences?7:221 credit or ad
- Where are Table Occurrences Used?8:181 credit or ad
- Portal Filtering6:501 credit or ad
- Totaling Filtered Portals6:341 credit or ad
- Filtered Relationships pt. 17:521 credit or ad
- Filtered Relationships pt. 26:131 credit or ad
- Portal Filtering Discussion5:341 credit or ad
- Calculated Portals6:361 credit or ad
- Dynamic Calculation3:401 credit or ad
- Date Range Portals7:481 credit or ad
- Self-Relationships6:381 credit or ad
- Table Occurrence Tricks pt. 15:571 credit or ad
- Table Occurrence Tricks pt. 24:491 credit or ad
- Conditional Value Lists pt. 12:291 credit or ad
- Conditional Value Lists pt. 26:201 credit or ad
- Scripts and Calculations7:051 credit or ad
- Organizing the Graph7:191 credit or ad
- Table Occurrence Groups4:441 credit or ad
Security20 lessons
- Overview pt. 16:301 credit or ad
- Overview pt. 27:241 credit or ad
- Complete Approach7:371 credit or ad
- Accounts6:001 credit or ad
- New Account5:501 credit or ad
- Other Privileges6:241 credit or ad
- Data Access and Design7:001 credit or ad
- Record Level Access5:251 credit or ad
- Extended Privileges5:441 credit or ad
- External File Protection5:291 credit or ad
- No Access Layout6:391 credit or ad
- Overdue Invoices pt. 15:551 credit or ad
- Overdue Invoices pt. 27:251 credit or ad
- Capturing Errors7:211 credit or ad
- Add Account8:071 credit or ad
- Delete Account2:341 credit or ad
- Multiple Files6:011 credit or ad
- Random Passwords6:591 credit or ad
- Manager Override pt. 15:551 credit or ad
- Manager Override pt. 25:331 credit or ad
Scripting18 lessons
- Send Email5:551 credit or ad
- Menu Button pt. 14:391 credit or ad
- Menu Button pt. 27:051 credit or ad
- Script Parameters4:131 credit or ad
- Find Rolodex7:171 credit or ad
- Dynamic List View3:551 credit or ad
- Dynamic Messages6:511 credit or ad
- Duplicate Invoices pt. 15:451 credit or ad
- Duplicate Invoices pt. 26:471 credit or ad
- Print Invoice Layout pt. 17:461 credit or ad
- Print Invoice Layout pt. 27:591 credit or ad
- Print Invoice Script5:471 credit or ad
- Batch Print Invoices7:471 credit or ad
- Inventory Control Add8:131 credit or ad
- Inventory Control Subtract5:491 credit or ad
- Deleting Portal Rows8:291 credit or ad
- Quick Find Script6:271 credit or ad
- Floating Menu5:041 credit or ad
Calculations15 lessons
- Sales Tax4:381 credit or ad
- Grand Total6:531 credit or ad
- Basic Phone Filter pt. 16:571 credit or ad
- Basic Phone Filter pt. 25:291 credit or ad
- Phone Number Validation5:231 credit or ad
- Remove Text Formatting5:501 credit or ad
- Overdue Invoice Display6:201 credit or ad
- Parsing Text Basics7:361 credit or ad
- Multiple Records5:321 credit or ad
- Scripts versus Calculations5:531 credit or ad
- Parsing Text Advanced5:101 credit or ad
- Field Level Tracking5:211 credit or ad
- Field Level Tracking Advanced7:011 credit or ad
- True Modification Timestamp5:101 credit or ad
- GetNthRecord Tooltip6:481 credit or ad
FileMaker Pro Advanced17 lessons
- Advanced Features Overview pt. 16:161 credit or ad
- Advanced Features Overview pt. 24:591 credit or ad
- Advanced Features Overview pt. 36:581 credit or ad
- Recover pt. 18:061 credit or ad
- Recover pt. 26:311 credit or ad
- Configuring Plug-Ins7:181 credit or ad
- Plug-In Examples5:271 credit or ad
- Database Design Report3:471 credit or ad
- Developer Utilities4:211 credit or ad
- File Maintenance6:411 credit or ad
- Debugging Scripts pt. 17:011 credit or ad
- Debugging Scripts pt. 26:421 credit or ad
- Custom Functions pt. 16:351 credit or ad
- Custom Functions pt. 23:131 credit or ad
- Recursive Custom Functions6:281 credit or ad
- Custom Menus Layout Driven8:211 credit or ad
- Custom Menus Scripted6:121 credit or ad
Multi-User Solutions12 lessons
- Hosts and Guests7:491 credit or ad
- Sharing a File4:471 credit or ad
- Record Locking Defined6:021 credit or ad
- Global Fields & Script Variables6:281 credit or ad
- Scripting for a Locked Record pt. 16:311 credit or ad
- Scripting for a Locked Record pt. 25:011 credit or ad
- Scripting for Multiple Locked Records6:471 credit or ad
- Marking Records pt. 15:481 credit or ad
- Marking Records pt. 25:411 credit or ad
- Saving a Found Set pt. 15:121 credit or ad
- Saving a Found Set pt. 25:061 credit or ad
- Retrieving a Found Set6:271 credit or ad