The Northwest Environmental Training Center presents:

Applied Environmental Database Design and Queries with Microsoft Access
Course ID: COMP-402 (Course 2 of 2 in a series)
March 20, 2008, 8:30 A.M. to 5:00 P.M. (1 Day)
Computer Classrooms In Seattle
Yarrow Bay Office Park - One North Building
10604 NE 38th Place, Suite 118
Kirkland, WA 98033

Instructor: Tom Sarriugarte

Register Online | Directions | Accommodations | Course Catalog
Course Description: This course provides participants with applied training in the environmental applications of Microsoft Access software. Through hands-on exercises, participants will delve into database design. Course participants will learn practical techniques for improving data storage, retrieval, and reporting. Participants will become more proficient with MS Access by applying their knowledge to complex and in-depth projects. This course is recommended for environmental professionals working with and managing environmental data with MS Access and beginners who have completed an introductory class such as COMP-401.

Course Topics:

Applied Query Functions

Form Controls

Customizing Controls

Building Reports from Calculated Queries
Working with Pivot Charts and Pivot Tables

Publishing Data on the Web

Designing Macros

Creating Switchboard Forms

Data Access Pages

This course is part of a series and is immediately preceded by the Introduction to Managing Environmental Data with Microsoft Access workshop, March 18, 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
- Create data Access pages
- Build multi-step macros for automating tasks

Prerequisites: Completion of COMP-401: Introduction to Managing Environmental Data with Microsoft Access, equivalent course work, or on the job experience is required.

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.

Register Online | Directions | Accommodations | Course Catalog

Northwest Environmental Training Center
A nonprofit 501(c)(3) program of the Northwest Environmental Education Council
650 S. Orcas Street, Suite 220 | Seattle, Washington 98108
Phone: (206)762-1976 | Fax: (206)762-1979
www.nwetc.org