Applied Environmental Data Management with MS Access 2007 Training

The Northwest Environmental Training Center presents:

Managing Environmental Data With Microsoft Access 2007, Applying the Tools
Course ID: COMP-402 (Course 2 of 2 in a series)
August 27, 2009, 8:30 A.M. to 5:00 P.M. (1 Day)
ExecuTrain - Sacramento
1860 Howe Ave. Ste 250
Sacramento, CA 95825
(916) 641-0600

Instructor: Michael Leech

Registration | Directions | Accommodations | Course Brochure PDF | Course Catalog

Course Description: This is the second part of the Managing Environmental Data with Microsoft Access 2007 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 2007 workshop, August 25-26, 2009. 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 2007 .

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.