User manual
Table Of Contents
- Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using FileMaker Pro
- About fields and records
- Opening and closing files
- Opening multiple windows per file
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Working with data in Table View
- Finding records
- Sorting records
- Previewing and printing files
- Backing up files
- Setting preferences
- Chapter 3 Designing and creating solutions
- Planning a solution
- Creating a FileMaker Pro file
- Creating and changing fields
- Setting options for fields
- Creating database tables
- Creating layouts and reports
- Working with layout themes
- Working with layout object, part, and background styles
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with layout parts
- Creating and editing charts
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing data
- Sharing databases on a network
- Importing and exporting 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 solutions on the web
- Chapter 6 Protecting files
- 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 Using FileMaker Pro Advanced
- Index
143
Shared files
See also Networks
accounts 115
clients 99
host 99
limitations 98
on web 109
privilege sets 115
saving 99
setting up privileges for 111
Shortcut menus, choosing from 13
Simple Mail Transfer Protocol (SMTP), sending email
through 109
Single-page form layout. See Table View
Slide controls 66
Snapshot links, saving and sending found set as 11
, 29
Solutions
See also Databases; Files; Runtime solutions
creating from Starter Solution 41
creating new 42
described 8
opening in Launch Center 15
publishing on web 109
Sorting records
described 33
in Table View 27
related 95
Sound files 44
Source file (relationships) 87
Source table (relationships) 87
Stacked bar charts 81
Stacked column charts 81
Starter Solutions, designing solutions with 8
Statistics, database 134
Status toolbar 18
, 66
Storage options for container fields 51
Stored results 51
, 52
Structure, database 134
Styles, setting for objects, parts, layout background 61
Subforms. See Portals
Subsummaries
See also Reports; Summary fields
creating reports 58
parts, described 80
printing 34
, 35
Subtotals. See Subsummaries; Summary fields
Summary fields
creating 49
described 44
, 49
dynamic reports in Table View 49
on layouts 80
Summary parts. See Subsummaries
Supplemental fields 50
Symbols, and field names 43
T
Tab controls 66
Tab order 24
Tabbing into fields 24
Table View 19
adding records 27
changing column order and size 26
copying records 27
creating quick charts 27
defining fields in 47
defining summary fields 49
deleting records 27
described 20
duplicating records 27
dynamic reports in 27, 49
sending email messages based on record data 27
sorting records 27
working with data and records in 26
, 27
Tables
defining 53
described 14
importing data into new 104
naming 53
table occurrences 88
Tabs
inserting in fields 25
setting position and alignment 77
Tab-separated text format 103
Testing solutions 127
Text
See also Fields
aligning with checkboxes and radio buttons 77
attributes 76
changing color 77
fields 44
formatting 76
highlighting 77
rotating Asian text 77
selecting 71
Text baselines, specifying options for 77
Text fields
described 44
entering and editing values in 25
Text notes in relationships graph 94
Themes, layout
changing 42
, 60
described 60
importing 60
managing 61
Time fields
described 44
entering and editing values in 25
formatting 76
Timestamp fields
described 44
entering and editing values in 25
formatting 76
four-digit years 25
Title header and footer parts 80