Access to Excel- Instant Excel Reports & Excel Pivot Tables
4.8 (91 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,612 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access to Excel- Instant Excel Reports & Excel Pivot Tables to your Wishlist.

Add to Wishlist

Access to Excel- Instant Excel Reports & Excel Pivot Tables

Learn to export perfectly formatted reports from Access to Excel! No programming! Finish course in just TWO HOURS!
4.8 (91 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,612 students enrolled
Last updated 8/2016
English
Current price: $10 Original price: $195 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Article
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Create links between Access and Excel that instantly update report data
View Curriculum
Requirements
  • A very basic knowledge of Access and Excel
Description

NEW SECTION - MARCH 2016! How to Link an Excel File to an Encrypted Access Database and Avoid a Common Problem. Learn how to password protect your databases the right way! LAST SECTION After the Conclusion.

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 is the target audience?
  • Anyone who would like to save lots of time in making periodic reports
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 37 Lectures Collapse All 37 Lectures 02:23:27
+
Introduction - Inspect Tables and Demonstrate the Problem
4 Lectures 06:46

Link to Database file
1 page


How about exporting a report?
01:24
+
Build the Data Table
4 Lectures 10:33
Just before we start
00:39

Create the Data Table
03:16

Add Two More Columns to our Table
04:53

Create macro to run the queries and test it
01:45
+
Put the report table in a separate database
2 Lectures 05:21
Create the New Database and import the Report Table
02:43

Link to the New Database and Test the Macro
02:38
+
Create Excel File and Link to Our Report Database
2 Lectures 11:22

Test the System and Remove a Potential Problem
04:40
+
Add a Second Report to Our Excel Spreadsheet
6 Lectures 31:28
Add a Sheet to the Excel File for Customer Totals
05:49

Create queries to get the Report Dates and Add to our Macro
05:40

Create the Customer Totals Table using the Same Dates
08:09

Final modifications to the Customer Totals table
04:49

Add the Customer Totals table to the external database, then link to it.
02:24

Create an Excel Data Connection to the Customer Totals Table and Final Test
04:37
+
An Alternate Method for Linking All Tables at Once
3 Lectures 03:37

Link to new Access and Excel files
1 page

Review of Tables in the New Database
02:31
+
Build the New Data Tables in Access
3 Lectures 16:26
Build a Query to Show the Top Ten Customers
03:21

Link Five Tables in a Query to Build the Order Summary Table
08:51

Add the New Queries to the Access Macro and Turn Off Warnings
04:14
+
Prep the Excel File and Link the New Data Tables
3 Lectures 15:36
Edit the Sheet Headers and Date Formulas
02:50

Create the Data Connection from Excel to Access for Multiple Tables
04:56

Import All Four of the Access Tables and Create Totals
07:50
+
Use Data Slices and Create a Pivot Table
2 Lectures 12:42
Add Data Slicing to Our Order Summary Report
05:33

Create the Pivot Table and Learn How to Modify It
07:09
+
Test the Instant Data Update from Access and Prep Excel File for Distribution
2 Lectures 10:12

Save Excel File for Sending and Remove the Connection
01:45
3 More Sections
About the Instructor
Bruce Myron
4.7 Average rating
2,653 Reviews
35,801 Students
15 Courses
Productivity Specialist

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.

Billy Myron
4.8 Average rating
1,384 Reviews
12,185 Students
12 Courses
Udemy Instructor

Hello, my name is Billy. I was born and raised in the state of Oregon, and still live there.

On Udemy, I primarily assist Bruce Myron as an instructor on his courses. They deal with Microsoft Access, Microsoft Access VBA, and other Microsoft Office programs such as Excel.