Objectives
- Start a new FileMaker or Claris Pro solution
- Import, export, and work with found sets of data
- Create calculations and use them in fields
- Create relationships between tables
- Build efficient layouts using themes and styles
Evaluation
At the end of the training, the participants who have achieved the objectives receive a certificate of achievement attesting the success of their participation.
Schedule
Day 1
Part 1: Foundations – Tables, fields, searching, and importing data
- The elements of FileMaker
- Use the elements of FileMaker as building blocks
- Data tables, text, number, date and time fields
- Learn to work with data
Part 2: The Data Model
- Understanding of different models to pave the way to learn the mechanics of the Relationship Graph in FileMaker.
Part 3 : Calcs Everywhere
- Basics of calculations
Day 2
Part 1: Relationships 01 – Let’s Begin
- Understanding of database relationships
- Entities, attributes, and key fields
Part 2: Layout Design – Form, list and report
- Explore tools for layout design
- Use tools and layout parts to create nuanced data entry forms, lists and reports
Part 3: Using, Managing, and Customizing Themes & Styles
- Explore cascading style sheets (CSS)
- Apply styles to layout objects
- Manage styles effectively
- Importance of naming conventions