Hard Copy - Func Hbk (v5 & later) - Desktop & Web

Alpha Five Functions Handbook

Functions and Expressions Made Easy

What's inside . . . 

Ch 1: The Basics
Once understood, most common functions are easy to use. Expressions can define calculations or combine fields with text, always following a consistent format throughout the program.

Ch 2: Character Functions
From changing the case of a letter to creating expressions for importing data, character type functions can manipulate both simple and complex data.

Ch 3: Date and Time Functions
Dates can be formatted in a variety of styles. One date subtracted from another, results in the number of days between the two. You can also calculate the time worked by an employee or show the duration of time of sporting event.

Ch 4: Numeric Functions
From simple arithmetic to advanced calculations, numeric functions give superior results.

Ch 5: Functions for Filtering and Ordering Records
Whether locating a single record within tens of thousands or printing a monthly sales report, filtering is at the heart of your application design.

Ch 6: Summary and Report Functions
Totals, averages, counts and other summaries will have your reports telling the whole story for you and your clients.

Ch 7: Lookup Function
The Lookup function requires more documentation than other functions because the syntax can be hard to understand. After doing the exercise and reading the principles behind its setup, just use the worksheet at the end of the chapter and you'll easily add lookups to your application!

Many thanks to Frances Peake for her assistance with this chapter.

Ch 8: Table Information
You can return the name of the table, the record number and other information about fields and tables.

Ch 9: Master Chart
When you know the name of the function, come here for quick reference to the syntax.

Book Specifications:
Size: 8 1/2 X 11
No of pages: 196
Cover: Heavy duty laminate.
Binding: Spiral Binding

 Check out the Table of Contents and List of Syntax Charts and then take a look at some sample pages . . .

Ch 2: Character Functions and sample syntax chart

All hard copies of our books have a 30-day Money Back Guarantee

This book is available in 3 formats:

Hard Copy: Contains spiral bound, full color copy of the book, Book on CD and Electronic Download Edition.

Book on CD: Contains book in PDF format.

Electronic Download Edition: Download book in PDF format.

All formats contain working databases for exercises in the book.

 Save on Combos & Bundles - see Author's Choices below