O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

FileMaker Pro 12: Intermediate

Video Description

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.

Table of Contents

  1. Introduction
    1. About John Mark Osborne 00:04:51
    2. System Requirements 00:03:17
    3. FileMaker 12 Family of Products 00:06:48
    4. About the Tutorial Series pt. 1 00:05:08
    5. About the Tutorial Series pt. 2 00:04:55
    6. Work Files 00:01:32
    7. Locked Files 00:06:28
  2. Interface Design
    1. Recap Previous Tutorial 00:08:03
    2. Screen Size 00:05:29
    3. Background pt. 1 00:04:19
    4. Background pt. 2 00:09:13
    5. Tabs/Bars and Buttons pt. 1 00:05:55
    6. Tabs/Bars and Buttons pt. 2 00:03:36
    7. Tabs/Bars and Buttons pt. 3 00:05:10
    8. Field Outlines 00:06:08
    9. Sub-Areas 00:10:11
    10. Buttons 00:06:57
    11. Finishing Touches pt. 1 00:04:33
    12. Finishing Touches pt. 2 00:04:33
    13. Tabbed Buttons pt. 1 00:05:17
    14. Tabbed Buttons pt. 2 00:03:15
    15. Tabbed Sub Area 00:07:24
    16. List View pt. 1 00:04:25
    17. List View pt. 2 00:07:55
    18. List View pt. 3 00:04:30
    19. Autosizing pt. 1 00:06:15
    20. Autosizing pt. 2 00:05:23
    21. Design Considerations 00:06:10
  3. Relationships
    1. Relational Theory 00:06:11
    2. Data Modeling pt. 1 00:07:28
    3. Data Modeling pt. 2 00:06:41
    4. Entity-Relationship Diagrams pt. 1 00:04:40
    5. Entity-Relationship Diagrams pt. 2 00:06:21
    6. Invoices ERD 00:05:05
    7. Creating a Relationship 00:06:39
    8. Related Fields 00:03:47
    9. Populating a Foreign Key pt. 1 00:06:11
    10. Populating a Foreign Key pt. 2 00:06:51
    11. Live Links 00:06:23
    12. Many-To-Many Relationship pt. 1 00:04:50
    13. Many-To-Many Relationship pt. 2 00:05:10
    14. Creating a Portal 00:08:28
    15. How the Join Works 00:04:15
    16. Portal Improvements 00:06:27
    17. Aggregating Portals 00:07:33
    18. Two-Way Relationships 00:08:42
    19. Sorting a Portal 00:03:54
    20. Start and End 00:05:36
    21. Go to Related Record 00:05:23
    22. Organizing Layouts 00:07:03
    23. Completing the Interface 00:06:53
  4. Table Occurrences
    1. What are Table Occurrences? 00:07:22
    2. Where are Table Occurrences Used? 00:08:18
    3. Portal Filtering 00:06:50
    4. Totaling Filtered Portals 00:06:34
    5. Filtered Relationships pt. 1 00:07:52
    6. Filtered Relationships pt. 2 00:06:13
    7. Portal Filtering Discussion 00:05:34
    8. Calculated Portals 00:06:36
    9. Dynamic Calculation 00:03:40
    10. Date Range Portals 00:07:48
    11. Self-Relationships 00:06:38
    12. Table Occurrence Tricks pt. 1 00:05:57
    13. Table Occurrence Tricks pt. 2 00:04:49
    14. Conditional Value Lists pt. 1 00:02:29
    15. Conditional Value Lists pt. 2 00:06:20
    16. Scripts and Calculations 00:07:05
    17. Organizing the Graph 00:07:19
    18. Table Occurrence Groups 00:04:44
  5. Security
    1. Overview pt. 1 00:06:30
    2. Overview pt. 2 00:07:24
    3. Complete Approach 00:07:37
    4. Accounts 00:06:00
    5. New Account 00:05:50
    6. Other Privileges 00:06:24
    7. Data Access and Design 00:07:00
    8. Record Level Access 00:05:25
    9. Extended Privileges 00:05:44
    10. External File Protection 00:05:29
    11. No Access Layout 00:06:39
    12. Overdue Invoices pt. 1 00:05:55
    13. Overdue Invoices pt. 2 00:07:25
    14. Capturing Errors 00:07:21
    15. Add Account 00:08:07
    16. Delete Account 00:02:34
    17. Multiple Files 00:06:01
    18. Random Passwords 00:06:59
    19. Manager Override pt. 1 00:05:55
    20. Manager Override pt. 2 00:05:33
  6. Scripting
    1. Send Email 00:05:55
    2. Menu Button pt. 1 00:04:39
    3. Menu Button pt. 2 00:07:05
    4. Script Parameters 00:04:13
    5. Find Rolodex 00:07:17
    6. Dynamic List View 00:03:55
    7. Dynamic Messages 00:06:51
    8. Duplicate Invoices pt. 1 00:05:45
    9. Duplicate Invoices pt. 2 00:06:47
    10. Print Invoice Layout pt. 1 00:07:46
    11. Print Invoice Layout pt. 2 00:07:59
    12. Print Invoice Script 00:05:47
    13. Batch Print Invoices 00:07:47
    14. Inventory Control Add 00:08:13
    15. Inventory Control Subtract 00:05:49
    16. Deleting Portal Rows 00:08:29
    17. Quick Find Script 00:06:27
    18. Floating Menu 00:05:04
  7. Calculations
    1. Sales Tax 00:04:38
    2. Grand Total 00:06:53
    3. Basic Phone Filter pt. 1 00:06:57
    4. Basic Phone Filter pt. 2 00:05:29
    5. Phone Number Validation 00:05:23
    6. Remove Text Formatting 00:05:50
    7. Overdue Invoice Display 00:06:20
    8. Parsing Text Basics 00:07:36
    9. Multiple Records 00:05:32
    10. Scripts vs. Calculations 00:05:53
    11. Parsing Text Advanced 00:05:10
    12. Field Level Tracking 00:05:21
    13. Field Level Tracking Advanced 00:07:01
    14. True Modification Timestamp 00:05:10
    15. GetNthRecord Tooltip 00:06:48
  8. FileMaker Pro Advanced
    1. Advanced Features Overview pt. 1 00:06:16
    2. Advanced Features Overview pt. 2 00:04:59
    3. Advanced Features Overview pt. 3 00:06:58
    4. Recover pt. 1 00:08:06
    5. Recover pt. 2 00:06:31
    6. Configuring Plug-Ins 00:07:18
    7. Plug-In Examples 00:05:27
    8. Database Design Report 00:03:47
    9. Developer Utilities 00:04:21
    10. File Maintenance 00:06:41
    11. Debugging Scripts pt. 1 00:07:01
    12. Debugging Scripts pt. 2 00:06:42
    13. Custom Functions pt. 1 00:06:35
    14. Custom Functions pt. 2 00:03:13
    15. Recursive Custom Functions 00:06:28
    16. Custom Menus Layout Driven 00:08:21
    17. Custom Menus Scripted 00:06:12
  9. Multi-User Solutions
    1. Hosts and Guests 00:07:49
    2. Sharing a File 00:04:47
    3. Record Locking Defined 00:06:02
    4. Global Fields & Script Variables 00:06:28
    5. Scripting for a Locked Record pt. 1 00:06:31
    6. Scripting for a Locked Record pt. 2 00:05:01
    7. Scripting for Multiple Locked Records 00:06:47
    8. Marking Records pt. 1 00:05:48
    9. Marking Records pt. 2 00:05:41
    10. Saving a Found Set pt. 1 00:05:12
    11. Saving a Found Set pt. 2 00:05:06
    12. Retrieving a Found Set 00:06:27
  10. Working with John Mark Osborne
    1. Free Resources 00:05:02
    2. Training 00:06:24
    3. Consulting and Meta-Consulting 00:02:41
    4. Solutions 00:05:18
    5. Contacting Me 00:02:48