Call our Course Adviser hotline
RIGHT NOW on

COURSE TITLE:

Lotus Approach Training UK

LEVEL:

Introduction : Intermediate : Advanced

COURSE LENGTH:

1 day

COURSE PRICES:

• On Site Price, at your Home or Office: Click here for Special Rates
• Off Site available for closed groups of 4 or more - Contact Us for a quote or call now on 0870 041 2102 

*All prices quoted exclude VAT

COURSE OVERVIEW:

Approach is a database package from Lotus used to view data, query files and produce simple reports. Approach offers integration with Lotus Notes, making it an excellent tool for reporting on, analyzing, and updating Notes data. Users may connect to all data, whether it is stored in dBASE, DB2, Oracle, Lotus Notes or almost anywhere else.

The course outlines below set out the full range of topics you can choose to cover during your on-site training course, and you can build your course around your exact training requirements, or any specific projects you or your staff are working on at present.
You will find that this approach makes our courses the most effective and productive use of your training budget available today.

Introduction Level

Overview of Lotus Approach
What is a Database?
Components of a Database
Approach Files and Database Files
Browse Mode versus Design Mode Getting Started with Lotus Approach
Starting an Approach Session
The Opening Screen; Parts of the Approach Screen
Changing the Size of the Approach Window
Menus
Dialogue Boxes; Dialogue Box Elements
SmartIcons
Getting Help
Ending an Approach Session

Creating a New Database
Creating a New Blank Database
Data Types
Saving Approach Files
Closing Files
Opening Files
Entering and Editing Data
Completing Records; Moving around a Database
Editing Text; Deleting a Record
Spell Checking a Database

Working in Design Mode
Understanding Design Mode
The Tools Palette; Adding Fields to a Form
Selecting Objects; Moving and Sizing Objects
Undoing an Action; Info Boxes
Changing the Properties of an Object
The Form Properties Info Box
Aligning Objects
Changing Column Widths in Worksheets
Renaming a Form
Creating a Drop-Down List

Adding New Forms and Worksheets
Using the Form Assistant
Using the Worksheet Assistant
Previewing and Printing

Print Preview
Printing

Reports
Creating a Report

Intermediate Level

Overview of Lotus Approach
Database Concepts
Database Layout
Approach Files and Database files
Views and Databases
Working with a Window
Changing Views and Environments Working in Design Mode
Understanding Design Mode
The Tools Palette
Info Boxes
Changing Properties of an Object
The Form Properties Info Box
Aligning Objects
Renaming Forms
Creating Drop-Down Lists

Controlling Data Entry
Automatic Data Entry
Data Validation
Formulas

Finding Records
Finding
Entering Criteria
Finding Ranges

Advanced Level

Macros
Getting Started with Macros
Editing and Deleting Macros
Useful Macro Names
Running a Macro
Macro Buttons
Looping Macros
Conditional Macros Advanced Form Design
Adding Text to a Form
Adding Drawings to a Form
Adding Check Boxes to a Field
Adding Radio Buttons to a Field

Importing Files
Creating a Database from a Spreadsheet
Creating a Database from a Text File
Passwords
Approach File Passwords
Removing Passwords

Advanced Joins and Repeating Panels
Repeating Panels
Many to Many Relationships

Charts
The Chart Assistant
The Properties Box

Crosstabs
Creating a Crosstab
Adding Summaries to a Crosstab
Creating a Chart from a Crosstab

Web Publishing
Publishing a Database on a Web Page

BACK TO TOP