This course is provided by Wintrac.
Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on
Desktop Application Software training,
E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
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
