FileMaker® Pro 9: Level 2 (Macintosh)
Course Specifications
Course number: 084285
Course length: 1.0 day(s)
Course Description
Course Objective: You will create a database model based on relationships between tables that hold data. You will automate tasks based on scripts and work with functions and data found in external data sources. In addition, you will publish your database on the web and provide utilitarian features to users.

Target Student: This course is for students who have some experience using FileMaker Pro and are aware that their need for managing data exceeds their current capabilities. In addition, this course is for the FileMaker Pro 9 user who needs to share databases with other users on a network or over the Internet.

Prerequisites: Before taking this course, students should have completed the FileMaker® Pro 9: Level 1 (Macintosh) course. In addition, they should be familiar with the basic functions of their computer’s operating system. Students should also have basic word processing skills, such as copying, pasting, and formatting text, and so on. 
Hardware Requirements
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configuration: 
•	PowerPC G3, G4, G5, or Intel-based Mac
•	256 MB RAM (512 MB RAM recommended)
•	Access to one of the following: a local CD-ROM drive, a local DVD drive, or access to a networked CD-ROM drive 
•	Mouse or other pointing device
•	VGA or higher video adapter and monitor
•	Network cards and cabling for local network access
•	Internet access (see your local network administrator)
•	Printer (optional)
•	Projection system to display the instructor's computer screen
Software Requirements
Each computer requires the following software:
•	Default Installation of FileMaker® Pro 9
•	Default installation of Microsoft® Office® 2008
•	Printer driver
•	MySQL Server Community Edition 5.0 or above
•	MySQL-Connector-ODBC version 3.51 or above
•	Adobe® Reader® 8.0 and above
Course Objectives
Upon successful completion of this course, students will be able to: 
•	create relationships between tables in a database file.
•	create buttons to perform tasks.
•	access data from external FileMaker sources or from an external database. 
•	enhance the layout of your database.
•	prepare and publish your database on the web.
•	follow some of the best practices to keep data safe and prevent information loss. 
Course Content
Lesson 1: Creating Relationships Between Databases

Topic 1A: Create Relationships 
Topic 1B: Access Data Using a Portal 
Topic 1C: Create a Lookup 
Topic 1D: Create a Relationship Using an Intermediate Table 
Topic 1E: Access Data from Related Tables 
Topic 1F: Summarize Related Data 
Topic 1G: Create a Value List 
Lesson 2: Creating Buttons

Topic 2A: Create Buttons to Execute Simple Tasks 
Topic 2B: Create Buttons to Execute Complex Tasks 
Topic 2C: Create Buttons to Execute Scripts 
Lesson 3: Sharing and Exchanging Data

Topic 3A: Share a Database with All Users on a Network 
Topic 3B: Share a Database Based on a Predefined Privilege Set 
Topic 3C: Share a Database Based on a Customized Privilege Set 
Topic 3D: Access Remote Data 
Topic 3E: Access Data from External Data Sources 
Lesson 4: Enhancing the Database Layout

Topic 4A: Add Tab Controls 
Topic 4B: Create a Layout Using Fields from Related Tables 
Topic 4C: Enhance the Layout 
Lesson 5: Publishing a Database on the Web

Topic 5A: Prepare a Database for Publishing 
Topic 5B: Publish a Database for the Web 
Topic 5C: Work with the Web Viewer Tool 
Lesson 6: Protecting Data

Topic 6A: Create a Backup of Database files 
Topic 6B: Maintain Data Security