Access 2016: 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
Design Computing: 3D Modeling in Rhinoceros with Python/RhinoscriptUniversity of Michigan via Coursera 3D SARS-CoV-19 Protein Visualization With Biopython
Coursera Project Network via Coursera A Simple Scatter Plot using D3 js
Coursera Project Network via Coursera Access Bioinformatics Databases with Biopython
Coursera Project Network via Coursera Accounting Data Analytics
University of Illinois at Urbana-Champaign via Coursera