This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access 365: Link Data to Excel with Macros and VBA
Section 1: Introduction
Introduction (1:54)
Section 2: Prepare the Access Data
Database Overview and Export Problems (11:28)
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 (7:36)
Add the Order Summary Table (10:05)
Clean Up the Navigation Pane by Creating a Custom Group (9:23)
Section 3: Setup the Excel File and Link to Our Database
Create the Excel File and Link to the Data (7:56)
Add More Sheets to the Excel File (8:19)
Add Subtotals and Use the Filters (5:40)
Add Data Slicing to Our Order Summary Report (5:50)
Create the Pivot Table and Prepare File for Distribution (8:21)
Section 4: Create VBA Program to Prep the Excel File for Distribution
Download New Database and Update the Excel Query Connections (5:22)
Create a VBA Function that will Prep the XL File (6:36)
Get the NewXLFile Name and Copy the Excel File (9:41)
Add VBA Code to Check Existence of the Files (7:07)
Open the Copied Excel File, Refresh Connections then Remove Them (8:40)
Add Our New Program to the Macro and Call from a Form (8:14)
Clean Up the Navigation Pane by Creating a Custom Group
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock