- View Offline
- Working with macros and managing macro security settings
- Creating, exporting, and deleting code modules
- Running a VBA procedure
- Debugging VBA code
- Defining variables, constants, and calculations
- Displaying a calculated result in a message box
- Repeating tasks with loops
- Creating conditional statements
- Manipulating database objects, such as forms, tables, and queries
- Adding, editing, and deleting records
- Looking up values in a table
- Requerying and repainting forms
Skill Level Advanced
- [Voiceover] Hi, I'm Curt Frye. Welcome to Up and Running with VBA in Access. In this course I will show you how to automate Access databases using macros, to run a macro by clicking a command button, and to manage macro security settings. I'll introduce Visual Basic for Applications, also known as VBA, starting with an overview of object-oriented programming, the Access object model, and using the Visual Basic Editor. The course focuses on adding logic to your VBA code, manipulating database objects, and controlling forms and reports using the Me object.
Whether you use Access for a small business, or for home projects you'll discover that VBA programming can make your databases much more useful. In short, I'm sure you'll find that your time with Up and Running with VBA in Access will be time well spent. Let's get going.