FileMaker Pro Beginning: Getting Started as a Developer
Class Details
Length of class: two days
Price per person: $595
Version covered: 2023
Description
This 2-day class, taught by FileMaker Partner Trainer and Certified Developer Tim Jones, will give you a solid foundation of knowledge to use in developing FileMaker database solutions. Learn how to plan database structures, create Entity-Relationship diagrams, define tables, fields and relationships, import data, create basic layouts, find and sort records, and write simple calculations.
Prerequisites
This class requires only basic computing skills, such as using a mouse and opening and closing windows. No prior FileMaker Pro or database experience is required.
Outline
Plan a Database Solution
- overview of the FileMaker platform
- plan database solutions and create E-R Diagram
- create new empty database file
- define tables and fields
- set auto-enter options and validation rules
- create simple calculation fields
Understand Relationships
- understand and diagnose relationship types
- resolve many-to-many relationships
- define relationships between tables
Work with Data
- create, edit and delete records
- import data from Excel and other sources
- import a batch of images
- convert Excel sheet into a new database
- place portals and related fields on layouts
Design Layouts
- create layouts optimized for Desktop and mobile
- use themes and styles to update formatting on all layouts
- display related data
- define data-driven value lists and drop-down menus
Find and Sort Records
- find records using multiple criteria and requests
- constrain and extend the found set
- sort records by multiple fields
- printing records
Upcoming Dates
Tue-Wed, May 28-29, 2024
8:00 AM - 3:00 PM
Wed-Thu, July 10-11, 2024
8:00 AM - 3:00 PM
Wed-Thu, August 21-22, 2024
8:00 AM - 3:00 PM