*This is a recording of a live webinar that took place in February 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,
- Course workbook,
- A .zip file of exercise files
After purchase, you will receive instructions regarding how to access files.
Access databases are more than just data tables. An Access database includes a collection of objects that all work together to perform specific tasks quickly and efficiently. By building on the knowledge gained in part one of this course, we will create highly efficient customized workflows that can reduce complex data processing and reporting tasks down to a single click.
This is the second course in a 2-part series. In "Introduction To Building Environmental Databases With Microsoft Access-WEBINAR (COMP-401W)", students learn the basic elements of constructing queries, forms, macros and reports. In this recommended follow up, you will build on those skills by creating end-user application examples that bring the newly learned elements together. Access analytic tools, PivotCharts, and PivotTables will be introduced, and an SQL primer will be included. NOTE: COMP-402W is not meant to be taken as a stand-alone class without first taking COMP-401W.
After completing this course, participants will be able to:
- Apply complex query functions to databases
- Create and design pivot charts and pivot tables
- Perform complex queries using multiple tables
- Create tools for forms and reports
- Build multi-step macros for automating tasks
Testimonials: "It was good to have this material to finish the course...Adam does a very good job. [He] is very knowlegeable & patient. Great resource." A. Sturdevant, December 2013
"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
*NOTE: COMP-402W is not meant to be taken as a stand-alone class without first taking COMP-401W.