Learn to use the intermediate and advanced features of Microsoft Access in this 12-hour online course recorded in February 2016. Includes session recordings (MP4) and sample Access databases.
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 software. Past attendees include technical managers, engineers, field staff, scientists, and government agency staff.
Both Part 1 and Part 2 are included in this package:
Part 1: Introduction to Building Databases in MS Access
(Course 401: 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.
Part 2: Creating Efficient Workflows and Custom Tools in MS Access
(Course 402: 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.