Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training          Email Us   Phone :
Contact Us   -   About Us   -   Clients    
Loading
Courses
A+
ADA
Adobe
AJAX
Android
Apache
AutoCAD
Business Analysis
Business Objects
Business Skills and Technology
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CORBA
Corel
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Legato
Lotus
Macintosh
Mainframe programming
Microsoft technologies
MS Access
MultiMedia and design
.NET
Network+
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Development
Professional Soft Skills Workshops
Project Management
Quality Center/Quick Test
Rational
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software Engineering
Software quality and testing
SQL Server
Sybase
Telecommunications
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
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 © 2012 Wintrac Inc.