Microsoft Access 365: Link Data to Excel with Macros and VBA
4.7 (381 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,427 students enrolled

Microsoft Access 365: Link Data to Excel with Macros and VBA

Create perfectly formatted, ready to distribute Excel files in seconds from inside Microsoft Access!
4.7 (381 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,427 students enrolled
Created by Bruce Myron
Last updated 6/2020
English
English [Auto]
Current price: $51.99 Original price: $74.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 3 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Create links between Access and Excel that instantly update report data
Requirements
  • A very basic knowledge of Access and Excel
Description

Learn How to Link Microsoft 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

The method starts out using queries and macros and then adds an introduction to VBA PROGRAMMING. If you have never used Microsoft Access VBA, this is an excellent introduction and a very practical example of how VBA can you life easier!  Anyone with just a very basic knowledge of Access and Excel can easily accomplish all the tasks in this course!

* Videos show you every step from the initial Access tables to finished Excel report!

* There is no fluff and you can go through the entire course in about 2.5 hours

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 time you need to prepare Excel files for distribution, it will only take seconds!  Using these techniques can save many hours every month!

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 a subscription to Microsoft 365 and have the full Office suite installed.

Who this course is for:
  • Anyone who would like to save lots of time in making periodic reports
Course content
Expand all 22 lectures 02:26:29
+ Prepare the Access Data
6 lectures 01:01:30
Modify the Query to Ask for Dates and Add them to the Query Result
12:32
Add a Report Dates table and get Customer Totals
10:26
Modify the Customer Totals table and Add Top Ten Table
07:36
Add the Order Summary Table
10:05
Clean Up the Navigation Pane by Creating a Custom Group
09:23
+ Setup the Excel File and Link to Our Database
6 lectures 36:24
Correction of Error in Query Used
00:18
Create the Excel File and Link to the Data
07:56
Add More Sheets to the Excel File
08:19
Add Subtotals and Use the Filters
05:40
Add Data Slicing to Our Order Summary Report
05:50
Create the Pivot Table and Prepare File for Distribution
08:21
+ Create VBA Program to Prep the Excel File for Distribution
6 lectures 45:41
Download new database and update the Excel query connections
05:22
Create a VBA Function that will Prep the XL File
06:37
Get the NewXLFile Name and Copy the Excel file
09:41
Add VBA Code to Check Existence of the Files
07:07
Open the Copied Excel File, Refresh Connections then Remove Them
08:40
Add our new program to the macro and call from a form
08:14
+ Conclusion
1 lecture 00:40
Conclusion and a Reminder
00:40
+ Bonus Lecture - Learn Even MORE!
1 lecture 00:15
Bonus Lecture - Learn Even More!
00:15