Introduction
Visualize your data with a customized Access application
()
What you should know
()
1. Explore the Graphical Capabilities of Access
Using Access as a visualization front-end for your data
()
Introducing the new Ivy-based charting engine
()
Building charts and graphs from database queries
()
Formatting data viz charts for legibility
()
Explore the range of charting types
()
2. Connect to External Data Sources
Load data from a CSV file
()
Read data from Excel
()
Connect to SQL Server
()
3. Build a Data Visualization Dashboard
Create a form-based dashboard
()
Query data for a chart
()
Add a chart to the dashboard
()
Add a key performance indicator to the dashboard
()
4. Create an Interactive Analysis Tool
Add customizable parameters to a query
()
Control a parameter with interactive elements
()
Create flexible graphs with parameter queries
()
Connect interactive data selection elements to a dashboard
()
Add a refresh button as a final touch
()
Conclusion
Following up with other resources
()
Ex_Files_Data_Visualization_for_Business_Managers.zip
(6.6 MB)