Site menu


Statistics


    Total online: 2
    Guests: 2
    Users: 0

 

Calendar


free counters



























Main » 2022 » January » 1 » Lynda Building Solutions Using Excel and Access 2016 Together
18:40:44
Lynda Building Solutions Using Excel and Access 2016 Together
Lynda Building Solutions Using Excel and Access 2016 Together
 



Included Exercise Files
Skill Level : Intermediate
Duration : 2h 19m
Number of lessons: 65
Date Released : 12/9/2017
Language : English
Size : 296,90 Mb


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.

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 a basic form on Excel tables
Building macros to run on-demand queries
Generating datasets using parameters, queries, and macros











https://www.filefactory.com/file/6091l5hlo16p/




 


 
Category: VIDEO TUTORIALS | Views: 149 | Added by: saradaddy | Rating: 5.0/1
Total comments: 0
javascript://
There are *:
Email:
Code *: