Building Solutions Using Excel and Access 2016 Together
Offered By: LinkedIn Learning
Course Description
Overview
Discover how to use Excel and Access 2016 together. Learn how to work with imports and exports, automate using macros and the AutoExec, build forms and reports, and more.
By combining the power of Microsoft Excel and Access 2016, you can build better end-user solutions and greatly enhance your own personal productivity. In this course, learn how to leverage Excel and Access, and get the most out of both tools working together. Robin Hunt shares strategies and techniques that can help you work smarter with these two programs, and avoid needing to manually rebuild each time you run reports by building solutions. Robin kicks off the course by reviewing how Excel and Access can be used together, and explaining how to build tables and calculate data in these two programs. She also explains how to work with imports and exports, automate using macros and the AutoExec, build forms and reports, and more.
By combining the power of Microsoft Excel and Access 2016, you can build better end-user solutions and greatly enhance your own personal productivity. In this course, learn how to leverage Excel and Access, and get the most out of both tools working together. Robin Hunt shares strategies and techniques that can help you work smarter with these two programs, and avoid needing to manually rebuild each time you run reports by building solutions. Robin kicks off the course by reviewing how Excel and Access can be used together, and explaining how to build tables and calculate data in these two programs. She also explains how to work with imports and exports, automate using macros and the AutoExec, build forms and reports, and more.
Syllabus
Introduction
- Welcome
- Using the exercise files
- What you should know
- How Excel and Access can work together
- Using the Problem Steps Recorder
- Using Microsoft Office screenshots
- Creating Access database tables
- Import and link Excel data as tables
- Creating tables from named ranges
- Creating basic queries using tables
- Maintaining linked tables
- Calculating in Excel versus Access
- Mining data in Excel: Common formulas
- Calculating in Access 2016 tables
- Calculating in Access 2016 queries
- Building a basic form on Excel tables
- Adding command buttons for navigation
- Setting the Access database options
- Building parameter queries using forms
- Setting drop downs for parameters
- Building reports on your new queries
- Refining your navigation forms
- Exporting information back to Excel
- Building an import-export macro
- Action queries in Access 2016
- Building macros to run on-demand queries
- Using the AutoExec macro in Access
- Building macros on events and buttons
- Building queries to create new datasets
- Building forms to filter your data
- Creating macros that export data
- Next steps
Taught by
Robin Hunt
Related Courses
Introduction to Office 365 Development and APIsMicrosoft via edX Office 365: Managing Identities and Services with Hands-on Labs
Microsoft via edX Compliance in Office 365: eDiscovery
Microsoft via edX Compliance in Office 365: Data Governance
Microsoft via edX Microsoft Exchange Server 2016 - 5: Hybrid Topologies with Office 365
Microsoft via edX