Filemaker Pro 6 or 7 Introduction to Creating Databases

Introduction
-Understanding database terms and concepts opening and browsing a FileMaker Pro database
-Different working modes and data views
-Menus and tools
-FileMaker Pro version compatibility

Working with a database
-Entering and deleting data in a record
-Adding new records
-Copying and pasting data and using view index
-Deleting and sorting records
-Finding data using multiple search requests and search
-Operators for more complex searching omitting records from a found set
-Previewing and printing records

Creating a new database
-Planning the database
-Different field types
-Field options such as auto-entry, validation and storage
-Creating value lists for a field
-Renaming and duplicating fields
-Adding calculation and summary fields
-Importing data from text/spreadsheet files and other FM Pro databases
-Integration with Microsoft Office
-How FileMaker Pro saves information

Working with Layouts
-Creating new Form and Columnar list layouts
-Using the layout tools
-Aligning elements accurately and sliding items
-Formatting fields on the layout
-Setting the field tab order
-Adding text and graphics to the layout
-Adding header and footer parts
-Creating summary layouts
-Creating envelope and label layouts
-Adding buttons to a layout
-Linking commands to buttons

Creating a relational database
-Relational vs flat file databases
-File lookups or related fields
-Creating relationships between files
-Setting relationship behaviour
-Adding lookup properties to fields
-Using fields from related databases in a layout
-Creating and using portals on a layout

Basic Scripting in FileMaker Pro
-About ScriptMaker
-Understanding the power and scope of scripts
-Modifying scripts
-Creating simple finding and sorting scripts
-Importing scripts from other databases
-Linking scripts to buttons
-Using sub-scripts and scripts from other files
-Creating conditional scripts

Network and web sharing
-Multi-user database sharing on a network
-Publishing FileMaker Pro databases on the Internet or an intranet
-Ponfiguring Browser options Styles, data views, search
-Layouts and sort behaviour
-Controlling access privileges