Access 2016: Building Dashboards for Excel
Overview
Visualize your Access data using Excel dashboards. Learn how to build powerful dashboards using slicers, timelines, charts, and macros.
Using Excel, you can optimize reporting for Access databases. Learn how to build powerful dashboards to visualize your data, using tools such as slicers, timelines, charts, and PivotCharts. Instructor Robin Hunt shows how to analyze, query, and export Access data for use in Excel, and connect directly to Access from Excel, so that you always have a live view of your data. Then learn how to build dashboards with slicers, timelines, and charts, and create macros that make your dashboards more user friendly. By the end of the course, you should be able to extend your current reporting capabilities and create more engaging visualizations.
Using Excel, you can optimize reporting for Access databases. Learn how to build powerful dashboards to visualize your data, using tools such as slicers, timelines, charts, and PivotCharts. Instructor Robin Hunt shows how to analyze, query, and export Access data for use in Excel, and connect directly to Access from Excel, so that you always have a live view of your data. Then learn how to build dashboards with slicers, timelines, and charts, and create macros that make your dashboards more user friendly. By the end of the course, you should be able to extend your current reporting capabilities and create more engaging visualizations.
Syllabus
Introduction
- Welcome
- What you should know
- Using the exercise files
- Understanding Excel limitations
- Understanding Access limitations
- Learning how queries, forms, and reports work with tables
- Working with table views
- Linking data to Access
- Working in table design
- Learning the basics of normalization
- Understanding table relationships
- Identifying primary and foreign keys
- Creating queries
- Sorting and filtering in a query
- Enhancing queries with functions
- Working with SQL view
- Building unique data queries
- Building aggregate data queries
- Exporting data from Access to Excel
- Using external connections in Excel
- Adding connections
- Refreshing data from other sources
- Changing data connections
- Building interactive charts
- Building pivots
- Building PivotCharts
- Moving charts
- Using slicers to filter data
- Using timelines to interact with data
- Working with Page Layout
- Creating macros that clear filters
- Creating macros for common filters
- Creating macros that navgiate
- Creating macros that refresh data
- Assigning macros to buttons
- Next steps
Taught by
Robin Hunt
Related Courses
Reviews
0.0 rating, based on 0 reviews
Never Stop Learning!
