Course Title: Microsoft Visual Basic for Access 2002



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.


Course Author/Expert: Mark Long / Certified Instructor

Language: english

Full Online Training Available: Yes

Number of Course Movies: 94

Course Duration: 7 hours



Never has it been so easy to learn Microsoft Visual Basic for Access 2002.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.




Course Outline:



The FIRST THREE chapters of this online training course can be viewed right now!





Click Here Now To View the First Three Chapters of Microsoft Visual Basic for Access 2002 Online Training For Free






If you then need all the lessons or complete access to over seven hundred different courses then join the online university for as long as you need them and even get an online university certificate.


01 Introduction
0101 Welcome/Intro
0102 Course Overview
0103 Who This Course Is For

02 VBA Basics
0201 This is VBA
0202 VBA IDE
0203 Project Window
0204 Properties Window
0205 Custom Toolbar
0206 Writing Code
0207 Getting Assistance In VBA

03 Variables
0301 Variables Explained
0302 Creating Variables
0303 Data Types
0304 Expressions
0305 Constants
0306 Static Variables
0307 Option Explicit
0308 Variable Scope
0309 Option Compare

04 Modules
0401 Intro to Modules
0402 Procedures
0403 Using Arguments
0404 Public vs Private
0405 Functions
0406 Using Form Modules
0407 Using Standard Modules
0408 Enhancing Code Readability

05 Event Based Programming
0501 Events
0502 Handling Events
0503 Choosing Events
0504 Form Events
0505 Control Events
0506 DoCmd

06 Forms
0601 Collections
0602 Forms Collection
0603 Multiple Forms

07 Validating Data
0701 Validation Levels
0702 Database Validation
0703 Code Level Validation
0704 Validating Strings
0705 Validating Numbers
0706 Validating Dates

08 Object Oriented Programming
0801 Intro to OOP
0802 Classes
0803 Objects
0804 Creating A Class
0805 Creating An Object
0806 Object Browser
0807 Using Application Objects

09 Control Structures
0901 If/Then
0902 Immediate If
0903 Case Statements
0904 Choose Function

10 Looping Through Code
1001 Looping Structures
1002 For Next Loops
1003 For Each
1004 Do Loops
1005 Do While
1006 Do Until
1007 Do Loop While
1008 Do Loop Until

11 Handling Errors
1101 Types of Errors
1102 Error Handling Terminology
1103 Creating An Error Handler
1104 Using The Err Object
1105 Exiting Error Handler Routine
1106 Error Handling Templates

12 Debugging
1201 Intro to Debugging
1202 Navigating Your Code
1203 Breakpoints
1204 Working In Break Mode
1205 Immediate Window
1206 Locals Window
1207 Watch Window

13 Data Access
1301 Data Access Basics
1302 Connection Object
1303 Recordset Object
1304 Referencing Fields
1305 Navigating Records
1306 SQL Queries
1307 Updating Records
1308 Adding Records Pt.1
1309 Adding Records Pt.2
1310 Deleting Records Pt.1
1311 Deleting Records Pt.2
1312 Connecting To SQL Server
1313 DAO vs ADO

14 Application Completion
1401 Documentation
1402 Testing
1403 Startup Options
1404 Splash Screens
1405 Packaging For Delivery
1406 Using The Database Splitter

15 Credits
1501 About The Author







To continue your learning, Click Here for the Online University and get access to all of the training courses, that's over 550 software programmes including 60,000 tutorial videos, for editing, image manipulation and graphics programmes. All for just $30 (approx £16) month. Unlimited access for as long as you need, cancel when you're finished, no contract, no minimum period, no hassle.



or


Click Here and we'll send you the training CD itself for Microsoft Visual Basic for Access 2002 at £79.95

| rss feed | add to google toolbar Add latest courses to Google Toolbar | After Effects Projects | Background Loops |

• TutorRoom© 2005 •