Getting Started with FileMaker

Getting Started with FileMaker

What is a database and why use it

Database description and benefits
Glossary of database terms
Other types of databases

Creating and opening FileMaker databases

Creating and opening FileMaker databases
Opening other databases or file formats

Entering and modifying your information

Adding and duplicating records
Copying and moving data
Deleting records
Field navigation, selecting fields, entering and changing data

Looking at data: Introduction to FileMaker Views

Button navigation
Form, List and Table Views
View selection

Looking at data: Introduction to FileMaker Modes

Browse, Find, Layout and Preview Modes
Mode selection

Working with your information

Moving between records in a found set

Finding and sorting records

Using buttons for finding and sorting data
Finding and sorting records

Previewing, printing and reporting

Using Preview Mode
Printing labels
Specify printer and paper options
Printing records

Saving and copying databases

Committing and restoring data
Save options

Sharing your database

Sharing your database
Instant Web Publishing

Modifying your database

Using Layout Mode
ScriptMaker Overview
Creating reports
Setting up calculations
Setting up and using external SQL data sources

Web Viewer Sample Database

Using the Web Viewer

Where do I go for assistance?

List of FileMaker resources for user assistance

Which FileMaker database product is right for me?

Matrix of products and functionality

Welcome to the FileMaker Learning Center

This resource is designed to help you get the most out of FileMaker Pro.

  • There are a number of Video Tutorials that provide step-by-step, visual instructions on commonly performed tasks, like Finding and Sorting Records, Sharing your database, and more. Simply click one of the links on your left, then click the Watch it now button to get started.
  • In addition to the videos on your left, you can find additional resources like 3rd party videos and product documentation to learn more about a specific feature.
  • Click the Beyond the Basics tab to get in-depth information on features, like Custom Menus or Instant Web Publishing, or general topics, like Security, managing an email marketing campaign, and much more. You can also download the product documentation.

Using Layout Mode

1:59

Additional Resources and Help

  • Creating and managing layouts and reports
  • Editing objects on layouts
  • Working with layout parts
  • Working with Web Viewers on layouts
  • Troubleshooting layouts
  • FileMaker Development Conventions
  • Creating layouts
  • Creating a form
  • Creating a table view
  • Creating labels
  • Creating envelopes
Download the databases used in the video tutorialsSend us your comments

Other types of databases

1:36

Additional Resources and Help

  • Database file
  • Database Management System (DBMS)
  • Moving FileMaker Beyond the Desktop
Download the databases used in the video tutorialsSend us your comments

Using the Web Viewer

4:19

Additional Resources and Help

  • Working with Web Viewers on layouts
  • Adding a Web Viewer
  • Changing a web address
  • Defining a custom web address
  • Navigating in Web Viewers
  • Troubleshooting layouts with Web Viewers
  • FileMaker Pro 8.5: The FileMaker Web Viewer
  • The FileMaker Web Viewer
  • Setting up the Web Viewer using templates
Download the databases used in the video tutorialsSend us your comments

Creating reports

4:44

Additional Resources and Help

  • About layout types
  • Creating a layout
  • Considerations when you create a columnar list/report layout
  • Creating a list/report view
Download the databases used in the video tutorialsSend us your comments

Setting up and using external SQL data sources

3:45

Additional Resources and Help

  • Accessing external data sources
Download the databases used in the video tutorialsSend us your comments

ScriptMaker Overview

3:16

Additional Resources and Help

  • Creating scripts to automate tasks
  • Creating and editing scripts using ScriptMaker
  • ScriptMaker examples
  • ScriptMaker dialog window and organizing scripts
Download the databases used in the video tutorialsSend us your comments

Getting Started with FileMaker

8:57

Additional Resources and Help

  • About FileMaker Pro databases
  • New features in FileMaker Pro 10
  • Data Modeling/Relational Design
Download the databases used in the video tutorialsSend us your comments

Sharing your database

1:55

Additional Resources and Help

  • Sharing and hosting files
  • Working with shared files as a client
  • Closing shared files
  • File hosting troubleshooting
Download the databases used in the video tutorialsSend us your comments

Setting up calculations

5:13

Additional Resources and Help

  • Defining calculation fields
  • Specify Calculation dialog box
  • About formulas
  • Calculations
  • Exploring the calculation dialog window
Download the databases used in the video tutorialsSend us your comments

Adding and duplicating records

1:20

Additional Resources and Help

  • Adding and viewing data
  • Adding, duplicating and deleting records
  • Adding and duplicating related records
  • Creating and duplicating records
Download the databases used in the video tutorialsSend us your comments

Browse, Find, Layout and Preview Modes

1:21

Additional Resources and Help

  • About FileMaker Pro modes
  • Browse mode
  • Find mode
  • Layout mode
  • Preview mode
  • Interface tour
Download the databases used in the video tutorialsSend us your comments

Using buttons for finding and sorting data

0:56

Additional Resources and Help

  • Using buttons with scripts
  • Defining a button
  • Copying a button
  • Changing a button definition
  • Deleting a button
  • Sorting using buttons
Download the databases used in the video tutorialsSend us your comments

Button navigation

1:13

Additional Resources and Help

  • Button
  • Defining a button
  • Using buttons with scripts
  • Assigning script steps to buttons
Download the databases used in the video tutorialsSend us your comments

Committing and restoring data

1:11

Additional Resources and Help

  • Committing data in records
  • Restoring data in records
  • Committing and restoring data
Download the databases used in the video tutorialsSend us your comments

Matrix of products and functionality

3:14

Additional Resources and Help

  • Introducing Filemaker Pro 8.5
  • FileMaker Pro 8 Advanced
  • Best Practices Upgrading to FileMaker Pro 8
  • Upgrading to FileMaker Pro 8
Download the databases used in the video tutorialsSend us your comments

Creating and opening FileMaker databases

4:47

Additional Resources and Help

  • Creating a FileMaker Pro file
  • Opening files
  • Converting files from FileMaker Pro 6 and earlier
  • Opening files with foreign system formats
  • Opening shared files as a client
  • Opening files troubleshooting
  • Closing windows and files
  • Closing files troubleshooting
  • Creating databases from templates
  • Creating databases from scratch
Download the databases used in the video tutorialsSend us your comments

Using Preview Mode

0:37

Additional Resources and Help

  • Previewing and printing information
  • Previewing data on a layout
  • Printing records
  • Printing scripts
  • Printing table and field information
  • Printing the relationships graph
  • Printing troubleshooting
  • Previewing pages and print options
Download the databases used in the video tutorialsSend us your comments

Instant Web Publishing

3:27

Additional Resources and Help

  • Publishing databases on the Web
  • Instant Web Publishing
  • Instant Web Publishing (IWP) overview
  • Preparing your database for IWP
  • IWP best practices
Download the databases used in the video tutorialsSend us your comments

Moving between records in a found set

1:22

Additional Resources and Help

  • Moving through records
  • Navigating in web viewers
  • Basic find
Download the databases used in the video tutorialsSend us your comments

List of FileMaker resources for user assistance

2:15

Additional Resources and Help

  • Getting Started with FileMaker Pro 8
  • FileMaker Knowledge Base
  • FileMaker Training
  • FileMaker Advisor Magazine
  • Support Options
Download the databases used in the video tutorialsSend us your comments

Database description and benefits

1:26

Additional Resources and Help

  • About planning a database
  • About FileMaker Pro databases
  • Flat vs. relational databases
Download the databases used in the video tutorialsSend us your comments

Copying and moving data

1:31

Additional Resources and Help

  • Copying and moving data in records
  • Moving text and data with drag-and-drop
  • Exporting the contents of a field
  • Editing and locking records
Download the databases used in the video tutorialsSend us your comments

Form, List and Table Views

1:05

Additional Resources and Help

  • Viewing records as a form, list or table
  • Entering data in records
  • Adding and viewing data
  • Adding and viewing data troubleshooting
  • Layout Setup Dialog
Download the databases used in the video tutorialsSend us your comments

Opening other databases or file formats

1:43

Additional Resources and Help

  • Starting with your own data
  • Saving, importing, and exporting data
  • Importing data into FileMaker Pro
  • Microsoft Excel format
  • Using ODBC and JDBC with FileMaker Pro
Download the databases used in the video tutorialsSend us your comments

Printing labels

1:45

Additional Resources and Help

  • Considerations when you create a Labels layout
  • Considerations when you create an Envelop layout
  • Printing labels and envelopes
Download the databases used in the video tutorialsSend us your comments

Finding and sorting records

2:07

Additional Resources and Help

  • Finding, sorting and replacing data
  • Sorting records
  • Options for sorting records
  • Sorting records by subsummary values
  • Sorting records troubleshooting
  • Sorting with one criterion
  • Sorting with multiple criterion
  • Sort using Custom Values
  • Sorting from related tables
Download the databases used in the video tutorialsSend us your comments

Deleting records

1:26

Additional Resources and Help

  • Deleting records
  • Deleting records and backing up files
Download the databases used in the video tutorialsSend us your comments

Specify printer and paper options

0:49

Additional Resources and Help

  • Specifying a default printer and paper options (Windows)
  • Specifying printer and paper options (Mac OS)
  • Print and paper options
Download the databases used in the video tutorialsSend us your comments

View selection

1:06

Additional Resources and Help

  • Status Area
Download the databases used in the video tutorialsSend us your comments

Glossary of database terms

2:46

Additional Resources and Help

  • Glossary
Download the databases used in the video tutorialsSend us your comments

Field navigation, selecting fields, entering and changing data

1:42

Additional Resources and Help

  • Entering data in records
  • Entering and changing data in fields
  • Field control setup
Download the databases used in the video tutorialsSend us your comments

Printing records

1:58

Additional Resources and Help

  • Previewing and printing information
  • Printing records
  • Printing troubleshooting
  • Print layouts
Download the databases used in the video tutorialsSend us your comments

Mode selection

1:22

Additional Resources and Help

  • About FileMaker Pro modes
  • Status Area
Download the databases used in the video tutorialsSend us your comments

Save options

2:46

Additional Resources and Help

  • Saving and sending records as an Excel file
  • Saving and sending records as a PDF file
  • Saving and copying files
  • Save as EXCEL
  • Save as PDF
Download the databases used in the video tutorialsSend us your comments

Beyond the Basics

Things to do next

Download the tutorial for a hands-on lesson
Read the User's Guide
Subscribe to a FileMaker Newsletter
Sign up for training
Join FileMaker Technical Network
Find a User Group near you

Explore more resources

Get the most from FileMaker with these additional resources. You'll find more video tutorials, podcasts, informational books and publications and more.

Additional Video Tutorials

Check out these additional video tutorials and learn more at your own pace.

Other Ways to Get Started

Learn how to get started in minutes by using your own data, a ready-made solution or creating your own database from scratch.

FileMaker Books

Go deeper into FileMaker Pro with books written by experts in the field.

FileMaker Publications

  • FileMaker Advisor Magazine
  • FileMaker Basics

FileMaker Technologies

Learn more about sharing your database over your network, web publishing, and integrating your database with other data sources.

Documentation

Access documentation for your FileMaker products.
 

How do I ...

  • Begin an email marketing program?
  • Work with FileMaker Pro and Excel?
  • Use Instant Web Publishing?
  • Migrate my pre-.fp7 solutions?

Download the tutorial for hands-on lessons.

  • FileMaker Pro Tutorial
  • FileMaker Pro Tutorial sample file

The FileMaker Files

  • See all

Additional Podcasts

  • Start an email marketing program
  • Learn about the FileMaker Business Productivity Kit

Webinars

  • See all

Community Resources

FileMaker Technical Network

Join the FileMaker Technical Network today and take your business further!

User groups

Find a group near you and exchange ideas, make contacts and meet people with similar interests.

Customer Stories

Three-time Academy Award® winner Walter Murch believes FileMaker Pro is an integral part of his editing process.

The College of Arts and Science at Syracuse University dramatically lowered its course-scheduling time from 75 minutes per student to around 30 seconds with its FileMaker Pro solution. .

More customer stories

Newsgroups

Keep up-to-date on FileMaker products and ideas through these newsgroups.

Email list

Join a group and get the latest information on custom functions, plug-ins, scripts or other topics.

FileMaker RSS

Get the FileMaker RSS feed.

FileMaker News

Get special offers, updates tips and more each month.

View all FileMaker Newsletters

Sign up today for your free subscription to FileMaker newsletters.

Support

FileMaker
Knowledge Base

The FileMaker Knowledge Base contains a vast amount of information about current and past FileMaker products, promotions, technical information, product documentation and more. It's free, fast and comprehensive, and best of all, it's available anytime you need information.

You can register with the Knowledge Base, keep all your most frequently-referenced answers in your "My Stuff" folder, and receive email notification when topics of your choice have been updated.

Visit the Knowledge Base

Search the Knowledge Base

FileMaker
Support Options

FileMaker provides a variety of support options, one of which is sure to meet your needs.

Free tech support is available any time via our FileMaker Knowledge Base.

FileMaker also provides limited free phone support. For more information, check out the free phone support page.

Priority Support is the option for users who will need ongoing support help. Find out more on the Priority Support page.

For additional support needs such as file recovery or consultant services, please visit our Support Options page.