Course Description
Learn the basic Access VBA concepts, tools and functions that you will need while you build a fully functional system!
Build a strong foundation in Access Visual Basic with this tutorial for Non-Programmers!
- Create VBA Subroutines for Forms and Control the Keyboard
- Extensive Training on Handling Errors
- Control Record Sorting and Searching for Specific Records
- Learn How to Move and Pass Data Between Forms
- Create Interactive Pull Down Filters for Form Data
- Build a Complex Report Entirely with VBA
- Introduction to SQL and How to Use SQL in VBA
- Turn the Ribbon and Nav Pane On and Off
- Prevent Form Closure or Resizing
- Learn How to Close Access with VBA
Powerful Skills That Increase Your Value in the Marketplace
Learning
VBA enables you to use all the power of Access to easily create systems
that will be in high demand with your current employer or other
businesses. The practical skills taught in this class will give you a
solid foundation in creating systems that people can use while making
sure that they do not create or run into errors.
There
is a HUGE need in the marketplace for people who can create systems in
Access. This is your opportunity to break away from the mass of people
who struggle to create effective Access databases, and learn to easily
automate tasks!
Content and Overview
All
you need is basic experience with Access components: tables, queries,
forms and reports. This course does not require any programming
experience or knowledge of macros.
Through 60+ lectures
and over 6 hours of content, you'll learn all of the Access VBA
fundamentals and establish a strong understanding of the concepts behind
programming with VBA. Each chapter builds on the previous one as you
build a complete system, putting your new learned skills into practical
use immediately.
Starting with simple goals, this course
will take you through VBA step by step as you add to your system in each
section. Since you will be expanding and enhancing the same system with
each section, the need for and usefulness of each new VBA concept will
be obvious.
By the time you have finished the course you
will have done so much with VBA and it will be so familiar that you will
be ready to tackle your own project immediately.
Building
systems with VBA will always bring up situations that are new but, with
your solid foundation in how VBA works and how to solve problems, you
will be able to expand your knowledge to handle these new situations.
The
course is complete with working files and finished code samples for
everything covered. You will be able to work alongside the author as you
work through each lecture and will receive a verifiable certificate of
completion upon finishing the course.
Curriculum
What Have You Learned in Section 8?
Activate the Add Customer Button
Activate the Delete Button
Add a Delete Query and Create a Test Macro
Break Into Programs and Infinite Loops
Building Our First Function and Saving Queries to VBA
Building the Search Criteria
Calculate the Average Days Between Orders
Call the HideMenu Subroutine from our Form
Congratulations and Next Steps
Course Overview
Create a Prompt to Save Changes
Create a Startup Subroutine and an Autoexec Macro
Create a Subroutine to Build All the Filters
Create the HideMenu subroutine
Create Your First VBA Subroutine!
Creating a Summary Table with a Query
Direct Download Links for Database Files
Doing the Steps With A Recordset
Enable Editing In the Dropdown Filters
Enhancing Our Instant Search
Expanding the Keydown Subroutine
Field Names and Reserved Words
Figure Out How to Get the Days Between Orders
Fix a Syntax Error and Take Over the Keyboard
How to Contact Me
Inspect the Tables and Review the Goal
Intro to SQL and Using SQL in the Recordsource
Locate Same Record When Returning from the Form
Make the Subroutine Toggle the Menus
Modify a Form to Utilize Data Sent to it.
Modify Subroutines to Sort DESC, More Error Handling
Modify the Form to Remember the Sort
On Open Event, Me Keyword and Orderby
Open Another Form with a Button Click
Plug the Average Days into the Report Table
Prevent Closing the Form and Activate the Exit Button
Restructure Tables and Add a Second Query to our VBA Function
Runtime Errors, Error Traps and Program Stops
Save the Filters when Closing the Form
Section 1: Introduction
Section 2 Conclusion and Review
Section 2 Notes
Section 2: Start Learning VBA and Handling Errors
Section 3 Conclusion and Review
Section 3 Notes
Section 3: Create Record Sorting Subroutines
Section 4 Conclusion and Review
Section 4 Notes
Section 4: Use Instant Search to Learn More About the Keyboard, Recordsets and Variables
Section 5 Conclusion and Review
Section 5 Notes
Section 5: Interact With Other Forms and Pass Information
Section 6 Conclusion and Review
Section 6 Notes
Section 6: Add Multiple Interactive Pulldown Filters
Section 7 Conclusion and Review
Section 7 Notes
Section 7: Build a Report Containing Complex Calculations
Section 8 Conclusion and Review
Section 8 Notes
Section 8: Turn Off The Menu, Ribbon and Navigation Pane
Section 9: Summary and Conclusion
Send Data to the Other Form
Set Dropdown Rowsources on the Fly
Setup Rowsource for Dropdown Filters
Setup Tasks
Setup the Clear Filter Buttons
Subroutines for Form Controls, VBA Editing Shortcuts
Testing for a Blank Record
Use an IF Statement and DoCmd
Use ElseIf and a Select Statement
Use the AfterUpdate Event to Rebuild the Filter
Using a Recordset and Bookmarks
Using Public Variables
View Database Table and Forms - Review the Goal
View the Example of Removing the Nav Pane and Ribbon
What Have You Learned in Section 2?
What Have You Learned in Section 3?
What Have You Learned In Section 4?
What Have You Learned in Section 5?
What Have You Learned in Section 6?
What Have You Learned In Section 7?
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
