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: Introduction
Overview

Students will learn the basic skills necessary to begin using Approach so they can design and create a basic database-management system.

Benefits

Students will learn how to design and create a basic database-management system that includes forms, worksheets, and reports. They will also learn how to find specific records within a database and how to join multiple databases.

Prerequisites

Windows 95: Introduction or equivalent knowledge.

Target Student:

Students enrolling in this course should understand the fundamentals of working with Windows 95.

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:

  • Demonstrate an understanding of database concepts by using database terminology and identifying the components of an Approach database.
  • Apply database design principles by creating a database and inputting data.
  • Modify forms, worksheets, and databases by adding, moving, and deleting fields.
  • Find specific records or groups of records by using Approach to sort and locate data.
  • Manage data by using search criteria such as operators and conditions.
  • List, group, and summarize data by creating and modifying reports.
  • Enhance forms by applying data-validation techniques, moving objects, and adding macro buttons and graphics.
  • Manage multiple databases by applying database design principles and joining multiple databases.
Delivery Method:

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

Course duration

1 Day(s)

Course outline

Lesson 1: Introduction to databases

  • Introduction to database concepts and terminology
  • An overview of Approach

Lesson 2: Creating a database

  • Database design concepts
  • Creating and saving a database structure
  • Adding records and observing the files

Lesson 3: Modifying forms, worksheets, and databases

  • Adding a form to an Approach file
  • Renaming and adding fields
  • Creating calculated fields
  • Deleting fields

Lesson 4: Managing records in a database

  • Finding records
  • The Find Assistant
  • Sorting, adding, and deleting records

Lesson 5: Additional data-management techniques

  • Using operators
  • Using And and Or conditions

Lesson 6: Creating and modifying reports

  • Columnar reports
  • Reports with groups
  • Printing enhancements

Lesson 7: Enhanced form design

  • Data-verification techniques
  • Display and tab-order enhancements

Lesson 8: Introduction to managing multiple databases

  • Database design techniques
  • Creating multiple database forms

Appendix A: Database file types

Appendix B: Using the Internet in Approach

Hardware/Software Requirements

You will need 8 megabytes (MB) of Random Access Memory (RAM) and 30 MB of hard-disk space if you are using Approach. See your reference manual for hardware considerations that apply to your specific hardware setup.

In addition, you will need printers if you want to print the views created in the course.


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.