Simplify updating Excel spreadsheets
If you are generating Excel spreadsheets from data inside an Access database, and want to learn how to streamline that process, this course is for you! Learn how to write code that will have Access generate an Excel file within your date parameters.
Don't know much about VBA?
No problem! This course will walk you through the process step-by-step. Watch as Bruce shows you exactly how the code works, and learn how VBA can open up a new world of possibilities.
Become so Much More Efficient
If you are constantly generating reports in Excel, then using the techniques in this course can save you hours of your time! Achieve an efficiency that would not be possible without Access, using practical and important VBA code techniques that Bruce demonstrates clearly and effectively.
Curriculum
Section 1: Introduction
Available in
days
days
after you enroll
Section 2: Prepare the Access Data
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
Section 4: Create VBA Program to Prep the Excel File for Distribution
Available in
days
days
after you enroll
- 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)