In this introductory course, students learn how to create a new database, enter and edit new records, build input and output layouts, and use predefined layouts for mailing labels. Participants learn how to define a relationship between two files and use related information in a layout. Creating and using buttons and scripts to automate repetitive tasks are also covered. This course builds on knowledge acquired in the introductory course. The main focus is on understanding principles of relational databases and the use of advanced techniques for working with graphic and text objects.
Students learn how to write scripts that control the dynamics and interactions with a database.
Sharing and protecting a database and assigning different privileges to different groups of users is also covered. This course teaches students advanced FileMaker techniques for building complete database systems. Students learn how to use relational features including portals, conditional scripting, use of global fields, and how to prepare mail merge documents. Layout techniques such as changing the tab order, and defining non-printing objects are also covered.