squnewlogo1a

3 Square Associates
FileMakerProfessionals

"you imagine it, we do it..."

FBA4C515x152
FileMaker Trainer Picture

FileMaker Training

We offer professional FileMaker training for basic, intermediate and advanced Filemaker users. Our training is built our vast knowledge of FileMaker and our 20+ years of teaching experience. The course outlines for Basic, Intermediate and Advanced are listed below. Our training is delivered in our well equipped, state of the art training studio running FileMaker 8.5. We can also provide on-site training upon request, just mention it when submitting your enquiry form on the left of this page.

Basic Training Course

Training Objective

To learn the basics of creating FileMaker Pro databases and to provide a thorough introduction to the basic features of FileMaker. Topics covered include finding records, sorting, creating forms, lists and general database jargon. After the course new users will be able to create a simple database and use existing FileMaker applications efficiently.

Basic Training Content:

- Explanation of files, records, fields and layouts

- Entering, editing, deleting and displaying records

- Full search options

- Sorting records

- Defining fields

- Designing reports and overview of the Layout function

- Creating Labels and Letters

- Entry options

- Introduction to secure files

- Introduction to relational thinking

- Sub-summaries and reports

- Introduction to buttons and scripts

- Import and export possibilities

- Networking

Duration: One Day Price: £550+VAT* per delegate (10% discount for 3+ delegates) Max 8 delegates per session. * Cost may vary per location

 

Intermediate Training Course

Training Objective

This course is designed to follow the Basic course and elaborate on FileMaker techniques in more detail. It also provides practical sessions using the relational model, including creation and use of relationships and portals. It also introduces scripting for automation, and represents the best way for those who want to create and maintain their own databases to learn some tried and tested developers' techniques. (Delegates should already have knowledge at least equivalent to the Basic course).

Intermediate Training Content:

- Relationships and relational thinking

- Defining relations between tables

- Defining calculations

- Creating and using portals

- Creating complex layouts

- Security and password privileges

- Introduction to scripting including a generalised Search Script

- Scripting parameters

- External scripts

- Using Calculations that reference related tables/fields

Duration: One Day Price: £550+VAT* per delegate (10% discount for 3+ delegates) Max 8 delegates per session. * Cost may vary per location

 

Advanced Training Course

Training Objective

This course is aimed at users with some database development experience. It demonstrates how you can automate your application using effective scripting techniques. Tips, tricks and pitfalls will be revealed. (Delegates should already have knowledge at least equivalent to the Intermediate course).

Advanced Training Content:

- Using Status functions

- Using the Set Field function

- Using Variables

- Using Objects and go to object function

- Using Web Viewer

- Change to Relationships within the same table (self relationships)

- Many to many relationships

- More about portals

- Entry calculations

- Looping scripts

- Validation on basis of calculation

- Scripts for functions and screen optimisation

- Security on the basis of variable data

- Instant Web Publishing FileMaker databases

Duration: One Day Price: £550+VAT* per delegate (10% discount for 3+ delegates) Max 8 delegates per session. * Cost may vary per location

Name:

Email:

Telephone:

Course Required:

Number Of Delegates:

Other Information:

 

 

Enquire About A FileMaker Training Course

Please complete and send the form below to enquire about any of our FileMaker training courses.