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
Contents
Preface
Learning how to use FileMaker Pro
Registration and customer support
xi
Using the FileMaker Pro documentation
xi
How this guide is organized
xii
A note about the illustrations
xii
Using FileMaker Pro Help
xiii
Starting FileMaker Pro Help
xiii
About the Help topic window
xiii
Finding a topic using the Help Contents
xiii
Finding a topic using the Help Index
xiv
Finding a topic using specific words
xv
Finding information on specific items in FileMaker Pro
xvi
Getting additional Help
xvi
Using other tools
xvii
Chapter 1
FileMaker Pro basics
About databases
1-1
About FileMaker Pro files
1-2
About fields and records
1-2
About layouts
1-3
About modes
1-3
About sharing data
1-4
Performing menu commands
1-4
Using toolbars
1-5
Using context menus
1-5
Managing files
1-6
Starting FileMaker Pro
1-6
Opening files
1-6
Closing files
1-7
Saving files
1-7
Quitting FileMaker Pro
1-8
Chapter 2
Adding and viewing data
About working with records in Browse mode
2-1
Viewing records
2-2
Viewing records in a table
2-2
Selecting the current record
2-3
Moving through records
2-4
Adding and duplicating records
2-4
Adding and duplicating related records
2-5
Deleting records
2-5
About entering data in records
2-6
Selecting a field
2-6
Entering and changing data in fields
2-7
Copying and moving data in records
2-8
Entering preset data from a value list
2-8
Moving data with drag and drop
2-9
Inserting the current date or other variable into fields
2-10
Replacing data in fields
2-10
About working with graphics, sounds, and movies
2-11
Inserting graphics into fields
2-11
Inserting movies and QuickTime multimedia
into fields
2-12
Pasting graphics, movies, and sounds from
the Clipboard
2-12
Playing movies in fields
2-12
Recording and playing sounds in fields
2-13
Deleting graphics, movies, or sounds from fields
2-13