Super Bundle - V9 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

Alpha Five Web Applications Made Easy

The Basics and More for V8 & V9 Platinum

What's inside . . .

• Ch 1: Sensational System: How designing for the web with Alpha Five is unique.
• Ch 2: Marvelous Moves: Introduction to Web Components, the heart of the Alpha Five Application Server.
• Ch 3: Solid Security: Keep the bad guys out with the Application Server's security system.
• Ch 4: Amazing Attributes: The Web Application Control Panel is packed with feature after feature after feature.
• Ch 5 - 7: Grand Grids: Oh, the grand things you can do with Grid Web Components!
• Ch 8: Commanding Components: Creating lookups, linking grids, navigations systems and dialogs.
• Ch 9: Graphic Goodies: Using the built-in HTML editors to add style and images.
• Ch 10: Sexy SQL Secrets: Connect to your remote database and use Alpha Five's user friendly features at the same time.
• Ch 11: Exhilarating Xbasic: Use Alpha Five's programming language to enhance your application.
• Ch 12: Platinum Power: Read all about Asynchronous JavaScript and XML, otherwise know as AJAX, and how it gives Alpha Five increased responsiveness.
• Ch 13: Intelligent Internet Delivery: What you need to do to take the final steps of putting your application on-line.
• Ch 13: Helpful Hints: Lots of odds and ends that didn't fit elsewhere .

Added bonus: You'll love our exclusive Pick and Click charts that detail all the Web Component options.

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

Chapter 2: Marvelous Moves: Creating a web application

Chapter 3: Solid Security: Developing web application security

Chapter 10: Sexy SQL Secrets: Connecting to remote databases

The equipment you will need in order to use this book:

One of these Alpha Five programs installed on your computer.

V8: Professional or Enterprise Edition.
V9: Standard or Platinum Edition.

Information on purchasing the software may be found at www.alphasoftware.com.

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

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 Ediltion: Download book in PDF format.

Note: All formats contain working databases for exercises in the book.

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

 Alpha Five Made Easy

The Basics and More for V9 Platinum (and Standard) editions

What's inside . . .

• Everything you need to know about Databases and Tables
• How to set up Field Rules and Data Entry
• The principles of Sets and Mapped Tables
• How to create outstanding Forms and Browses
• How to wow your customers with Reports, Letters and Labels
• What you need to know about Operations
• Creating fancy and simple Buttons, Hyperlinks and Bubble Help
• How to Find, Sort and Filter your data
• Use Alpha Five for E-Mailing and Faxing and AlphaMailer for easy mass mailings
• Enhance your application with Checkboxes, Radio Buttons, Listboxes and Tree Controls
• Add outstanding Graphics to your database
• Use Action Scripting to point and click your way to Xbasic
• Get user input with Xdialog and create Custom Menus
• Use Alpha Five’s easy design features with SQL databases

Already have a previous version? Click here to find out  What’s New in the V9 Book

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

  Lesson 4:   Forms & Browses
  Lesson 5:   Reports
  Lesson 10: Images

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

All Hard Copies and Books on CD 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 Ediltion: Download book in PDF format.

All formats contain working databases for exercises in the book.

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