Section 1: Introduction
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
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)
