- How queries, forms, and reports work with tables
- Linking data to Access
- Building and working with queries
- Working with SQL view
- Exporting and linking data to Excel
- Charting and pivots in Excel
- Building interactive charts
- Building Excel macros for dashboard
- Creating macros that navigate
- Assigning macros to buttons
Skill Level Intermediate
- [Robin] This course is meant to show you how to expand the reporting capabilities and the routine steps you do in Excel today using Access to build what we commonly know as dashboards in Excel. I'll show you how to build queries that include your functions so that every time you have new data, you're not rebuilding functions. I'll show you how to include total and aggregate queries. I'll show you how to link that data directly to Excel so it stays in real time, and I'll show you how to refresh options so that your users don't have to know the intricacies of refresh, but can work with your file as you intended. I'll show you how to build interactive slicers that filer your data, I'll show you how to build common macros that make your file even easier to work with. Hi, I'm Robin Hunt. Let's get started building dashboards using your Access data in Excel.
1. The Benefits of Moving to Access
2. Understanding the Access Structure
3. Analyze Database Tables
4. Build and Work with Queries
5. Export and Link Data to Excel
6. Charting and Pivots in Excel
7. Build Excel Macros for Dashboard
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.