FileMaker

FileMaker Pro Level 2 FM-02

  • 0 upcoming dates
  • $825 per seat

About this class

Our FileMaker course uses the latest version, but if you haven?t upgraded yet, all courses feature work from earlier versions of FileMaker as well. Our instructors will be happy to point out differences between the software versions throughout the course. For private training in any legacy version. (contact us at 916-920-1700 for details).

This two-day, instructor-led course is designed for both Macintosh and Windows users, who have some experience using FileMaker Pro, but are finding that their needs for managing data exceeds their current capabilities.

What you'll be able to do

  • Format field objects
  • Create interfaces for IOS devices
  • Create efficient interfaces for the user
  • Learn about powerful tools in the FileMaker Platform including:
  • Calculations, scripting and reports
  • Integration with other business systems
  • Security
  • Sharing and deployment of your app to other users

Before you attend

Students should attend Course FM-01, FileMaker Pro Level 1 or have equivalent knowledge and skills.

Course outline

  1. Module 1Formatting Field Objects

    • Data formatting
    • Conditional formatting
    • Field control styles
    • Value lists

  2. Module 2User Interface Best Practices

    • Human interface best practices
    • FileMaker Web Direct guide

  3. Module 3Calculations

    • Creating calculations
    • Specify calculation dialog
    • Creating calculation fields
    • Functions
    • Operators
    • Boolean results

  4. Module 4Scripting

    • What are scripts?
    • Script steps
    • Creating and organizing scripts
    • Organizing scripts
    • Editing scripts
    • Triggering scripts
    • Buttons and button bars
    • Single step scripts
    • Create email with file as attachment
    • Startup script

  5. Module 5User Interface Best Practices

    • User interface best practices

  6. Module 6Calculations

    • Creating calculations
    • Functions and operators

  7. Module 7Scripting

    • What are scripts?
    • Creating and editing scripts
    • Writing scripts
    • Triggering scripts
    • Buttons
    • Startup script

  8. Module 8Reporting

    • Subsummary reports
    • Subsummary parts
    • Summary fields
    • Using subsummary parts to enhance user experience
    • Charts
    • Quick charts

  9. Module 9Integration

    • Sharing data with outside users
    • Exporting records
    • Saving as a PDF
    • Integrating with other data sources
    • What is ODBC?
    • External SLQ Sources (ESS)
    • Import from OOBC data sources
    • Execute SQL Script step

  10. Module 10Security

    • Prompt for login
    • Using FileMaker Pro
    • Using FileMaker Server
    • Opening FileMaker files
    • Opening local files
    • Transferring files to an IOS device
    • Opening hosted files

Download the full outline (PDF)

Run this for a team

Private cohorts run on your dates, at your site or online, with the labs pointed at your environment. Above about four people it usually costs less than buying seats.

Or call 916-920-1700, weekdays 8 to 5 Pacific.

More software development classes

See all
Build Intelligent Applications
Microsoft AB-410

Build Intelligent Applications

This course teaches learners how to design and build intelligent applications on the Microsoft Power

  • $1,895 per seat
Next: Nov 16–18 Confirmed to run

8 dates on the calendar