Introduction
to Managing Environmental Data with Microsoft Access
Course No. COMP-401
August 8 - 9, 2006, 8:30 A.M. to 5:00 P.M. (2 Day)
Portland State University | Cramer Hall,
Computer Lab CH01 | Portland, Oregon
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 Advanced Level Queries with Microsoft Access workshop, August 10, 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:
$395. $325 for nonprofits; Native American Tribes; government employees;
students; teachers; and NAEP, NWAEP, and NEBC members. A $50 discount applies
when registering for both workshops in this series (COMP-401 and 402).
To find out more about NWETC's programs send us email