A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West

Compare Recently Viewed Course Dates


Exclusive
Office

Programming Microsoft Access 2002
(Microsoft Training Course: 2657) - 3 days - £1700 exc VAT

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> Target Audience
Knowledge workers and technologists who are familiar with using Access and other Microsoft Office applications but whose previous programming experience is limited
Any programmers who require an introduction to Office development using Visual Basic
> 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 XML
  10. Finalizing Your Application
Module 1: Introduction to Programming
  • Using Visual Basic Help
  • Writing Procedures
  • Working with Variables
  • Controlling Program Flow
  • Calling Procedures
  • Lab:
  • Introduction to Programming
Skills
  • Use Visual Basic Help.
  • Use the 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.
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
  • Lab:
  • Responding to User Actions
Skills
  • Create an event procedure.
  • Add an event procedure to a form.
  • Respond to user actions programmatically.
  • Perform specific tasks by using the DoCmd object.
top
Module 3: Validating Data
  • Overview of Data Validation
  • Validating Data Without Using Code
  • Validating Data by Using Code
  • Lab:
  • Validating Data
Skills
  • Differentiate between data validation at the table level, form level, and code level
  • Use the built-in validation tools in Microsoft Access.
top
Module 4: Using Functions and Understanding Scope
  • Using functions
  • Understanding scope
  • Lab:
  • Using Functions and Understanding Scope
Skills
  • Describe the appropriate use of functions.
  • Call built-in and custom functions in an application.
  • Create a custom function.
  • Describe the different levels of scope available to variables and procedures.
  • Define variables at the appropriate level of scope.
  • Define procedures at the appropriate level of scope.
top
Module 5: Using Debugging Tools
  • Stepping Through Code
  • Viewing Variables
  • Lab:
  • Using Debugging Tools
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
  • Adding Error Handlers
  • Lab:
  • Handling Run-Time Errors
Skills
  • Trap run-time errors.
  • Create error handlers.
  • Use the Err object.
top
Module 7: Looping Through Code
  • Overview of Looping Structures
  • For Loops
  • Do Loops
Skills
  • List the different looping structures available in Visual Basic for Applications.
  • Write a For...Next loop to perform execution of code statements a fixed number of times.
  • Write a Do...While and a Do...Until loop to perform execution of code statements a variable number of times.
  • Describe the difference between beginning-of-loop and end-of-loop evaluation methods, and write code statements to accomplish each type of evaluation.
top
Module 8: Working with Records
  • Overview of Recordsets
  • Retrieving Data
  • Structured Query Language (SQL)
  • Manipulating Data
  • Lab:
  • Working with Records
Skills
  • Define recordsets.
  • Access data in tables by using ADO recordsets.
  • Retrieve data by using SQL and ADO recordsets.
  • Manipulate data by using SQL and ADO recordsets
top
Module 9: Working with XML
  • About XML
  • Importing XML
  • Exporting XML
  • Transforming XML
  • Modifying XML using the DOM
Skills
  • Describe XML and related technologies.
  • Import XML into Access.
  • Export XML from Access.
  • Transform XML by using the Extensible Stylesheet Language for Transformations (XSLT).
  • Modify XML by using the DOM.
top
Module 10: Finalizing Your Application
  • Reviewing Your Application
  • Enhancing the User Interface
  • Packaging for Delivery
  • Lab:
  • Finalizing Your Application
Skills
  • List four good coding practices and describe why you should use them.
  • Describe the testing criteria for an application.
  • Customize a switchboard.
  • Hide code by creating an MDE file.
  • Describe how to use the Compact and Repair utility to maintain your database application.
  • Describe why and how to use the Database Splitter utility.
  • Describe when and how to use the Packaging Wizard to prepare an application for distribution.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • 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
> Purpose
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). Create a custom switchboard for an Access application. NB. It may be necessary to extend the finish time of the final day on this course.
> EXAMS
There are no exams directly associated with this course