Access logoCourse ID: COMP-401 (Course 1 of 2 in a series)
May 25-26, 8:30 A.M. to 5:00 P.M.
Wingate by Wyndham - Denver Tech Center
8000 E Peakview Ave
Greenwood Village, CO 80111

Instructor: Adam Wilbert
Description: Participants will gain basic to intermediate skills in using Microsoft Access 2007 to build relational databases for managing and mining their environmental data. This comprehensive class uses extensive hands-on exercises for in-depth use of tables, queries, forms, reports, and macro objects in Access 2007. These Access database subjects use real-world environmental examples with actual field data. This class is recommended for anyone desiring concentrated exposure to Access training.
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, May 27, 2010. Participants may register for this course individually or 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) laptop with Microsoft Access 2007 installed.

Optional laptop rental: To participate in this class, you must have a laptop with Access 2007 installed. We have arranged for students who do not have a laptop of their own to rent one for $150 for the duration of the class.

Continuing Education Units: 1.3 CEU's

Registration: $495/$395* for two day introductory class, or $650/$545* for all three days
(*reduced tuition is available to employees of Native American tribes, nonprofits, and government agencies; students; and NAEP and RMAEP 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. Register Online!

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.

To find out more about NWETC's programs send us an email

Northwest Environmental Training Center
A 501(c)(3) nonprofit program of the Environmental Outreach and Stewardship Alliance (EOS Alliance)
650 S. Orcas Street, Suite 220, Seattle, Washington 98108
Phone: (206)762-1976, Fax: (206)762-1979
www.nwetc.org