Tutorial

Contents
Lesson 1
FileMaker Pro basics
How to use this tutorial 7
We begin with a demonstration 7
We explain how it works 7
You build the structures 7
Where to find the lesson files 7
If you need to start over 8
Database concepts 8
What is a database? 8
Why use a database? 8
How is a database organized? 8
How is field data displayed? 8
FileMaker Pro basics 9
About FileMaker Pro modes 9
For more information 9
Lesson 2
Browsing information
O pen a database and move between records 11
View information in different ways 11
See a different layout 12
View your layouts as forms, lists, and tables 13
For more information 14
Lesson 3
Finding and sorting records
Find records based on criteria in a single field 15
Find records based on criteria in separate fields 16
Find records that match multiple criteria in the same field 16
Find records that match a range of criteria in the same field 17
Narrow your search 18
Sort your found set 18
For more information 19
Lesson 4
Creating a database and entering records
Create a simple database and define fields 21
Look at the sample file 21
A bout field definitions 22
Create a database 22
Enter data into the database 23
Create the first record 23
Create another record 23
Modify data in a record 23
For more information 23
Lesson 5
Customizing what you see
Customize your view in Layout mode 25
Look at the sample layouts 25
About layouts and tables 26
About customizing layouts 26
Customize a layout 26
Resize, move, and add a field 26
Select and resize a field 26
Move a field 26
Add a field 27
Display a number as currency 27
Add color to a layout part 28
Add custom text to a layout 29
Add text 29