Download Entire Document
Quick Start
Introduction
Office - QB GUI
The Integrated Query Builder GUI
The Connections pane
Opening a Connection
The Main Toolbar
The Relations and other panes
The Columns pane
The SQL pane
Creating a QB - Project
Creating a Database Connection
The Data Browser
Creating and Saving a Query
Defining Relations and Joins
Selecting Fields and Defining Criteria
Using SQL functions
SQL Functions Reference
Concatenation To String
Masking Concatenated Fields
Aggregate functions
String functions
Numeric functions
Date Part functions
Date Name functions
Conversion To Char
Conversion To Number
Conversion To Date
Null Case function
Simple Case function
Defining SQL Manually
Running Query and the Result tab
Export and Printing
Storage and File Processing Support
Transferring Data Between Connections
Output to HTML or Mail Query
The Options dialog
Building custom query builders
Introduction to ELS-QB ActiveX component
ELS - QB FAQ
Technical Support