The Northwest
Environmental Training Center presents:
Course
Brochure PDF (includes directions, hotel info, and registration
form) | Directions | Accommodations
Introduction
to Managing Environmental Data with Microsoft Access
Course No. COMP-401
September 26 - 27, 2006, 8:30 A.M. to 5:00 P.M. (2 Days)
ExecuTrain
of Sacramento
2901 K Street, Suite 450
Sacramento, California
This class is full as of September 20, 2006. Please contact us if you'd like to be added to the waiting list, or be informed of future class offerings.
Instructor:
Michael
Leech, Database Designer/GIS Analyst, Michael Leech Consulting
Description:
This course provides participants with an overview of relational database
applications and design. Participants will learn how to customize and work
more efficiently with existing databases and how to design new databases.
This course is recommended for environmental professionals who are interested
in becoming more proficient with Microsoft Access to support information management
in the workplace. Each participant will have their own computer workstation
to complete hands-on exercises throughout the class.
Course
Topics:
|
Understanding
Database Design
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 Applied
Environmental Database Design and Queries with Microsoft Access workshop,
September 28, 2006. 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
- Design and repair environmental databases
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.4
Registration:
$495 ($395* for
Native American Tribes; nonprofits; government agencies; students; and AFS,
and NAEP 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.
A 501(c)(3) non-profit program of EOS Alliance
650 S. Orcas Street, Suite 220 | Seattle, Washington 98108
Phone: (206)762-1976 | Fax: (206)762-1979
www.nwetc.org