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
204 | Index
Authorized users. See Accounts; Privilege
sets
Auto Enter 92
Auto-complete 118
Automating tasks. See Scripts
Average for summary fields 89
B
Backups
and antivirus software 201
guidelines for 199
scripts for files 68
Blank layout
See also Layouts
described 106
Blank records, printing 62
Body, described 130
Boolean values
described 46, 82, 95
finding 46
formatting 123
Break fields 130
Browse mode
described 28
finding data in 42
Browser, web
opening URL 172
Browsing records 29
Buttons, including in tab order 38
C
Calculation fields
defining 85
described 82
formulas 85
stored and unstored results 96
Calculations
See also Calculation fields
formatting 122
related fields
field references to 86
summarizing data 150
Calendars
displaying in fields 118
Case-sensitive text, finding 45
Changing
data in fields 38
find requests 55
lookups 153
preferences 69
relationships 148
Characters
maximum in fields 38
not allowed in field names 81
Checkboxes, displaying fields as 119
Clients
described 156
limits, on the web 172
performing tasks 160
saving files 157
Clones 27
Closing windows and files 26
Columnar list/report layout
See also Layouts
described 102
Columns
changing width 109
in tables 31
printing records in 106
Combo boxes, displaying fields as 119
Comma-separated text format 164
Compacted copies of files 27
Comparison operators 86
Container fields
See also Fields
described 82
formatting 126
Control styles for fields 119
Copying
field definitions 27
files 26
records 35
related records 36
scripts 27
Count for summary fields 89
φμπ10_υσερσ_γυιδε.βοοκ Παγε 204 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ