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
- Finding records
- Making a find request
- Performing quick finds based on data in one field
- 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
- Saving find requests
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- 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
- Defining database fields
- Using supplemental fields
- Setting options for fields
- Defining 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
- 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
- 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 with accounts and privilege sets
- Chapter 7 Converting databases from FileMaker Pro 6 and earlier
- Chapter 8 Security measures
- Index
208 | Index
Formatting
calculations 122
dates 123
export data 170
graphics 126
import data 164
numbers 122
text 122
times 124
timestamps 125
Forms
See also Layouts
Standard form layout 102
viewing records as 29
Formulas, calculation fields 85
Found set
described 28, 40
switching with omitted set 56
fp7 filename extension 24
Fraction of Total for summary fields 89
Full Access privilege set, described 180
Functions 87
Furigana field option 85
G
Global storage options 97
Grand summaries, described 130
Graphics, formatting fields for 126
Groups. See Accounts; Privilege sets
Guest account 179
H
Headers, described 130
Hiding records 55
Host
database on web 172
described 156
FileMaker Server 156
performing tasks 160
saving files 157
HTML table format 164
I
Importing 163–170
adding new records 165, 166
described 163
file formats supported 164
into existing files 165
into new tables 165
source file or table 165, 168
target file 165
updating existing records 165
updating matching records 166
Indexing
fields 96
text field limitations 46
Info palette 110
Instant Web Publishing
described 155, 172
privileges for 189
sharing files 172
Intranet 172
See also Web
Invalid values, finding 46
IP addresses, limiting 172
J
JDBC
field name considerations 81
privileges for 178, 189
Join expressions. See Relationships
Join fields. See Match fields
K
Key fields. See Match fields
L
Labels
field 117, 118
vertical 105
Labels (mailing), printing 63
Labels layout, creating 63
φμπ10_υσερσ_γυιδε.βοοκ Παγε 208 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ