Lotus Approach 97 Fundamentals

This course is intended for end users who want a fundamental understanding of the features and functionality of Lotus Approach 97 to create and modify a database; use forms; view and organize information; analyze data; create sub forms; produce and print reports; and utilize the Internet capabilities.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

This course is intended for end users who want to learn the fundamental capabilities of Approach. Participants should have taken Microsoft Windows 95 - Fundamentals (Course 70011).

Objective

• Identify the functions and elements of Approach 97.


• Join databases create charts and integrate data from other applications.


• Locate data in Approach 97 databases using the Find/Sort Assistant.


• Improve data entry by using forms and views and ensure data integrity.


• Identify the types of reports that can be generated in Approach 97.


• Create and modify reports.

Topics Include

Unit 1: Approach 97: An Introduction

• Identify the functions of Approach 97.
• Launch Approach 97 from the Windows 95 desktop.
• Match the elements of the Action Bar with their functions.
• Match the buttons in the Approach 97 StatusBar with their functions.
• Match the SmartIcons in Approach 97 with their functions.
• Identify the factors that determine the planning of a database.
• Match the database elements with their descriptions.
• Match the Approach field types with the type of data they accept.
• Create a database from the Welcome to Lotus Approach dialog box.
• Add a new record to a database from the Browse environment.
• Delete a record in a database from the Worksheet view of the Browse environment.
• Save a database from the Browse environment.

Unit 2: Joins Charts and Data Integration

• Join a database to another database.
• Create a many-to-many join between two databases.
• Create an alias join on a database.
• Create a chart from selected fields of a database.
• Edit the elements of a displayed chart.
• Display grid lines on a selected chart.
• Display chart series labels on a selected chart.
• Add a table to a selected chart.
• Import data from a 1-2-3 worksheet.
• Import data from a text file.
• Export data in a different file format.

Unit 3: Working with Data

• Match the find request SmartIcons with their functions.
• Match the find request containing wildcards with the search results.
• Search a database using the range find request.
• Locate records in a database using a multiple find request.
• Sort records in a database on one field.
• Create a find/sort using the Find/Sort Assistant dialog box.
• Edit a saved Find/Sort.
• Create a query.
• Add a condition to a query.
• Remove a condition from a Query.

Unit 4: Working with Forms and Views

• Create a form using the Form Assistant.
• Move an object in a form from the Design environment.
• Create a dialog box for a form.
• Add a field to a view.
• Remove a field in a view.
• Match the Default Value radio buttons with their functions.
• Match the Validation check boxes with their functions.

Unit 5: Presenting Data

• Match the Approach 97 report types with their descriptions.
• Create a standard report including selected fields of a database.
• Insert trailing information in the displayed report.
• Move a field of a report.
• Resize a field.
• Sort the data in a field.
• Group records of a column.
• Print the displayed report.
• Summarize records of a column.
• Create a Crosstab report.
• Interchange the contents of the Crosstab rows and columns.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media