Microsoft Visual Basic for Access 2002 Tutorials
	Quantity in Basket: none Code: VTC-33548 Price:$89.95
	Quantity:
Microsoft Visual Basic for Access 2002 Tutorials Producer: See all VTC titles Media: CD-ROM Author: Mark Long / Certified Instructor ISBN: 1-932808-20-5 Duration: 7 hrs / 94 lessons Compatibility: Win XP, ME, 2000, 98, NT, Mac OS X, OS 9 Microsoft Visual Basic for Access 2002 is actually the language used to build Microsoft applications such as Word, Excel, and PowerPoint. In this Virtual Training Company tutorial, author Mark Long teaches you how to use Visual Basic for Access to build and publish your own programs. He teaches you the concept of event programming, code control structures, variables, constants, and much more. To get started today, simply click on one of the Visual Basic for Access 2002 lessons. Try For Free Right Now To help you evaluate this training program, some of the tutorials may be viewed for free online. Listed below are all of the chapters and lessons for this title. Click on any of the linked lessons below to watch them now online! CD Contents Introduction Welcome/Intro (03:15) Course Overview (04:18) Who This Course Is For (03:00) VBA Basics This is VBA (03:08) VBA IDE (03:22) Project Window (05:17) Properties Window (05:56) Custom Toolbar (03:04) Writing Code (06:33) Getting Assistance In VBA (03:05) Variables Variables Explained (03:15) Creating Variables (03:53) Data Types (03:55) Expressions (03:17) Constants (03:43) Static Variables (02:43) Option Explicit (04:33) Variable Scope (04:16) Option Compare (02:08) Modules Intro to Modules (02:48) Procedures (03:55) Using Arguments (02:42) Public vs Private (03:32) Functions (02:14) Using Form Modules (02:14) Using Standard Modules (02:59) Enhancing Code Readability (02:39) Event Based Programming Events (02:17) Handling Events (02:08) Choosing Events (03:41) Form Events (03:43) Control Events (04:27) DoCmd (02:32) Forms Collections (02:30) Forms Collection (04:29) Multiple Forms (03:27) Validating Data Validation Levels (03:23) Database Validation (05:09) Code Level Validation (03:04) Validating Strings (03:08) Validating Numbers (03:43) Validating Dates (01:49) Object Oriented Programming Intro to OOP (03:27) Classes (02:20) Objects (02:56) Creating A Class (02:25) Creating An Object (04:21) Object Browser (04:19) Using Application Objects (03:10) Control Structures If/Then (04:38) Immediate If (02:02) Case Statements (03:15) Choose Function (02:56) Looping Through Code Looping Structures (01:56) For Next Loops (04:07) For Each (02:54) Do Loops (02:31) Do While (02:09) Do Until (01:58) Do Loop While (01:43) Do Loop Until (01:56) Handling Errors Types of Errors (03:40) Error Handling Terminology (03:09) Creating An Error Handler (03:57) Using The Err Object (03:55) Exiting Error Handler Routine (03:41) Error Handling Templates (02:39) Debugging Intro to Debugging (01:51) Navigating Your Code (03:50) Breakpoints (04:17) Working In Break Mode (02:48) Immediate Window (03:29) Locals Window (01:42) Watch Window (01:41) Data Access Data Access Basics (03:40) Connection Object (05:26) Recordset Object (04:59) Referencing Fields (03:57) Navigating Records (04:26) SQL Queries (03:25) Updating Records (03:48) Adding Records Pt.1 (06:03) Adding Records Pt.2 (03:29) Deleting Records Pt.1 (03:43) Deleting Records Pt.2 (04:54) Connecting To SQL Server (03:48) DAO vs ADO (02:22) Application Completion Documentation (01:53) Testing (03:50) Startup Options (01:43) Splash Screens (03:02) Packaging For Delivery (03:05) Using The Database Splitter (02:06) Credits About The Author (01:47) To view the Free Tutorials you must have Quicktime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality. Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.