Author
Robin Hunt
Released
2/9/2018- Understanding the software limitations
- Working with Access tables
- Analyzing table relationships
- Building queries
- Exporting data for Excel
- Linking to Access data from Excel
- Building charts and PivotCharts in Excel
- Creating macros
Skill Level Intermediate
Duration
Views
- [Robin] Hi, I'm Robin Hunt. Welcome to Access 2016: Building Dashboards for Excel. Are you ready to extend the reporting capabilities of your Access database into a basic dashboard in Excel? In this course, I'll show you how to work with tables in Access, link data into Access, how to build reusable, unique and aggregate queries, how to link Access data to Excel, how to build a dashboard with slicers and timelines, how to build macros to make your dashboard more user friendly. I hope you'll find these techniques useful when you're ready to extend your Access reporting capabilities.
Let's get started building dashboards with Access and Excel.
-
Introduction
-
Welcome38s
-
-
1. Benefits of Moving to Access
-
2. Understanding the Access Structure
-
Working with table views3m 31s
-
Linking data to Access2m 36s
-
Working in table design2m 52s
-
-
3. Analyzing a Table
-
4. Building and Working with Queries
-
Creating queries3m 15s
-
Working with SQL view4m 44s
-
Building unique data queries2m 30s
-
-
5. Exporting and Linking Data to Excel
-
Adding connections1m 39s
-
Changing data connections1m 29s
-
6. Charting and Pivots in Excel
-
Building pivots6m 2s
-
Building PivotCharts1m 47s
-
Moving charts3m 19s
-
Using slicers to filter data6m 43s
-
Working with Page Layout7m 42s
-
7. Building Excel Macros for Dashboard
-
Assigning macros to buttons4m 28s
-
Conclusion
-
Next steps22s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome