|
Provided by: XChange Training UK Filemaker Pro 6 or 7 Introduction to Creating DatabasesDatabases and SQL |
 |
Training
Provided by XChange Training UK
FileMaker Pro is a leading database management tool for the Macintosh and PC. Its popularity lies in the simplicity with which beginners can start creating databases. Nevertheless, as of FileMaker Pro 7, this database management application has joined the league of industial-sized databases and offers a wide range of features on top of its still very intuitive user interface.
This course is aimed at users who want to be able to confidently use and customise existing database solutions or to start building their own simple databases with FileMaker Pro 7. Basic Scripting and relational issues will also be covered.
By the end of this one day course, you will be able to create a FileMaker Pro database file with custom fields, that provides functionality for a variety of business applications that you have specified. You will also be confident making the next steps into more complex database design.
|
|
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
-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
About The Training Provider: XChange Training UK
XChange Training UK - XChange Training offer bespoke and scheduled training in a large range of creative and web technolgies including Adobe training courses for Adobe InDesign CS4 & CS3, Adobe Dreamweaver CS4 & CS3, Adobe Illustrator CS4 & CS3, Adobe Photoshop CS4 & CS3, Adobe Flash CS4 & CS3 & Flash ActionScript; Adobe Acrobat 9 & 8 and Adobe Premiere CS3 and QuarkXPress 8 & 7; Macromedia Dreamweaver 8, Macromedia...
