Home   |   Instructor-led Training   |   Self-Paced Learning                Email Us   Phone :
Contact Us   -   About Us          
 
Courses
A+
ADA
Adobe
AJAX
AutoCAD
Business Skills and Technology
C++ programming
Cisco
Citrix
Cognos
ColdFusion
COM/COM+
CORBA
Corel
Crystal Reports
Data Mining
DB2
Desktop Application Software
Enterprise Architecture
ITIL
Java
JBoss
Legato
Lotus
Macintosh
Mainframe programming
Microsoft / MCT
MS Access
MultiMedia and design
.NET
Network+
Object oriented analysis and design
OpenVMS
Oracle
Perl
PHP
PowerBuilder
Professional Development
Professional Soft Skills Workshops
Project Management
Rational
SAS
Security
SharePoint
SOA
SQL Server
Telecommunications
Tivoli
Unix/Linux/Solaris/AIX/HP-UX
Visual Basic
Visual Foxpro
VMware
Web 2.0
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Approach Millennium Edition 9.5: Advanced
Overview:

Students will learn how to manipulate multiple databases, create crosstabs and charts to summarize data, create macros, and customize the Approach environment.

Prerequisites:

Approach Millennium Edition 9.5: Introduction or equivalent knowledge.

Benefits:

Students will learn how to manipulate multiple databases by using some of the advanced features in Approach Millennium Edition 9.5.

Target Student:

Students enrolling in this course should understand introductory Approach Millennium Edition database concepts.

Performance-Based Objectives:

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • Define databases and add data to them by using templates and by importing and exporting data.
  • Explore the Approach Preferences settings, and identify and solve common data problems by applying the concepts of data normalization.
  • Create forms based on multiple databases by using a repeating panel.
  • Display data from multiple databases by creating repeating panel reports.
  • Analyze and evaluate the information in databases by creating worksheets, crosstabs, and charts.
  • Create form letters and generate mailing labels from databases.
  • Use existing macros like templates to create new macros, and create decision-making macros by using the If function.
  • Personalize the Approach environment by displaying a customized set of SmartIcons and creating a custom menu.
Hardware/Software Requirements:

You will need 8 megabytes (MB) of Random Access Memory (RAM) (16 MB is recommended) and 32 MB of hard-disk space for default installation in an IBM PC or fully compatible personal computer with a speed of 80486/50 MHz or higher, a hard drive, and a 3.5" high-density disk drive. Printers are not required, although you need an installed printer driver to use Print Preview. You will also need Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows NT 4.0, as well as Lotus SmartSuite Millennium Edition Release 9.5. See your reference manual for hardware considerations that apply to your specific hardware setup.

Delivery Method:

Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Course duration:

1 Day(s)

Course outline:

Lesson 1: Copying, Importing, and Exporting Data
  • Using an Existing Approach File to Create a Database
  • Importing Files
  • Exporting Files
Lesson 2: Managing Multiple Databases
  • Exploring Approach Preferences
  • Data Normalization
  • Analyzing Database Relationships
  • Joining Databases
Lesson 3: Advanced Form Design
  • Repeating Panel Forms
  • Form Enhancements
Lesson 4: Advanced Report Design
  • Repeating Panel Reports
  • PowerClick Reporting
Lesson 5: Analyzing Data
  • Creating Worksheets and Crosstabs
  • Charting Data
Lesson 6: Form Letters and Mailing Labels
  • Creating a Form Letter
  • Creating Mailing Labels
Lesson 7: Creating and Using Macros
  • Creating and Using a Macro
  • Modifying Macros
  • Creating a Looping Macro
  • Attaching Macros
Lesson 8: Customization
  • Customizing the SmartIcons
  • Customizing Menus
Appendix A: An Overview of LotusScript



Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.