Learning FileMaker Pro 6.0

Prices

Summary of the Chapters

Module 1

Chapter 1: Introduction to Databases

Demonstrates how to set up a simple database, add records, edit records, delete records and print a standard form layout in columns. The following is an example of the database produced:

Back to FileMaker Pro | Top | Next

Chapter 2: Columnar Reports and Tables

This chapter demonstrates how to display data more effectively in columnar reports and tables. The following is an example of one of the reports created.

Back to FileMaker Pro | Top | Previous | Next

Chapter 3: Finding and Sorting Data

This chapter provides activities on how to sort data into alphabetical, numerical or chronological order, how to filter information and how to search for information. For example, one of the reports created shows books not yet received sorted in book title order.

Back to FileMaker Pro | Top | Previous | Next

Chapter 4: Creating Data Entry Forms

This chapter provides activities on how to create data entry forms. It includes how to insert fields, adjust field widths and positions, how to align fields and labels, how to change fields text and fill colours, how to insert graphics, add pop-up or menu lists and how to set the field entry order to produce forms similar to:

Back to FileMaker Pro | Top | Previous | Next

Chapter 5: Using Buttons

This chapter demonstrates how to create user-friendly databases that setup a database that someone can use without needed a detailed knowledge of FileMaker Pro. This is achieved through the use of buttons to open layouts and run commonly used commands. A tabbed interface is also created.

Back to FileMaker Pro | Top | Previous | Next

Chapter 6: Using Scripts

This chapter demonstrates the creation of scripts to record commonly used steps. For example, the following report is opened by a script and sorted into Subject Area order.

Back to FileMaker Pro | Top | Previous | Next

Module 2

Chapter 7: Layouts That Total Items

This chapter provides activities that show the user how to include sub-totals and grand totals in reports. It covers how to set groups so that sub-totals can be set and layouts formatted. The following diagram demonstrates one of the reports that is created.

Back to FileMaker Pro | Top | Previous | Next

Chapter 8: Looking up Data from Other Files

This chapter provides activities on how to lookup data from support files and insert that data into a parent file. The concepts of a relational database system introduced along with the use of repeating fields and setting value lists. The following invoice is created where data is looked up from a customers file and a stock list.

Back to FileMaker Pro | Top | Previous | Next

Chapter 9: Rational Databases

This chapter extends the use of relational database systems. It covers defining relationships, setting portals to display related file data, the different options available when relating files to one another and the advantages of relational database systems. The following layout is created and displays data from a Products database in a Departments database:

Back to FileMaker Pro | Top | Previous | Next

Chapter 10: Creating a Business Invoice System

This chapter provides activities that apply the relational database concepts developed on the previous chapter to create a complete business invoice system. It covers creating the relationships, preparing the invoice, completing calculations, inserting a company logo and enhancing the invoice system by creating reports, popup lists, adding buttons and using the invoice. The following invoice is created:

Back to FileMaker Pro | Top | Previous | Next

Chapter 11: Useful Features

This chapter demonstrates some of the useful tools that FileMaker Pro offers. For example, importing data from other sources, creating mailing labels, setting passwords, setting access privileges and user groups, and charting data.

Back to FileMaker Pro | Top | Previous

Home | Products | Prices | Ordering | Podcasts | Downloads | Contact