FileMaker Pro Introduction & Intermediate - (Public class max is 5 students)
* Training at your company site (group or 1on1) -- click here.
Course Description
You have probably used a computer to gather, process, and share information. For example, you may have searched for product information on the Internet, totalled expenses using a spreadsheet application, or typed and printed a memo using a word processing application. You may now need to store a large amount of information in an organized manner so that you can quickly and easily sort the information in various ways, and locate specific pieces of information efficiently. In this case, you'll use FileMaker Pro to create and use databases to store and organize information so that it is available for efficient retrieval.
Course Objective: You will use FileMaker Pro to create and use databases to store and organize information.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
Course Content
Lesson 1: Maintaining a Database
Topic 1A: Browse Records
Topic 1B: Add Records
Topic 1C: Edit Records
Topic 1D: Sort Records
Topic 1E: Print a Report
Lesson 2: Finding Records
Topic 2A: Find Records Meeting All Specified Criteria
Topic 2B: Specify an OR Search
Topic 2C: Refine Found Sets
Lesson 3: Setting Up a Database
Topic 3A: Create a New Database File
Topic 3B: Import Data
Topic 3C: Calculate Field Data Automatically
Topic 3D: Create an Automatic Numbering Field
Topic 3E: Control Field Validation
Lesson 4: Formatting Fields
Topic 4A: Position and Resize Fields
Topic 4B: Format Fields
Topic 4C: Format Value Lists
Topic 4D: Create Repeating Fields
Topic 4E: Set Tab Order
Lesson 5: Adding Graphics and Text to Layouts
Topic 5A: Draw and Position Graphic Elements
Topic 5B: Import Graphics
Topic 5C: Add Text Elements
Lesson 6: Creating Layouts for Mailing Form Letters
Topic 6A: Create Mailing Labels
Topic 6B: Create a Personalized Form Letter
Lesson 7: Creating Columnar Reports
Topic 7A: Create a Columnar Report Layout
Topic 7B: Create Summary Data
Topic 7C: Create Sub-Summary Data
Course Content
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