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
