Skip Navigation Links
Training Exchange Logo
March 28, 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 1: Introduction to Building Environmental Databases
Hosted by Northwest Environmental Training Center

A well designed database can increase the efficiency and can eliminate errors in your data storage protocols. By reducing redundancy, and eliminating the potential for human error, you can ensure that your data remains consistent and valid, and always up to date.

Access databases provide more than just a place to store your data. By creating a custom application that is specifically tailored to your project, an Access database creates the foundation through which you will quickly enter information, and more importantly, quickly retrieve answers to your questions about the data and build reports outlining the results.

This two day introductory course is designed for participants who wish to gain beginning to intermediate skills in using Microsoft Access to build relational databases for collecting, organizing, and analyzing their environmental data. It is applicable to anyone that manages environmental resources, sets or responds to environmental policy, or needs to evaluate regulatory compliance. This comprehensive class uses Access 2010 to cover in-depth the use of Tables, Queries, Forms, Reports, and Macro objects through extensive hands-on exercises. These Access database subjects are taught using real-world environmental examples with actual field data. This class is recommended for anyone desiring a concentrated exposure to Access training in a powerful two day class. For additional exposure, a recommended third day, "Creating Efficient Workflows and Custom Tools in Microsoft Access (COMP-402)" is also offered immediately following this course.

After completing this course, participants will be able to:

  • Understand concepts of database structure and design
  • Create relationships between tables
  • Import and export datasheets
  • Perform simple queries on multiple tables
  • Construct and customize forms for retrieving data
  • Build 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 10, 2014 - June 11, 2014
Bullet  Anchorage, AK
  April 8, 2014 - April 9, 2014
Bullet  Austin, TX
  October 22, 2013 - October 23, 2013
Bullet  Bellingham, WA
  March 25, 2009 - March 26, 2009
Bullet  Honolulu, HI
  November 12, 2008 - November 13, 2008
Bullet  Sacramento, CA
  June 10, 2008 - June 11, 2008
Bullet  San Francisco, CA
  April 22, 2008 - April 23, 2008
Bullet  Kirkland, WA
  March 18, 2008 - March 19, 2008
Logo for USA.gov website