


Lesson 14: Create and assign Accounts and Privileges to allow database administrators to manage accounts and assign appropriate levels of access to records, layouts, value lists, and scripts. Lesson 13: Create a special display called a portal, in which data will be shown from fields in related tables. File Options - Switch to Layout/Perform Script 44-45.Creating a Button to Execute a Script.Navigating to Specified Layouts using Buttons.Creating a Main Menu with Navigation Buttons 39.Automate tasks for opening and closing a file. Lesson 12: Create a new layout to allow a one-click navigation to other layouts and scripts. Build a report that summarizes and sorts data on a field and show sub-totals from a related field. Lesson 11: Create individualized form letters by merging fields from related tables. Boolean Find (Finding Multiple Requests).Lesson 10: Learn different methods for finding records, such as finding data in one field (simple find), multiple fields (Boolean Find), and excluding (omitting) records. Creating a Horizontal Dividing Line Between Groups of Layouts.Use Toolbars to provide quick access to many FileMaker Pro menu commands. Lesson 9: Create a new layout for labels and learn how to add visual enhancements to existing layouts, such as dividing lines and grouping similar layouts. Entering New Records / Modifying Records.Learn tips and techniques for adding and modifying records to speed data entry.

Lesson 8: Review relationships between Match Fields in different tables.
