FileMaker Pro Level 1 FM-01

Module 1FileMaker Platform Overview

• What are FileMaker apps?
• FileMaker version compatibility
• Accessing an app
• Real-world use cases
• Get started options

Module 2Using Starter Solutions

• Choose a starter solution
• Quick mobile development

Module 3Viewing and Working with Data

• Layouts
• Modes within layouts
• Views within layouts
• Records
• Working with Data
• Creating a new record
• Duplicating a record
• Modifying data
• Saving data
• Deleting data

Module 4Finding and Sorting Records

• Specifying search criteria
• Performing AND or OR searches
• Extending and constraining a found set
• Using operation in search criteria
• Finding strings of characters in a field
• Finding a range of data
• Finding exact data
• Choosing sort fields
• Setting sort order

Module 5User-Centered Design

• What is user-centered design?
• Three basic principles
• Think goals, not features
• Think differently

Module 6Importing Data

• Converting an existing file
• Converting Excel files

Module 7Creating Fields and Tables

• Create new tables
• Field types
• Fields used to automate and aggregate data
• Create new fields from the field picker

Module 8Relationships

• Relationship types
• Identifying relationship types
• Using primary and foreign keys to relate tables
• Primary keys
• Foreign keys
• Creating relationships

Module 9Layouts

• Creating layouts
• Layout parts
• Adding fields to a layout
• Selecting fields from field picker
• Layout themes and styles
• Themes
• Styles
• Creating more layouts

Module 10Layout Design Tools

• Status toolbar and inspector
• Layout resizing
• Layout width
• Screen stencils
• Selectin, resizing and moving objects
• Guides and grids
• Dynamic guides
• Ruler guides
• Object grip
• Using layout design tools

Module 11Special Layout Objects

• Portal
• Tap control
• Side control
• Popover
• Web viewer