Training Courses

Filemaker Pro Database Design : Introduction

Two Day Course

Overview

This practical 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, export to Adobe PDF 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.
You need no previous experience to attend this course.

  • Private Courses

    One to one tuition or a private group with just your colleagues. Your choice of duration, content and location. We can train at one of our centres or onsite with you wherever you are located.

    We offer a free consultation service to help work out every detail and build the perfect course for you.

    From £545 + VAT

    Get A Free Consultation & Quote

Course Outline

  • Introducing 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
    • Using Container fields
    • Using conditional formatting
    • Numbering pages
    • Creating headers and footers
    • Setting passwords
    • Creating layouts with a summary
    • Creating letters and forms
    • Creating lists
    • Creating page breaks
    • Using the Comments feature

    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
    • The FileMaker Web Viewer
    • Using web themes
    • Web security issues
    • Exporting to PDF

    Questions and answers
Experience + Flexibility

We know training inside out. We can advise you on all the options to make sure you get the best possible course.

Tell us you need to cancel 5 working days before your course and there’s no charge. Great for your peace of mind.

Our trainers bring their years of industry experience into the classroom. You'll leave confident and prepared.

The smallest class size in the industry. More one on one time with the trainer and a less intimidating group size.

Tell us which you use and it'll be booted up and waiting with the latest software when you arrive.

We provide a lovely onsite lunch so you can relax. We can cater for any dietary requirement with no fuss.

Comfort + Location
Reputation + Feedback

Our Clients


We've worked very hard over the last 20 years to grow our business through personal recommendations.

When you attend a course we ask you to tell us how it went. We use your feedback to help us improve our courses.

We publish all our customer satisfaction stats live on our site (good or bad) because we want everyone to know just how highly you rate us every day, every week and every year.

We know that choosing the best course can be difficult, maybe the thoughts of the 7446 other clients we've asked will give you the inspiration to join us too.

The most recent comments from attendees of our courses are shown below. We reckon they will give you a pretty good indication of how they think we perform.

  Client Ratings

Attendees surveyed7446
  Trainer Knowledge9.8 / 10
  Trainer Materials9.6 / 10
  Trainer Preparation9.8 / 10
  Overall Trainer Score9.7 / 10
  Centre Lunch9.6 / 10
  Centre Staff9.9 / 10
  Overall Centre Score9.7 / 10
  Overall Experience9.6 / 10
  % Who Would Recommend Us99.7%

  Recent Feedback


"very well explained course, Time taken to allow us to understand. "

"Preparation, Knowledge, Lunch, Approachability, "

"Making the course to suit me - thank you!"

"Great training and venue"

"Amazing course - Extremely happy! Wish I had done this, and other Microsoft Office courses, year ago. Also very impressed you offered me a car parking place for the day. Thanks!"

"There was time in the sessions to ask enough questions and time for Tom to answer and not rush through the day"

"Whole day has been wonderful and really interesting thank you. Especially Simo's support! (Lunch was delicious)"

"Clear and helpful training"

"communicating, explaining, and relevant examples"

"Good one to one session, patient, good review of my work. "

"Debbie was very approachable and great at finding the answer to those very tricky questions."

"Tailored to our needs. Finished the day with a far greater knowledge of powerpoint."

"Course was well-delivered and well-paced"

"everything but especially giving time for questions and discussions slightly outside of the planned training but still keeping to time. "

"Clear, relevant information presented in an interesting way. Class was a good size and the subject enjoyable. The staff was very hospitable."

"Very knowledgeable, easy to follow along, great resources, great facilities. Smashing lunch!"

"Tom was good at being able to handle ad-lib questions that enabled us to deep dive into some areas that were of particular interest to me."

"Explaining the work and how to find the easiest way in Keynote."

"very clear and undertsanable throughout . cheerful and happy teacher that kept you engaged "

"TRAINER MADE SOME EXAMPLES RELATIVE, TRAINER IS VERY KNOWLEDGEABLE AND BROUGHT PREVIOUS EXPERIENCES INTO THE COURSE"

"brilliant examples and real life application. tutor was happy to go over what we needed him to."

"Giving real life examples that we can take away :)"

"Excellent course content. Engaging course, on which I learnt a lot."

"Very knowledgeable trainer, very engaging with good examples. Small class size. Great lunch and facilities."

"course structure, examples, explanations, the food! instructions on getting here, general communication."

"Great space, friendly, approachable - top marks."

"Like the small classes, tutor was great - very knowledgeable, good mix of theory and practical"

"The information was clear, the day was well organised. Thank you"

"Reading the review and actually taking into account the comments! Thank you so much for the gluten and lactose free biscuits!"

"Very clearly explained, thank you! "