User manual FILEMAKER PRO 9 TUTORIAL

[. . . ] FileMaker® Pro 9 Tutorial © 2001-2007 FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker is a trademark of FileMaker, Inc. , registered in the U. S. And other countries, and ScriptMaker and the file folder logo are trademarks of FileMaker, Inc. All other trademarks are the property of their respective owners. [. . . ] Enter a line space, then type President. Choose View menu > Browse Mode to see your personalized letter, ready to print, for every record in the database. See "Add a graphic to the layout" on page 29 to learn how to add a logo to the letterhead. 6. When you are finished with this lesson, close the file by choosing File menu > Close. 36 FileMaker Pro Tutorial Lesson 7 Simplifying data entry You can simplify the way you enter data in FileMaker Pro and improve accuracy by using value lists, calculation fields, and data auto-entry. Click in the large box and enter the values for this list, New and Continuing, by typing each value on its own line. 1 1 1 see how value lists can aid data entry write and test a calculation formula use a field's auto-entry options to automatically enter data Enter data using value lists Value lists let you choose the value you want from a scrolling list, a pop-up menu, checkboxes, or radio buttons. These lists can contain predefined values, or can be constructed dynamically based on the values in a particular field. They are an efficient way to enter frequently used values into your database. 8. Click OK to close the Edit Value List dialog box. Click OK to finish. A value list with predefined values, displayed as radio buttons Define a value list 1. Open the Tutorial folder on your hard drive. Choose Data Entry from the Layout pop-up menu if it is not already Assign a value list to a field and display it as radio buttons 1. Select the Membership info tab, if it is not already displayed. Select the Membership Type field. selected. 4. Choose File menu > Manage > Value Lists. Name the new value list by typing Membership Types. Choose Format menu > Field/Control > Setup. For Display as, choose Radio Button Set. 38 FileMaker Pro Tutorial 6. For Display values from, choose Membership Types. Select Radio Button Set The calculation formula uses values from the current record or related records. The formula can use values from all field types. You can use calculations to return text values (for example, combining the contents of first name and last name fields into a full name field), dates, times, timestamps, and the contents of container fields. Create a calculation field Members of the Corporate Travelers Club pay an annual fee. New members pay a fee of $200, while continuing members pay $100. The following calculation returns a membership renewal fee based on membership type. There are several ways of formulating a calculation, each of which can yield the correct result. [. . . ] Click OK. Create a custom privilege set Suppose your business relies on temporary staff at certain times of the year. This staff needs to have access to your data, but you want to prevent temporary employees from printing or exporting information in your database. You can create a specific privilege set for temporary staff that does not allow access to printing or exporting data. 1. Choose File menu > Manage > Accounts & Privileges. [. . . ]