Applied Environmental Data Management with MS Access Training

The Northwest Environmental Training Center presents:

Managing Environmental Data With Microsoft Access, Applying the Tools
Course ID: COMP-402 (Course 2 of 2 in a series)
Novemmber 14 , 2008, 8:30 A.M. to 5:00 P.M. (1 Days)
Honolulu Community College
847 Dillingham Blvd
Honolulu, HI 96817

This course is FULL
If you would like to be placed on the waiting list for this course, please call (206) 762-1976

Instructor: Jennifer Scheuerell

Directions | Accommodations | Course Catalog | Course Brochure (pdf)

Course Description: This is the second part of the Managing Environmental Data with Microsoft Access training class. In the first class, COMP-401, students learn the basic elements of constructing queries, forms, macros and reports. Now they build on and deepen those skills by creating end-user application examples that bring all of those newly learned elements together. In addition, the Access analytic tools PivotCharts and PivotTables are introduced and an SQL primer is included. Comp-402 is split out into a separate class to allow students flexibility in their scheduling and may be taken at a later date although it is highly recommended that the two class series be taken together. Comp-402 is not meant to be taken as a stand-alone class without taking Comp-401.

Course Topics:

Applied Query Functions

Form Controls

Customizing Controls

Building Reports from Calculated Queries

Working with Pivot Charts and Pivot Tables

Designing Macros

Creating Switchboard Forms

This course is part of a series and is immediately preceded by the Introduction to Managing Environmental Data with Microsoft Access workshop, November 12 - 13, 2008. Attendees may register for either course individually or both courses. A discount applies when registering for both courses.

After completing this course, participants will be able to:
- Apply complex query functions to databases
- Create and design pivot charts and pivot tables
- Perform complex queries using multiple tables
- Create tools for forms and reports
- Build multi-step macros for automating tasks

Prerequisites: Completion of COMP-401: Introduction to Managing Environmental Data with Microsoft Access.

Course Materials: Each attendee 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: 0.7

Registration: $250 ($195* 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.