FileMaker Pro Beginning: Getting Started as a Developer
Class Details
Length of class: two days
Price per person: $595
Version covered: 2024
Description
By the end of this two-day class by FileMaker Certified Developer Tim Jones, you will have built two simple database solutions from scratch, learning to plan and build database structures that implement one-to-many relationships, create Entity-Relationship diagrams, define tables, fields, and relationships, import data, create basic layouts, find and sort records, and write simple calculations. In the process, you will have gained a solid foundation of knowledge to use in developing your own FileMaker database solutions.
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
Mon-Tue, November 25-26, 2024
8:00 AM - 3:00 PM