Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: XChange Training UK

Filemaker Pro 6 or 7 Introduction to Creating Databases

Click here for more information or to take this course
XChange Training UK


  home  : Computer  : Databases and SQL

Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

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.

Training Avaliability and Delivery

Classroom instructionClassroom instruction
Contact XChange Training UK for more information
Course Level:intermediate
Schedule:1 days
Training Presented in:English

Related Keywords:  filemaker pro   training   introduction   uk training 

Training Program Details


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

About XChange Training UK - Training Provider

XChange Training UK - XChange Training offer bespoke and scheduled training in Adobe InDesign CS3 & CS2, Adobe Dreamweaver CS3, Adobe Illustrator CS3 & CS2, Adobe Photoshop CS3 & CS2, Adobe Flash CS3 & Flash ActionScript; Adobe Acrobat 8, 7 & 6 and Adobe Premiere CS3; QuarkXPress 7 & 6; Macromedia Dreamweaver 8, Macromedia Flash 8, Macromedia Freehand MX and Macromedia Studio 8; Maxon Cinema 4D; FileMaker Pro 9 & 8;...

More DTP skills for design and print Training from XChange Training UK

Click here for more information or to take this course
Custom Search

Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you a Filemaker pro training provider?
You could be on this page today - for FREE!