Access to Excel- Instant Excel Reports & Excel Pivot Tables (Udemy.com)

Learn to export perfectly formatted reports from Access to Excel without programming! Finish course in just 2 HOURS!

( 100 Reviews )

Created by: Bruce Myron

Produced in 2021

What you will learn

Create links between Access and Excel that instantly update report data

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 96 / 100

Course Description

Learn How to Link Access Tables to Excel Spreadsheets, then Update the Data Instantly!
This course shows you how to link Access to Excel so you can run a query for any time period and have it instantly update when you refresh ALL of your linked data in multiple Excel sheets. Using the techniques from this course will save you hours of time every time you create your reports!
From a Student -
"I was looking for a course that jumps right into examples and walks through the methodology in Access and Excel. This class does that perfectly. Plus, you get to see Bruce's thought process, which I believe will help in future Access/Excel projects." - Jonathan Sanborn
From another Student -
"This course is very detailed and deals with real world solutions to everyday tasks. I have used the techniques for several of my daily and weekly reports and it's amazing with a click of a button I can process the reports instantly where it took hours a week before.
The course is a fantastic step by step tutorial. Bruce breaks it down and simplifies the process and procedures so you can quickly master them and implement them in your project.!" - Stephen Davanzo
New Sections and Lectures Have Been Added
This Course has now DOUBLED in size to TWO Hours! Additional content covers an alternate method for linking to Excel and creation of Data Slice Tables and a Pivot Table in Excel. Now FIVE reports in the Excel file and they can all be updated from Access in a matter of seconds!
The method uses queries and macros, but NO PROGRAMMING, so anyone with just a very basic knowledge of Access and Excel can easily accomplish all the tasks in the course.
* Videos show you every step from the initial Access tables to finished Excel report!
* There is no fluff and you can learn the entire method in a little over one hour!
From another Student -
"This is an excellent course. Easy to follow with great explanations of what to do and why. I have learned so much and will refer back to this course. I can see this course and the information it teaches being very, very helpful in real world situations where you need to access database data in excel and use excel functionality to manipulate the data further. Awesome!" - Bronwyn Wilson
Think of how much time this will save you! Any reports you do on a regular basis can be setup with this method and you can save many hours every month!
This is especially helpful if you have to recreate a report for some past time period. Since Access can hold many years of data, you can recreate monthly reports for any time period - instantly!
And remember - you don't have to know anything more than the bare basics of Access and Excel to learn how to instantly send data from Access to Excel. Click the Take This Course button and start learning right now!
Another Student -
"I have taken several of Bruce's courses and they all are the same, Simply Excellent! I would take this course 2nd in his series after the Intro to Access for Excel Users. The material is for real world users that need to know how Access projects work in the real world situations. This instructor is very easy to understand and follow with a vast amount of practical experience to draw from. Enjoy!" - Rodney

Required Software
You should have Office 2010 or later. The course was created using Office 2013.Who this course is for:

Anyone who would like to save lots of time in making periodic reports

Time: 2h

Instructor Details

Bruce Myron

4.8 Rating
100 Reviews

Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business.
"Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce
I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do.
I have also spent time as a full time trainer providing group classes on the Microsoft Office programs.
In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible.
Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed.
My goal is to show my students how to create systems that business will value and that will create long term income.

Excel Basics (2017)

4.9 (15 Reviews)

Provider: YouTube
Time: 12h

Free

Microsoft Excel - Online Tutorial for Beginners (2010)

0.0 (0 Reviews)

Provider: Chandoo.org
Time: 1h 30m

Free

Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies (2016)

0.0 (0 Reviews)

Provider: Amazon

$14.53

More Courses

Reviews

4.8

100 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Qudsia Lone

Finished..the..course--Very-helpful-and-informative--best-of-all-PRACTICAL!...will-definitely-take-more-from-same-teacher.--Browser-not-allowing-me-to-add-spaces-to-my-typed-text-for-some-reason-sorry.

By Rui Baptista

Many of techniques were familiar.However I learnt a lot. The course is well structured and very clear.Right now I need to jump to VBA Access

By Karel J Clettenberg

Bruce is an excellent teacher. The pace was easy to follow and to the point. He does not waste time showing how you can do every variation of the same task. This course is well worth the time spent. Also, I compliment Bruce on his prompt and thorough answers to any questions that are posted in his courses.

By Akinleye Tunde

Excellent delivery and easy to understand.Thanks Bruce Myron

By George Wood

Excellent course...tons of valuable tips and information...I highly recommend using Access in conjunction with Excel...looking forward to more lessons of such a high calibre. Thank you.

By John Lamont

His presentation of a complex system of automating boring repetitive tasks being reduced to small understandable steps is amazing. His methods are practical and extremely appropriate for a business as distinct from what textbooks tell you.

By John Ovens

This is the second course that I have taken. Bruce is an exceptional instructor and has opened my eyes to how to use both Access and Excel to get the best results. I would recommend this course and am looking forward to taking on the VBA course.
Thanks Bruce.
JVO - Melbourne

By Bare

This was a really great course. Totally enjoyed the clear explanations and straight to the main points. No technical clutters, just easy simple plain english to explain complex stuffs! Bruce's use of clear & simple terms suggests client centricism on his expertise & professionalism. I have always looked for a course that combines the powers of Access & Excel into 1; you usually get them as distinct separate strengths. I'm glad Bruce's course ended that search for me in a positive & engaging experience. I'm rating it a 5!

By Nancy White

Love Bruce's courses! And my client will love seeing his Access data in familiar Excel format that he can manipulate to his heart's content!

By Asouza

Please, update the course, removing obsolete parts and keeping the new ones;
Use cell names in Excel, for example, in start and end dates.

By Bonnie Ufferman

I found Bruce Myron's Access to Excel - Instant Excel Reports & Excel Pivot Tables to be very helpful and applicable to tasks I use at work on a daily basis. I highly recommend his work!

By Christos Agapiou

An amazingly useful and practical course on how to link MS-Access with MS-Excel. Instructor is an excellent communicator and gives the lectures in a super efficient manner! Highly Recommended!!!