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
137
Calendars, displaying in fields 74
Characters
maximum in fields 25
not allowed in field names 43
Charting data
creating charts 82
described 81
editing charts in Layout mode 83
quick charts 82
Checkbox sets, displaying fields as 74
Clients
described 99
performing tasks 102
saving files 99
Closing windows and files 16
Color, changing for text 77
Column charts 81
Columns
changing width 65
printing records in 63
resizing in tables 26
Comma-separated text format 103
Comparison operators 48
Constant values 48
Container fields
See also Fields
described 10
, 44
formatting 76
inserting files into 25
storage options for 51
Context menus, choosing from 13
Control styles for fields 74
Copying
files 17
records 22
related records 23
Creating. See Adding; Defining
Currency, formatting 76
Current record 21
Custom functions, creating 130
Custom menus 131
, 132
D
Data
charting 81
described 13
entering automatically 22
, 51
entering in fields 25
formatting 68
importing and exporting 103
privileges for sharing 111
viewing in forms, lists, or tables 19
Data entry 25
Data Entry Only privilege set 113
Data sources
described 108
updating 128
Data types
See also Field types
and calculation results 49
Data Viewer 133
Database Design Reports (DDR) 134
Database schemas, in Database Design Reports 134
Database statistics 134
Database structure, re-creating 134
Databases
See also Files; Solutions
described 8
, 13
planning 37
printing 35
protecting 110
Databases, relational. See Relational databases
Date fields
described 44
entering and editing values in 25
formatting 76
four-digit years 25
, 51
Dates
See also Date fields
displaying calendars 74
entering data 25
four-digit years 51
typing in 25
DDR (Database Design Reports) 134
Defining
See also Adding
accounts 117
calculation fields 48
databases 43
fields 43
lookups 96
passwords 116
privilege sets 119
summary fields 49
tables 53
value lists 74
Defining fields
described 43
in Field Picker dialog box 46
in Table View 47
Deleting
data 25
fields from a layout 74
find requests 32
related records 24
, 95
Developer Utilities
creating runtime solutions 125
described 125
Displaying shortcut and context menus 13
Distributing runtime solutions
described 126
distributing updates 128
Document preferences 36
Dragging fields to a layout 73
Drop-down calendars, displaying fields as 74
Drop-down lists, displaying fields as 74