FileMaker Pro is an award-winning database software program that works both for Mac, Windows and Mobile users. This comprehensive three-day hands-on FileMaker Pro course focuses on the features and benefits of FileMaker with step-by-step easy to follow instructions plus mentored lab exercises. Attendees will learn how to build a sample FileMaker solution from start to finish using all of the built-in tools and templates to demonstrate the different kinds of databases you can create with FileMaker Pro. The course also covers calculations, scripting, and how to keep your data secure. Course taught by an expert real-world FileMaker Pro Certified Instructor.
- Price: $1,295.00
- Duration: 1 day
- Delivery Methods: Virtual
Date | Time | Price | Option |
---|---|---|---|
Please contact us at info@toptalentlearning.com or 469-721-6100 for this course schedule. |
FileMaker Platform Overview
- FileMaker Product Line
- FileMaker Version Compatibility
- Accessing a Solution
Understanding a Database
- Fields vs. Records vs. Tables
- Database information vs. Spreadsheet Information
Viewing and Working with Data
- Layouts
- Modes Within Layouts
- Views Within Layouts
- Records: Adding, Deleting, and Duplicating
- Working With Data
Using Starter Solutions
- Choose a Starter Solution
- Quick Mobile Development
Viewing and Working with Data
- Layouts
- Modes Within Layouts
- Views Within Layouts
- Records: Adding, Deleting, and Duplicating
- Working With Data
Finding and Sorting Records
- Specifying Search Criteria
- Extending and Constraining a Found Set
- Using Operators in Search Criteria
- Sorting Records
User-Centered Design
- Understanding User-Centered Design
- Basic Principles
User-Interface Best Practices
- Objectives
- User-Interface Best Practices
Creating Fields and Tables
- New Tables
- Field Types
- Create New Fields from the Field Picker
- Create New Fields from the Manage Database Dialog
Layouts
- Creating Layouts
- Adding Fields to a Layout
- Layout Themes and Styles
- Creating More Layouts
Layout Design Tools
- Status Toolbar and Inspector
- Layout Resizing
- Guides and Grids
- Using Layout Design Tools
Reporting
- Basic Reports
- Planning for Reports
- Subsummary Reports
- Working with Charts
Integration
- Sharing Data With Outside Users
- Integrating with Other Data Sources
- FileMaker Pro Connectivity Options
- Integrating with Web Services
- Working ODBC
Formatting Field Objects
- Data Formatting
- Conditional Formatting
- Field Control Styles
- Value Lists
Relationships
- Objectives
- Relationships
- Using Primary and Foreign Keys to Relate Tables
- Creating One-to-Many and Many-to-Many Relationships
Special Layout Objects
- Portal
- Tab Control
- Slide Control
- Popover
- Web Viewer
Importing Data
- Converting an Existing File
- Converting Excel Files
Scripting
- Understanding Scripts
- Creating and Editing Scripts
- Writing Scripts
- Buttons
- Startup Script
Solution Logic: Calculations
- Mobile Functions
- Container Functions
- Aggregate Functions
- Custom Functions
Solution Logic: Scripting
- Conditional Scripting
- Scripting Tools
- Script Triggers
- Custom Menus
- Using Scripts to Find Data
- Navigation
- Window Management
- Looping Techniques
- Scripting for Mobile Users
Exporting Data
- To Tab-Delimited Text
- To Excel
- Sending Records as Email
- Creating PDFs
- Data Repair
Calculations
- Creating Calculations
- Functions and Operators
- Number Functions
- Text Functions
- Date and Time Functions
- Logical Functions
Security
- Creating Accounts and Granting Access
- Setting Up Privilege Sets
- Restricted Conditional Deletes
- Conditional Record Access
- Advanced Security & Encryption
Deployment
- Deployment Options
- Introduction to Using FileMaker Server
- Deploying Using FileMaker WebDirect
- FileMaker Platform Overview
- Understanding a Database
- Viewing and Working with Data
- Using Starter Solutions
- Viewing and Working with Data
- Finding and Sorting Records
- User-Centered Design
- User-Interface Best Practices
- Creating Fields and Tables
- Layouts
- Layout Design Tools
- Reporting
- Integration
- Formatting Field Objects
- Relationships
- Special Layout Objects
- Importing Data
- Scripting
- Solution Logic: Calculations
- Solution Logic: Scripting
- Exporting Data
- Calculations
- Security
- Deployment
No special instructions regarding this course’s target audience provided. Please contact us to discuss if you are unsure whether this course is for you!
Basic knowledge of a Mac or PC computer is required. Understanding of some database terminology is also helpful.