Udemy Microsoft Access VBA for Non Programmers

/01 Introduction/

001 Course Overview.mp4

002 Setup Tasks.mp4

003 Direct Download Links for Database Files.pdf

004 How to Contact Me.mp4

desktop.ini

/02 Start Learning VBA and Handling Errors/

001 View Database Table and Forms - Review the Goal.mp4

002 Create Your First VBA Subroutine.mp4

003 Fix a Syntax Error and Take Over the Keyboard.mp4

004 Use an IF Statement and DoCmd.mp4

005 Use ElseIf and a Select Statement.mp4

006 Runtime Errors, Error Traps and Program Stops.mp4

007 Break Into Programs and Infinite Loops.mp4

008 What Have You Learned in Section 2 Quiz.html

009 Section 2 Conclusion and Review.mp4

010 Section 2 Notes.pdf

desktop.ini

/03 Create Record Sorting Subroutines/

001 On Open Event, Me Keyword and Orderby.mp4

002 Subroutines for Form Controls, VBA Editing Shortcuts.mp4

003 Modify Subroutines to Sort DESC, More Error Handling.mp4

004 What Have You Learned in Section 3 Quiz.html

005 Section 3 Conclusion and Review.mp4

006 Section 3 Notes.pdf

desktop.ini

/04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/

001 Expanding the Keydown Subroutine.mp4

002 Using Public Variables.mp4

003 Building the Search Criteria.mp4

004 Field Names and Reserved Words.mp4

005 Using a Recordset and Bookmarks.mp4

006 Enhancing Our Instant Search.mp4

007 What Have You Learned In Section 4 Quiz.html

008 Section 4 Conclusion and Review.mp4

009 Section 4 Notes.pdf

desktop.ini

/05 Interact With Other Forms and Pass Information/

001 Open Another Form with a Button Click.mp4

002 Send Data to the Other Form.mp4

003 Modify a Form to Utilize Data Sent to it..mp4

004 Intro to SQL and Using SQL in the Recordsource.mp4

005 Locate Same Record When Returning from the Form.mp4

006 Modify the Form to Remember the Sort.mp4

007 Create a Prompt to Save Changes.mp4

008 Activate the Add Customer Button.mp4

009 Testing for a Blank Record.mp4

010 Activate the Delete Button.mp4

011 What Have You Learned in Section 5 Quiz.html

012 Section 5 Conclusion and Review.mp4

013 Section 5 Notes.pdf

desktop.ini

/06 Add Multiple Interactive Pulldown Filters/

001 Setup Rowsource for Dropdown Filters.mp4

002 Enable Editing In the Dropdown Filters.mp4

003 Set Dropdown Rowsources on the Fly.mp4

004 Create a Subroutine to Build All the Filters.mp4

005 Use the AfterUpdate Event to Rebuild the Filter.mp4

006 Setup the Clear Filter Buttons.mp4

007 Save the Filters when Closing the Form.mp4

008 What Have You Learned in Section 6 Quiz.html

009 Section 6 Conclusion and Review.mp4

010 Section 6 Notes.pdf

desktop.ini

/07 Build a Report Containing Complex Calculations/

001 Inspect the Tables and Review the Goal.mp4

002 Creating a Summary Table with a Query.mp4

003 Building Our First Function and Saving Queries to VBA.mp4

004 Add a Delete Query and Create a Test Macro.mp4

005 Restructure Tables and Add a Second Query to our VBA Function.mp4

006 Figure Out How to Get the Days Between Orders.mp4

007 Doing the Steps With A Recordset.mp4

008 Calculate the Average Days Between Orders.mp4

009 Plug the Average Days into the Report Table.mp4

010 What Have You Learned In Section 7 Quiz.html

011 Section 7 Conclusion and Review.mp4

012 Section 7 Notes.pdf

desktop.ini

/08 Turn Off The Menu, Ribbon and Navigation Pane/

001 View the Example of Removing the Nav Pane and Ribbon.mp4

002 Create the HideMenu subroutine.mp4

003 Call the HideMenu Subroutine from our Form.mp4

004 Make the Subroutine Toggle the Menus.mp4

005 Create a Startup Subroutine and an Autoexec Macro.mp4

006 Prevent Closing the Form and Activate the Exit Button.mp4

007 What Have You Learned in Section 8 Quiz.html

008 Section 8 Conclusion and Review.mp4

009 Section 8 Notes.pdf

desktop.ini

/09 How to Create and Modify Table Structures In VBA/

001 Overview and Goal.mp4

002 Create Delete Subroutine and Make First Changes to SummRpt Function.mp4

003 Backup the SummRpt Function and Make the First Changes.mp4

004 Pull a Query from VBA Back to Design, Change It and Update VBA.mp4

005 Use TableDefs to Add a Field to a Table.mp4

006 Use TableDefs to Create a Table and Add FIelds to it..mp4

007 Make Final Changes and Test the Modified Function.mp4

desktop.ini

/10 Summary and Conclusion/

001 Congratulations and Next Steps.mp4

desktop.ini

/11 Section 11 USING SUBFORMS/

001 Download the Subforms Database.pdf

002 Overview of the Tables in the Subforms Database.mp4

003 Overview of the Forms in the Subforms Database.mp4

004 Add OrderList as a Subform to the Customer Form..mp4

005 Using an On Exit Subroutine to Capture the Order Number You Were On.mp4

006 Pass the Order Number to the Go To Order Button.mp4

007 Open the Orders Form and Move to the Specified Order.mp4

008 Create Code to Return to the Customer Form.mp4

009 Setup the OrdProdList Subform.mp4

010 Create a Total in the Subform.mp4

011 Update the Subtotal and Order Total.mp4

012 Add a New Product to the Order.mp4

013 Create the Add Order Subroutine and Post a New Order.mp4

014 Get the New Order Number and Open the Order Form.mp4

015 Review, Conclusion and Future Enhancements.mp4

desktop.ini

/12 Using POPUP Forms/

001 Download the POPUPS Database.pdf

002 Import Customer List Form and Rename it as CustPopup.mp4

003 Prepare the CustPopup form for use as a popup form..mp4

004 Modify the Customer Form code to Open the Popup.mp4

005 Make the Popup Move to the Current Customer On Open.mp4

006 Use the TAG Property to send the OrdCust Value Back from the Popup Form.mp4

007 Add a Customer From Inside the Popup Form.mp4

desktop.ini

/13 A CLASSIC Double Loop Walk Thru/

001 Double Loop Database Download.pdf

002 A CLASSIC situation that MUST be handled correctly.mp4

003 Database Overview and Why You Want One Table.mp4

004 The Code Behind the Recalc Button.mp4

005 Doing Total Queries and Making the Subroutine a Function.mp4

desktop.ini

/14 BONUS/

001 Bonus Lecture - Expand Your Knowledge With My Other Courses.pdf

desktop.ini

/

kat.cr.txt

KAT.CR.txt

Total files 125