Microsoft Access for Environmental Professionals Training

The Northwest Environmental Training Center presents:

Introduction to Managing Environmental Data with Microsoft Access
Course ID: COMP-401 (Course 1 of 2 in a series)
November 12 - 13, 2008, 8:30 A.M. to 5:00 P.M. (2 Days)
Honolulu Community College
847 Dillingham Blvd.
Honolulu, HI 96817

Instructor: Tom Sarriugarte

Register Online | Directions | Accommodations | Course Brochure PDF | Course Catalog

Description:This course is designed for participants who wish to gain beginning to intermediate skills in using Microsoft Access to build relational databases for managing and mining their environmental data. This comprehensive class uses Access 2003 to cover in-depth the use of Tables, Queries, Forms, Reports, and Macros objects through extensive hands-on exercises. These Access database subjects are taught using real-world environmental examples with actual field data. This class is recommended for anyone desiring a concentrated exposure to Access training in a powerful 2 to 3 day class.

Course Topics:

Database Design Principles

Relational Database Concepts

Importing and Exporting Data

Creating Tables

Using Datasheets

Data Validation

Defining Table Relationships

Performing Simple Queries

Customizing Forms

Using Calculated Values

Parameter Queries

Using Action Queries

Creating and Using Forms

Creating and Using Reports

Designing Simples Macros

Database Security/Permissions

This course is part of a series and is immediately followed by the Applied Environmental Data Management With Microsoft Access workshop, November 14, 2008. Participants may register for either course individually or both courses. A discount applies when registering for both courses. Courses begin each day at 8:30 A.M. and end at 5:00 P.M.

After completing this course, participants will be able to:
- Understand concepts of database structure and design
- Create relationships between tables
- Import and export datasheets
- Perform simple queries on multiple tables
- Construct and customize forms for retrieving data
- Build macros for automating tasks

Prerequisites: No experience with MS Access is required; however, basic understanding of Microsoft Office software and basic computer skills are required.

Course Materials: Each participant will receive a binder containing the course proceedings (slides, exercises, and reference material)

What to Bring: Pen or pencil (and paper if you prefer not to write in your binder)

Continuing Education Units: 1.3

Registration: $495 ($395* for Native American Tribes; nonprofits; government agencies; students; and NAEP, NEBC, NWAEP members). An additional discount applies when registering for both COMP-401 and COMP-402. You may register online via the link below. You may also register via phone by calling the Northwest Environmental Training Center at (206)762-1976.

Cancellation Policy: Registration fees are fully refundable up to 30 days prior to the event and 50 percent refundable (or 100% credit) thereafter up to 3 business days prior to the event. No refunds are issued for cancellations occurring less than 3 business days before the start day. Course registration fees and cancellation policy are subject to change without notice.

Disability Accommodations: To request disability accommodations, please contact us at info@nwetc.org or (206) 762-1976 at least 30 days prior to the event.