Approach Millennium Edition: Introduction

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.