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
4
Finding records 28
Performing quick finds in Browse mode 28
Making find requests in Find mode 29
Finding data in related fields 31
Viewing, repeating, or changing the last find 31
Saving find requests 32
Deleting and reverting requests 32
Hiding records from a found set and viewing hidden records 32
Finding and replacing data 32
Sorting records 32
Previewing and printing files 33
Previewing data on a layout 34
Printing records 35
Printing table and field information 35
Printing the relationships graph 35
Backing up files 36
Setting preferences 36
Chapter 3
Designing and creating solutions 37
Planning a solution 37
Creating a FileMaker Pro file 41
Creating a file using a Starter Solution 41
Creating a new file 42
Creating and changing fields 43
About naming fields 43
About choosing a field type 44
Creating and changing fields in the Field Picker dialog box 46
Creating and changing fields in Table View 47
Creating calculation fields 48
Creating summary fields 49
Using supplemental fields 50
Setting options for fields 50
About indexing and storage options 52
Creating database tables 53
Creating layouts and reports 54
About layout types 56
Creating Labels and Envelopes layouts 58
Working with layout themes 60
Working with layout object, part, and background styles 61
Setting up a layout to print records in columns 63
Setting up columns in a layout 64
Changing the width of columns 65
Working with objects on a layout 66
Organizing data with panel controls and popovers 66
Using the Inspector to format objects 68
Using tools to precisely position objects 69
Selecting objects 71