Tutorial
Table Of Contents
- Lesson 1 FileMaker Pro basics
- Lesson 2 Browsing information
- Lesson 3 Finding and sorting records
- 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 Making databases relational
- Lesson 11 Keeping your data safe
8 FileMaker Pro Tutorial
The working files mimic the sample files, except the features being
taught in particular lessons have been removed. You will add these
missing items and structures as you complete each lesson.
If you need to start over
If you make a mistake or need to start over, replace your existing
Tutorial folder with a new copy from the FileMaker Pro 7 CD.
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 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.
FileMaker Pro 7 CD
Sample02.fp7
Sample03.fp7
Sample04.fp7
Sample05.fp7
Sample06.fp7
Sample07.fp7
Sample08.fp7
Sample09.fp7
Sample10.fp7
MyFile05.fp7
MyFile06.fp7
MyFile07.fp7
MyFile08.fp7
MyFile09.fp7
MyFile10.fp7
Tutorial
Sample Files Working Files
Overview of the FileMaker Pro Tutorial folder structure
English Extras
FileMaker Pro 7 folder
or