What you’ll learn

Working with tables

• Creating tables
• Defining fields
• Auto-enter settings
• Calculated fields
• Container fields
• Looked-up value
• Data validation
• Defining repeating Fields

Working with records

• New, edit, delete records
• Defining search criteria
• Efficient search using search operators
• Omitting records
• Sorting records

Working with multiple tables

• Setting relationship amongst tables
• lookup data from another tables

Drawing Techniques

• Using different drawing tools
• Colorize objects and lines

Layout Setup

• Changing layout names
• Showing / hiding layouts
• Setting default view

Working with layouts

• Create reports for different devices
• Inserting fields
• Using Inspector
• Using Drop-down list / pop-up menu
• Using checkboxes and radio buttons
• Using drop-down calendar
• Setting data formats
• Text formattings
• Managing and aligning objects, fields and buttons
• Objects formattings
• Repeating fields

Advanced Layout Design

• Understanding and using Parts
• Working with the three basic parts
• Using leading grand summary
• Using trailing grand summary
• Using sub-summaries

Exchanging Information with other Applications

• Importing and exporting Excel data
• Exchanging data with other FileMaker Pro files