Course Description

(Course 1 of 2 in a series)

Course ID:

COMP-401W

Category:

Technical / Software

Continuing Education Units:

0.60CEUs

Description:

**This course will be presented online as a live webinar in three 2-hour sessions. Sessions will be recorded and will be available to all enrolled attendees.**

All classes will be from 9 a.m.-11 a.m. Pacific (10 a.m. to 12 p.m. Mountain) (11 a.m. to 1 p.m. Central) and (12 p.m.-2 p.m. Eastern). Registrants will receive login information no later than 48 hours before the start of the first session.

This webinar is being presented by Sustainable City Networks and NWETC.

A well designed database can increase the efficiency and can eliminate errors in your data storage protocols. By reducing redundancy, and eliminating the potential for human error, you can ensure that your data remains consistent and valid, and always up to date.

Access databases provide more than just a place to store your data. By creating a custom application that is specifically tailored to your project, an Access database creates the foundation through which you will quickly enter information, and more importantly, quickly retrieve answers to your questions about the data and build reports outlining the results.

This introductory course is designed for participants who wish to gain beginning to intermediate skills in using Microsoft Access to build relational databases for collecting, organizing, and analyzing their environmental data. It is applicable to anyone that manages environmental resources, sets or responds to environmental policy, or needs to evaluate regulatory compliance. This comprehensive class uses Access 2010 to cover in-depth the use of Tables, Queries, Forms, Reports, and Macro 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 tsix-hour class. For additional exposure, we recommended "MS Access Part 2 WEBINAR-Creating Efficient Workflows and Custom Tools in Microsoft Access (COMP-402W)" is offered beginning February 2,2016.

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

"Instructor is extremely knowledgeable and explained software very well. It was very valuable that examples were specific to environmental data." Anonymous, December 2013

"Very useful, class was hands on. I feel like I learned a lot." B. Barry, December 2013

"Access can be a useful tool for data management: the more people who know how to use it, the better. Plus the instructor is great! This is highly relevant to our work as Environmental Consultants." J. Hopp, April 2013" J. Hopp, April 2013

An additional $50 discount applies when registering for both courses in the series.

*Reduced tuition is available to employees of Native American tribes, government agencies, nonprofits, students and NAEP, NEBC, NWAEP members. You may register online or by calling the Northwest Environmental Training Center at 425-270-3274.

Prerequisites:

Basic understanding of Microsoft Office software and basic computer skills are required.

Attendees will receive a .pdf containing workshop proceedings and reference material. Webinar login instructions will be sent after registration.

Intended Audience:

This course is beneficial for any professional who works with a large amount of data, and needs to improve their Access skills to be able to make the most of the power of the software. Past attendees include environmental managers, engineers, field staff, scientists, and government agency staff.

Once your order has been placed, you are subject to our cancellation policy regardless of the status of your invoice.

31 days prior to training -> 100% refund
30-16 days prior to training -> 50% refund
15 - start of course -> No refund available

Attendee replacement acceptable at anytime.

Course registration fees and cancellation policy are subject to change without notice.

Order:

More Information

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

What to Bring

A personal computer with Access 2010 (Access 2007 acceptable)

Billing Information

In order to guarantee a space in a course, the tuition must be paid in full TWO WEEKS before the first day of the course by either check or credit card. State and government agencies paying with a purchase order are allowed payment under the two-week time frame if a copy of the purchase order is received by NWETC.

If You Need to Cancel

Cancellations*

With 31 or more days notice, we will offer a 100% refund or credit towards a future course. The credit is good for one year and may be applied to any course.
With 30-8 days notice, we will offer a course credit towards a future course. The credit is good for one year and may be applied to any course.
With fewer than 8 days notice, there is no course credit available

*Please note that attendee replacement is welcome at any time