Faysal AzizFileMaker Essentials
Turn Everyday Data into Useful Apps
Build a practical desktop application, organise information and simplify everyday tasks.
Why this course
Information is easier to work with when it has a clear structure, a convenient entry screen and a reliable way to find what matters. Claris FileMaker Pro brings these elements together, allowing users to create custom desktop applications through visual tools, layouts and built-in functions.
This hands-on foundation course introduces FileMaker in an approachable, practical way. Participants build a small desktop application while learning how to organise records, choose suitable fields, design forms and bring existing information into their database. They then add useful calculations, simple automation and a straightforward report. Each topic builds on the previous one, helping participants understand how the application works as they create it.
The course uses an active FileMaker Pro trial and focuses on skills participants can apply to everyday work. Practical exercises build towards completing and understanding one small desktop application within a single day.
Learning outcomes
By the end of the course, participants will be able to:
- Create a desktop database with suitable tables, fields and records.
- Design clear forms and list layouts for everyday use.
- Import, find, sort and export data.
- Add simple calculations and button-driven automation.
- Produce a straightforward report and PDF output.
- Protect access to their application and create backup copies.
Prerequisites
- Comfort using desktop applications, managing files and working with spreadsheet-style data.
- A laptop running a Claris-supported Windows or macOS version and meeting FileMaker Pro’s system requirements.
- An active FileMaker Pro trial installed before training.
- Unrestricted internet access.
6 modules
011. Getting Started with FileMaker Pro3 topics
- Custom applications and everyday data management
- FileMaker Pro interface and operating modes
- Creating and opening a FileMaker file
022. Building and Organising a Database4 topics
- Tables, fields and records
- Field types and unique record identifiers
- Data validation and automatic field entries
- Introduction to table relationships
033. Designing Clear Data Entry Screens4 topics
- Form and list layouts
- Field placement, labels and formatting
- Dropdown lists and value lists
- Layout navigation
044. Working with Data and Reports4 topics
- CSV import and field matching
- Adding, editing and deleting records
- Finding records and sorting results
- Simple reports, printing and PDF output
055. Simplifying Everyday Tasks3 topics
- Calculated fields and simple functions
- Basic scripts
- Buttons and script execution
066. Protecting and Managing the Application3 topics
- User accounts, passwords and access permissions
- Saving copies and desktop backups
- Exporting data to CSV
This outline serves as a training guideline. The trainer reserves the right to amend the content, sequence or emphasis without prior notice to reflect participant needs, available software and the practical requirements of delivery.
A programme built around your team.
Share your training goals and requirements.