Lotus Approach

Lotus Approach Millennium Edition

Lotus Approach Millennium Edition is a relational database forming part of the SmartSuite office applications suite. This course is designed to allow readers to get to grips with the basic features of Approach. Readers will be able to create databases; view data, design data queries and produce reports. The course also provides an introduction to database theory and practice, plus hints and tips on good database design techniques.

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.

Benefits
This 2 day course is designed to introduce the fundamentals of the package and to help you quickly achieve a reasonable level of productivity
Students will gain a practical knowledge on how to design, create and maintain databases, and produce meaningful reports.

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

This seminar is designed for beginning users planning on working with an Approach database.

Overview: Students will learn the basic skills necessary to begin using Approach so they can design and create a basic database-management system.

Topics covered include:
Introduction to Databases
Introduction to Database Concepts and Terminology
An Overview of Approach
Creating a Database
Database Design Concepts
Creating and Saving a Database Structure
Adding Records and Observing Files
Modifying Forms, Worksheets, & Databases
Adding a Form to an Approach File
Renaming and Adding Fields
Creating Calculated Fields
Deleting Fields
Managing Records in a Database
Find Records
The Find Assistant
Sorting, Adding, and Deleting Records
Additional Data Management Techniques
Using Operators
Using And and Or Conditions
Creating and Modifying Reports
Columnar Reports
Reports with Groups
Printing Enhancements
Enhanced Form Design
Data-verification Techniques
Display and Tab-order Enhancements
Introduction to Managing Multiple Databases
Database Design Techniques
Creating Multiple Database Forms
Prerequisites: Students enrolling in this course should have taken Windows 95 �Introduction (or higher) or have equivalent knowledge.

Pages:- 1 2
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>