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
Index | 213
Searching. See Finding records
Secondary files. See Relational databases
Security, file 198
operating system guidelines 198
planning 181, 197
Selecting
fields 38, 114
objects 114
records 32
Selection tool 114
Self-joins 144
for summarizing data in portals 150
Server. See Host; FileMaker Server
Settings. See Preferences
Shared files
See also Networks
accounts 182
clients 156
host 156
in workgroups 172
limitations 156
on web 172
opening 23
privilege sets 182
saving 157
setting up privileges for 177
Simple Mail Transfer Protocol (SMTP),
sending email through 164
Single-page form layout. See Standard form
layout
Slider 34
Sorting
records 45, 58
records in table format 31
related records 149
Sound files 82
Standard Deviation for summary fields 89
Standard form layout
See also Layouts
described 102
Starter Solutions. See Templates
Status toolbar 29, 110
Stopping lookups 153
Stored results 96
Strict data type 95
Strings, text. See Text, literal
Subforms. See Portals
Subsummaries
See also Reports; Summary fields
creating reports 102
parts, described 130
printing 60, 61
Subtotals. See Subsummaries; Summary
fields
Summarizing data in related fields 150
Summary fields
Average for 89
Count for 89
defining 88
described 82, 88
Fraction of Total for 89
Maximum for 89
Minimum for 89
on layouts 130
options for 90
Standard Deviation for 89
Total for 89
Summary parts. See Subsummaries
Supplemental fields 91
Symbols
and field names 81
finding 44
φμπ10_υσερσ_γυιδε.βοοκ Παγε 213 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ