Tutorial
Table Of Contents
- Contents
- Lesson 1 FileMaker Pro basics
- Lesson 2 Browsing information
- Lesson 3 Finding and sorting records
- Use quick find to search a database
- Find records based on criteria in a single field
- Find records based on criteria in specific separate fields
- Find records that match multiple criteria in the same field
- Find records that match a range of criteria in the same field
- Narrow your search
- Save a find request to use later
- Find records using a Saved Find
- Sort your found set
- Add a new record in List View
- For more information
- Lesson 4 Creating a database and entering records
- Lesson 5 Customizing what you see
- Lesson 6 Creating lists, mailing labels, and form letters
- Lesson 7 Simplifying data entry
- Lesson 8 Automating tasks with buttons and scripts
- Lesson 9 Creating and running reports
- Lesson 10 Charting data
- Lesson 11 Making databases relational
- Lesson 12 Sharing and exchanging data
- Lesson 13 Protecting data in FileMaker Pro
- Lesson 14 Backing up your databases
10 FileMaker Pro Tutorial
Where to find the sample file
The sample file contains data for The Corporate Travelers Club and provides a place for you to practice
building the database elements that are described in each lesson. If you need to start over, replace your
existing sample file with a new copy. If the sample file was installed, it is in:
FileMaker Pro 11/English Extras/Tutorial
or
FileMaker Pro 11 Advanced/English Extras/Tutorial
You can also download the sample file from the FileMaker website by visiting:
www.filemaker.com/documentation
Database concepts
What is a database?
A database is a method of organizing and analyzing information. You’ve probably used several databases
recently without realizing it. A date book, a parts list, and even your own address book are databases.
Why use a database?
Storing information in a database file has many benefits. A database doesn’t just hold information—it helps you
organize and analyze the information in different ways. For example, databases allow you to group information
for reports, sort information for mailing labels, count your inventory, or quickly find a particular invoice.
Computerized databases offer many additional advantages over their paper-based counterparts: speed,
reliability, precision, and the ability to automate many repetitive tasks.
How is a database organized?
A database file is organized into one or more tables. Tables store records. Each record is a collection of fields.
Imagine your address book is a FileMaker Pro database file. Each listing in your address book is one record
in an Address Book table. Each record has information, such as name, address, city, and so on. Each of these
pieces of information—name, address, and city—is stored in a separate field.
How is field data displayed?
FileMaker Pro displays fields on layouts. Each layout is based on a single table, and displays records from
that table.
Imagine that your database has a Tasks table in addition to the Address Book table. A layout based on the
Address Book table will display fields and records from the Address Book table. A layout based on the Tasks
table will display fields and records from the Tasks table.