Approach Millennium Edition 9.5: Introduction

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

Prerequisites:

Windows 95: Introduction, Windows 98: Introduction, or Windows NT 4.0: Introduction or equivalent knowledge.

Target Student:

Students enrolling in this course should understand the fundamentals of working with Windows 95, Windows 98, or Windows NT 4.0.

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.

Benefits:

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

Hardware/Software Requirements:

You will need at least 8 megabytes (MB) of Random Access Memory (RAM) and 32 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.

Delivery Method:

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

What's Next:

Approach Millennium Edition 9.5: Introduction is the first course in this series. Approach Millennium Edition 9.5: Advanced, the next course in this series, teaches student how to import and export data, create forms and reports from joined databases, and change Approach preferences. Students who want to learn advanced features can take Approach Millennium Edition 9.5: Advanced.

New features covered in this series

Below is a table listing the new software features that are covered in ZD Education courseware:

New Feature	Introduction
SmartCenter	>X
Year 2000 date enhancements	>X
Find Assistant	>X
Enhanced Internet/intranet publishing	>X

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

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.