Lynda.com - Up and Running with VBA in Access
English | Duration: 4h 39m | Video: AVC (.mov) 960x540 | Audio: AAC 48KHz mono | 335MB
Genre: eLearning
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
Download
http://www.filesonic.com/file/2672056294/VBA.in.Access.part1.rar
http://www.filesonic.com/file/2672059794/VBA.in.Access.part2.rar
http://www.filesonic.com/file/2672059644/VBA.in.Access.part3.rar
http://www.filesonic.com/file/2672056284/VBA.in.Access.part4.rar
Mirror
http://www.filejungle.com/f/dNTrvq
http://www.filejungle.com/f/FpYqdh
http://www.filejungle.com/f/3aVzdr
http://www.filejungle.com/f/jYn9wb
