Data Visualization for Business Managers with Access

1h 41mIntermediate2025-01-07

Authors

Adam Wilbert

Data Visualization Expert

Course details

Microsoft Access lets you build visual databases with ease, all without writing a single line of code. This course, targeted uniquely at business managers, provides comprehensive training on leveraging the graphical capabilities of Microsoft Access to create visually appealing and insightful charts and graphs. Instructor Adam Wilbert shows you how to connect to external data sources, build a data visualization dashboard, and design interactive analysis tools to make data-driven decisions more effectively. By the end of this course, you’ll be equipped with the technical know-how and skills you need to leverage data for strategic decision-making.

Learning objectives
Explore the graphical capabilities of Microsoft Access.
Connect Access to external data sources.
Build a data visualization dashboard.
Create an interactive analysis tool.

Skills covered

Microsoft AccessDesktop DatabasesData VisualizationData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

01 - Visualize your data with a customized Access application
02 - What you should know

1. Explore the Graphical Capabilities of Access

03 - Using Access as a visualization front-end for your data
04 - Introducing the new Ivy-based charting engine
05 - Building charts and graphs from database queries
06 - Formatting data viz charts for legibility
07 - Explore the range of charting types

2. Connect to External Data Sources

08 - Load data from a CSV file
09 - Read data from Excel
10 - Connect to SQL Server

3. Build a Data Visualization Dashboard

11 - Create a form-based dashboard
12 - Query data for a chart
13 - Add a chart to the dashboard
14 - Add a key performance indicator to the dashboard

4. Create an Interactive Analysis Tool

15 - Add customizable parameters to a query
16 - Control a parameter with interactive elements
17 - Create flexible graphs with parameter queries
18 - Connect interactive data selection elements to a dashboard
19 - Add a refresh button as a final touch

Conclusion

20 - Following up with other resources