| Search (advanced search) | ||||
Use this Search form before posting, asking or make a new thread.
|
|
03-25-2014, 03:18 PM
Post: #1
|
|||
|
|||
Lynda - Up and Running with VBA in Access
![[Image: 2a2646d154e036d11a94298d85830304.jpg]](http://i60.fastpic.ru/big/2013/1130/04/2a2646d154e036d11a94298d85830304.jpg) Lynda - Up and Running with VBA in Access MP4 | AVC 152kbps | English | 960x540 | 15fps | 4h 38mins | AAC stereo 128kbps | 534 MB Genre: Video Training Enhance productivity by automating routine tasks and providing custom functionality not built into Access with a few basics in VBA code. 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. Introduction 2m 23s Welcome 58s What you should know before watching this course 40s Using the exercise files 45s 1. Automating Processes Using Macros 20m 32s Introducing Access Automation 3m 45s Running macros 2m 30s Working with data macros 4m 15s Running a macro by clicking a command button 6m 12s Managing macro security settings 3m 50s 2. Introducing Visual Basic for Applications (VBA) 27m 54s Introducing object-oriented programming 3m 11s Examining the Access Object Model 4m 29s Working in the Visual Basic Editor 2m 59s Creating, exporting, and deleting code modules 6m 59s Creating a subroutine 1m 41s Creating a function 4m 12s Adding comments to your code 3m 0s Running a VBA procedure 1m 23s 3. Debugging Your VBA Code 19m 46s Managing errors in VBA code using On Error statements 5m 18s Stepping through a subroutine or function 3m 51s Setting breakpoints in your code 2m 56s Verifying output using temporary message boxes 4m 38s Watching a value in a routine 3m 3s 4. Defining Variables, Constants, and Calculations 43m 35s Introducing Access data types 3m 23s Declaring variables and requiring declaration before use 6m 21s Managing variable scope 5m 5s Defining constants and static variables 5m 23s Creating a calculation using mathematical operators 5m 12s Displaying a calculated result in a message box 7m 24s Defining an array 6m 21s Defining and using an object variable 4m 26s 5. Adding Logic to Your VBA Code 28m 37s Repeating a task using a For...Next loop 4m 15s Stepping through all items of a collection using a For...Each loop 4m 42s Repeating a task using a Do...While loop 4m 15s Repeating a task using a Do...Until loop 3m 42s Performing a task when conditions are met using an If...Then statement 6m 40s Selecting actions using a Case statement 5m 3s 6. Manipulating Database Objects Using DoCmd 40m 0s Opening a form 6m 18s Opening a report 4m 45s Opening a table 3m 30s Opening a query 3m 24s Closing an object 3m 59s Closing a database or quitting Access 3m 52s Sounding beeps and displaying the hourglass cursor 4m 6s Running a menu command 2m 28s Printing the active database object 3m 1s Displaying or hiding warnings 4m 37s 7. Reading and Manipulating Table Data 48m 26s Displaying every row in a table (Recordset) 3m 42s Adding a new record to a table 3m 34s Editing values in an existing table row 6m 23s Preserving data integrity using transactions 4m 37s Displaying a table property using the TableDef object 4m 14s Closing a Recordset 3m 39s Deleting the current record 4m 49s Finding records within a table 8m 32s Moving within a Recordset 5m 12s Counting the records in a Recordset 3m 44s 8. Manipulating a Database Using the Application Object 16m 30s Summarizing values in a table field 3m 22s Finding the first or last value in a table field 2m 58s Looking up a value in a table field 3m 31s Create a progress bar using the SysCmd object 6m 39s 9. Controlling Forms and Reports Using the Me Object 30m 7s Allowing or disallowing additions, deletions, and edits 5m 9s Manipulating form filters 6m 15s Setting the caption and background picture 5m 25s Requerying and repainting forms 4m 40s Discovering a record source 3m 3s Setting the ScrollBars property 2m 52s Rendering a form or reporting visible or invisible 2m 43s Conclusion 53s Additional resources and final thoughts 53s Code: Buy Premium Account and download as fast as you can or you will lose file you need ( File death because of Copyright Infringement )Click my nick to see more my articles |
|||
