Microsoft Access Up to Speed

Register Now for Online Sessions Beginning Jan. 19

Font Size:
Default font size
Larger font size

Instructor Adam Wilbert is a cartographer and database consultant. He has developed Access databases for the National Park Service as well as database and GIS solutions for small businesses and non-profit organizations. In 2007 Adam founded CartoGaia, a freelance cartography firm that merges a passion for data with aesthetic design. CartoGaia produces data management solutions and high-end custom maps for land use agencies, non-profit organizations and recreational groups. He is also the author of "Access 2007: Queries in Depth" available in the online training library. When Adam's not working at the computer, he's out exploring the world through the lens of infrared photography.

Posted: Thursday, January 21, 2016 8:00 am

Learn to use the intermediate and advanced features of Microsoft Access in this 12-hour online course recorded in January 2016.

This course, presented by Sustainable City Network and the Northwest Environmental Training Center, 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 technical managers, engineers, field staff, scientists, and government agency staff.

Click here to purchase and download the webinar series in our content store.

Part 1: Introduction to Building Databases in MS Access

(6 hours)

A well designed database can increase efficiency and 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 scientific, engineering or environmental data. It is applicable to anyone that manages resources, sets or responds to 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. These Access database subjects are taught using real-world examples with actual field data. This class is recommended for anyone desiring a concentrated exposure to Access training in a powerful six-hour class.

For additional exposure, we recommended Part 2: Creating Efficient Workflows and Custom Tools in Microsoft Access.

Part 2: Creating Efficient Workflows and Custom Tools in MS Access

(6 hours)

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 this recommended follow up, you will build on your 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.

More about

Online Poll