There are no dates currently on the public training schedule for this course. However, we can provide this training to your group of three or more people either remotely or at your business location. Please contact us for more information on our corporate training rates and availability by calling (562) 291-3291 or filling out this contact form.
| Price per person: | $595 |
| Length of class: | two days |
| Version covered: | 2025 |
| Delivery format: | live over Zoom |
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 database structures, create Entity-Relationship diagrams, implement one-to-many relationships, resolve many-to-many relationships, define tables, fields, and relationships, import data, create basic layouts, find and sort records, and write simple calculations. After just two days, you will have gained a solid foundation of knowledge to use in developing your own FileMaker database solutions.
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.
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