Approach Millennium Edition 9.5: Introduction

Course specifications

Course number: AME-L1-076-404

Software version number: 9.5

Course length: 1 day

Course description

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

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

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.

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

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.

 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.

New features covered in this series

Course content

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