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 Objectives
You will develop a system of automated inter-related databases, and you will share databases over a network or the Internet.
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.
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.
Performance-Based Objectives
- 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.
Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Platform Requirements
- Windows 98, Me, NT 4.0 (Service pack 6), Windows 2000, or Windows
XP. (Windows 98, NT 4.0, 2000, or XP required for Web Companion and ODBC features).
Hardware Requirements
- An Intel-compatible computer Pentium 90 or higher.
- At least 32 MB of RAM.
- A CD-ROM drive.
Software Requirements
- 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.
Course duration
1 Day(s)
Course outline
Lesson 1: Defining One-to-Many and Many-to-One Data Relationships
- Topic 1A: Define a Many-to-One Relationship
- Topic 1B: Display Related Information from
a “Many” Database
Lesson 2: Setting Up a Many-to-Many Database Relationship
- Topic 2A: Create an Intermediate Database
- Topic 2B: Access Data from a Related “Many” File
- Topic 2C: Summarize Related “Many”
Data
- Topic 2D: Control Addition or Deletion of
Related Records
- Topic 2E: Create Value Lists from Data in
Related Files
Lesson 3: Creating Buttons and Scripts
- Topic 3A: Create Buttons that Execute Commands
- Topic 3B: Create Scripts to Perform Complex
Tasks
- Topic 3C: Create Buttons to Execute Scripts
Lesson 4: Sharing FileMaker Pro Databases
- Topic 4A: Set Up a Database for Access by
Multiple Users
- Topic 4B: How to Control Access to a Database
Lesson 5: Creating a Database for the Web
- Topic 5A: Define Container and Global Fields
- Topic 5B: Enable the FileMaker Pro Web Companion
- Topic 5C: Determine the Look of a Published
Database
- Topic 5D: Create a Custom Home Page for a
Web-Enabled Database