The Northwest
Environmental Training Center presents:
Course
Brochure PDF (includes directions, hotel info, and registration form)
| Directions
| Accommodations
Applied
Environmental Database Design and Queries with Microsoft Access
Course No. COMP-402
September
28, 2006, 8:30 A.M. to 5:00 P.M. (1 Day)
ExecuTrain
of Sacramento
2901 K Street, Suite 450
Sacramento, California
This class is full as of September 20, 2006. Please contact us if you'd like to be added to the waiting list, or be informed of future class offerings.
Instructor:
Michael Leech, Database Designer/GIS Analyst, Michael Leech Consulting
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
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,
September 26 - 27, 2006. 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
- 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 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 AFS and NAEP
members). 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.
To find out more about NWETC's programs please
call us at (206)762-1976 or send
us email
Northwest
Environmental Training Center
A 501(c)(3) nonprofit program of EOS Alliance
650 S. Orcas Street, Suite 220 | Seattle, Washington 98108 | Main: 206-762-1976
| Fax: 206-762-1979
| www.nwetc.org
