R:BASE University - The Learning Center for R:BASE and R:BASE Related Products!

R:BASE eXtreme 9.1 for Non-Programmers

Schedule and Locations:

New locations to be announced...

Cost Per Attendee: $745.00

Training Style: Lecture (all attendees should bring their notebook computers)

Days: 2

Time: 9:00 AM - 5:00 PM

For reservations and/or questions, please call 1+724.733.0053 or send an email to training@rbase.com

Who Should Attend?

R:BASE eXtreme 9.x for Non-Programmers is intended for new and existing R:BASE users/developers who would like to get a better understanding of the R:BASE eXtreme 9.x for Windows Designers, command syntax, custom environment settings, and basic tips and tricks. This course is for those who are already comfortable in R:BASE and wish to evolve into understanding the many facets of R:BASE eXtreme 9.x.

Topics:

Introduction

Installation and Configuration
Default Directories
Default Settings
Customizing Personal Settings
Understanding the Configuration File

Understanding the R:BASE eXtreme 9.x Windows Environment

Understanding the Menu Bar

Database
Tools
Settings
Utilities
Window
Help

Understanding the Tool Bar

R:BASE Database Explorer
R:BASE Editor
R> Prompt
Browse/Edit Table
Query Builder
RBDefine
Application Designer
Codelock
File Gateway
Report Designer
Label Designer
Form Designer
Print Report/Label
Run a Form
Help

Understanding the Group Bar

Databases
Applications
Command Files
Tables
Views
Stored Procedures
Reports
Labels
Forms

Using the R:BASE and SQL Command Syntax

Reading Command Syntax
New and Enhanced Commands

PROPERTY
GETPROPERTY
PRINT
GATEWAY
CHOOSE
DIALOG
PAUSE

Understanding Plugins
Customizing CHOOSE, PAUSE, and DIALOG commands
Creating Command Files
Using Entry/Exit Procedures
Using R:BASE Functions

R:BASE Editor (RBEdit)

Editor Settings
- General
- String
- Display
- Color
Command File Analyzer (Structure)
Bookmarks
Watch Variables
Data Dictionary
Command Dictionary
Copy, Cut, Paste, Search, Replace
R:Style (Ctrl+Y)
- -ERROR- Messages
Exporting your command file to RTF and HTML Files

R> Prompt

Re-Sizable R> Prompt Window
Context Sensitive Syntax Help
Context Sensitive Command Paste
Result Window
Copying and Pasting Results
Command History
Customizing R> Prompt Settings
Data Dictionary
Saving and Managing Output Results
Running Command Files
Using Watch Variables

Understanding the Data Browser/Editor

Switching Modes
Search
Moving Column(s)
Show Column(s)
Hiding Column(s)
Refresh
Lock Columns
Change Column Font
Change Column Background Color
Sorting Data
Clear Sort
Zebra Stripes
Record Counter
Switching to Single Row mode
Displaying/Updating NOTE/VARCHAR/BLOB Data

Understanding the Query Builder

Creating New Queries
Modifying Existing Queries
SQL Window
Add Table(s)
Remove Table(s)
Selecting Column(s)
Removing Column(s)
Build SELECT Clause
Build WHERE Clause
Build ORDER BY Clause
View Results in Query Browser
Creating JOINs
Creating UNIONs

Understanding the Data Designer (RBDefine)

Data Wizard
Creating New Database
Adding Table(s)
Adding Column(s)
Adding Constraints
Modifying Existing Table(s)
Removing Column(s)
Removing Constraints
Defining Rules
Enabling Triggers

Understanding the Application Designer

Application Wizard
Creating Applications
Application Main Window
Caption
Icons
Background
Wallpaper
Images
Actions
Main Menu
Toolbar Drop-Down Menus
Toolbar
Designing Cool Applications

Understanding the Report Designer

Tool Bar
Standard Controls
Variable Controls
Database Controls
Advanced Controls
- Region
- CrossTab
- Sub-Report
- PCC Label
Object Tree
Data Tree
Standard
Format
Edit
Draw
Align or Space
Size
Nudge
Rulers
Grid Options
Displaying Data
Data Dictionary
Report Header
Report Footer
Page Header
Page Footer
Page Style
Breaks
- Break On:
- Data Field, Custom Field, Variable
- On Break Change
- Start New Page
- Reset Page Number
- New Page When Less Than ##
- Keep Break Together
- Reprint Break Header on Subsequent Pages
Orientation (Portrait, Landscape)
Cache Pages
Pass Setting (One Pass, Two Pass)
Units (Screen Pixels, Printer Pixels, Inches, Millimeters, Thousandths of MM)
Variables
- Add or Edit Variables
- List Expressions
Report Preview
- Whole Page
- Page Width
- 100%
- User Defined %
- Goto First Page
- Prior Page
- Next Page
- Last Page
- Goto xx Page
Print To
- Printer
- TXT File
- HTML File
- RTF File
- PDF File
- MS Excel File
- JPEG File
- GIF File
- BMP File
- EMF File
- WMF File
- File (Comma Delimited, Tab Delimited, Fixed Length)
- DIF File
- PNG File
- SVG File
- SYLK File
- WB1 File
- WK1 File
Using System Variables
- Date
- Date Time
- Document Name
- Print Date Time
- Page Count
- Page Set
- Page Set Desc
- Page No
- Page No Desc
- Time
Designing Sub Reports
Designing Reports with Title/Summary Pages
Designing CrossTab Reports
Designing Columnar Reports
Designing Reports with Watermarks
Designing Reports with Regions

Understanding the Label Designer

Label Templates
Tool Bar
Standard Components
Data Components
Advanced Components
Variables/Expressions
Object Tree
Data Tree
Format
Ruler
Grids
Displaying Data
Data Dictionary
Cache Pages
Pass Setting (One Pass, Two Pass)
Units (Screen Pixels, Printer Pixels, Inches,Millimeters, Thousandths of MM)
Label Preview
Print To
- TXT File
- HTML File
- RTF File
- PDF File
- MS Excel File
- JPEG File
- GIF File
- BMP File
- EMF File
- WMF File
- DIF File
- PNG File
- SVG File
- SYLK File
- WB1 File
- WK1 File
Designing Custom Mailing Labels
Designing Security Tags
Designing Employee Identity Cards
Designing Product Labels with Barcodes

Understanding the Form Designer

Menu Bar
Tool Bar
Wallpapers
Backgrounds
Standard Controls
Database Controls
Variable Controls
Additional Controls
Internet Controls
File System Controls
Legacy Controls
Form Properties
Object Properties
Table Settings
Variables/Expressions
Object List/Analyzer
Change Tab Order
Data Dictionary
Lock Control(s)
Custom Themes

Miscellaneous Topics

Upgrading to R:BASE eXtreme 9.x for Windows
- Databases
- Forms
- Reports
- Labels
- Views
- Command Files
- EEPs
- Applications
Do's and Don'ts