Skip Navigation Links
Training Exchange Logo
March 29, 2024
Search
Current Training

By Course Title
By Location
By Date
By Training Partner
By Delivery Method

Course Catalog
By Course Title
By Training Partner
By Delivery Method

Students

View Registrations/Transcripts
Edit Your Profile
Request Training

About Trainex
Overview
Contact Us
Help!

OLEM Training Coordination Team
Locate Team Members
Regional/State Training
Brochure

Other Training Resources
EPA
Other U.S. Government
Microsoft Access Part 2: Creating Efficient Workflows and Custom Tools
COMP-402
Hosted by Northwest Environmental Training Center

Access databases are more than just data tables. An Access database includes a collection of objects that all work together to perform specific tasks quickly and efficiently. By building on the knowledge gained in part one of this course, we will create highly efficient customized workflows that can reduce complex data processing and reporting tasks down to a single click.

This is the second course in a 2-part series. In "Introduction To Building Environmental Databases With Microsoft Access (COMP-401)", students learn the basic elements of constructing queries, forms, macros and reports. In this recommended third day, you will build on those skills by creating end-user application examples that bring the newly learned elements together. Access analytic tools, PivotCharts, and PivotTables will be introduced, and an SQL primer will be included. This course is separate from COMP-401 so that students may take it at a later date if you do not have flexibility in their schedule, however we highly recommend that the two courses be taken together. COMP-402 is not meant to be taken as a stand-alone class without first taking COMP-401.

**Please bring a personal laptop with Access 2010 (Access 2007 acceptable) a pen or pencil and paper if you prefer not to write in your manual. If you are not able to provide a laptop with Office (various types acceptable, 2010 preferred) we can provide one at a fee. Please contact us at 425-270-3274 to make arrangements two weeks prior to course.

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
For general information contact Ralph Fontaine by telephone at 425-270-3274 or via e-mail at rfontaine@nwetc.org

 Upcoming Events

 No upcoming events.


Previous Events (click to view/hide)
Bullet  Bennett, CO
  June 12, 2014 - June 12, 2014
Bullet  Anchorage, AK
  April 10, 2014 - April 10, 2014
Bullet  Sacramento, CA
  November 21, 2013 - November 21, 2013
Bullet  Austin, TX
  October 24, 2013 - October 24, 2013
Bullet  Aurora, CO
  August 8, 2013 - August 8, 2013
Bullet  Baton Rouge, LA
  July 18, 2013 - July 18, 2013
Bullet  Portland, OR
  June 6, 2013 - June 6, 2013
Bullet  Seattle, WA
  April 11, 2013 - April 11, 2013
Bullet  Sacramento, CA
  February 13, 2013 - February 13, 2013
Bullet  Helena, MT
  October 25, 2012 - October 25, 2012
Bullet  Honolulu, HI
  September 27, 2012 - September 27, 2012
Bullet  Atlanta, GA
  September 13, 2012 - September 13, 2012
Bullet  Portland, OR
  August 9, 2012 - August 9, 2012
Bullet  Albany, NY
  July 19, 2012 - July 19, 2012
Bullet  Austin, TX
  May 24, 2012 - May 24, 2012
Bullet  Anchorage, AK
  April 12, 2012 - April 12, 2012
Bullet  Seattle, WA
  March 8, 2012 - March 8, 2012
Bullet  Richmond, VA
  February 23, 2012 - February 23, 2012
Bullet  Sacramento, CA
  January 26, 2012 - January 26, 2012
Logo for USA.gov website