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