Up and Running with VBA in Access shows how to enhance productivity by automating routine tasks and providing custom functionality not built into Access. Author Curt Frye introduces object-oriented programming and provides database designers with a foundation in the Access object model and the Visual Basic for Applications (VBA) programming language. The course covers automating tasks with macros, working in the Visual Basic Editor, writing functions, adding logic, reading data, controlling forms, and more. Exercise files are included with the course
Topics include:
- 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
- author
- Curt Frye
- subject
- Business, Databases, Office Suites
- software
- Access 2003, 2007, 2010, Visual Basic for Applications
- level
- Advanced
- duration
- 4h 38m
- released
- Oct 06, 2011
- DVD
- purchase
viewed
duration
Suggested courses to watch next:
