*This is a recording of a live webinar that took place in January 2016 in three 2-hour sessions.**
The webinar was presented by Sustainable City Networks and NWETC.
Purchase includes 5 files:
Audio/Video recording of three 2-hour sessions,
A .zip file of exercise files
After purchase, you will receive instructions regarding how to access files.
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
"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
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
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.
Continuing Education Units: 0.60 CEUs