Microsoft Access VBA for Non Programmers – YOU Can Do This!

Microsoft Access VBA can be learned quickly even if you've never done programming! Make complex jobs easy with VBA!

Created by: Bruce Myron
Productivity Specialist

What Will I Learn?

• Be able to create and test vba subroutines and functions
• Be comfortable with moving to and from the vba editor
• Take control of the keyboard within forms
• Control interaction between forms and pass data back and forth
• Tie sorting to clicking on controls within forms
• Create and debug pull down filters on forms
• Create the capability to instantly search for records
• Use recordsets within forms to locate specific records
• Convert queries into SQL and place them inside vBA code
• Create complex reports using embedded queries and recordsets
• Secure forms by turning off resize and close capabilities
• Hide the menu and navigation pane and bring them back

Requirements

• No programming knowledge is necessary! Just a very basic familiarity with Access Tables, Queries, Forms and Reports. The videos show every step and you will also always have finished examples to compare to. The course was created in Access 2010, but the downloadable databases provided with each section are in Access 2000 format, so can be used with any version of Access from 2000 through 2016, or with a current Office 365 subscription.

Target audience

• This course is meant for those who have a basic familiarity with Microsoft Access, but have never used macros or done any VBA programming.