BN.com Gift Guide

FileMaker Pro 5/5.5 Advanced for Windows and Macintosh: Visual QuickPro Guide

Overview

FileMaker Pro 5/5.5 for Windows and Macintosh: Visual QuickPro Guide is designed for intermediate to advanced database users and developers who want to break through to the next level of FileMaker. This Visual QuickPro Guide takes you from working with records and files to creating and designing databases, printing and networking, Web publishing and more. Some of the topics covered in this book include creating data reports and relationships, calculation fields, working with conditional script steps, script ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (5) from $1.99   
  • New (1) from $150.42   
  • Used (4) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$150.42
Seller since 2008

Feedback rating:

(196)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New

Ships from: Chicago, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

FileMaker Pro 5/5.5 for Windows and Macintosh: Visual QuickPro Guide is designed for intermediate to advanced database users and developers who want to break through to the next level of FileMaker. This Visual QuickPro Guide takes you from working with records and files to creating and designing databases, printing and networking, Web publishing and more. Some of the topics covered in this book include creating data reports and relationships, calculation fields, working with conditional script steps, script troubleshooting, FileMaker and third-party software, and creating multi-user files on a single network.
Read More Show Less

Product Details

  • ISBN-13: 9780201787269
  • Publisher: Pearson Education
  • Publication date: 12/1/1901
  • Series: Visual QuickPro Series
  • Pages: 500
  • Product dimensions: 7.08 (w) x 9.00 (h) x 0.91 (d)

Table of Contents

1. About FileMaker Pro 5.0.
FileMaker 5.0: Highlights of New Features. FileMaker 5.0 Editions. About Upgrading to FileMaker 5.0. Using This Book.

2.Organizing Data Efficiently.
About Relational Databases. Gathering Information. Creating a Field List. Developing a Data Structure Strategy. Creating a Data Structure Chart. Field Design Tactics. Implementing Relationships. Testing Your Database.

3. Layout Enhancements.
Usability, Legibility, and Logical Grouping. Cross-Platform Issues. Using Graphic Text. Formatting Elements as Buttons. Reusing Graphics. Entering Data in a Standard Layout. Creating and Formatting Value Lists. Validating Formats with Value Lists. Working with Conditional Value Lists. Using Calculated Field Labels. Creating Field Masks. Copying Layouts.

4. Calculation Fields.
Merging Fields Using Calculations. Formatting Labels or Envelopes. Formatting Form Letter Modules. Augmenting a Form Letter.

5. Creating Data Reports.
Using Search Operators. Creating an “Inverted” Search. Creating Summary Layout Parts. Using Counts and Averages. Creating Running Totals. Creating Sub-summary Reports. Sorting Data for Sub-summary Reports. Exporting Summary Data.

6. Creating Relationships.
About Relationships. Creating a Match Field in a Master File. Lookup vs. Related Fields. Using a Match Field to Choose a Related Record.Using Calculated Match Fields. Field Formatting with a Calculated Match Field. About Repeating vs. Related Fields. About Portals. Sorting Data in Portals. Summarizing Related Data. About Self-Relationships. Using a Portal for Navigation. Searching for Self-Relationship Data. Creating a Lookup with a Self-Relationship.

7. Creating Simple Scripts.
Planning a Simple Script. Storing Settings Before Scripting. Using ScriptMaker. Creating a Basic Script. Creating Sub-scripts. Combining Sub-scripts. Retaining Multiple Settings in a Script. Using Sub-scripts for Multiple Export Settings. Adding Comments to a Script. Using External Scripts.

8. Working with Conditional Script Steps.
About Conditional Steps. Using the If Command. Using If with Else. About Status Functions. Using Status Functions with If Steps. Using Loop in a Script. Using Counters to Control Loops. Controlling Scripts with User Input. Customizing Documents with If Steps.

9. Extending the Interface with Scripts.
Making a Find Layout with a Script. Creating Script Buttons. Deleting Records in a Related File. Creating a Main Menu Layout. Linking to the Main Menu. Running Scripts from Fields. Creating Interactive Error Messages.

10. Script Troubleshooting.
Testing Finished Scripts. Fixing Typical Errors. Creating an Error Trap Script. Debugging Scripts. Printing Scripts. Changing and Adapting Scripts.

11. FileMaker and Other Programs.
Using Scripts to Send Email. Using Scripts to Send Bulk Email. Using a Script to Open URLs. Exporting Data to Static HTML Tables. Exporting Formatted Text. Using Excel Data in FileMaker. Working with ODBC. Sharing Databases Using ODBC. Using AppleScript with FileMaker Scripting.

12. Data Importing and Repairing.
Migrating to FileMaker 5.0. Importing Data from Other Sources. Cleaning Up Text Data Before Importing. Finding and Eliminating Duplicates. Importing Data without Duplications. Troubleshooting Problem Data. Replacing Inconsistent Formatting. Separating Parts of Data.

13. Multi-User Files on a Network.
Setting Network Protocols. Setting Up Multi-User Files. Hiding Related Files. Creating an Opening Script. Accessing Databases Over the Internet. Testing Scripts for Access Problems.

14. Using FileMaker Pro Server.
Hosting Files on FileMaker Server. Optimizing Server Settings. Setting Up a Usage Log. Managing Server Remotely.

15. Web Publishing.
Instant Web Publishing. Configuring Databases for Web Access. Choosing a Layout Style. Tracking Activity and Access. Accessing a File with a Browser. Enabling Remote Administration. Restricting Database Access. Creating a Custom Home Page. Creating a Guest Book. Testing Your Web Database. About Custom Web Publishing. Setting Up Custom Web Publishing. Creating a Template Format File. Prompting User Input with CDML. Providing Visitor Feedback. Searching for Data with CDML. Editing Data with CDML. Browsing Records. Using the Web Security Database. XML and JDBC. FM Developer's Edition.

16. FileMaker 5.5 Applications and OS Additions.
FileMaker Pro 5.5: Highlights of New Features. FileMaker Pro Server 5.5: Highlights of New Features. FileMaker DE 5.5: Highlights of New Features.

17. Using FileMaker 5.5 's New Features.
Validating by Number of Characters. Using GetField. Updating Auto-Entry Serial Numbers. Disabling Toolbars. Creating Interactive Buttons. Restricting Access Privileges. Changing Password Access.

18. Importing and Connecting.
Import from Excel Ranges. About Improved Script Importing. Importing with Scripts. Setting the Next Auto-Entry Serial Number. Using Relative Paths. Using FileMaker Mobile. About FM5.5's ODBC Functions. Storing SQL Commands in Fields. Using Calculations to Build Complex Queries. Creating Dynamic SQL Queries.

19. Web Publishing with FileMaker 5.5.
Suppressing Built-In Navigation in IWP. Creating Web Layouts. Creating a Web-Based Find Script. Switching Layouts with a Script. Web Display Considerations.

Appendix A: FileMaker and Third-Party Software.
Appendix B: FileMaker Resources.
Index.
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)