Please note the price listed above is for groups
This course is for the 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 that needs to share databases with other users on a network or over the Internet.
Before taking this course, students should have completed the FileMaker Pro 9: 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, pasting, and formatting text, and so on.
Course Completion Skills:
Create relationships between tables in a database file.
- Create buttons to perform tasks.
- Access data from external filemaker sources or files found in 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.
Lesson 1 Creating Relationships Between Databases
Access Data Using a Portal
Create a Lookup
Create a Relationship Using an Intermediate Table
Access Data from Related Tables
Summarize Related Data
Create a Value List
Lesson 2 Creating Buttons
Create Buttons to Execute Simple Tasks
Create Buttons to Execute Complex Tasks
Create Buttons to Execute Scripts
Lesson 3 Sharing and Exchanging Data
Share a Database with All Users on a Network
Share a Database Based on a Predefined Privilege Set
Share a Database Based on a Customized Privilege Set
Access Remote Data
Access Data from External Data Sources
Lesson 4 Enhancing the Database Layout
Add Tab Control
Create a Layout Using Fields from Related Tables
Enhance the Layout
Lesson 5 Publishing a Database on the Web
Prepare a Database for Publishing
Publish a Database for the Web
Work with the Web Viewer Tool
Lesson 6 Protecting Data
Create Backup of Database files
Maintain Data Security