Lotus Approach Introduction
Course Aims
Lotus Approach is a relational database forming part of the SmartSuite office applications suite. This one day course is designed to allow trainees to get to grips with the basic features of Approach. Trainees 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.
Course Outline
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
Reports
Creating a Report
|
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 |
Target Audience
New, recent or intending users of Lotus Approach who have little or no existing database knowledge.
Assumed Knowledge
A working knowledge of PCs and Windows is assumed, gained from the workplace or by prior attendance on a "MS Windows User Introduction" course.
|
