FileMaker Classes

• FileMaker Inc. FileMaker: Getting Started with FileMaker

• FileMaker Inc. FileMaker: Creating Layouts

• FileMaker Inc. FileMaker: Functions, Relationships, Lookups and Portals

​

FileMaker Inc. FileMaker: Getting Started with FileMaker

3 Hours

​

• Databases

  • Fields, records, and tables

• Parts of the screen

  • Title Bar

  • Toolbars

  • Status Area/Book Column

  • Zoom Controls

  • Status Area Control Button

  • Mode Indicator Button

• Moving within a record

• Moving between records

• Modes

  • Browse

  • Find

  • Layout

  • Preview

• Views

  • View as Form

  • View as List

  • View as Table

• Creating new records

• Editing a record

• Duplicating records

• Adding information from the index

• Inserting special info

• Finding information

  • Performing simple finds

  • Performing complex finds

  • And finds

  • Or finds

  • Omitting records

  • Constraining and extending found sets

  • Performing a quick find

  • Symbols

• Sorting records 

 

Top

​

FileMaker Inc. FileMaker: Creating Layouts

3 Hours

It is highly recommended but not required that you take FileMaker Inc. FileMaker: Getting Started with FileMaker first.

 

• Layout options

• Displaying rulers

• Changing tab order

• Creating buttons

• Working with layout tools

  • Selection tool

  • Text tool

  • Line tool

  • Rectangle tool

  • Rounded Rectangle tool

  • Oval tool

• Changing lines and fills

• Copying the formatting from one object to another

• Aligning objects

• Changing the order of objects

• Sliding objects together

• Creating tabbed layouts

• Creating summary reports

  • Summary fields

  • Summary parts

  • Sub-summaries

  • Grand summaries

• Creating mailing labels

 

Top

​

FileMaker Inc. FileMaker: Functions, Relationships, Lookups and Portals

3 Hours

It is highly recommended but not required that you take FileMaker Inc. FileMaker: Getting Started with FileMaker and FileMaker Inc. FileMaker: Creating Layouts first.

 

• Working with calculated fields

• Functions

  • The Round function

  • The IF function

  • Logical operations

  • Text operators

  • Nested IF statements

  • Today's Date calculation

  • The PMT function

  • The SUM Function

  • The PROPER Function

  • The Right Function

  • The COUNT function

  • The AVERAGE function

  • The MAX function

  • The MIN function

  • The DAYNAME function

  • The MONTHNAME function

  • The YEAR function

• Establishing relationships

• Using repeating fields

• Creating lookups

• Creating portals

​

Top