The Northwest Environmental Training Center presents:


Registration Form | Course Brochure PDF (includes directions, hotel info, and registration form) | Directions | Hotel Accommodations

Applied Environmental Database Design and Queries with Microsoft Access
Course No. COMP-402
August 10, 2006, 8:30 A.M. to 5:00 P.M. (1 Day)
Portland State University | Cramer Hall, Computer Lab CH01 | Portland, Oregon

Instructor: Michael Leech, Database Designer/GIS Analyst, Michael Leech Consulting

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 to improve 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

Linking Spatial Data (GIS) to Access Databases
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, August 8 - 9, 2006. Attendees may register for either course individually or both courses. A discount applies when registering for both courses. Courses will begin each day at 8:30 A.M. and end at 5:00 P.M.

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
- Link spatial data (GIS) to an Access database

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

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: $225. $185 for nonprofits; Native American Tribes; government employees; students; teachers; and NAEP, NWAEP, and NEBC members. A $50 discount applies when registering for both workshops in this series (COMP-401 and 402).

 

Registration Form | Course Brochure PDF (includes directions, hotel info, and registration form) | Directions | Hotel Accommodations
JOIN OUR MAILING LIST | REQUEST OR SUGGEST A TRAINING COURSE | OTHER PROGRAMS OF EOS ALLIANCE
Training Programs and Events | Business & Government Partners | Technical Resources | Financial Assistance | Other Programs | Employment & Volunteer Opportunities

To find out more about NWETC's programs send us email.

A 501(c)(3) non-profit program of EOS Alliance
650 S. Orcas Street, Suite 220 | Seattle, Washington 98108
Phone: (206)762-1976 | Fax: (206)762-1979
www.nwetc.org