2657 Programming Microsoft Access 2002 Training Course



Length: 3 day(s) | Vendor: Microsoft | Course Category: MOC | Community:

  Request Dates  Ask Question   Email Course Outline   Print Page

View all Testimonials >

Request Information

Want more information? Fill out the form below and we'll contact you shortly.

Name 

Phone 

Email 

Subject 

Message 





Course Description:


This course teaches programming concepts and how to add simple functionality to a Microsoft Access 2002 database by using Microsoft Visual BasicĀ® for Applications.
Required Experience
Ability to design a relational database
Ability to use Microsoft Access to create a database with multiple tables, forms, and reports, and to create queries

Lessons



1Introduction to ProgrammingUsing Visual Basic Help
Writing Procedures
Working with Variables
Controlling Program Flow
Calling Procedures
2Responding to User ActionsOverview of the Class Application
Adding Event Procedures
Working with Events
Using Objects, Properties, and Methods
Using the DoCmd Object
3Validating DataOverview of Data Validation
Validating Data Without Using Code
Validating Data by Using Code
4Using Functions and Understanding ScopeUsing Functions
Understanding Scope
5Using Debugging ToolsStepping Through Code
Viewing Variables
6Handling Run-Time ErrorsTypes of Errors
Adding Error Handlers
7Looping Through CodeOverview of Looping Structures
For Loops
Do Loops
8Working with RecordsOverview of Recordsets
Retrieving Data
Structured Query Language (SQL)
Manipulating Data
9Working with XMLAbout XML
Importing XML
Exporting XML
Transforming XML
Modifying XML using the DOM
10Finalizing Your ApplicationReviewing Your Application
Enhancing the User Interface
Packaging for Delivery

Share |

Since 1982, New Horizons Computer Learning Centers has grown to become the largest independent IT training company worldwide. We offer more courses, at more times and in more locations than any other computer and business training company. Businesses and individuals can choose from hundreds of course offerings, delivered by experts, and offered in hundreds of convenient locations around the world.


Albany, NY
(518) 452-6444
10 Airline Drive, Ste 101
Albany, NY 12205
Charlotte, NC
(704) 522-9747
9140 Arrowpoint Blvd, Ste 400
Charlotte, NC 28273
Harrisburg, PA
5095 Ritter Road, Ste 114
Mechanicsburg, PA 17055
Lancaster, PA
(717) 791-0200
1020 New Holland Ave
Lancaster, PA 17601