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
Chapter 2 | Using FileMaker Pro 14
An invoicing system is an example of a more complex database, with multiple related tables,
multiple layouts, and calculated fields.
You can also view a subset of your data; for example, view only invoices for a particular month. A
database doesn’t just hold information—you use a database to organize and analyze information
so that you understand its significance.
Fields are the basis of a database table. Fields are used to store, calculate, and display the data
you enter into a record. Each piece of information in a record—like name, ID number, and
telephone number—is stored in a field.
A database table contains one or more fields that hold similar information about one subject or
activity. For example, the fields on a record in the Customers table contain address information for
one customer. Tables also define the organization of records based on that table.
A database can consist of one file with one table, which might hold the names, addresses, and
telephone and fax numbers of all your customers. A database can also consist of several files,
each of which can contain one or more tables that, together, contain all the information about
related topics (sometimes called a database system). Using the relational capabilities of
FileMaker
Pro, you can join information between files and tables to create a relational database.
For example, one table can show you which customers bought a particular item and a related table
can show how much they paid.
BC
Michelle Cannon
123 4th St. SW
Edmonton
(717) 555-0011
CAN
N4V 1LN
Records
Fields
Your address book is like a database
Invoices table
002
Customer ID
Andre Common
Customer Name
818-555-1234
Phone
Product ID
Product
FB3
Price
Baguette $3.95
FB14 Croissants $9.95
12345
Invoice ID
FB3Product ID
BaguetteProduct
$3.95Price
002Customer ID
Andre CommonName
818-555-1234Phone
Products table
Customers table
34Stock