Learning FileMaker Pro 7

Prices

Summary of Module 1

Chapter 1: Introduction to Databases

Introduces students to the value of a database by searching and sorting data to find information about students of a mythical school. Searches are carried out on numeric, text and multiple fields. The following prepared database is used:

Back to FileMaker Pro | Top | Next

Chapter 2: Creating a Database

Students are shown how to create a database about actors from scratch. This includes entering text and number fields, entering records, editing records, the different screen views available, formatting fields and printing the data. The following printout is created.

Back to FileMaker Pro | Top | Previous | Next

Chapter 3: Standard Form Layout

Students are shown how to display data using the Standard Form Layout. This includes selecting the fields to be included in the layout and the layout theme. The layout is formatted into columns, the size of the Body part adjusted, Header text inserted and formatted, and a page number inserted in the Footer part. The following layout is produced:

Back to FileMaker Pro | Top | Previous | Next

Chapter 4: Columnar Report Layouts

Students are shown how to create a columnar report. This includes selecting the fields and layout theme, sorting the data, adjusting the field widths in the layout, formatting the fields and field labels, adding a header and inserting a footer. The following layout is created:

Back to FileMaker Pro | Top | Previous | Next

Chapter 5: Creating a Data Entry Screen

Students are shown how to create a data entry screen from a blank layout. The field tool is used to insert fields onto the layout. The layout tools including the Graphics and Text Rulers, Page Margins, Ruler Lines, T-Squares and the Object Size Box are used to assist with the creation of the layout. The fields are then aligned, formatted and field borders turned on. The following layout is created:

Back to FileMaker Pro | Top | Previous | Next

Chapter 6: Formatting Layouts

In this chapter students format the data entry screen created in the previous chapter. This includes using the Drawing Tools to add shadings and effects to the layout, inserting images, formatting the fields with pop-up menus, radio buttons, drop-down calendars, and formatting field behaviours. The following data entry screen is produced.

Back to FileMaker Pro | Top | Previous | Next

Chapter 7: Using Buttons

Students are shown how to insert buttons to change the screen to a different layout or to run commands. Prepared graphics are used as buttons along with the Button Tool. Buttons are copied from one layout to another and set not to print. The following diagram shows the buttons that are added to a prepared data entry screen.

Back to FileMaker Pro | Top | Previous | Next

Chapter 8: Tabbed Interfaces

Students are shown how to use the buttons to add a tabbed interface to the data entry screen used in the previous chapter. Fields are added to each tab region and formatted using the Format Painter tool. The tabs are then formatted using the Drawing Tools. The following layout is created:

Back to FileMaker Pro | Top | Previous | Next

Chapter 9: Data Searching Tools

Students are shown how to do advanced searches on a database, This includes AND and OR searches, omitting records, finding blank entries, using range searches on numbers and dates, using wildcard characters and finding duplicate records. For example, the book acquisitions for a month are displayed:

Back to FileMaker Pro | Top | Previous | Next

Chapter 10: Calculation Fields

Students are shown how to do mathematical calculations on number fields, how to combine text fields together and how to do age calculations. For example, the following layout combines the Title and Author fields:

Back to FileMaker Pro | Top | Previous | Next

Project 1

The Multi-user version provides a detailed project about managing the rental properties for a real estate agency. All the data for the projects is provided.

Back to FileMaker Pro | Top | Previous | Summary of Module 2

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