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 :
qty