Title Language  : 

Find a Course... Try for Free!

 

FileMaker Pro 8: Beginner Training

Course Content
FileMaker Pro 8 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 including: field creation, finding, sorting, layout mode, container fields, auto-entry, validation, printing, scripts, calculations, importing, exporting and interface design. 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 one of the FileMaker Pro 8: Beginner lessons.

The completed invoicing solution included on the beginner, intermediate and advanced FileMaker Pro 8 training is provided as a visual goal. Upon completion of all three titles, you will have created the exact same invoicing solution. If you would like to purchase the completed invoicing solution, please visit the www.databasepros.com web site.

* Most techniques used in these videos are applicable to both FileMaker 8 and 7. Substitute techniques for FileMaker 7 users will be discussed when necessary.

** This tutorial is part one in a 3-part FileMaker Pro 8 series.

QT 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 (01:51)
 FileMaker 8 Family of Products (04:53)
 About the Tutorial Series (04:20)
 Why an Invoicing Example? (03:02)
 What is a Database? (05:48)
 Planning your Solution (02:11)
Creating a Database
 Templates (03:21)
 New Empty File (01:32)
 Creating Fields (04:16)
 Housekeeping Fields (05:26)
 Modifying Fields (03:31)
 Organizing Fields (02:49)
 Other Tabs (01:49)
Working with the Database
 Data Entry (06:52)
 Status Area (03:57)
 The 4 Modes (03:17)
 Records Menu (06:59)
 Previewing Pages (03:33)
 New Layout pt. 1 (05:07)
 New Layout pt. 2 (02:57)
Finding and Sorting
 Basic Find (02:11)
 How the Index Works pt. 1 (04:44)
 How the Index Works pt. 2 (02:47)
 New Requests (02:58)
 Symbols pt. 1 (05:46)
 Symbols pt. 2 (05:46)
 Constrain and Extend (02:53)
 Found Sets without Find Mode (02:58)
 Sorting Records (04:58)
 New Window (02:03)
Modifying Layouts
 Status Area (01:50)
 Arrow Tool (03:53)
 Text Tool (05:27)
 Line Tool (04:31)
 Rectangle Tool (03:27)
Modifying Layouts Advanced
 Tab Control Setup (03:31)
 Tab Control Creation (05:03)
 Field/Control and Lists (05:39)
 Field/Control and Others (04:02)
 Parts Overview (04:24)
 Parts Creation (04:25)
 Layouts Menu (04:39)
 Format Menu (05:00)
 Arrange Menu (05:39)
 View Menu (06:23)
Working with Container Fields
 Creating Container Fields (01:57)
 Inserting a Picture (04:40)
 Inserting a PDF (03:46)
 Insert Other Files (02:18)
 Miscellaneous (03:11)
Auto-Entry
 Serial Numbers pt. 1 (05:43)
 Serial Numbers pt. 2 (03:05)
 Value from Last Visited (02:27)
 Calculated Auto-Enter (06:38)
 Lookups (06:03)
Validation
 Strict Data Type (05:49)
 Not Empty/Unique/Existing (06:22)
 Ranges (04:04)
 Custom Messages (05:07)
 Always vs. Data Entry (03:14)
Printing
 Print Layouts (06:36)
 Contact List (05:43)
 Labels (04:55)
 Merge Letters (06:00)
 Sliding Objects (04:58)
 Sub-Summary Reports pt. 1 (07:05)
 Sub-Summary Reports pt. 2 (04:26)
 Sub-Summary Improvements pt. 1 (04:18)
 Sub-Summary Improvements pt. 2 (03:36)
 Improved Contact List (06:19)
Scripting and Calculations
 Definition of a Script pt. 1 (04:20)
 Definition of a Script pt. 2 (04:14)
 Definition of a Calculation (04:55)
 Navigation (06:00)
 Advanced Navigation pt. 1 (04:25)
 Advanced Navigation pt. 2 (05:21)
 Open Script (06:13)
 Recreate the Status Area (03:35)
 Billing or Shipping Labels pt. 1 (06:40)
 Billing or Shipping Labels pt. 2 (03:02)
 Birthdays (07:07)
Importing and Exporting
 Import and Export Defined (03:55)
 Importing Files pt. 1 (04:22)
 Importing Files pt. 2 (03:34)
 Importing a Folder (04:53)
 Data Sources pt. 1 (03:40)
 Data Sources pt. 2 (04:10)
 Exporting Files (03:09)
 Group By (04:28)
 Export to HTML (03:24)
 Importing Schema (05:06)
Miscellaneous Features
 Global Field pt. 1 (03:01)
 Global Field pt. 2 (04:17)
 Repeating Field (05:59)
 Furigana (02:59)
 Spell Checking (03:16)
 Find/Replace (02:35)
 Engraving and Embossing (03:59)
 Send Email (06:07)
 Improved Print Script (03:52)
 Tooltips pt. 1 (04:20)
 Tooltips pt. 2 (03:24)
Working with John Mark Osborne
 Free Resources (03:43)
 Training (02:31)
 Consulting and Meta-Consulting (01:49)
 Solutions (06:14)
 Contact Information (00:41)


Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: FileMaker Pro 8: Beginner
Author: John Mark Osborne
SKU: 33659
ISBN: 1-932808-96-5
Duration: 7.5 hrs / 107 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

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 LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products