FileMaker Pro FM-001

Syllabus

Using Starter Solutions

Choose a Starter Solution.

Viewing 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

Finding and Sorting Records

Specifying Search Criteria
Performing AND or OR Searches
Extending and Constraining a Found Set
Using Operators in Search Criteria
Finding Strings of Characters in a Field
Finding a Range of Data
Finding Exact Data
Sorting Records
Choosing Sort Fields
Setting Sort Order

Importing Data

Converting an Existing File
Converting Excel Files

Creating Fields and Tables

Create New Tables
Field Types
Fields Used to Automate and Aggregate Data
Create New Fields from the Field Picker

Relationships

Relationship Types
Identifying Relationship Types
Using Primary and Foreign Keys to Relate Tables
Primary Keys
Foreign Keys
Creating Relationships

Layouts

Creating Layouts
Layout Parts
Adding Fields to a Layout
Selecting Fields from Field Picker
Layout Themes and Styles

Layout Design Tools

Status Toolbar and Inspector
Inspector
Layout Resizing
Layout Width
Screen Stencils
Selecting, Resizing, and Moving Objects
Guides and Grids
Dynamic Guides
Ruler Guides
Object Grid
Using Layout Design Tools

Formatting Field Objects

Data Formatting
Conditional Formatting
Field Control Styles
Value Lists

Calculations

Creating Calculations
Specify Calculation Dialog
Creating Calculation Fields
Functions and Operators

Scripting

Script Steps
Creating and Organizing Scripts
Editing Scripts
Triggering Scripts
Buttons & Button Bars
Single Step Scripts
Create email with file as attachment

Integration

Sharing Data With Outside Users
Exporting Records
Saving as a PDF

Security

Login
Accounts
Privilege Sets

Duration : 1 days
Regular Rate : 265.00 $
Preferential Rate : 225.25 $
Note :
Upcoming Dates :