Training Home | FileMaker Pro 9 Training DVD
FileMaker Pro 9 Training DVD
Take your skills to the next level. This 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 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 FileMaker Pro 9 tutorials. In order for the demo videos to play QuickTime needs to be installed.Introduction
- Welcome
- Using the exercise files
1. Getting Started
- What is a database?
- Flat files vs. relational databases
- How FileMaker works
- Activation
- Essential preferences
- Interface tour
- Using the Help system
2. Database Creation Essentials
3. Managing Fields
- Managing fields
- Using text fields
- Using number fields
- Using date fields
- Using time/timestamp fields
- Using container fields
- Using calculation fields
- Using summary fields
- Organizing fields
4. Auto-Enter Field Options
- Creating auto-entry fields
- Creating serial fields
- Auto-entering previous values or data
- Auto-entering calculated values
- Field filtering
- Looking up values from other fields
5. Validation and Storage Field Options
- Field validation and custom messages
- Always vs. data entry validation options
- Storage options for global fields
- Indexing options for fields
6. Working with Records in FileMaker
- Creating and duplicating records
- Editing and locking records
- Deleting records and backing up files
- Committing and restoring data
7. Creating Layouts
- Layout overview
- Creating layouts
- Creating a standard form
- Creating a list/report view
- Creating a table view
- Creating labels
- Creating envelopes
8. Working with Layouts
- The Layout Setup dialog window
- Layout parts overview
- Exploring layout tools and status area
- Arrange, Group, and Lock layout objects
9. Formatting Layout Objects
- Text formatting
- Placing and formatting objects and graphics
- Formatting fields and applying field attributes
- Conditional formatting
- Field behaviors
- Using Auto-Complete
- Creating and using the Tab Control feature
- Setting the tab order
- Resizing layout objects
10. Web Viewer Essentials
- Using the FileMaker Web Viewer
- Adding Web Viewer to your layouts
- Setting up the Web Viewer using templates
11. Finding Data in FileMaker
- Basic find
- New requests in find mode
- Search symbols
- Constraining and extending a find request
- Finding date/time and timestamp data
- Finding matching records without find mode
- Find and Replace
12. Sorting Data Tutorials
- Sorting with one criterion
- Sorting with related fields
- Sorting with multiple criteria
- Sorting using custom values
- Sorting using buttons
13. Value Lists
- Creating static value lists
- Creating a value list from a field
- Using value lists from other files
- Displaying second values and second fields
- Field control setup
- Additional uses of value lists
14. Printing
- Print layouts
- Previewing pages and print options
- Print and paper options
- Printing lists
- Printing detail
- Sliding objects
- Printing merge letters
- Printing labels and envelopes
- Summary reports
- Subsummary reports
- Saving as an Excel file
- Saving as a PDF
15. Importing and Exporting
- Importing data
- Exporting data
16. Calculation Essentials
- Defining a calculation
- Exploring the Calculation dialog window
- Date and Time functions
- Text functions
- Number functions
- Get functions
- Logic functions
- Summary fields and functions
17. FileMaker Script Essentials
- Understanding scripts
- Understanding script steps
- Assigning script steps to buttons
- The ScriptMaker dialog window
- Creating multi-line scripts
- Subsummary scripts
- Open scripts
- Adding Find criteria to a script
- Using script parameters
18. Relationships
- ER diagrams
- Primary and foreign keys
- Creating relationships using the FileMaker Relationship Graph
- Tables vs. table occurrences
- Using related fields
- Going to related records
19. Portals
- Creating portals
- Creating and deleting records via portals
20. Using Multiple Windows
- Creating a new window
- Scripting a new window
- New window limitations
21. Securing Your files
- Security overview
- Understanding default accounts
- Setting up accounts, privilege sets, and external privileges
- Managing accounts
- File options
FileMaker Training Video Conclusion
- Goodbye
FileMaker Pro 9 Training Essentials
Title Information.
FileMaker Pro 9 represents a significant upgrade over previous versions, with many new and enhanced features. These include support for external SQL (ODBC) data sources with supplemental fields, an enhanced Web Viewer, toolbar improvements, multiple script editing windows, and new calculation functions. In this FileMaker Pro 9 Training Video , instructor Cris Ippolite covers each of FileMaker 9's features in detail. The tutorials demonstrate how to build a database from scratch for a thorough understanding of FileMaker from start to finish. Exercise files accompany the tutorials. This training DVD is suitable for beginners. Close »
Format : DVD
Price : $99.95 | £49.95 | €64.95
Publisher : lynda.com, Inc.
Duration : 10.75 hours - 124 lessons
Platform : PC or Mac
Closed Captioning : No
FileMaker Pro 9 Related Training Videos :
FileMaker Pro 9 Beyond the Basics
FileMaker Pro 9 Beyond the Basics
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.
