Microsoft Access 2007 for Environmental Professionals Training

Introduction to Managing Environmental Data with Microsoft Access 2007
Course ID: COMP-401 (Course 1 of 2 in a series)
December 9-10, 2009, 8:30 A.M. to 5:00 P.M. (2 Days)
Computer Classrooms in Seattle - Kirkland Computer Lab
Yarrow Bay Office Park - One North Building
10604 NE 38th Place, Suite 118
Kirkland, Washington
(425) 576-9747

Instructor: Michael Leech

This course is full. Please click on Waitlist Registration to be added to the waitlist.

Waitlist Registration | Directions | Accommodations | Course Catalog

Description:This course is designed for participants who wish to gain beginning to intermediate skills in using Microsoft Access 2007 to build relational databases for managing and mining their environmental data. This comprehensive class uses Access 2007 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 2007, Applying the Tools workshop, December 11, 2009. Participants may register for either course individually or both courses. A discount applies when registering for both courses. 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 2007 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 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.

Disability Accommodations: To request disability accommodations, please contact us at info@nwetc.org or (206) 762-1976 at least 30 days prior to the event.