How to Use Data Analytics in Microsoft Access

preview_player
Показать описание
MS Access database has been around for many years as an office productivity tool providing a place to hold data and have that data utilized interactively. This tutorial introduces individuals to learn that basic elements of a database and use them primarily for data visualization.
#MSAccess, #DataVisualization, #BusinessIntelligence, #dataanalytics , #ExcelAlternative
download link to files:
timecodes
00:00-MS Access 2019 Beginner's Tutorial Introduction
00:44-MS Access 2019 Data Visualization Design Process
01:27-Blank Database Design
01:49-Import Data From Excel File
03:17-Query Design
05:12-Form Design - Open Blank Form
05:39-Form Design - Insert Modern Chart And Combo Box
12:04-Form Design - Add More Combo Boxes
16:44-Form Design - Create A Macro Button To Refresh Data
18:32-Form Design - Add A Different Modern Chart Type
21:08-Form Design - Edit Chart Formatting And Properties
31:15-Complete Data Visualization Tool Using MS Access 2019 Database
31:57-Thank You!

Background track credits:
Downtown Glow by Ghostrifter & Devyzed
Creative Commons — Attribution-NoDerivs 3.0 Unported — CC BY-ND 3.0
Рекомендации по теме