 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Lotus Approach Millennium Edition Introduction
Course Aims
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. |
Assumed Knowledge
A working knowledge of PCs and Windows 95/98/NT is assumed, gained from the workplace or by prior attendance on a "MS Windows 95/98/NT User Introduction" course. |
Course Audience
New, recent or intending users of Lotus Approach who have little or no existing database knowledge. |
|
Table of Contents
|
Overview of Lotus Approach Millennium
|
Approach Files and Database Files
|
|
Browse Mode versus Design Mode
|
|
|
|
Getting Started with Lotus Approach Millennium
|
Starting an Approach Session
|
|
Parts of the Approach Screen
|
|
Changing the Size of the Approach Window
|
|
Ending an Approach Session
|
|
|
|
Creating a New Database
|
Creating a New Blank Database
|
|
|
|
Entering and Editing Data
|
Spell Checking a Database
|
|
|
|
Working in Design Mode
|
Understanding Design Mode
|
|
Moving and Sizing Objects
|
|
Changing the Properties of an Object
|
|
The Form Properties Info Box
|
|
Changing Column Widths in Worksheets
|
|
Creating a Drop-Down List
|
|
|
|
Controlling Data Entry
|
|
|
Sorting Records
|
Sorting Records by a Single Field
|
|
Sorting Records by More than One Field
|
|
|
|
Finding Records
|
Examples of Find Criteria
|
|
|
|
Adding New Forms and Worksheets
|
Using the Worksheet Assistant
|
|
|
|
Joining Databases
|
Joining Two Database Files
|
|
Creating a Form Based on Joined Databases
|
|
|
|
|
Previewing and Printing
|
|
|
Reports
|
Changing the Properties of a Column
|
|
|
|
|
Form Letters
|
|
|
|
|
