Learning FileMaker Pro 10

Prices

Summary of Module 2

Chapter 11: Creating Scripts

Introduces students to the creation of scripts. Script commands covered include Enter Browse Mode, Go to Layout, Sort Records, Perform Find, Print Setup and Print. Students are shown how to set buttons to run scripts, duplicate scripts, edit scripts and print the script commands. The following printout is the result of one of the scripts:

Back to FileMaker Pro | Top | Next

Chapter 12: Totalling Items

Students are shown how to produce totals on number fields. The use of Summary Fields and the Trailing Grand Summary Part are introduced. The following layout is created:

Back to FileMaker Pro | Top | Previous | Next

Chapter 13: Displaying Sub-Totals

Students are shown how to create sub-totals on grouped data. This includes inserting Sub-Summary parts, duplicating Summary fields, sorting the data into the required order, duplicating layouts, editing Sub-Summary parts and creating scripts to automatically produce the required sub-totals. The following is one of the reports that is created:

Back to FileMaker Pro | Top | Previous | Next

Chapter 14: Looking Up Data From External Files

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

Back to FileMaker Pro | Top | Previous | Next

Chapter 15: Looking Up Data From Internal Files

Students are shown how to use multiple tables within the one database. Relationships between the tables are set and data looked up from internal tables. The invoice from the previous chapter is modified to look up data from an internal Customers table:

Back to FileMaker Pro | Top | Previous | Next

Chapter 16: Relational Databases

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

Back to FileMaker Pro | Top | Previous | Next

Chapter 17: Portals

The Departments layout from the previous chapter is modified to display data from the Products table in a Portal frame, which allows multiple records to be displayed. It covers creating the Portal, setting the Portal's size, formatting the Portal, editing the Portal and using the Portal.

Back to FileMaker Pro | Top | Previous | Next

Chapter 18: Sales Invoice Systems

This chapter provides activities that apply the relational database concepts developed in the previous 2 chapters to create a complete sales invoice system. It covers creating the relationships, preparing the invoice, completing calculations, popup lists, adding buttons and using the invoice. The following invoice is created:

Back to FileMaker Pro | Top | Previous | Next

Chapter 19: Reporting on Invoice Systems

Reports are created on the sales data produced from the Sales Invoice system developed in the previous chapter. One report shows the sales totals of each item that the company sells. A second report displays the monthly sales figures.

Back to FileMaker Pro | Top | Previous | Next

Chapter 20: Useful Features

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

Back to FileMaker Pro | Top | Previous

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