 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Lotus Approach 97 Introduction
Course Aims
Approach 97 for Windows 95/98 is a database from Lotus designed specifically for graphical Smartsuite products. This course is designed to teach the essential skills required to start using Approach to a level of competence sufficient for readers to produce their own database application; to be able to 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. |
Assumed Knowledge
A working knowledge of PCs and Windows 95 is assumed, gained from the workplace or by prior attendance on a "MS Windows 95 User Introduction" course. |
Course Audience
New, recent or intending users of Lotus Approach 97 who have little or no existing database knowledge. |
|
Table of Contents
|
Overview of Lotus Approach 97
|
Approach Files and Database Files
|
|
Browse Mode versus Design Mode
|
|
|
|
Getting Started with Lotus Approach 97
|
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
|
|
Closing and Opening Files
|
|
|
|
Entering and Editing Data
|
Spell Checking a Database
|
|
|
|
Working in design Mode
|
Understanding Design Mode
|
|
Selecting, 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 by a Single Field
|
|
Sorting 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
|
Creating a Report; Report Panels
|
|
Changing the Properties of a Column
|
|
|
|
|
Form Letters
|
|
|
|
|
