United States FileMaker Pro 12: Intermediate Training
CD Contents For This Title
All the chapters and lesson contents of FileMaker Pro 12: Intermediate are listed below.
To help you evaluate our training, we have made some of the tutorials for FileMaker Pro 12: Intermediate freely available. Click on any of the linked lesson listings below to preview FREE!
FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical \"how to\" course by FileMaker expert John Mark Osborne starts from intermediate level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 features and techniques including: interface design, relational database design, relationship operators, multiple predicates, table occurrences, portal filters, security, scripts, calculations, FileMaker Pro Advanced, multi-user solutions, record locking, multi-keys, deleting duplicate records and new FileMaker Pro 11 features. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning. To begin learning today, simply click on the movie links.
Choose your media type:
To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
Hide This|
Introduction
|
||
| About John Mark Osborne | (04:51) | |
| System Requirements | (03:17) | |
| FileMaker 12 Family of Products | (06:48) | |
| About the Tutorial Series pt. 1 | (05:08) | |
| About the Tutorial Series pt. 2 | (04:55) | |
| Work Files | (01:32) | |
| Locked Files | (06:28) | |
|
Interface Design
|
||
| Recap Previous Tutorial | (08:03) | |
| Screen Size | (05:29) | |
| Background pt. 1 | (04:19) | |
| Background pt. 2 | (09:13) | |
| Tabs/Bars and Buttons pt. 1 | (05:55) | |
| Tabs/Bars and Buttons pt. 2 | (03:36) | |
| Tabs/Bars and Buttons pt. 3 | (05:10) | |
| Field Outlines | (06:08) | |
| Sub-Areas | (10:11) | |
| Buttons | (06:57) | |
| Finishing Touches pt. 1 | (04:33) | |
| Finishing Touches pt. 2 | (04:33) | |
| Tabbed Buttons pt. 1 | (05:17) | |
| Tabbed Buttons pt. 2 | (03:15) | |
| Tabbed Sub Area | (07:24) | |
| List View pt. 1 | (04:25) | |
| List View pt. 2 | (07:55) | |
| List View pt. 3 | (04:30) | |
| Autosizing pt. 1 | (06:15) | |
| Autosizing pt. 2 | (05:23) | |
| Design Considerations | (06:10) | |
|
Relationships
|
||
| Relational Theory | (06:11) | |
| Data Modeling pt. 1 | (07:28) | |
| Data Modeling pt. 2 | (06:20) | |
| Entity-Relationship Diagrams pt. 1 | (04:40) | |
| Entity-Relationship Diagrams pt. 2 | (06:21) | |
| Invoices ERD | (05:05) | |
| Creating a Relationship | (06:39) | |
| Related Fields | (03:47) | |
| Populating a Foreign Key pt. 1 | (06:11) | |
| Populating a Foreign Key pt. 2 | (06:51) | |
| Live Links | (06:23) | |
| Many-To-Many Relationship pt. 1 | (04:50) | |
| Many-To-Many Relationship pt. 2 | (05:10) | |
| Creating a Portal | (08:28) | |
| How the Join Works | (04:15) | |
| Portal Improvements | (06:27) | |
| Aggregating Portals | (07:33) | |
| Two-Way Relationships | (08:42) | |
| Sorting a Portal | (03:54) | |
| Start and End | (05:36) | |
| Go to Related Record | (05:23) | |
| Organizing Layouts | (07:03) | |
| Completing the Interface | (06:53) | |
|
Table Occurrences
|
||
| What are Table Occurrences? | (07:22) | |
| Where are Table Occurrences Used? | (08:18) | |
| Portal Filtering | (06:50) | |
| Totaling Filtered Portals | (06:34) | |
| Filtered Relationships pt. 1 | (07:52) | |
| Filtered Relationships pt. 2 | (06:13) | |
| Portal Filtering Discussion | (05:34) | |
| Calculated Portals | (06:36) | |
| Dynamic Calculation | (03:40) | |
| Date Range Portals | (07:48) | |
| Self-Relationships | (06:38) | |
| Table Occurrence Tricks pt. 1 | (05:57) | |
| Table Occurrence Tricks pt. 2 | (04:49) | |
| Conditional Value Lists pt. 1 | (02:29) | |
| Conditional Value Lists pt. 2 | (06:20) | |
| Scripts and Calculations | (07:05) | |
| Organizing the Graph | (07:19) | |
| Table Occurrence Groups | (04:44) | |
|
Security
|
||
| Overview pt. 1 | (06:30) | |
| Overview pt. 2 | (07:24) | |
| Complete Approach | (07:37) | |
| Accounts | (06:00) | |
| New Account | (05:50) | |
| Other Privileges | (06:24) | |
| Data Access and Design | (07:00) | |
| Record Level Access | (05:25) | |
| Extended Privileges | (05:44) | |
| External File Protection | (05:29) | |
| No Access Layout | (06:39) | |
| Overdue Invoices pt. 1 | (05:55) | |
| Overdue Invoices pt. 2 | (07:25) | |
| Capturing Errors | (07:21) | |
| Add Account | (08:07) | |
| Delete Account | (02:34) | |
| Multiple Files | (06:01) | |
| Random Passwords | (06:59) | |
| Manager Override pt. 1 | (05:55) | |
| Manager Override pt. 2 | (05:33) | |
|
Scripting
|
||
| Send Email | (05:55) | |
| Menu Button pt. 1 | (04:39) | |
| Menu Button pt. 2 | (07:05) | |
| Script Parameters | (04:13) | |
| Find Rolodex | (07:17) | |
| Dynamic List View | (03:55) | |
| Dynamic Messages | (06:51) | |
| Duplicate Invoices pt. 1 | (05:45) | |
| Duplicate Invoices pt. 2 | (06:47) | |
| Print Invoice Layout pt. 1 | (07:46) | |
| Print Invoice Layout pt. 2 | (07:59) | |
| Print Invoice Script | (05:47) | |
| Batch Print Invoices | (07:47) | |
| Inventory Control Add | (08:13) | |
| Inventory Control Subtract | (05:49) | |
| Deleting Portal Rows | (08:29) | |
| Quick Find Script | (06:27) | |
| Floating Menu | (05:04) | |
|
Calculations
|
||
| Sales Tax | (04:38) | |
| Grand Total | (06:53) | |
| Basic Phone Filter pt. 1 | (06:57) | |
| Basic Phone Filter pt. 2 | (05:29) | |
| Phone Number Validation | (05:23) | |
| Remove Text Formatting | (05:50) | |
| Overdue Invoice Display | (06:20) | |
| Parsing Text Basics | (07:36) | |
| Multiple Records | (05:32) | |
| Scripts versus Calculations | (05:53) | |
| Parsing Text Advanced | (05:10) | |
| Field Level Tracking | (05:21) | |
| Field Level Tracking Advanced | (07:01) | |
| True Modification Timestamp | (05:10) | |
| GetNthRecord Tooltip | (06:48) | |
|
FileMaker Pro Advanced
|
||
| Advanced Features Overview pt. 1 | (06:16) | |
| Advanced Features Overview pt. 2 | (04:59) | |
| Advanced Features Overview pt. 3 | (06:58) | |
| Recover pt. 1 | (08:06) | |
| Recover pt. 2 | (06:31) | |
| Configuring Plug-Ins | (07:18) | |
| Plug-In Examples | (05:27) | |
| Database Design Report | (03:47) | |
| Developer Utilities | (04:21) | |
| File Maintenance | (06:41) | |
| Debugging Scripts pt. 1 | (07:01) | |
| Debugging Scripts pt. 2 | (06:42) | |
| Custom Functions pt. 1 | (06:35) | |
| Custom Functions pt. 2 | (03:13) | |
| Recursive Custom Functions | (06:28) | |
| Custom Menus Layout Driven | (08:21) | |
| Custom Menus Scripted | (06:12) | |
|
Multi-User Solutions
|
||
| Hosts and Guests | (07:49) | |
| Sharing a File | (04:47) | |
| Record Locking Defined | (06:02) | |
| Global Fields & Script Variables | (06:28) | |
| Scripting for a Locked Record pt. 1 | (06:31) | |
| Scripting for a Locked Record pt. 2 | (05:01) | |
| Scripting for Multiple Locked Records | (06:47) | |
| Marking Records pt. 1 | (05:48) | |
| Marking Records pt. 2 | (05:41) | |
| Saving a Found Set pt. 1 | (05:12) | |
| Saving a Found Set pt. 2 | (05:06) | |
| Retrieving a Found Set | (06:27) | |
|
Working with John Mark Osborne
|
||
| Free Resources | (05:02) | |
| Training | (06:24) | |
| Consulting and Meta-Consulting | (02:41) | |
| Solutions | (05:18) | |
| Contacting Me | (02:48) | |
Email this Page
Send us FeedbackTitle Information / Pricing
| Title: | FileMaker Pro 12: Intermediate |
| Author: | John Mark Osborne |
| SKU: | 34352 |
| ISBN: | 978-1-61866-059-6 |
| Release Date: | 2012-09-01 |
| Price: | |
| Duration: | 16 hrs / 156 lessons |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP NOW
LEARN MORE » Related Titles
Select Bandwidth
Now Shipping
Client Testimonials
I have taken 4 courses with Mark Long, SQL Server 2005, 2008, 2012 Administration and 2008 Development and I must say the teaching and quality are...
Lisa B.