Exclusive
Office

Mastering Microsoft Access 2000 Programming
(Microsoft Training Course: 1300) - 3 days - £1700 exc VAT



> Target Audience
THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
This course is intended for Microsoft Access users with no programming experience and teaches how to use Visual Basic for Applications to add simple functionality to a Microsoft Access database.
> Course outline
  1. Introduction to Programming
  2. Responding to User Actions
  3. Validating Data
  4. Using Functions and Understanding Scope
  5. Using Debugging Tools
  6. Handling Run-Time Errors
  7. Looping Through Code
  8. Working with Records
  9. Working with Records
  10. Finalizing Your Application

Supplementary InformationThis course has now retired and is no longer available. It is possible for us to run a closed Access 2007 course for more than two people. Please call for details.
Module 1: Introduction to Programming
  • Overview of a Microsoft Access application
  • Writing procedures
  • Working with variables
  • Controlling program flow
  • Calling procedures
  • Getting help
Skills
  • Use Visual Basic Editor to add code to applications
  • Declare and use variables
  • Use built-in functions to obtain values from users
  • Create and call Sub procedures
  • Use conditional statements to control the flow of programs
  • Use Visual Basic Help
top
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
Skills
  • Create an event procedure
  • Add an event procedure to a form
  • Respond to user actions programmatically
  • Perform specific tasks using the DoCmd object
top
Module 3: Validating Data
  • Overview of data validation
  • Validating data without using code
  • Validating data by using code
Skills
  • Differentiate between data validation at the table level, form level, and code level
  • Use the built-in validation tools in Microsoft Access
  • Write Visual Basic for Applications code to validate data
top
Module 4: Using Functions and Understanding Scope
  • Using functions
  • Understanding scope
Skills
  • Create custom functions
  • Create private and public variables
top
Module 5: Using Debugging Tools
  • Stepping through code
  • Viewing variables
Skills
  • Set breakpoints to stop program execution
  • Run selected portions of code
  • Test data and procedures in the Immediate window
  • Monitor variable values in the Locals window
  • Add and edit watch expressions
top
Module 6: Handling Run-Time Errors
  • Types of errors
  • Run-time errors
  • Adding error handlers
Skills
  • Trap run-time errors
  • Create error handlers
  • Create a template to write procedures
  • Use the Err object
  • TOP
top
Module 7: Looping Through Code
  • Overview of looping structures
  • Do loops
  • For loops
  • Interrupting the execution of a loop
Skills
  • Create loops to control the flow of programs
top
Module 8: Working with Records
  • Overview of record sets
  • Retrieving data
  • Structured Query Language (SQL)
  • Manipulating data
Skills
  • Retrieve data using SQL and ADO record sets
  • Manipulate data using SQL and ADO record sets
  • TOP
top
Module 9: Working with Records
  • Overview of record sets
  • Retrieving data
  • Structured Query Language (SQL)
  • Manipulating data
Skills
  • Retrieve data using SQL and ADO record sets
  • Manipulate data using SQL and ADO record sets
top
Module 10: Finalizing Your Application
  • Reviewing your application
  • Enhancing the user interface
  • Packaging for delivery
Skills
  • Use good coding practices
  • Customize a switchboard form
  • Hide code by creating an MDE file
  • Package an application for distribution
top
> Pre-Requisites
Completion of Course MS 1539, Mastering Database Fundamentals using Microsoft Access 2000, or six months experience using Microsoft Access
    > Purpose
    The overall aim of the course is to give the delegate a sound knowledge of programming in Access. At the end of the course, students will be able to use the programming capabilities of Microsoft Visual Basic for Applications in Microsoft Access applications to write custom functions and event-driven procedures; validate data; find and trap errors; gain access to and manipulate data in tables using ActiveX Data Objects (ADO) and Structured Query Language (SQL); and create a custom switchboard for an Access application.
    > Supplementary Information
    This course has now retired and is no longer available. It is possible for us to run a closed Access 2007 course for more than two people. Please call for details.