UMSL logo

Computer Education & Training Center

FileMaker

FileMaker Classes

Master the essentials of the FileMaker database system by attending a hands-on instructor-led class at the Computer Education & Training Center at UMSL. Learn to use the FileMaker Pro environment to create the database solution that you need.

Introduction to FileMaker Pro

(Prerequisite: Experience with Windows or Mac OS X.) Learn to use the FileMaker database system to help you keep track of inventory, update mailing lists, and manage information files. Master the skills necessary to plan and design a database, as well as add, change, and delete data. Additional topics include working with multiple layouts/reports, using Date type data, using the drawing tools, manipulating your database with the Sort and Find commands, converting an Excel data table into a FileMaker database, and exporting a FileMaker table into Excel format.  [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7697 Mon., Mar. 13West CountyDick Koerper

Intermediate Applications of FileMaker Pro

(Prerequisite: Introduction to FileMaker Pro or equivalent experience.) Increase your knowledge of FileMaker Pro by learning techniques for designing an effective database. Learn to use the calculation and summary fields to customize your database files. Learn to automatically look up data by linking one database or table to another in order to populate a table. Discover how to create more sophisticated reports, including defining and placing totals and subtotals within reports. Other topics covered include mail merge, generating mailing labels, converting files from earlier versions, and creating a static HTML table to display your data on the Web. [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7698 Mon., Mar. 20West CountyDick Koerper

Advanced Applications of FileMaker Pro

(Prerequisite: Intermediate Applications of FileMaker Pro or equivalent experience.) Learn to effectively use a relational database system to work with multiple databases. Discover how to use scripts to automate your FileMaker database, link to other FileMaker databases, create buttons, and use repeating fields. Additional topics include Solutions (templates) and using text parsing calculations to filter out unneeded text. Learn to create an interactive website using a FileMaker database and set up security for your database.  [Course Outline]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7699 Mon., Mar. 27West CountyDick Koerper