| |
Lotus Approach Introductory Outline
Aims of the Two-Day Course
This course has been designed to give new or recent users, with no formal
training, the skills they need to produce their own database application,
view data, query files and produce simple reports. An introduction to
database theory and practice, plus hints and tips on good database design
techniques are also given. The course is 100% hands-on, with exercises
to practice the skills as you learn them.
Course Content
- Getting Started
- Database Basics
- Overview of Lotus Approach 97
- What is a Database?
- Components of a Database
- Approach Files and Database Files
- Browse Mode versus Design Mode
- Getting Started with Lotus Approach 97
- 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 and 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, 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
|
- Controlling Data Entry
- Automatic Data Entry
- Data Validation
- Formulas
- Sorting Records
- Sorting by a Single Field
- Sorting by More than One Field
- Finding Records
- Switching to Find Mode
- Criteria and Operators
- Examples of Find Criteria
- The Find Assistant
- Using AND/OR Criteria
- Redisplaying all Records
- Deleting a Found Set
- Adding New Forms and Worksheets
- Using the Form Assistant
- Using the Worksheet Assistant
- Joining Databases
- Joining Two Database Files
- Creating a Form Based on Joined Databases
- Previewing and Printing
- Reports
- Creating a Report; Report Panels
- Changing the Properties of a Column
- Form Letters
- Creating a Form Letter
- Creating Mailing Labels
|
Prerequisites
No previous experience of using Lotus Approach is necessary, although
keyboard and mouse experience is assumed. Familiarity with the use of
Windows software is essential.
Course Duration
Six hours (9.30am to 12.30pm and 1.30pm to 4.30pm).
Next Course
Advanced Level
Prices
|
