Access Programming
CTU-ACCESSPRG-C

 Email this information to yourself or a friend

 Remind me of this course at a later date




Official Program Description

Access Basic Programming


jump to schedules and register button

Learn how to create powerful applications using Access. You will explore programming constructs such as objects, arrays, functions, and debugging.

Who Should Attend

This class is geared towards experienced Access users who are interested in programming with the Visual Basic language.

Prerequisites

Appropriate introductory and advanced courses plus several weeks of practice. No programming experience is required.

Attend and You Will Learn

Getting Started Functions

  • Introduction to programming in Access
  • Why program in Access?
  • Creating a macro
  • Understanding modules
  • Creating a standard module
  • Understanding the development environment
  • Using the Project Explorer
  • Using the Properties Window
  • Using the Code Window

 Working with Procedures and Functions

  • Understanding procedures
  • Creating a sub procedure
  • Creating a function procedure
  • Calling procedures and function
  • Working with code

Objects, Properties, Methods and Events

  • Understanding objects and collections
  • Understanding properties
  • Understanding methods
  • Understanding events

Understanding the Access Object Hierarchy

  • Understanding access objects
  • Using the object browser
  • Controlling the application object
  • Understanding the forms collection and form object
  • Understanding the controls collection and control object
  • Using the "with" statement
  • Understanding the reports collection and report object
  • Understanding the DoCmd object
  • Using the screen object

Using Variables, Arrays and Constants

  • Declaring variables
  • Declaring arrays
  • Declaring constants
  • Declaring object variables

Using Functions, Message Boxes and Input Boxes

  • Using intrinsic functions
  • Using message boxes
  • Using input boxes

Controlling Program Execution

  • Using control structures
  • Working with conditional expressions
  • Using the If...Then...End If structure
  • Using the If...Then...Else...End If structure
  • Using the select case...End select structure
  • Using the Do...Loop structure
  • Using the For...Next structure

Debugging Code

  • Understanding errors
  • Using debugging tools
  • Stepping through code and setting break points
  • Understanding error events
  • Understanding the err object
  • Using the On Error statement
  • Writing an Error handling routine
  • Compiling all procedures



Sections

  Access Programming
CTU-ACCESSPRG-C - 010
   
 
  2015 - TTS - Jan - Apr 2015   Status:  Available
 
In-Class:   Thu, Fri 9:00AM - 4:30PM
23 Apr 2015
In-Class:   Thu 9:00AM - 4:30PM
30 Apr 2015
Class Schedule: 2 Sessions
Contact Hours: 12.0
Course Fee(s):
Registration Fee non-credit    $449.00
Gov't & Non-Profit Registration Fee non-credit    $349.00
Potential Discount(s):
CTU-MultClassDisc>250
  1.20 CEUs
Location:   On Campus
 
  Access Programming
CTU-ACCESSPRG-C - 011
   
 
  2016 - TTS - Jul - Aug 2015   Status:  Available
 
In-Class:   Thu, Fri 9:00AM - 4:30PM
27 Aug 2015 to 28 Aug 2015
Class Schedule: 2 Sessions
Contact Hours: 12.0
Course Fee(s):
Registration Fee non-credit    $449.00
Gov't & Non-Profit Registration Fee non-credit    $349.00
Potential Discount(s):
CTU-MultClassDisc>250
  1.20 CEUs
Location:   On Campus