Access 2016: Building Dashboards for Excel | Robin Hunt | LYNDA

Access 2016: Building Dashboards for Excel | Robin Hunt | LYNDA
English | Size: 352.62 MB
Category: CBTs

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.

Topics include:

Understanding the software limitations
Working with Access tables
Analyzing table relationships
Building queries
Exporting data for Excel
Linking to Access data from Excel
Building charts and PivotCharts in Excel
Creating macros
Table of Contents:

Introduction
1. Benefits of Moving to Access
2. Understanding the Access Structure
3. Analyzing a Table
4. Building and Working with Queries
5. Exporting and Linking Data to Excel
6. Charting and Pivots in Excel
7. Building Excel Macros for Dashboard
Conclusion

About the Instructor:

Robin Hunt is a developer/educator specializing in process development, data management, and custom workflows.

Robin loves to inspire people to "think something new" and has a passion for people and data. She actively seeks ways to engage in efforts that support her community and loves being an active part of the entrepreneurial and startup community that’s growing in Birmingham, Alabama.

Robin has been thankful to have followed her entrepreneurial spirit and found a way to combine both her love for teaching and her technical skills as a developer. It’s rare to find a developer who is also passionate about teaching or vice versa, but Robin seamlessly blends the two and gives her clients and students the best of both worlds. As a developer, she specializes in process development, data management, and customized workflow solutions. As an educator she loves all things social, data related, and searchable and analyzing them for better decision-making. You can learn more about Robin and her projects at LinkedIn.

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.