Access 2019: Building Dashboards for Excel
Offered By: LinkedIn Learning
Course Description
Overview
Explore how make visually appealing dashboards inside Excel that collect and display information from Access.
Syllabus
Introduction
- Make Excel data entry more visual
- What you should know
- Working with the exercise files
- Understanding the limitations of Excel
- Understanding the limitations of Access
- Learning how queries, forms, and reports work with tables
- Work with table views
- Link data to Access
- Learning the basics of normalization
- Understanding table relationships
- Identify keys
- Understanding join types
- Create queries
- Sort and filter in a query
- Enhance queries
- Build unique data queries
- Work with SQL view
- Build aggregate data queries
- Import to and from Access
- Link data to Excel
- Work with external connections
- Refresh data from other sources
- Add data from connections
- Change connections
- Build sunburst charts and treemaps
- Build pivots and set refresh settings
- Build PivotCharts
- Using slicers and timelines to filter
- Set slicer options
- Move charts
- Work with page layout
- Create macros that clear filters
- Create macros for common filters
- Create macros that navigate
- Assign macros to buttons
- Next steps
Taught by
Robin Hunt
Related Courses
Intro to StatisticsStanford University via Udacity Introduction to Data Science
University of Washington via Coursera Passion Driven Statistics
Wesleyan University via Coursera Information Visualization
Indiana University via Independent DCO042 - Python For Informatics
University of Michigan via Independent