extra bits

database features p. 2

  • In addition to executing a Find with a single criterion, you can specify multiple criteria. You can search for records that satisfy any of the criteria (an Or search) or records that meet all criteria (an And search).

  • You can also perform a Find that locates records within a range, such as all people between the ages of 18 and 21.

flat file vs. relational p. 5

  • Conceptually, flat-file databases are much easier for new users to understand. While more powerful and flexible, learning to create relational databases has a much steeper learning curve.

  • The FileMaker database you'll make in this book is a simple relational one. For a flat-file database tutorial, see my previous book: Creating a Database in FileMaker Pro: Visual QuickProject. While written for FileMaker Pro 7, its database can also be constructed in FileMaker Pro 8.

about FileMaker Pro p. 6

  • A FileMaker layout can include as many or as few of the defined fields as you like. Think of a layout as simply one view into the database.

  • There is no requirement that a given field be included in any of a database's layouts. Some fields are intended only to be part of a calculation, for example.

  • The addition of simple scriptsoften only a single stepcan greatly enhance a database's ease of use. For example, you can create one-step scripts to switch to a particular layout, create a new record, delete the current record, or restore the database to a default sort order.

  • In FileMaker Pro, scripts can be executed by choosing the script name from the Scripts menu or by clicking a button to which the script has been attached. The first ten scripts in the Scripts menu can also be run by pressing a -key or -key combination.

  • Any FileMaker database can have a when opening or when closing script that automatically runs whenever the database is opened or closed.

Creating a Database in FileMaker Pro 8. Visual QuickProject Guide
Creating a Database in FileMaker Pro 8: Visual QuickProject Guide
ISBN: 0321414837
EAN: 2147483647
Year: 2005
Pages: 115

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net