Course Overview

This hands on course is designed for those who need to create relational databases in FileMaker Pro. The course teaches you how to plan, design and create a database to a detailed brief.

You will learn to create different layouts, summarise information and produce reports.

This course is a private company course so feel free to build a new database during the course or work on your existing database if you wish.

 

 Course Outline

INTRODUCTION TO DATABASE DESIGN
Basic considerations
Gathering resources
Producing a flowchart of work

DESIGNING YOUR DATABASE
Relational or flat field?
Defining the relationships between databases and fields
Designing the layouts

CREATING A NEW DATABASE
Defining and formatting fields
Specifying field relationships
Entering/importing data
Defining calculation and
date fields
Setting look up fields
Creating a list of values
Creating layouts
Designing layouts for screen
Designing layouts for print
The Layout/Report Assistant
Defining the part types in a layout
Specifying the size of layout parts
Importing graphics in a layout
Numbering pages
Creating headers and footers
Setting passwords
Creating layouts with a summary
Creating letters and forms
Creating lists
Creating page breaks



OPTIMISING YOUR DATABASE FOR YOUR USER'S REQUIREMENTS
Scripts and buttons
When to use Scripts
Creating a new script
Scriptmaker and how to use it
Chaining and using scripts
Creating buttons
Calculations
Summaries
Conditionals

INSTANT WEB PUBLISHING
Allowing authorised user access to
your database over an intranet
Using web themes
Web security issues

Questions and answers