https://my.oditech.com/downloads/FileMaker/12/fmp12_users_guide.pdf
Chapter 1 - Introducing FileMaker Pro
- About this guide
- Using FileMaker Pro documentation
- Where to find PDF documentation
- Online Help
- Templates, examples, and more information
- Suggested reading
- FileMaker Pro overview
- Creating simple or complex databases
- Using layouts to display, enter, and print data
- Finding, sorting, and replacing data
- Protecting databases
- Creating scripts to automate tasks
- Sharing and exchanging data
- Saving and sending data in other formats
Chapter 2 - Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- What FileMaker Pro doesn’t save
- About modes
- Using the status toolbar
- Viewing records
- Selecting the active record
- Moving through records
- Adding and duplicating records
- Adding and duplicating related records
- Deleting records
- Entering data
- Selecting a field
- Entering and changing data in fields
- Working with data in Table View
- Displaying data in Table View
- Working with records 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
- Previewing data on a layout
- Printing records
- Printing labels and envelopes
- Printing scripts
- Printing table and field information
- Printing the relationships graph
- Automating tasks with scripts
- Backing up database files
- Setting preferences
Chapter 3 - Creating databases
- Planning a database
- Creating a FileMaker Pro file
- Creating a file using a Starter Solution
- Creating a blank, empty file
- About naming fields
- About choosing a field type
- Creating and changing fields
- Creating and changing fields in the Manage Database dialog box
- Creating and changing fields in Table View
- Creating calculation fields
- Creating summary fields
- Using supplemental fields
- Setting options for fields
- Defining automatic data entry
- Defining field validation
- About indexing and storage options
- Creating database tables
- Creating layouts and reports
- About layout types
- Working with layout themes
- Setting up a layout to print records in columns
- Setting up columns in a layout
- Changing the width of columns
- Working with objects on a layout
- Using the Inspector to format objects
- Using the Inspector to position objects
- Using tools to precisely position objects
- Selecting objects
- Working with fields on a layout
- Placing and removing fields on a layout
- Setting up checkbox sets and other controls on a layout
- Deciding where to place related fields
- About merge fields
- Formatting field data on a layout
- Allowing or preventing entry into fields
- Working with parts on a layout
- About layout part types
- Creating and editing charts
- Creating a chart
- Editing a chart
Chapter 4 - Working with related tables and files
- About relationships
- Relational database terminology
- About the relationships graph
- About match fields for relationships
- Types of relationships
- Planning a relational database
- Working with the relationships graph
- Creating relationships
- Changing relationships
- Summarizing data in portals
- Filtering records in portals
- About lookups
- Creating lookups
- Editing lookups
Chapter 5 - Sharing and exchanging data
- Sharing databases on a network
- Enabling file sharing and hosting files
- Opening shared files as a client
- Opening shared databases remotely using a URL
- Closing a hosted file
- 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
- Accounts, privilege sets, and extended privileges
- About the predefined accounts
- About the predefined privilege sets
- Planning security for a file
- Password-protecting a file
- Creating accounts and privilege sets
- Viewing accounts and privilege sets
- Creating accounts
- Creating accounts that authenticate via an external server
- Creating privilege sets
- About enabling record-level access
- 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 11 and earlier
- Conversion overview
- Solving basic conversion problems
