->
Lynda - Building Solutions Using Excel and Access 2019 Together
Categories: Tutorials
Lynda - Building Solutions Using Excel and Access 2019 Together - 779736
Lynda - Building Solutions Using Excel and Access 2019 Together
By combining the powers of Microsoft Excel and Access 2019, you can automate repetitive Excel tasks and boost your personal productivity. In this course, learn strategies and techniques that can help you work smarter with Excel and Access, and avoid needing to manually rebuild each time you run reports by building solutions. Discover how to most effectively leverage these two programs, and get the most out of both tools working together. 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 demonstrates how to work with imports and exports, automate using macros and the AutoExec, build forms and reports, and more.


Table of Contents

  • Introduction
  • 1. Understanding How to Use Excel and Access for a Solution
  • 2. Building Tables in Excel and Access
  • 3. Calculating Data in Excel and Access
  • 4. Building Macros to Run Imports and Queries
  • 5. Building Reports for Your Solution
  • 6. Building Forms for Your Solution
  • 7. Using Parameters, Queries, and Macros to Generate Datasets
  • Conclusion

    • Lynda - Building Solutions Using Excel and Access 2019 Together


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.


    Categories Sitemap



    rss