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
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
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.