Course Description: Learning FileMaker Pro: Advanced (Windows)
Overview: Students will develop a system of automated inter-related databases, and will share databases over a network or the Internet. This class is suitable for FileMaker Pro versions 7, 8, 8.5, 9, 10 and 11.

Prerequisites: Before taking this course, students should have completed the Learning FileMaker Pro: Intermediate (Windows) course. In addition, they should be familiar with the basic functions of their computer’s operating system. Students should also have basic word processing skills, such as copying and pasting text, formatting type, and so on. Finally students should have basic knowledge of a Web design application or HTML.

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits: Students will learn to create a single database or set up a database that can be accessed by multiple users. Learning to create systems of connected multiple database files will allow students to efficiently organize and maintain inter-related data. They can also share a FileMaker Pro database for access over the Internet so that users can access the database using a Web browser.

Target student: Learning FileMaker Pro: Advanced was designed for the student who needs to store and organize information for individual, workgroup or company use, as well as for use by the public via the Internet. They should have some FileMaker Pro experience, including completing the Learning FileMaker Pro: Introduction (Windows) course.

What's next: This is the third class in the series. Next is the 4-day FileMaker Training Series.

Objectives

Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
  • Access data in an existing database.
  • Link databases with one-to-many and many-to-one data relationships.
  • Relate databases containing a theoretical many-to-many data relationship.
  • Create scripts to automate repetitive tasks, and will create buttons that execute scripts, switch layouts, or perform commands.
  • Set up databases for sharing over a network, and will define users, groups, and access privileges for those databases.
  • Instant Web Publishing of FileMaker Database.

Course Content
Lesson 1: Many-to-many Relationships
Relationship types
Many-to-many relationship formation
Lookups
Related table summary

Lesson 2: Advanced Layouts
Layout efficency boosters
Layout Parts
Object appearance
Merge fields
Field entry behavior
Tab Control and Web viewer

Lesson 3: Complex Scripts
Chained Scripts
Related Record scripts
Intercepting errors
Script parameters and script variables
Script Problems

Lesson 4: Networking database
Database security
Multiple user access
Web publishing