FileMaker Pro 8: Beginner Tutorials
Online Contents For This Course
We have made some of the video tutorials for
FileMaker Pro 8: Beginner
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
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.
Choose your media type:
|
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) | ||
Course Information
| Course: | FileMaker Pro 8: Beginner |
| Author: | John Mark Osborne |
| SKU: | 33659 |
| ISBN: | 1-932808-96-5 |
| Release Date: | 2005-12-07 |
| Duration: | 7.5 hrs / 107 tutorials |
| Work Files: |
Yes |
| Captions: | No |
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 782 courses, 81,350 video tutorials (20,800+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More
United States
Email this Page
Send us Feedback