FileMaker Pro 7.0: Level 2

Learning Outcomes:

• Successfully Link databases with one-to many and many-to-one relationships utilizing criteria within the Lesson Lab.

• Create buttons that execute scripts, switch layouts, or perform commands without error, given a set of instructions provided.

• Accurately set up databases for sharing over a network within the time frame and using information provided by the instructor in the exercise.

• Successfully publish a FileMaker Pro database on the Web as instructed in the Lesson Lab.

Students will learn the advanced skills necessary to create a system of integrated databases that can manage the information efficiently, and make it easy to alter the system as your needs change.

• Defining One-to-Many Relationships
• Defining Many-to-One Relationships
• Create an Intermediate Database
• Control Addition or Deletion of Related Records
• Create Value Lists from Data in Related Files
• Create Buttons that Execute Commands and Scripts
• Create Scripts to Perform Complex Tasks
• Set up a Database for Multiple User Access
• Define Container and Global Fields
• Enable Instant Web Publishing
• Determine the Look of a Published Database
• Create a Custom Home Page for a Web-Enabled Database

FileMaker Pro 7.0: Level 2

Upon completing this course, students will be able to:

Link databases with one-to many and many-to-one relationships. Relate databases containing a theoretical many-to-many data relationship. Create scripts to automate repetitive tasks. Create buttons that execute scripts, switch layouts, or perform commands. Set up databases for sharing over a network. Define users, groups, and access privileges for those databases. Publish a FileMaker Pro database on the Web.

Class targeted to: Designed for students needing to learn the more advanced features of FileMaker Pro and techniques of integrated database system design.

Prerequisites: FileMaker Pro 7.0: Level I or equivalent knowledge.