FileMaker Pro is an easy to use cross- platform database development program, which allows you to quickly create management solutions for your business.
Delegates will learn how to operate a database and then how to design a database from simple creation of fields and layouts to more advanced features of button creation and scripting and plug-in development.
The course can be specifically arranged to work on a real database for use within an organisation and thus tackle design, development and implementation in one go.
Sample Course Outline - This can be customised to suit you!
Introduction to Designing a Database
Setting up a basic customer record database
Field definition - types of fields
Layouts - form, table, list view
Status area toggle
Tab order in layouts
Tool bars - T square
Control access to a field in modes of working
Conditional formatting of fields
Modes of working, browse, find, preview, layout
Input screen
Print screen
Global fields - samples of addresses etc
User interface
Finding information - using symbols e.g ==
Sorting information
Basic button design - common tasks
Buttons to change layouts
Creating buttons to store a find request or a sort request
Concept of layouts design using Yacht Matrix as an example
Sorting and summary fields
Sub summary parts
Relationships 1
Intro to Relationships
Linking databases
General concepts
Creating a new table within the main database
One to many contacts for 1 customer
Creating a portal
Moving to the related record and back
Example - Customers, invoices, products
Relationships Continued
Example - clients, estimates, products, invoices,
Look up from one table to another used in a pricing database
Self join relationship
Multi criteria relationship
Discussion of development system
When to use a self - join relationship
Scripts and buttons
Automating the database with Buttons & Scripts
Start up scripts
Discussion of scripts in samples
Script Maker examples
If structure example
Loop structure example
Data entry example
A startup script example
Functions
Sharing Data
Server copy of FileMaker
File sharing over the network
Importing and exporting data
