Overview
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.
You will develop a system of automated inter-related databases, and you will share databases over a network or the Internet.
Before taking this course, students should have completed the FileMaker Pro 7.0: Level 1 (Windows) 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, and so on. Finally, students should have basic knowledge of a Web design application or HTML.
The target student for this course is 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 7.0: Level 1 (Windows) course.
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
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 Objectives
Prerequisites
Target Student:
Platform Requirements
Hardware Requirements
Software Requirements
Performance-Based Objectives
Delivery Method:
Course duration
1 Day(s)
Course outline
Lesson 1: Defining One-to-Many and Many-to-One Data Relationships
Lesson 2: Setting Up a Many-to-Many Database Relationship
Lesson 3: Creating Buttons and Scripts
Lesson 4: Sharing FileMaker Pro Databases
Lesson 5: Creating a Database for the Web