File Maker Pro 8
Advanced

Course Code: CT15-038

In  this course you will set database options to ensure accuracy and efficiency, extend your knowledge of relationships, and control onscreen and printing layout.

Objectives
After completing the course, participants will be able to:

  • Set field options to make data entry and values more accurate and efficient

  • Create many-to-many relationships

  • Control how field data appears onscreen and when printed via layout parts, sliding, merge fields, and field behaviour options

  • Create and troubleshoot complex scripts

  • Share databases via a local network and the Web.

What you will learn
Topics covered by this course include:

Field options

  • Advanced value lists
  • Advanced calculations
  • Field auto-entry
  • Field validation
  • Container fields

Advanced layouts

  • Layout efficiency boosters
  • Layout parts
  • Object appearance
  • Merge fields
  • Field entry behaviour

Complex scripts

  • Chained scripts
  • Related record scripts
  • Intercepting errors
  • Script parameters
  • Script problems

Networking databases

  • Database security
  • Multiple user access
  • Web publishing

Many-to-many relationships

  • Relationship types
  • Many-to-many relationship formation
  • Lookups
  • Related table summary

Appendix A: Complex relationships

  • Self-joining relationships
  • Dependent value lists
  • Multiple relationships to one table
  • Complex criteria relationships

Prerequisites
Course participants should have FileMaker Pro 8: Basic or equivalent experience.

Dates and times
Please refer to your Fourth R centre for dates and times.

© Copyright The Fourth R®

 [Back to IT Training Courses]