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
FileMaker Pro basics
1-3
1 date
1 time
1 graphic, sound, movie, or, for Windows only, OLE
1 the result of a formula that calculates the field’s value
1 a summary of the values in the field for a group of records
About layouts
FileMaker Pro layouts determine how information is organized for
viewing, printing, reporting, finding, and entering data. Layouts do
not store your data—they just display it.
Database files can have many different layouts, which display data
in a variety of ways. Within one database file, you can design
separate layouts for entering data, reporting summaries, printing
mailing labels, publishing a database on the Web, and so on. You can
change a layout’s design without affecting the data or other layouts
for the file. When you change the data in a field, the changes are
reflected in the same field on all the layouts in the database.
In a layout, you:
1 choose which fields to display
1 arrange and format fields
1 add or modify field labels
1 create reports, for example, to group or summarize data
1 add buttons, which make your file easier to use
1 specify how records are printed
1 add graphics and text to add emphasis and interest
About modes
You work with data in FileMaker Pro using four modes.
Switch modes by using the mode pop-up menu in the lower left
corner of the window or by choosing a mode from the View menu.
Steve Williams
789 Ninth Avenue
New York, NY 10001
The same data can be arranged differently with multiple layouts
Juanita Alvarez 555-1234
Michelle Cannon 555-1234
Andre Common 555-1234
Marie Durand 555-1234
Jean Durand 555-1234
William Johnson 555-1234
John Lee 555-1234
Patrick Murphy 555-1234
Le Nguyen 555-1234
Kentaro Ogawa 555-1234
Mary Smith 555-1234
John Smith 555-1234
Sophie Tang 555-1234
Steve Williams 555-1234
Betty Wilson 555-1234
Phone List
Dear Sophie,
Thank you for reserving a cruise with us. We
value your business and appreciate the
opportunity to serve you.
If you have any questions about your
reservations, please call us—we want you to
be satisfied with your cruise.
Sincerely,
John Lee
In this mode You do this
Browse Work with the data in a file. You can add, view, change, sort,
omit (hide), and delete records. Browse mode is where you’ll
do much of your work, such as data entry.
Find Search for particular records that match a set of criteria. You
can then work with this subset of your records, called the
found set. After you find a group of records, FileMaker Pro
returns to Browse mode so you can begin working with
them.
Layout Determine how information is presented on your screen or in
printed reports, labels, and forms. You design layouts for
specific tasks, like data entry or printing invoices or
envelopes. Select and arrange fields and other objects to
modify an existing layout or create new layouts.
Mode pop-up menu