FileMaker Pro 13 for beginners

This is a complete top to bottom course to learn database information management using FileMaker Pro for a beginner.

Created by: Vaughn Clement
Informations Systems Specialist

What Will I Learn?

• This FileMaker Developer Course contains 12 hours of instructional lessons and 65 lectures providing top to bottom use of FileMaker Pro 13
• you will learn the basics of database design and analysis
• you will be able to define the database design requirements
• you will be able to formulate a design cost and price proposal for your company or client
• you will learn the usage of the FileMaker Pro program interface to design and develop database information solutions
• you will learn hands on and lab techniques to design and develop working database projects
• you will create a project “FM Codebook” to gain a full working knowledge to build your own project design codebook for future projects
• you will learn how to use your database requirements to structure database tables
• Using the database tables you will create the individual objects in the table that will be used to enter data into screen layouts
• you will be able to set the table object types in the table setup to meet the design requirements
• ou will be able to set the layout style for the type of device that will use that screen size
• you will be able to set the layout theme for all objects and the screen elements
• you will be able to add scripts at the table level of any layout objects that require default scripting
• you will be able to edit field objects for formulas, calculations, optional input restrictions, and auto entry inputs
• you will learn how to set relational design links that are used between tables
• you will be able to define the settings of relational connections using the dialogs for editing relationships
• you will be able to using FileMaker create the relational database structure to make your solution functional
• you will be able to test the relational link design, and test for errors
• you will be able to diagnosis and correct link errors in the database structure
• you will be able to use the field scripting editor to develop scripts that control layout objects
• you will use the scripting language to add any required formatting, or calculation in tables at the layout design level
• you will be able to test layout scripts for errors and correct output errors
• you will be able to use the layout inspector to mange changes in the layout objects
• you will be able to use the field picker to add or edit layout objects
• you will learn the layout design capabilities used to build the user interface
• you will be able to work in the browse and layout modes to view and edit layouts
• you will be able to set headers, and footer on the layout
• you will using your database outline, organize the screens and layouts for navigation and custom buttons usage
• you will using labs, design layouts for the screens in the example projects
• using the RIDE (Rapid Interface Develop Engine) you will add drop down lists
• using the RIDE you will add off screen edit layouts for drop down lists for the iPhone and iPad
• using the RIDE lab you will add a layout tabbed interface
• using the RIDE lab you will add a popover element
• using the RIDE lab you will add content to Container fields
• using the RIDE lab you will add a popup menu
• using the RIDE lab you will add a guides and rulers
• using the RIDE lab you will add a tab controls
• using the RIDE lab you will add a portals
• using the RIDE lab you will add a insert, photos, images, and text in layouts
• using the RIDE lab you will add a picture slider in a layout
• using the RIDE lab you will add a charts from a table or chart in a layout
• using the RIDE lab you will learn about the menu builder
• you will use the program menus to format, add graphics, and other screen elements to enhance the quality of the layout design
• you will be able to add buttons and using the scripting screen add and edit scripts to make the buttons function
• you will be able to save the database as a copy, for a backup, or for redesign while keeping the original project
• you will be able to describe the full usage of the go to layout
• you will be able to describe the full usage of the table layouts
• you will be able to describe the full usage of the form layouts
• you will be able to describe the full usage of the find layouts
• you will be able to describe the full usage of the reports
• you will be able to describe the full usage of the Browse mode
• you will be able to describe the full usage of the menu designer
• you will be able to describe the full usage of the Layout mode
• you will be able to describe the full usage of the Find mode
• you will be able to describe the full usage of the Preview mode
• you will be able to find and use the program help to locate support, and scripting language help

Requirements

• A Mac or PC Windows Computer
• FileMaker Pro, or FileMaker Pro Advanced
• Optional iPhone or iPad
• Optional FileMaker Go, iPhone or iPad

Target audience

• Individuals who are starting a new career path.
• Consultants who want to learn database design
• Students who want to learn information management
• Teachers who want to add database design to the curriculum
• Current database designers who want to learn FileMaker Pro
• Individuals who are learning IT Data Management
• Employees in IT positions who want to add new capabilities in their firm
• Small and medium size businesses who want to develop solutions for their company