User manual
Table Of Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Working with data in Table View
- Finding records
- Performing quick finds in Browse mode
- Making find requests in Find mode
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Viewing, repeating, or changing the last find
- Saving find requests
- Deleting and reverting requests
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 3 Creating databases
- Planning a database
- Creating a FileMaker Pro file
- Creating and changing fields
- Setting options for fields
- Creating database tables
- Creating layouts and reports
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with parts on a layout
- Displaying data in charts
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing and exchanging data
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record data
- Supported import/export file formats
- Setting up recurring imports
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Working with external data sources
- Publishing databases on the web
- Chapter 6 Protecting databases
- Protecting databases with accounts and privilege sets
- Creating accounts and privilege sets
- Viewing extended privileges
- Authorizing access to files
- Security measures
- Enhancing physical security
- Enhancing operating system security
- Establishing network security
- Backing up databases and other important files
- Installing, running, and upgrading antivirus software
- Chapter 7 Converting databases from FileMaker Pro 6 and earlier
- Index
36 FileMaker Pro User’s Guide
Finding ranges of information
To find values that are Use this operator Examples
Less than a specified value < <40
<9/7/2010
<M
Less than or equal to a specified value <=
or ≤ (Mac OS)
<=95129
≤05:00:00
<=M
Greater than a specified value > >95129
>9/7/2010
>M
Greater than or equal to a specified value >=
or ≥ (Mac OS)
>=100
>=9/7/2010
≥8:00
≥M
Within the range you specify. A range is different based on the data
type:
1 Numbers: least to greatest
1 Dates and times: earliest to latest
1 Text: first to last word, based on the index order of words (not the
sort order)
.. or ... (two or three periods) 12:30...17:30
1/1/2010..6/6/2010
A...M
To f i n d d a t e s Type this in the field
In June 2010 6/2010
From July 2010 through October 2011 7/2010...10/2011
That occur on a Friday =Friday
From the 10th through the 16th of October or November 2010
(if the date format is MM/DD/YYYY)
{10..11}/{10..16}/2010
That occur on March 1st between 1868 and 1912 in the Japanese
Emperor Year era of Meiji
m*/3/1
That occur on December 31st between 1930 and 1940 in the Japanese
Emperor Year era of Showa
S{5..15}+12+31
To f i n d t i m e s Type this in the field
In the 3 o’clock hour, not including 4:00 PM 3 PM
Between 8:00 AM and 8:59:59 PM 8 AM..8 PM
In the morning AM
Any of the times 4:30, 5:30, 6:30 PM {4..6}:30 PM
To find timestamps Type this in the field
In the 3 o’clock hour today // 3 PM
In the 7 o’clock hour in May 2010 5/2010 7 PM