The Northwest
Environmental Training Center presents:
Register Online | Course Brochure PDF (includes directions, hotel info, and registration form) | Directions | Accommodations
Applied
Environmental Database Design and Queries with Microsoft Access
Course ID: COMP-402 (Course 2 of 2 in a series)
June 14, 2007, 8:30 A.M. to 5:00 P.M. (1 Day)
New Horizons
2355 South Technology Drive
West Valley City, Utah (Salt Lake City area)
Instructor: Tom Sarriugarte
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, June 12 - 13, 2007. 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.
To find out more about NWETC's programs send us an email.
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