Course Info

MS2657 - Programming Microsoft Access 2002

Categories Microsoft Access Training, Database Training, Scripting Training, Visual Basic Training

Duration 3 days (21 hours)

Pre-requisites
DMD - Database Modeling and Design, MA1 - Introduction to Microsoft Access 2000, MA2 - Microsoft Access 2000 Intermediate, MA3 - Microsoft Access 2000 Advanced and MSSQL - ANSI-SQL Using Microsoft SQL Server, or equivalent knowledge and experience.

Courseware MS2657-MS (200 pages)

Price $1185

Notes

This course teaches programming concepts and how to add simple functionality to a Microsoft Access 2002 database by using Microsoft Visual Basic® for Applications. It is designed for technologists who are familiar with using Access and other Microsoft Office applications but whose previous programming experience is limited. After completing this course, students will be able to use the programming capabilities of Microsoft Visual Basic for Applications in Microsoft Access 2002 to write custom functions and event-driven procedures, validate data, find and trap errors, gain access to and manipulate data in tables by using Microsoft ActiveX® Data Objects (ADO) and the Structured Query Language (SQL) and create a custom switchboard for an Access application.

Module 1: Introduction to Programming
      Using Visual Basic Help
      Writing Procedures
      Working with Variables
      Controlling Program Flow
      Calling Procedures
      Lab 1.1: Introduction to Programming
Module 2: Responding to User Actions
      Overview of the Class Application
      Adding Event Procedures
      Working with Events
      Using Objects, Properties, and Methods
      Using the DoCmd Object
      Lab 2.1: Responding to User Actions
Module 3: Validating Data
      Overview of Data Validation
      Validating Data Without Using Code
      Validating Data by Using Code
      Lab 3.1: Validating Data
Module 4: Using Functions and Understanding Scope
      Using Functions
      Understanding Scope
      Lab 4.1: Using Functions and Understanding Scope
Module 5: Using Debugging Tools
      Stepping Through Code
      Viewing Variables
      Lab 5.1: Using Debugging Tools
Module 6: Handling Run-Time Errors
      Types of Errors
      Adding Error Handlers
      Lab 6.1: Handling Run-Time Errors
Module 7: Looping Through Code
      Overview of Looping Structures
      For Loops
      Do Loops
Module 8: Working with Records
      Overview of Recordsets
      Retrieving Data
      Structured Query Language (SQL)
      Manipulating Data
      Lab 8.1: Working with Records
Module 9: Working with XML
      About XML
      Importing XML
      Exporting XML
      Transforming XML
      Modifying XML using the DOM
Module 10: Finalizing Your Application
      Reviewing Your Application
      Enhancing the User Interface
      Packaging for Delivery
      Describe when and how to use the Packaging Wizard to prepare an application for distribution.
      Lab 10.1: Finalizing Your Application