Training Home | FileMaker Pro 9 Beyond the Basics
Advanced FileMaker Pro 9 Training DVD
Take your skills to the next level. This Advanced FileMaker Pro 9 training DVD is the ultimate in comprehensive learning for the discerning professional.
The training uses broadcast quality audio and video to deliver concise and informative training right to your desktop. Complete with practical working files and presented via an intuitive, easy-to-use interface, These Advanced FileMaker Pro 9 tutorials make learning simple, quick and enjoyable. All training courses are authored by certified professional instructors who have a passion for teaching.
Training Benefits - Learn from the Pros
- Reduce learning time by 80%. Learn from a professional trainer from your own desk.
- Visual training method, offering users increased retention and accelerated learning.
- Breaks even the most complex applications down into simplistic steps, ideal for users who learn faster when shown.
Table of contents : see below. - Try a Free Demo
For evaluation purposes the links below offer an insight into the quality of these Advanced FileMaker Pro 9 tutorials. In order for the demo videos to play QuickTime needs to be installed.Introduction
- Welcome
- Using the exercise files
1. Data Modeling
- Introducing data modeling
- Reviewing relationships types
- Developing a list of entities
- Diagramming relationships
- Resolving one-to-one and many-to-many relationships
- Comparing the Relationship Graph and ERD
2. Beyond Basic Relationships
- Understanding multi-step relationships
- Working with external files
- Non-equijoin relationships
- Using global fields in relationships
3. Working with Number and Text Function Calculations
- Reviewing number functions
- Floor/Ceiling functions
- Round/Truncate functions
- Reviewing text functions
- Length functions
- Pattern Count functions
- Position functions
- Left/Right/Middle functions
- Filter and Substitute functions
4. Working with Logical Function Calculations
- Reviewing logical functions
- Logical functions pt. 1: IsEmpty
- Logical Functions pt. 2: Let
- Logical Functions pt. 3: Evaluate
- Self functions
5. Working with Text Formatting Function Calculations
- Reviewing text formatting functions
- Defining fields using text formatting functions
6. Working with Aggregate Function Calculations
- Reviewing aggregate functions
- Defining fields using aggregate functions
- Using the List function
7. Working with Objects in FileMaker
- Naming objects
- Using the Go to Object script step
- Using the LayoutObjectNames function
- Using the Get(ActiveLayoutObjectName) function
- Using the GetLayoutObjectAttribute function
- Putting it all together
8. Beyond Basic Reporting
- What is a subsummary report?
- Creating subsummary reports
- Subsummary reports with no body part
- Ranking reports
- Summarizing by multiple variables
- Cross-tab reports
9. Beyond Basic Scripting
- Scripting for developers
- The ''If'' script step
- More with custom dialogs
- Error capture
- The Set Field script step
- Script parameters
- Script results
- Looping scripts
- Script variables
- Copying and pasting scripts
10. Publishing Your FileMaker Databases on a Network
- Peer-to-peer networking
- The benefits of FileMaker Server
- Mixing FileMaker 7, 8, and 9
- FileMaker Server vs. FileMaker Server Advanced
- Installing FileMaker Server
- The Deployment Assistant
- The Admin Console start page
- Configuring FileMaker Server
- Uploading databases
- Scheduling
11. Working with External SQL Sources in FileMaker
- Connecting to external data sources
- Setting up DSN (Mac)
- Setting up DSN (Windows)
- Managing sources
- Adding to the Relationship Graph
- Creating supplemental fields
- Synchronizing shadow fields
- Working with Flash and external data sources
12. Extending the Web Viewer
- Using custom URLs in the Web Viewer
- Tabbing into and within the Web Viewer
- Printing and previewing with the Web Viewer
- Setting the Web Viewer script step
- Flash in the Web Viewer
13. Publishing Your Databases on the Web
- FileMaker 9 web publishing options
- Prepping your files for web publishing
- Configuring the server for web publishing
14. Instant Web Publishing Tutorials
- Instant web publishing (IWP) overview
- Prepping your database for IWP
- Hosting options for IWP
- Logging in and out
- Browse mode
- Find mode
- Edit mode
- Special considerations
15. The XSLT Site Assistant
- Preparing your files for XSLT
- Using the XSLT Site Assistant
- Previewing your site
16. The PHP Site Assistant
- Preparing files for publishing
- Choosing a layout group
- Selecting a site profile
- Defining the site
- Previewing the PHP site
FileMaker Training Video Conclusion
- Goodbye
FileMaker Pro 9 Beyond the Basics
Title Information.
In this Advanced FileMaker Pro 9 Training Video , Certified Developer and Authorized Trainer Cris Ippolite offers comprehensive training in how to use FileMaker Pro 9 to its full potential. The tutorials teach numerous hands-on techniques for publishing FileMaker Pro 9 databases to networks and the web. This training video also covers relationship types, external data sources, the new FileMaker Server 9, functions, objects, simple and complex reports, and even the new PHP Site Assistant. Exercise files accompany the tutorials. Close »
Format : DVD
Price : $99.95 | £49.95 | €64.95
Publisher : lynda.com, Inc.
Duration : 8.75 hours - 96 lessons
Platform : PC or Mac
Closed Captioning : No
Advanced FileMaker Pro 9 Related Training Videos :
FileMaker Pro 9 Training DVD
FileMaker Pro 9 Training DVD
Learn Online - Unlimited Access - Low Price
Giving you amazing freedom to learn at your own pace these online training videos combine high quality professionally created content, broadcast standard high definition video and crystal clear audio, at an extremely cost effective price. The tutorials are presented via an easy to use interface.
You can now access an entire library of professionally created tutorials in High Definition video for the same price as our competitors charge from one DVD.
Users are bound by no constants on the amount of titles that can be viewed, access can be from any location and where available, working files are included at no extra charge.
Comprehensive list of all Online Training Courses included in the online service.
CREATE A TEST ACCOUNT
Sample the quality of this online training with a free online test account. You will have immediate access to the first 20 minutes of all the tutorials in the online learning library.
