major projects for IT training crown software and compter consultancy

Lotus Approach Intermediate

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 more advanced 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
Database Concepts
Database Layout
Approach Files and Database files
Views and Databases
Working with a Window
Changing Views and Environments

Working in Design Mode
Understanding Design Mode
The Tools Palette
Info Boxes
Changing Properties of an Object
The Form Properties Info Box
Aligning Objects
Renaming Forms
Creating Drop-Down Lists

Controlling Data Entry
Automatic Data Entry
Data Validation
Formulas

Finding Records
Finding
Entering Criteria
Finding Ranges
And/Or Conditions
Using the Find Assistant
Naming Found Sets
Sorting

Joining Databases
Joining Two Database Files
Creating a Form Based on Joined Databases

Form Letters
Creating a Form Letter
Creating Mailing Labels

Reports
Report Panels
Changing the Properties of a Column

Target Audience

Recent users of Lotus Approach who have a little knowledge and which to expand this further.

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.

IT training microsoft office lotus smartsuite

For further information e-mail:info@major-projects.co.uk
All site content is © Major Projects Limited | Website design is © Ambrow Limited