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
150 FileMaker Pro User’s Guide
Networks
cross-platform
13, 109
FileMaker Server 109
New Layout/Report assistant, described 71
Non-shared files 128
Number fields
See also Fields
described
58
entering and editing values in 27
finding 35
formatting 86
Numbers
formatting
86
invalid 35
O
Objects, layout
aligning to other objects
78
described 77
formatting 78
locked 80
positioning 78
selecting 80
setting auto resize options 79
ODBC
overview
115, 116
using FileMaker as client
described
120
supplemental fields 65
using FileMaker as data source
field name considerations
57
privileges for 125, 132
Omitting
fields during printing
84
records 39
related records 37, 40
Opening
files
17
multiple windows 19
Operators
comparison
62
in find requests 32, 36
mathematical 62
relational 97, 101, 104
Operators list 32
Options, file 49
OR searches 38
P
Page breaks, viewing in Preview mode 43
Page margins, viewing in Preview mode 43
Page numbers
in layout parts
73
viewing in Preview mode 43
Page orientation for printing 45
Panels, tab panels on layouts 71
Paragraphs, formatting 86
Parts. See Layout parts
Passwords
defining 128
protecting files with 128
related files, planning 54
troubleshooting 140
PDF documentation 9
PDFs, saving data as 114
Photos, in container fields 58
Picture fields. See Container fields
Pie chart icon in status toolbar
32
Pie charts
creating
92
described 92
example 92
Planning
databases
51
file security 127
relational databases 51
Pointer tool. See Selection tool
Pointers to files. See Relationships
Pop-up menus, displaying fields as
83
Portals
See also Relational databases
adding records
26
deleting records 26
described 97
filtering records in 105
omitting related records 40
placing related records 84
selecting 80
selecting records 24
summarizing data in 105
Preferences
application
49
described 49
file 49
Preview mode, described 21, 43
Previewing printing. See Printing
Previewing columns
75