Microsoft Access for Environmental Professionals Training

The Northwest Environmental Training Center presents:

Introduction to Managing Environmental Data with Microsoft Access
Course ID: COMP-401 (Course 1 of 2 in a series)
June 17-18, 2008, 8:30 A.M. to 5:00 P.M. (2 Days)
California State University - Sacramento
Solano Hall, Room 2001
6000 J Street
Sacramento, California

Instructor: Tom Sarriugarte

Register Online | Directions | Accommodations | Course Brochure PDF | Course Catalog

Description: This course is designed for participants who wish to gain beginning to intermediate skills in using Microsoft Access to build relational databases for managing and mining their environmental data. This comprehensive class uses Access 2003 to cover in-depth the use of Tables, Queries, Forms, Reports, and Macros 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 2 to 3 day class.

Course Topics:

Database Design Principles

Relational Database Concepts

Importing and Exporting Data

Creating Tables

Using Datasheets

Data Validation

Defining Table Relationships

Performing Simple Queries

Customizing Forms

Using Calculated Values

Parameter Queries

Using Action Queries

Creating and Using Forms

Creating and Using Reports

Designing Simples Macros

Database Security/Permissions

This course is part of a series and is immediately followed by the Managing Environmental Data With Microsoft Access, Applying the Tools workshop, June 19, 2008. Participants are encouraged to request both courses when registering. Courses begin each day at 8:30 A.M. and end at 5:00 P.M.

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

Prerequisites: No experience with MS Access is required; however, basic understanding of Microsoft Office software and basic computer skills are required.

Course Materials: Each participant 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: 1.3

Registration: $495 ($395* 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 the day prior to the event. Registration may occur up to the day prior to the event provided that space is available.