FileMaker Pro
This course introduces you to FileMaker Pro, a powerful relational database tool for computers which runs on both Windows and Macintosh computers.
What's a database?
Databases are used to store information that an individual (or company) might require. They commonly contain very large amounts of information indeed and their major advantage over other methods of storing information is the speed with which relevant information can be recalled and displayed in useful form.

The ability to efficiently use databases has almost become a mandatory skill for anyone working in a modern business environment. This course will provide you with the capability and confidence to use FileMaker professionally.
We will work with you and use FileMaker first to build a simple database application containing several tables and then build more complex databases which illustrate how to create relationships between one table and another. The aim is to design a database to efficiently store the required information without unnecessary redundancy.
Sample the course
Click here to play a sample movie from the course.
Click here to play another movie which illustrates sorting techniques.
Cost of this FileMaker course
-
Online learning via broadband ($AUD75.00)
The most popular option is to take a course on the use of FileMaker as an online learning student. Our online broadband learning courses features rapid enrolment, many multi media instructional movies, online forums, multi-choice reviews, questionnaires, submission of assignments, email support etc. This is an enhanced learning experience at an affordable price. Click one of the broadband online learning sites above and click on the blue information button to sample a course. Visit http://www.softwaretutor.net now and enrol. The course cost is $AUD75.00 for >30 hours of high quality training. You can pay by PayPal which accepts direct deposit and credit cards and start immediately or send us an email requesting an enrolment. We will enrol you and post out an invoice. Payment can then be made by direct deposit. Our bank details will be on the invoice. We do offer reduced rates for studenst from the same organisation.
-
One-on-one learning - your offices or ours (Regency Park, South Australia)
We can provide face to face learning. This cost for a day's training in the use of Filemaker is $AUD550.00. We do require some information about what it is that you or your organization hopes to achieve by training so that we can prepare appropriate materials in advance of the course.
Each participant in one-on-one full day courses is automatically enrolled at no extra cost in the broadband learning version of the matching course. This would normally cost an additional $75.00 per person. In this way, students get a double benefit - personal tuition and the ability to access any of the written instructional materials online, replay any of the demonstration movies, download sample files, log questions, take quizzes and submit assignments for review.
We continue our drive to reduce our carbon emissions by using digital delivery of course materials. If you do need to a paper print of part of the course notes (say to print the steps in an operation), we encourage you to print just the web page you are currently viewing rather than the whole module. This can usually be done through the preview option in the print facility of the browser you are using, and selecting print the current page.
About our courses & methodology
Experience over many years has taught us that adults learn best by progressing through a course of study at their own pace and at times that suit them. Wherever possible, they like to learn by working on their own materials, rather than work through long unrelated practice exercises. Our courses are specifically designed so that this can occur. We introduce a topic, provide a movie showing you how to do the task with your software and then give detailed step-by-step instructions for you to follow.
Credit card payment
We use PayPal, an organization which takes all credit cards using a secure Internet facility. PayPal is a partner within the eBay system. We have chosen PayPal because it is independent of us, allows us to hold money in trust until we have delivered the course. Paypal is now operational in Australia. We will provide a tax invoice on receipt of payment in addition to the PayPal receipt if requested.
When you have finished this course
Please remember to build on your knowledge of FileMaker after you complete this course. We strongly recommend that FileMaker be used quite intensively after these early stages of learning. You will lose a lot if you let new-found skills ‘wither on the vine’. Practice is the key to learning sophisticated software. The key to success is to complete your first real project as soon as possible.
Prerequisites:
An understanding of basic computer operation including being able to create, save and locate files. It is assumed that you have a need to store substantial quantities of information and wish to retrieve 'sub sets' of this data quickly and efficiently.
The course is suitable for those who have used FileMaker Pro applications where others have 'programmed' FileMaker databases for you and you now want to learn to 'drive' FileMaker on your own.
What we will cover:
The table below provides an overview of the course content.
Module |
Description |
|
Using FileMaker Pro |
Relational databases, flat file databases, comparing FileMaker Pro with Microsoft Excel. What's a database? Some examples of FileMaker in action. Starting FileMaker, creating your first FileMaker database - a catalogue for a retail plant nursery. Refining the catalogue. Creating a second catalogue - one for a wine merchant. Using a FileMaker Pro database developed by a professional programmer - a list manager application; one which totals up the value of a sub set of items selected from a list. An overview of the use of the software including a number of 'real world' case studies. |
|
New in FileMaker Pro |
A discussion of the features new to the current version of FileMaker Pro. |
|
Some Preliminaries |
Installing FileMaker Pro, starting the program. Versions of FileMaker. Exploring the world of FileMaker templates. Sharing data among users of different software. FileMaker and the Windows operating system. Using Windows Explorer to create a suitable folder structure for storing databases. |
|
The FileMaker Interface |
Viewing records in a database. The Browse mode. The Find mode. Finding a single record meeting particular criteria. Narrowing the search criteria. Coping with large amounts of data in a field. Sorting data. Layout mode - making changes to forms. The Preview mode. Using drop down menus. |
|
Building a blank database with a single table database |
The main components of a database - Tables, Forms, Queries. Creating a brand new single table database application from scratch. Creating fields, records, data types, field sizes and descriptions. Inserting, deleting and modifying fields in a table. Testing the database with real data. |
|
Building a multi table relationship database |
Creating a new multiple table database application from scratch. Understanding and planning relationships between tables - the GUI approach. Developing a safety incident reporting database which links the incident with the persons affected. Planning another application - a database for a Contract Clinical Research Organization. |
|
Case Study 1: |
Building a database for an Insurance Broking firm. Planning the application, creating the tables, deciding on fields to be linked, setting up portals, (including graphics company logo), deciding on navigational tools, testing the application. |
|
Web databases |
Using the web publishing facility in FileMaker Pro. |