FileMaker Pro Intermediate | Training Course
Claris Authorised
Training Provider
Course Facts
- 2 day course
- Our Trainers are Authorised Professionals
- Live Online or Classroom-based
- Certificate of completion
- Maximum class size of 6 for scheduled courses
- Unlimited support after your course
- Courses at all levels: Introduction, Intermediate, Advanced and Masterclasses
Course Outline
- Introduction to relational database systems
- Managing data using One-to-Many relationships
- Introduction to Scripting
- Scripting the creation of records
- Event-driven scripting using script triggers
- The power of calculation fields
- Database sharing and security issues
- Further scripting techniques
We offer FileMaker Pro Intermediate as a private course, which means the course content can be fully customised to your exact learning requirements and run on your preferred dates.
FileMaker Pro Private One-to-One Training
One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.
Enquire NowFileMaker Pro Team Training for Companies
Group bookings provide you with the most cost-effective way to train your team.
Enquire NowFileMaker Pro Intermediate — Team and Bespoke Training
Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.
- Sessions can be run online or in person, on your site or at our London training centre.
- We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
- Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
- We offer a free consultation service to work out every detail of your course.
Prices for bespoke sessions with our expert trainers start at £595 + VAT, depending on the course and number of people.
Costs include all preparation time to customise the course to your exact requirements.
FAQs about the FileMaker Pro Intermediate course
Is this FileMaker Pro Intermediate course suitable for me?
This course is designed for people who have experience in FileMaker Pro or have already attended one of our FileMaker Pro training courses or who would like to further their knowledge of best practice in the use of FileMaker Pro. If you are have any questions about whether the course could meet your needs, please speak to our customer service team, who will be delighted to advise you.
How is the content taught throughout the FileMaker Pro Intermediate course?
Our FileMaker Pro Intermediate course is extremely interactive. You will be using FileMaker Pro throughout the day, working through examples and live projects under the guidance of our trainer, who will be supporting you through each step.
How many people are likely to be in the class when I attend the FileMaker Pro Intermediate course?
For private classes in FileMaker Pro Intermediate, we recommend a maximum of 8 to 10 people from the same company in the class. Please ask our customer service team to help you find the right balance of people per class and the number of days training you need.
Should I attend the FileMaker Pro Intermediate course in person or live online?
For in-person courses at our London training centre, you will receive a warm personal welcome, your choice of the latest Mac or PC and morning and afternoon refreshments. If you prefer to attend remotely, rest assured that you will be taught live by the same experts that deliver our in-person courses, covering the same training content, using the same exercises and materials. A second monitor is recommended but not essential.
What support is available after I attend the FileMaker Pro Intermediate course?
We offer ongoing support to our FileMaker Pro Intermediate course attendees through email and by arrangement, phone calls. You are welcome to ask any questions on topics covered during training. Our trainer will always do their best to explain principles and help you with any issues you encounter.
Will I receive a certificate upon completion of my FileMaker Pro Intermediate course?
Yes, you'll receive a certificate of completion from Transmedia, demonstrating your knowledge and attendance on our FileMaker Pro Intermediate course. Our certificates note our Authorised Training Centre status.
What you will learn
- Understanding relational database systems and how to create efficient relationships between tables to solve complex data challenges.
- How to manage data using one-to-many relationships, including displaying, filtering and navigating related records with portals.
- Creating and editing scripts to create, edit and delete records, automate workflows and enhance user interactions with custom windows.
- Exploring event-driven scripting using triggers to execute actions based on user interactions, window or layout changes.
- How to use calculation fields with logical and aggregate functions to perform advanced data analysis and dynamic calculations.
- Implementing database security by defining accounts, privilege sets and rules to control access and protect sensitive data.
- Mastering general techniques to streamline data management processes and improve the functionality of your FileMaker solutions.
- Learning more advanced skills to enable you to build more robust databases that enhance productivity across your organisation.
Overview of FileMaker Pro Intermediate
Course Outline for FileMaker Pro Intermediate
Introduction to relational database systems
- The efficiencies achieved using related tables and the problems they solve
- Defining relationships between tables and understanding the Match field
- 'One to many' relationships
- 'One to one' relationships
- 'Many to many' relationships
Managing data using One-to-Many relationships
- Placing fields from a parent-table on a child layout
- Understanding and using portals on a parent layout
- Displaying related records in a portal
- Creating new records in a portal
- Navigating related files using the Go to Related Record script step
- Filtering portals
Introduction to Scripting
- Scripts v. button single actions
- Creating, duplicating and editing scripts
- Locating and adding script steps to a script
- Commonly scripted procedures
- Running scripts from buttons
- Building a Button Bar
- Scripting the creation of new windows
- Use the Card style window
- Specifying name, size and position
- Switching between windows
- Organising scripts using the Script Workspace window
- Organising scripts in folders
Scripting the creation of records
- Recap on the concept of primary and secondary keys
- Scripting the creation of related records using Set Variable and Set Field script steps
- Using the Commit Record script step
- Refreshing portals
Event-driven scripting using script triggers
- Window-based triggers
- Object-based triggers
- Layout-based triggers
- Worked examples
The power of calculation fields
- Formulae, operators and functions
- Using Text and Number functions
- Using logical functions such as If(), IsEmpty() and Case()
- Using aggregate calculations such as Count(), Min() and Max()
- Using the Let() function
Database sharing and security issues
- Defining accounts and passwords
- Understanding privilege sets
- Granting limited access by specifying a formula or rule
- Assigning full access rights to a script
Further scripting techniques
- Using script variables
- Using script parameters
- Running scripts using event triggers
- Script trigger categories
- Using script triggers - worked examples
- Using custom dialogs in scripts
- Using conditional script steps; If,Else If, Else and End If
- Using globally stored fields as part of a scripted search
- Scripting the export of data e.g as an Excel file or as a PDF and using variables to name the output file
Our Clients
Our Recent Success Stories
Resolve
Greg's Story
Head of Video at Hurst UK
Photoshop
Karen's Story
Picture Editor at Reach PLC
Photoshop
Kiren's Story
Marketing Manager at Dataminer
600+ Reviews
Why Transmedia?
Unlimited Training Support
We offer unlimited training support after your course.
Bespoke Training Solutions
Customised training and software solutions based on your exact specification.
Worldwide Creative Skills Training
Join our authorised training courses live online from anywhere in the world.
Authorised Training Professionals
Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.
Courses Live Online
Join our virtual classrooms to learn from the comfort of your own space in real time from our accredited training experts.
SEE COURSES
Classroom Training
Join us at one of our Authorised Training Centres for a traditional classroom-based experience.
We have everything ready for you to have the best training experience.
SEE COURSES
Private Courses
One-to-one tuition or a private group training with just you or your colleagues.
We can train you live online, at one of our centres or onsite, wherever you are located.
SEE COURSESUseful Links
- Home page for Claris FileMaker — create custom robust operational apps. – Official FileMaker page, showing how to create custom robust operational apps
- FileMaker store – Where to buy FileMaker software
- FileMAker Wikipedia page – History and background of Claris FileMaker
- Claris Community - join the Claris and FileMaker Community – Become part of the FileMaker community and get help and resources
Latest Blog Articles
Harnessing the Power of Web Services in FileMaker with API Connections
Low-Code Automation Tools and the Claris Platform
Entrepreneurs, SMEs and Department Heads - Why You Need Claris FileMaker