The only difference between these two plug-ins is that the Local Companion is designed for accessing databases that reside on the same workstation as the client application (in this case, Excel), while the Remote Companion is used when the database system is on a different workstation. The first step in getting the log database ready for access by Microsoft Excel (where we’ll create our chart) is to turn on sharing via the Remote or Local Data Access Companion FileMaker Pro plug-ins. The scenario is that a database administrator wants to pull data from the Log.fp5 database in order to create meaningful charts and graphs of the records entered in the log.

Working files are included, allowing you to follow along with the author throughout the lessons.We’ll use the same “Darn Good Security System” solution to demonstrate a real world example of how you might want to access FileMaker Pro as a data source. Once you have completed this computer based training course, you will have a solid understanding of how to create your own database using FileMaker. Finally, you will learn about relationship techniques, such as using join tables and sorting related data, as well as deployment considerations, including single user systems and backups and file handling. This video tutorial will also cover how to add visual power, work with data, the fundamentals of database design, automation options, and calculation basics. Ray will then teach you how to build the interface, including using the layout tools, creating and formatting objects, and setting the tab order. You will start by learning about the new features in FileMaker Pro 13, then jump into covering important database concepts, preliminary data design, and the basics of data security. This course is designed for the absolute beginner, meaning no previous experience with FileMaker is required. This FileMaker Pro 13 training course from Infinite Skills teaches you the basics of managing your data using the FileMaker Pro database.

Filemaker pro tutorial 11