You have probably been using FileMaker Pro for a while, maintaining databases that other people have designed, and even designing some yourself. You may have created several databases to track information like contacts, inventory, or other information that you can't adequately manage using a spreadsheet or word processing application. However, you may be faced with a project where a single FileMaker database cannot handle the information you need to manage. For example, you may want to link customers with the purchases they make. If you have tried to place this information in a single database, you may have duplicated data unintentionally. In this course, you will use FileMaker Pro to create a system of integrated databases that can manage the information efficiently, and make it easy to alter the system as your needs change.

In addition, you may need to share your databases with other users on a network or even over the Internet. You will set up databases so that they can be accessed by someone in the same office, or by a customer using a Web browser.

Course Objective:

You will develop a system of automated inter-related databases, and you will share databases over a network or the Internet.

Target Student:

Office personnel who work with personal computers, who need to store and organize information for individual, workgroup, or company use, as well as for use by the public via the Internet. They have some FileMaker Pro experience, including completing the FileMaker Pro 6.0: Level 1 course.

Prerequisites:

Before taking this course, students should have completed the FileMaker Pro 6.0: Level 1 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 and pasting text, formatting type, etc. Finally, students should have basic knowledge of a Web design application or HTML.

Delivery Method:

Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Course duration

1 Day.

Hardware Requirements

• Mac OS X: An Apple G3 computer or higher (excluding G3 upgrade cards).
• Mac OS X: At least 128 MB of RAM.
• Mac OS: A Power Macintosh computer or higher.
• Mac OS: At least 32 MB of RAM.
• A CD-ROM drive.

• FileMaker Pro 6.0.
• Web space and FTP access to that space (for optional task)
• A Web design program or an HTML or text editor

• Mac OS version 8.6 through 9.2.2, or Mac OS X. However, at the time of this printing, Toolbars are not supported under Mac OS X.

Upon successful completion of this course, students will be able to:

• link databases with one-to-many and many-to-one data relationships.
• relate databases containing a theoretical many-to-many data relationship.
• create scripts to automate repetitive tasks, and will create buttons that execute scripts, switch layouts, or perform commands.
• set up databases for sharing over a network, and will define users, groups, and access privileges for those databases.
• publish a FileMaker Pro database on the World Wide Web.