|
Scavenger hunt to locate new FileMaker Pro 6.0 features
|
|
|
Exercise on conditional value lists with extra credit for conditional
value lists in a portal
|
|
|
Courseware was written for FileMaker Pro 6.0 and includes references
interesting new features throughout the course
|
|
|
Learn how to ER diagram
|
|
|
Exercises with Many-to-Many, One-to-Many and One-to-One relationship
creation
|
|
|
Topics include an invoicing system that is added onto throughout the 2
day course
|
|
|
Fine tune your skills on the most important FileMaker Pro features with
exercises on finding, sorting, importing and exporting. All aspects will
be covered from beginning to intermediate
|
|
|
Subsummary reports are the key to making sense of your FileMaker Pro
data and one of the most important exercises in this course
|
|
|
Aggregate functions are used to show how to total portals in the
invoicing solution
|
|
|
Exercises on Auto-Enter and Validation teach how the options for a
field can aid data entry
|
|
|
Field formatting exercises allow you to filter numbers, dates and times
|
|
|
An extra credit exercise shows how to reproduce the field formatting
with a calculation to extend the types of filtering that can be done
|
|
|
The invoicing solution is brought back to show how value lists can be
used to aid data entry
|
|
|
Global fields in a single-user and multi-user scenario considered along
with common applications
|
|
|
Calculations are utilized in Define Fields, Set Field, Replace and
Insert Result. Exercises cover when and where to use calculations
|
|
|
Functions covered include Left, Right, Middle, LeftWords, RightWords,
MiddleWords, Position, Substitute, If, Case, Choose, time functions, date
functions and most of the logical functions
|
|
|
Merge fields allow you to mimic a form letter in a word processor. This
exercise show all the basics to make a successful letter |
|
|
Discussion of which scripts to focus upon, the many ways to activate a script, default script steps and why they
are there and ScriptMaker shortcuts
|
|
|
Idiot proofing a solution with a find example. Shows how to use Set
Error Capture, If, Loops, Set Field, Allow User Abort, Show Message,
Status Functions and many other script steps
|
|
|
Set Field is covered in more detail with exercises on key concepts such
as appending, prepending, extracting, subtracting, pushing and pulling
|
|
|
Deleting duplicates is one of the most common tasks and is covered with
three approaches
|
|
|
Instant web publishing is much more sophisticated in FileMaker Pro 5.0
and covered by a exercise that shows how to test a solution locally as
well as the many possible pitfalls like security and passwords
|
|
|
Custom web publishing is the next step and is demonstrated through
exercises in finding, listing records, show a form view, adding records
and editing records
|
|
|
Many of the techniques in scripting, calculations and relationships are
brought together in this exercise which demonstrates how to maximize the
available screen space. Topics include creating a tabbed interface, reproducing the status area
so it can be hidden, buttons with multiple functions and a menu bar
|
Prerequisites
