FileMaker Pro
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: $1295.00
- Duration: 2 days
- Delivery Methods: Virtual
- DIR Discount: 7.0%
Why choose TOPTALENT?
- Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
- Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
- Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
- Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.
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
Question: What if I have to reschedule my class due to conflict?
Answer: Ten (10) business days’ notice is required to reschedule a class with no additional fees. Notify TOPTALENT LEARNING as soon as possible at 469-721-6100 or by written notification to info@toptalentlearning.com to avoid rescheduling penalties.
Question: How do I enroll for this class?
Answer: Please contact our team at 469-721-6100; we will gladly guide you through the online purchasing process.
Question: What happens once I purchase a class?
Answer: You will receive a receipt and an enrollment confirmation sent to the email you submitted at purchase. Your enrollment email will have instructions on how to access the class. Any additional questions our team is here to support you. Please call us at 469-721-6100.
Question: What is your late policy?
Answer: If a student is 15 minutes late, they risk losing their seat to a standby student. If a student is 30 minutes late or more, they will need to reschedule. A no-show fee will apply. Retakes are enrolled on a stand-by basis. The student must supply previously issued courseware. Additional fees may apply.
Question: What happens when I finish my class?
Answer: You will receive a ‘Certificate of Completion’ once you complete the class. If you purchased an exam voucher for the class, a team member from TOPTALENT LEARNING will reach out to discuss your readiness for the voucher and make arrangements to send it.
