FileMaker Pro: Level 2

Enrolment Form

Click to Download

An enquiry form about this course can be found at the bottom of the page.

Course Overview

Skill Level: 2 Intermediate

Duration: 1 Day

Description: You have probably been using FileMaker Pro for a while, maintaining databases that other people have designed, and even designing some yourself. You may have created several databases to track information like contacts, inventory, or other information that you can’t adequately manage using a spreadsheet or word processing application. However, you may be faced with a project where a single FileMaker database cannot handle the information you need to manage. For example, you may want to link customers with the purchases they make. If you have tried to place this information in a single database, you may have duplicated data unintentionally. In this course, you will use FileMaker Pro 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. In addition, you may need to share your databases with other users on a network or even over the Internet. You will set up databases so that they can be accessed by someone in the same office, or by a customer using a Web browser.

Lesson 1: Defining One-to-Many and Many-to-One Data Relationships

Topic 1A: Define a Many-to-One Relationship
Topic 1B: Display Related Information from a "Many" Database

Lesson 2: Setting Up a Many-to-Many Database Relationship

Topic 2A: Create an Intermediate Database
Topic 2B: Access Data from a Related "Many" File
Topic 2C: Summarize Related "Many" Data
Topic 2D: Control Addition or Deletion of Related Records
Topic 2E: Create Value Lists from Data in Related Files

Lesson 3: Creating Buttons and Scripts

Topic 3A: Create Buttons that Execute Commands
Topic 3B: Create Scripts to Perform Complex Tasks
Topic 3C: Create Buttons to Execute Scripts

Lesson 4: Sharing FileMaker Pro Databases

Topic 4A: Set Up a Database for Access by Multiple Users
Topic 4B: How to Control Access to a Database

Lesson 5: Creating a Database for the Web

Topic 5A: Define Container and Global Fields
Topic 5B: Enable Instant Web Publishing
Topic 5C: Determine the Look of a Published Database
Topic 5D: Create a Custom Home Page for a Web-Enabled Database