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
Diseño de sistemas de información gerencial para intranet con Microsoft AccessUniversidad del Rosario via edX Competencias digitales de ofimática: Microsoft Access
Universitat Autònoma de Barcelona (Autonomous University of Barcelona) via Coursera Diseño de software para la toma de decisiones organizacionales
Universidad del Rosario via edX Excel to Access: Intro to Microsoft Access for Excel Users
Udemy Access 2007: Shortcuts
LinkedIn Learning