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
|
Index 153
Sorting
records
34, 42
records in Table View 30
related records 105
Sound files 58
Standard Deviation for summary fields 64
Standard form layout
See also Layouts
described
72
Starter Solutions. See Templates
Status toolbar
22, 77
Stopping lookups 107
Stored results 68
Strict data type 67
Strings, text. See Text, literal
Subforms. See Portals
Subsummaries
See also Reports; Summary fields
creating reports
74
parts, described 92
printing 43, 44
Subtotals. See Subsummaries; Summary fields
Summarizing data in related fields
105
Summary fields
Average for
63
Count for 63
creating 63
defining in Table View 63
described 58, 63
Fraction of Total for 64
Maximum for 64
Minimum for 64
on layouts 92
options for 64
Standard Deviation for 64
Total for 63
Summary parts. See Subsummaries
Supplemental fields
65
Symbols
and field names
57
finding 34
System Preferences, configuring mouse
(Mac OS)
15
T
Tab controls
described
71
including in tab order 27
Tab order 27
Table format
See also Table view layout; Table View
described
22
viewing records as 22
Table View
See also Table format; Table view layout
adding records
29
adding records in new file 56
changing column order and size 29
changing default when creating new database 57
copying records 30
creating and changing fields in 61
creating databases in 56
creating dynamic reports 30, 63
creating fields 56
defining summary fields 63
deleting records 29
duplicating records 29
hiding or showing fields 61
sending email messages based on record data 30
sorting records 30
viewing data 29
working with records 29
Table view layout
See also Table format; Table View
described
73
Tables
defining
69
described 16
importing data into new 116
naming 70
table occurrences 98
viewing records as 22
Tabs
inserting in fields
28
setting position and alignment 86
Tab-separated text format 114
Templates
creating files
55
described 55
Text
See also Fields
attributes
85
fields 58
finding 34
formatting 85
highlighting 86
literal 33
rotating Asian text 89
selecting 80