
Lynda - Building Solutions Using Excel and Access 2019 Together
MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch | Duration: 2h 29m
Genre: eLearning | ExerciseFiles | Language: English | Size: 360 MB
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. Topics include: How Excel and Access can work together Using the Problem Steps Recorder Leveraging screen capture tools Building tables in Excel and Access Creating basic queries using tables Maintaining linked tables Calculating in Excel versus Access Building forms Building macros to run on-demand queries Generating datasets using parameters, queries, and macros
Top Rated News
- Sean Archer
- AwTeaches
- Learn Squared
- PhotoWhoa
- Houdini-Course
- Photigy
- August Dering Photography
- StudioGuti
- Creatoom
- Creature Art Teacher
- Creator Foundry
- Patreon Collections
- Udemy - Turkce
- BigFilms
- Jerry Ghionis
- ACIDBITE
- BigMediumSmall
- Boom Library
- Globe Plants
- Unleashed Education
- The School of Photography
- Visual Education
- LeartesStudios - Cosmos
- All Veer Fancy Collection!
- All OJO Images
- All ZZVe Vectors