User manual
Table Of Contents
- Preface Learning how to use FileMakerPro
- Chapter 1 FileMaker Pro basics
- Chapter 2 Adding and viewing data
- Chapter 3 Finding and sorting information
- Finding records
- Finding text and characters
- Finding exact matches in text fields
- Finding numbers, dates, and times
- Finding ranges of information
- Finding data in related fields
- Finding records that match multiple criteria
- Finding empty or non-empty fields
- Finding duplicates
- Finding all records except those matching criteria
- Hiding records from a found set and viewing hidden records
- Viewing, repeating, or changing the last find
- Sorting records
- Finding records
- Chapter 4 Previewing and printing information
- Chapter 5 Creating a database
- Chapter 6 Creating and managing layouts and reports
- Chapter 7 Customizing layouts
- Chapter 8 Working with related files
- Chapter 9 Protecting databases with passwords and groups
- Chapter 10 Creating scripts to automate tasks
- About scripts
- Creating scripts: an overview
- About ScriptMaker steps
- Control script steps
- Navigation script steps
- Sort, find, and print script steps
- Editing script steps
- Fields script steps
- Records script steps
- Windows script steps
- Files script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
- Changing scripts
- Duplicating, renaming, or deleting scripts
- Importing scripts
- Listing scripts in the Scripts menu
- Using buttons with scripts
- Example of a ScriptMaker script
- Chapter 11 Using formulas and functions
- Chapter 12 Importing and exporting data
- Chapter 13 Sharing databases on a network
- Chapter 14 Publishing databases on the Web
- About publishing databases on the Web
- How users work with databases on the Web
- What you need to publish databasesontheWeb
- Publishing databases on the Web: an overview
- Enabling FileMaker Pro Web Companion
- Configuring FileMaker Pro WebCompanion
- Enabling Web Companion sharing
- Setting up browser views
- Testing your published database
- About browser views for web publishing
- Chapter 15 Using ODBC with FileMakerPro
- Appendix A Customizing FileMaker Pro
- Appendix B Backing up and recovering files
- Appendix C FileMaker Pro Quick Reference (Windows)
- Appendix D FileMaker Pro Quick Reference (Mac OS)
- Index
Chapter 1
FileMaker Pro basics
This chapter presents basic information about databases and using
FileMaker Pro. You’ll learn about:
1 working with fields and records
1 using FileMaker Pro modes
1 performing menu commands
1 managing files
If you’re new to FileMaker Pro, start by reviewing the tutorial,
included in the FileMaker Pro Getting Started Guide.
About databases
A database is a collection of information, or data, that you can
organize, update, sort, search through, and print as needed. Your own
address book or filing cabinet might be an example of a database.
With the address book and filing cabinet, you store similar pieces of
information organized for easy retrieval.
With a filing cabinet, you must choose a way to sort your data, for
example, alphabetically by last name or by region. By storing contacts
and addresses in FileMaker Pro, you can organize your information in
many ways. You can sort your information by country, city, last name,
or even sort by all three of these fields!
You can also view a subset of your data, for example only contacts in a
particular city. A database doesn’t just hold information—you use a
database to organize and analyze information so that you understand its
significance.
A database can be one file, which might hold the names, addresses,
and telephone and fax numbers of all your clients.
A database can also be many files that, together, contain all the
information about a particular topic, or related topics (sometimes
called a database system). Using the relational capabilities of
FileMaker Pro, you can join information between files to create a
relational database. For example, one file can show you which
clients went on a particular tour and a related file can show how
much they paid. (For more information about relational databases,
see chapter 8, “Working with related files.”)
M N
Michelle Cannon
123 4th St. SW
Edmonton
(717) 555-0011
CA
N4V 1LN
Records
Fields
Your address book is like a database