Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
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



 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
? Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy