United States FileMaker Pro 12: Beginner Training
CD Contents For This Title
All the chapters and lesson contents of FileMaker Pro 12: Beginner are listed below.
To help you evaluate our training, we have made some of the tutorials for FileMaker Pro 12: Beginner 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 beginner level and uses a single invoicing example to demonstrate all the features in FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 including: field creation, finding, sorting, layout mode, container fields, auto-entry, validation, printing, scripts, calculations, importing, exporting, interface design and new FileMaker Pro 12 features including charting, snapshot links and the inspector. 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) | |
| Why an Invoicing Solution? | (04:21) | |
| Work Files | (01:32) | |
| Locked Files | (06:28) | |
| Conversion | (03:24) | |
| What is a Database? pt. 1 | (05:02) | |
| What is a Database? pt. 2 | (05:23) | |
| Planning Your Solution | (05:02) | |
| New FileMaker 12 Features Overview | (08:17) | |
| New FileMaker 12 Functions | (08:12) | |
| New FileMaker 12 Scripts | (07:09) | |
| New Filemaker 12 Charting | (02:23) | |
| New FileMaker 12 Layout | (06:04) | |
|
Creating a Database
|
||
| Quick Start | (04:14) | |
| New Empty File | (08:03) | |
| Creating Fields | (08:00) | |
| Housekeeping Fields pt. 1 | (05:04) | |
| Housekeeping Fields pt. 2 | (08:16) | |
| Adding Fields to a Layout | (06:31) | |
| Modifying and Organizing Fields | (06:04) | |
| Other Tabs | (04:29) | |
|
Working with the Database
|
||
| Data Entry | (05:58) | |
| Importing Data pt. 1 | (06:47) | |
| Importing Data pt. 2 | (07:57) | |
| Status Toolbar | (07:36) | |
| Customizing the Status Toolbar | (02:44) | |
| The Four Modes | (06:12) | |
| Records Menu pt. 1 | (06:43) | |
| Records Menu pt. 2 | (06:50) | |
| Previewing Pages | (04:58) | |
| New Layout pt. 1 | (05:36) | |
| New Layout pt. 2 | (05:36) | |
| Table View | (05:52) | |
| Schema from Table View | (02:39) | |
|
Finding and Sorting
|
||
| Basic Find | (05:23) | |
| How the Index Works | (05:51) | |
| New Requests | (06:52) | |
| Range Finds | (06:29) | |
| Wildcards | (05:18) | |
| The Rest of the Operators | (08:05) | |
| Found Sets without Find Mode | (05:58) | |
| Constrain & Extend | (03:38) | |
| Sorting Records | (06:51) | |
| New Window | (04:29) | |
| Quick Find | (02:26) | |
| Save Find Requests | (07:10) | |
| Snapshot Links | (03:07) | |
|
Layouts Beginner
|
||
| Status Toolbar pt. 1 | (06:04) | |
| Status Toolbar pt. 2 | (06:22) | |
| Arrow Tool | (06:23) | |
| Field Tool | (04:15) | |
| Text Tool | (05:34) | |
| Working with Text pt. 1 | (04:05) | |
| Working with Text pt. 2 | (04:04) | |
| Line Tool | (04:52) | |
| Rectangles & Ovals | (07:31) | |
| More with Text Blocks | (06:24) | |
|
Layouts Intermediate
|
||
| Tab Control pt. 1 | (08:51) | |
| Tab Control pt. 2 | (06:11) | |
| Themes | (05:23) | |
| Field Control | (07:59) | |
| Value Lists pt. 1 | (04:47) | |
| Value Lists pt. 2 | (04:54) | |
| Explicit Layout Size | (02:50) | |
| Parts Overview | (07:25) | |
| Adding & Modifying Parts | (05:20) | |
| Layouts Menu pt. 1 | (07:17) | |
| Layouts Menu pt. 2 | (06:37) | |
| Format Menu | (05:34) | |
|
Layouts Advanced
|
||
| Arrange Menu | (07:05) | |
| View Menu | (07:52) | |
| Inspector Basics | (03:00) | |
| Inspector - Position Tab | (05:43) | |
| Inspector - Appearance Tab pt. 1 | (06:48) | |
| Inspector - Appearance Tab pt. 2 | (04:26) | |
| Inspector - Data Tab | (07:04) | |
| Insert Menu | (04:48) | |
| Positioning Objects Precisely | (06:01) | |
| Other Tools pt. 1 | (04:13) | |
| Other Tools pt. 2 | (05:22) | |
|
Working with Container Fields
|
||
| Creating Container Fields | (02:19) | |
| Inserting a Picture | (07:45) | |
| Inserting a PDF | (05:46) | |
| Interactive Files | (03:06) | |
| External Files | (06:42) | |
| Insert Other Files | (04:53) | |
| Other Insert Items | (06:03) | |
|
Auto-Entry
|
||
| Serial Numbers pt. 1 | (06:50) | |
| Serial Numbers pt. 2 | (06:04) | |
| Value from Last Visited | (04:50) | |
| Calculated Auto-Enter pt. 1 | (04:51) | |
| Calculated Auto-Enter pt. 2 | (06:44) | |
| Lookups pt. 1 | (04:28) | |
| Lookups pt. 2 | (07:38) | |
| UUID | (04:56) | |
|
Validation
|
||
| Strict Data Type | (06:13) | |
| Not Empty/Unique and Existing | (07:49) | |
| Ranges | (05:42) | |
| Calculated Validations | (05:25) | |
| Customizing Messages | (05:18) | |
| Always vs. Data Entry | (05:51) | |
|
Printing
|
||
| Layout Assistant | (05:04) | |
| Printing Philosophy | (03:57) | |
| Creating a Print Layout | (07:19) | |
| Contact List | (06:40) | |
| Print Options | (04:02) | |
| Labels | (05:44) | |
| Adjusting Labels | (05:25) | |
| Merge Letters | (06:59) | |
| More Merge Letters | (08:23) | |
| Sliding Objects | (06:38) | |
| Envelopes | (02:44) | |
| Building a Report | (06:07) | |
| Viewing a Report | (06:52) | |
| Summarizing a Report | (04:42) | |
| Varying a Report | (05:11) | |
| Improved Contact List pt. 1 | (06:49) | |
| Improved Contact List pt. 2 | (04:25) | |
| Quick Charts | (04:33) | |
| Charting in Reports | (05:23) | |
|
Scripting and Calculations
|
||
| Definition of a Script | (05:03) | |
| Basic Script | (05:33) | |
| Script Steps with Depth | (07:53) | |
| Evil Script Steps | (05:38) | |
| Activating Scripts | (06:49) | |
| Definition of a Calculation | (05:49) | |
| Basic Calculation | (04:55) | |
| Layout Navigation | (04:37) | |
| Record Navigation | (02:06) | |
| More Scripts | (02:58) | |
| Manage Scripts | (04:38) | |
| Deleting a Record | (05:53) | |
| Printing a Layout | (06:23) | |
| Open Script | (04:47) | |
| Open Script Considerations | (06:21) | |
| Close Script | (04:57) | |
| Recreate the Status Toolbar | (06:12) | |
| Case vs. If | (05:18) | |
| Billing or Shipping Labels | (04:16) | |
| Fixing the Label Calculation | (04:21) | |
| Age Display | (06:46) | |
| Birthdays Find | (05:49) | |
|
Importing and Exporting
|
||
| Import and Export Defined | (06:22) | |
| Importing FileMaker Files | (04:23) | |
| Updating FileMaker Files | (05:25) | |
| Importing a Folder | (04:23) | |
| Exporting Files | (06:52) | |
| Group By | (06:38) | |
| Export to HTML | (02:13) | |
| Importing Schema | (05:34) | |
|
Miscellanneous Features
|
||
| Global Fields Defined | (05:29) | |
| Custom Report Title | (06:16) | |
| Multi-User Global Fields | (03:48) | |
| Repeating Fields | (06:31) | |
| Furigana | (04:03) | |
| Spell Checking | (05:50) | |
| Find/Replace | (05:22) | |
| Send Email | (06:13) | |
| Tooltips | (05:00) | |
| Tab Order | (03:15) | |
|
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: Beginner |
| Author: | John Mark Osborne |
| SKU: | 34323 |
| ISBN: | 978-1-61866-046-6 |
| Release Date: | 2012-06-08 |
| Price: | |
| Duration: | 16 hrs / 169 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 used a Mac in business and for personal use since 1986. I thought I knew pretty much all it could do as far as the system went. I bought...
Carol Jones