Description

Building Solutions Using Excel and Access 2016 Together

Building Solutions Using Excel and Access 2016 Together
MP4 | Video: 720p | Duration: 2:19:07 | English | Subtitles: VTT | 331.3 MB
By coMB ining 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 togetherUsing the Problem Steps

RecorderLeveraging screen capture toolsBuilding tables in Excel and AccessCreating

basic queries using tablesMaintaining linked tablesCalculating in Excel versus

AccessBuilding a basic form on Excel tablesBuilding macros to run on-demand queriesGenerating datasets using parameters, queries, and macros

Enroll now to go through a deep dive of the most popular spreadsheet

tool on the market, Microsoft Excel. As a Microsoft Certified Trainer I will use

my 20+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses you will master Excel tools that

will clear away the pain of stumbling through your daily tasks.

You will start with the basics, building a solid foundation

that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular

Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master: